Getting "Invalid Column Name" error while getting data from database

See more:

C#

C#4.0

Hi Team,

I am making simple application in Windows based C#.

I am extracting data from database to Listview using search textbox . My table like this :-


DNO NAME EDUCATION EMAIL PHONE

100 Steve MS steve@gmail.com 123

When I put DNO value "100" in search textbox then I got data successfully in Listviw . However If I put Name value "Steve" as well as other column value then I got error "Invalid
Column Name Steve" .

Sir This is my Listview Code and Table Creation Query
private void Submit_Click(object sender, EventArgs e)
{ SqlConnection objCon = new SqlConnection("Data Source=OM-PC;Initial Catalog=master;Integrated Security=True");
SqlDataAdapter objAdapt = new SqlDataAdapter("select * from Place Where NAME="+ textBox1.Text.ToString(),
objCon); DataTable objDT = new DataTable();
objAdapt.Fill(objDT);
//now initialize listview
// Set the view to show details.
listView1.View = View.Details;
// Allow the user to edit item text.
listView1.LabelEdit = true;
// Allow the user to rearrange columns.
listView1.AllowColumnReorder = true;
// Select the item and subitems when selection is made.
listView1.FullRowSelect = true;
// Display grid lines.
listView1.GridLines = true;
// Sort the items in the list in ascending order.
// listView1.Sorting = SortOrder.Ascending;
//finally fill listview
for (int i = 0; i < objDT.Rows.Count; i++)
{ DataRow objDR = objDT.Rows[i];
ListViewItem listitem = new ListViewItem(objDR["NAME"].ToString()); listitem.SubItems.Add(objDR["Education"].ToString()); listitem.SubItems.Add(objDR["Email"].ToString()); // listitem.SubItems.Add(objDR["Phone"].ToString()); listView1.Items.Add(listitem); } }


* CREATE TABLE PLACE(DNO INT NOT NULL , NAME VARCHAR(20), EDUCATION VARCHAR(10), EMAIL NVARCHAR(20), PHONE INT ))


Please help me for this .