Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
why this message??? But every thing sound correct!
Mfwamba Tshimanga
Jul 3 2014 9:17 PM
1.2k
Reply
Hi!
I wrote these codes to make filter from my textbox.... At the same time we can observ records be filtered inside of the datagrid. unfortunatly I receive this message
Cannot implicitly convert type 'System.Data.CommandType' to 'string'
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection(@"Data Source=localhost\\sqlexpress;Initial Catalog=master;Integrated Security=True");
public Form1()
{
InitializeComponent();
}
private void textBox1_KeyUp(object sender, KeyEventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText =
CommandType.Text;
// the bug it's here
cmd.CommandText = "select * from consultoria where produto like ('"+textBox1.Text+"%')";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
dataGridView1.DataSource = dt;
}
}
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Reportviewer on one textbox
Regarding Sql error code