hello ...
I am executing a command using data adaptor in my application.When i use data adapter less data is displaying ..but when i execute same command in sql server all data is displaying ..
Can u please tell me why it is happening ..I am attaching code also ...
List<string> result = new List<string>();
result.Clear();
using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=chitfund1;Integrated Security=True"))
{
using (SqlCommand cmd = new SqlCommand("select DISTINCT cid from Customer where cid LIKE '%" + cid + "%'", con))
{
con.Open();
//cmd.Parameters.AddWithValue("@SearchText", cid);
// SqlDataReader dr = cmd.ExecuteReader();
DataSet ...
Go to the complete details ...