Comments by SantoshRohinSantosh (Top 41 by date)

Thanks for the solution but there can be no of products ,so should I use the scrip in each text box???
Please elaborate the solution.

Hello friends please help

NO sir I didnt found this use full please give me other suggesstions

Okay Arun Thanks I'l try this.

thank you Deepak but just tell me that what should I do for database back up?

And what about data base???

No one there???

Do i need to include any assembly for that?

Ya but compiler is not accepting that.

Thanks dude but I am not doing project in Asp.net
It is stand alone project.
Can you please help me?

Ya it have value.

Ya I debug values are coming right but still I am getting exception.

Okay thank you for the explanation. I'l try by self.

Can you edit in my code I am that perfect sir.

Thanks Abhinav. I want to use list or any other option then array because now it is working fine because the data is limited in database but when data will increase in database then array will not be an good option.So can you suggest me any other option?

Thank you so much Yogesh It is working.

Thanks yogesh but this is not working ,I am using SQL server so can you suggest me any other idea?Please.

How to gate date and month only?

I am building windows application sir.

You just tell me GRIFF how i'l give title to the datagridview?

Will you please elaborate.

ya i did but not working

If i do that it is giving me error.
Input string is not in correct format.

thanks it work

thanks it work

What is sqlstatement in this?

ClsConnection.Conn.Open();
getbatchid();

string cid = "a";

string s = "select Student_Id from tbstudent_batchmaster where Batch_Identity='" + batchid + "'";



SqlCommand cmd = new SqlCommand(s, ClsConnection.Conn);

SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{

cid = sdr.GetValue(0).ToString();

Int32.TryParse(cid, out actval);
//ArrayList attribut = new ArrayList();
//attribut.Add("actval");
//fillstudentdata();

//ClsConnection.Conn.Close();
//ClsConnection.Conn.Open();

dtstudent.ColumnHeadersVisible = true;
dtstudent.RowHeadersVisible = false;
dtstudent.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
string selectCommand1 = "select FName+' '+LName as Name from ADD_Master where ADD_No='" + actval + "'";
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(selectCommand1, ClsConnection.Conn);
SqlCommand cmd1 = new SqlCommand();

cmd1.CommandText = selectCommand1;
DataSet ds1 = new DataSet();
sqlDataAdapter1.Fill(ds1);
//ClsConnection.Conn.Close();
dtstudent.DataSource = ds1.Tables[0];
DataGridViewCheckBoxColumn cb = new DataGridViewCheckBoxColumn();
cb.HeaderText = "test";
cb.Name = "test";
cb.Visible = true;
cb.Width = 40;
dtstudent.Columns.Add(cb);
dtstudent.Columns[0].Visible = false;
dtstudent.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dtstudent.Refresh();
dtstudent.DataSource = null;
dtstudent.Rows.Clear();
dtstudent.Columns.Clear();


}


ClsConnection.Conn.Close();

HiIf i do that then it is giving me error
ExecuteReader requires an open and available Connection. The connection's current state is closed.

Thanks Caralin but that is not working.Can u suggest any other option?

Thanks manognya
But if i close the connection then it is giving me following error.
There is already an open DataReader associated with this Command which must be closed first.

Okay

I got the solution,it is like this
foreach (DataGridViewRow row in datagridallstudents.Rows)
{

DataGridViewCheckBoxCell cell = row.Cells["SELECT"] as DataGridViewCheckBoxCell;
//select is the header name.
ClsConnection.Conn.Close();

if (cell.Value != null)
{
MessageBox.Show(row.Cells[0].Value.ToString());
}

Thanks Pashad

Thanks pashad but i am not using aspx page i am doing standalone project so please help me in doing that.

This method is not giving the exact count .It is giving me 0 count .

Thanks Amit but there is no such event GridView1_RowDataBound
Can u tell me some other mehtod to do it.