Comments by ashu_dhiman (Top 27 by date)

private string _id;
public string Id
{
get { return _id; }
set { _id = value; }
}
private DateTime dt;
public DateTime _dt
{
get { return dt; }
set{dt=value;}
}
private void DataShowForm_Load(object sender, EventArgs e)
{
string s;
SqlConnection con = new SqlConnection("data source=ASHU-PC;initial catalog=login;integrated Security=true");
SqlDataAdapter adp = new SqlDataAdapter("select * from tblPSData where code_id='" + _id + "' and SDate='"+_dt+"' order by serial_no", con);
DataSet ds = new DataSet();
adp.Fill(ds,"tm");(This line came with exception "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.")
dataGridView1.DataSource = ds.Tables["tm"];
}

mayur there is difference b/w the last one and this. Last is base on Id Only but this is according to ID and Particular date...

yes but it show's all the records related to particular ID but i want only those records who enter on particular date for e.g: when i double click on row who has code-101, service_name:School, Date-14-03-2011, Total_Records_Enter-36

it only shows 36 records enter in School Service on Date-14-03-2011

thanks mayur problem solved

i analyse it if i resolved i let u know i thougth the acess specifier might be creating this prob.??

thanks mayur for suggestion and guidence

private string _id;
public string Id
{
get { return _id; }
set { _id = value; }
}

same sir

i allready do this exceptio is remain same

set
{
Id = value; (This Line)
}

i tried your mention method and getting exception

An unhandled exception of type 'System.StackOverflowException' occurred in WindowsFormsApplication11.exe

private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
rownumber = e.RowIndex;
empid = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
}


private void dataGridView1_CellDoubleClick(object sender,DataGridViewCellEventArgs e)
{
DataShowForm ds = new DataShowForm();
ds.Show();
}

No current form shows the entity code, entity name, and total number of record present in particular entity in datagrid view. And i want to fetch all the record from table dbo.tblPSData when a double click on particular Entity Row. For e.g when i doubleclick entity row who's code is 102, a new winform loaded and show all the records whose entity code is 102 from table dbo.tblPSData present in data base.

i want to show all the records present in entity on double click event....

Thank You..... :)

Currently Data Store in Table like...

From_Place TO_Place Area
London Scottloand NULL

New Delhi Mumbai NULL

NULL NULL Kolkata To Chennai

NULL NULL Chandigarh TO Dehradun


Required Result is to be Like

From_Place TO_Place Area
London Scottloand NULL

New Delhi Mumbai NULL

Kolkata Chennai NULL

Chandigarh Dehradun NULL

i already did that but still getting same

sir i have been looking for urgent help so i also post it here this is the only reson.

hello Maciej

i have table in database name data_details it has different column name as customer_name,cs_address,date_birth.
And i want to enter already set default value for date_birth column if i get null value during inserting the new record.

Krumia sir your assumption is exactly match my view so could you help me how can i do this???

sir actually i m working on astrology site and i wanna provide the functionality to user which shows kundali chart of client how can solve this problem??