Hi,
i have a form like ordersearch and in that one button named like search.after run the application when i was click on the search button it displays the data.without enter the orderno in the specified textbox.
private void btn_search_Click(object sender, EventArgs e)
{
//MessageBox .Show ("");
SqlConnection con = new SqlConnection("data source=mars-104;initial catalog=marsweb;integrated security=true");
SqlCommand cmd = new SqlCommand("select compname,compaddress,invoiceno,orderno,convert(varchar,ondate,105)as [ondate],convert(varchar,invoicedate,105)as [invoicedate],amountstatus,netamount,netvat,tamount from tbl_report2 where orderno=@orderno", con);
con.Open();
cmd.Parameters.AddWithValue("@orderno", txt_orderno.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
con.Close();
}
else
{
//GridView1.Controls.Clear();
GridView1.DataSource = null;
MessageBox.Show("sorry no data availlable");
}
}
private void txt_orderno_TextChanged(object sender, EventArgs e)
{
GridView1.Controls.Clear();
}
private void OrderSearch_Load(object sender, EventArgs e)
{
//GridView1.Controls.Clear();
//txt_orderno.Focus();
}
}
Best,
Sudheep.