如何把這個查詢變成一個類以便其它程式呼叫,這個類如何寫以及呼叫。
程式如下：textBox1 輸入文字，以textBox1中的文字查詢表中含有的該文字的欄位
//查詢按鈕單擊事件
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
string connStr = "Data Source=.;Initial Catalog=test;User ID=sa;Password=root";
SqlConnection conn = null;
try
{
conn = new SqlConnection(connStr);
conn.Open();
string sql = "select * from course where name like '%“+ textBox1.Text.Trim() +"%'";
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show("出現錯誤！" + ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
}
uj5u.com熱心網友回復：
public void SqlQuery(string where)
{
string connStr = "Data Source=.;Initial Catalog=test;User ID=sa;Password=root";
SqlConnection conn = null;
try
{
conn = new SqlConnection(connStr);
conn.Open();
string sql = "select * from course where name like '%“+ where +" % '";
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show("出現錯誤！" + ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
uj5u.com熱心網友回復：
public class ADC
{
public static void SqlQuery(string where)
{
........
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
ADC.SqlQuery(textBox1.Text.Trim());
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/195674.html
標籤：C#