private void getgrid(string sql)
{
try
{
//char a='"';
//char b='"';
//string x=Convert.ToString(a);
//string y=Convert.ToString(a);
//string SQL=@""+sql+"";
string strSQL ="";
DataSet datgrid=new DataSet();
strSQL="exec get_ItUser \""+sql+"\"";//这里加入双引号用 \" 不成功
datgrid = datcns.ExeDatset(strSQL);
MyDataGrid1.Dispose();
MyDataGrid1.DataSource=datgrid.Tables[0];
MyDataGrid1.DataBind();
}
catch(Exception ex)
{
WebUtil.msg(ex.ToString());
}

}
sql= " AND B.b_deliverydate>='" + stadate.Value.Trim() + "' and B.b_deliverydate<='" + endDate.Value.Trim() + "'";

get_ItUser是存储过程

在查询分析器里,语句
exec get_ItUser " AND B.b_deliverydate>='2007-08-01' and B.b_deliverydate<='2007-08-23'"

运行成功
代码里本身strSQL="exec get_ItUser ""+sql+"";但调试时显示不了
exec get_ItUser " AND B.b_deliverydate>='2007-08-01' and B.b_deliverydate<='2007-08-23'"

而是显示了exec get_ItUser AND B.b_deliverydate>='2007-08-01' and B.b_deliverydate<='2007-08-23',少了两个双引号,

所以我想在SQL语句里增加双引号.

你的是C#语言，我不知道能不能用函数（Strings.chr(34)就是双引号）来实现，如果是的话，就可以。