Comments by manish7664 (Top 49 by date)

Thanks Mr RyanDev.

sir now i used this but it's also not working...
comm.CommandText = "update timeatten set timeout='" + textBox2.Text + "' where id='" + comboBox1.Text + "'";

insert query working fine-->
comm.CommandText = "insert into timeatten (id,name,timein)values('" +comboBox1.Text+"','"+textBox1.Text+"','"+textBox2.Text+"' )";

update query execute successfully but database not updated....
comm.CommandText = "update timeatten set id='" + comboBox1.Text + "' where timeout='" + textBox2.Text + "'";
please help...

thanks for reply . i had used same code in timeout button but Timeout time saving in new row.
like...
Id Name timein timeout
1 A 09:15:34 AM NULL
1 A NULL 05:17:10 PM

I want this ....
Id Name timein timeout
1 A 09:15:34 AM 05:17:10 PM

i used below code and it's working fine. Thanks once again both of you.
int comboxchoice = Convert.ToInt32(comboBox1.SelectedIndex);
command.Parameters.AddWithValue("@id", comboxchoice);
textBox1.Text = comboBox1.SelectedValue.ToString();

if i do so then what value i select from combox same value showing in taxtbox.
i want if i select 1 then manish (Column Value) should show in textbox.

i want to change the text box values according to the combo box selection.
below code Execute fine but when i select id from combobox then "System.Data.DataRowView" show in textbox instead of database value.
could you please help me what's wrong in my code....

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=MANISH-PC\SQLEXPRESS;Initial Catalog=test2.mdf;Integrated Security=True");
conn.Open();
SqlCommand command = new SqlCommand("select name from table1 where id=@id", conn);
int comboxchoice;
Int32.TryParse(comboBox1.SelectedItem.ToString(), out comboxchoice);
command.Parameters.AddWithValue("@id", comboxchoice);
SqlDataAdapter adp = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adp.Fill(ds, "table1");
textBox1.Text = comboBox1.SelectedValue.ToString();
}

now my code run successfully but i have one problem when i select id from combobox then "System.Data.DataRowView" showing in textbox instead of database value.
i request you that please tell me what mistake i am doing in code....
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=MANISH-PC\SQLEXPRESS;Initial Catalog=test2.mdf;Integrated Security=True");
conn.Open();
SqlCommand command = new SqlCommand("select name from table1 where id=@id", conn);
int comboxchoice;
Int32.TryParse(comboBox1.SelectedIndex.ToString(), out comboxchoice);
command.Parameters.AddWithValue("@id", comboxchoice);
SqlDataAdapter adp = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adp.Fill(ds, "customer");
textBox1.Text = comboBox1.SelectedValue.ToString();
}

Thanks Mr Maciej and Mr Richard. but int32.tryparse not taking here.
int comboxchoice = Int32.TryParse(comboBox1.SelectedItem.ToString());
command.Parameters.AddWithValue("@id", comboxchoice);

Mr Richard guide me how can i remove Input string was not in a correct format error

Thanks for reply. I made changes as per your suggestion but it's showing error
Error -Input string was not in a correct format.

please help

if i'nt do this then only first row save.

i have selected all field null except id and name .

s

Thanks you so much.....

Mr Raul . i need your help.
i have two form.in first form have two textbox and one find button and second form have one datagrid.
i want when i click form 1 find button then form 2 datagrid open and if i click any perticular datagrid records cell then selected record show in form 1 textbox
i use below code but not working .

// Form 1

private void cmdfind_Click(object sender, EventArgs e)
{
Form2 form2 = new Form2();
form2.Show();

}
//Form 2

private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
Form2 form2 = new Form2();
DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
form2.textBox1.Text = row.Cells[0].Value.ToString();
form2.textBox2.Text = row.Cells[1].Value.ToString();
}

Mr Nirdesh .i am not able to used textbox1 and textbox2 in form 2.
here one error coming with red bottom line -->
Error--> only assignment,call,increment,decrement,and new object expression can be used as a statement

Thanks but it's not working

Mr Arun Thanks for reply. but if i used sqldataadpter adp= new data... outside
then one error coming.

where {0}='{1}'" could you please explain..

Thanks

if i remove refreshdata() from from load then nothing show in form textbox.
now could you please tell me what's the problem.

i chked no records in database . if i remove refreshdata() from Form load then nothing show in form textbox.

hi. I have a MainForm that have some textbox and combobox and one Datagridview that datagrid linked to my database table.
i want, when i insert a new record at that time Datagridview show new record information automaticaly by Pushing the button(Save New Record.)
that's my question.

Thank you notnitrial.

it is possible to cast one control in three time .i've simple used this and it's working fine
foreach (Control cntl in this.Controls)
{
if (cntl is TextBox || cntl is ComboBox || cntl is RichTextBox)
{
cntl.Text = string.Empty;
cntl.Text = string.Empty;
cntl.Text = string.Empty;

}
}

thanks for reply . but i want to ask one thing why we can give one control in textbox,combobox and richtext.
what the differance in both condition
if (cntl is TextBox && cntl is ComboBox && cntl is RichTextBox) and
if (cntl is TextBox)
{
//code
}
if(cntl is combobox)
{
//code

if (cntl is richtextbox )
{//code
}

Unable to cast object of type 'System.Windows.Forms.TextBox' to type 'System.Windows.Forms.ComboBox

not working...

Thanks Mr Marcin .your code working fine. but i want to ask one thing you also using same controls (cntl) in multiple if condition.

you also doing same thing . the diff. is you are giving same condition in multiple if block.

i am newly in c#. could you please tell me how can move records without using [i].
Thanks in advance

Mr Jawad first thanks for your reply. could you please explain wht's the differance if i declare "datatable tbl= new datatable()" inside of form block or declare inside of button_click block.

5 records in mydatabase.

no error. 2nd form successfully loaded but records not showing from database to form textbox.

Thank You