sql语句中c#变量的问题?

[Bmonkey]

请问在sql语句中怎么样调用c#中定义的变量?
pb中是在该变量前加一个":"号,c#中编程应该怎么写?

[jiezhi]

string mySql="insert into t_czry(yhm,xm,kl,js)values('"+Txt_ADD_YHM.Text.Trim()+"','"+Txt_ADD_XM.Text.Trim()+"','"+Txt_ADD_KL.Text.Trim()+"','专家')";

[Knight94]

例如：
string strQuery="select * from yourTable where yourField=@Field1";
SqlCommand myComm=new SqlCommand(strQuery,myConn);
myComm.Parameters.Add("@Field1",FieldValue);//进行传入参数

[LYH1977]

string strQuery.Format("Select * From TableName Where Field1='{0}'and Field2={1}",string1,int2);

[covis]

mycmd.CommandText="select count(*) as num from lvdian where lvdianbh='"+textBox1.Text.Trim()+"'";

[LiSDN]

用Parameters好點

[topsir]

SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;" +
"Initial Catalog=northwind");

SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn);

catDA.InsertCommand = new SqlCommand("InsertCategory", nwindConn);
catDA.InsertCommand.CommandType = CommandType.StoredProcedure;

SqlParameter myParm = catDA.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int);
myParm.Direction = ParameterDirection.ReturnValue;

catDA.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.NChar, 15, "CategoryName");

myParm = catDA.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID");
myParm.Direction = ParameterDirection.Output;

DataSet catDS = new DataSet();
catDA.Fill(catDS, "Categories");

DataRow newRow = catDS.Tables["Categories"].NewRow();
newRow["CategoryName"] = "New Category";
catDS.Tables["Categories"].Rows.Add(newRow);

catDA.Update(catDS, "Categories");

Int32 rowCount = (Int32)catDA.InsertCommand.Parameters["@RowCount"].Value;
好好看看上面代码,你会明白的.