how to search name by giving a single letter

your query should be like
SELECT * where name like '"+name+"%'

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

string sql = SELECT * FROM TableName WHERE Name LIKE ' " + name + "%' ".

Also above query could be a candidate for sql injection. Use command with parameters while forming query which needs runtime inputs as shown below:

string name = txtName.Text + " %";
string connectionString = ConsoleApplication1.Properties.Settings.Default.ConnectionString;

using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM TableName WHERE Name LIKE @Name", connection))
{
command.Parameters.Add(new SqlParameter("Name", name));

SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
int column1 = reader.GetInt32(0);
------------------------------------
}
}
}

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Thank u all

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator