本文整理汇总了C#中Connection.sqlQuery方法的典型用法代码示例。如果您正苦于以下问题：C# Connection.sqlQuery方法的具体用法？C# Connection.sqlQuery怎么用？C# Connection.sqlQuery使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Connection的用法示例。
在下文中一共展示了Connection.sqlQuery方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GenerateGrid
private void GenerateGrid(DataTable dt)
{
String grid = "";
String sql = "";
conn = new Connection(System.Configuration.ConfigurationManager.ConnectionStrings["ConStrLANDCOMPLocal2"].ToString());
if ((Session["usersWilay"] is object) && (Session["userID"] is object))
{
wilayah = "0" + Session["usersWilay"].ToString();
user = Session["userID"].ToString();
}
try
{
sql = "DECLARE @LookupType varchar(10); SET @LookupType='"+lt+"'; "
+ "DECLARE @LookupParams varchar(1000); SET @LookupParams='" + lps + "'; "
+ "DECLARE @LookupSearch varchar(1000); SET @LookupSearch='" + ls + "'; "
+ "DECLARE @LookupWilayah varchar(10); SET @LookupWilayah='" + wilayah + "'; "
+ "EXEC landcomp.[c_lookup] "
+ "@LookupType"
+ ",@LookupParams"
+ ",@LookupSearch"
+ ",@LookupWilayah"
+ "";
dt = conn.sqlQuery(sql);
grid = "<rows>" + grid + GenerateHead(dt);
grid = grid + GenerateContent(dt) + "</rows>";
Response.ContentType = "application/xhtml+xml";
//Response.ContentType = "text/plain"; // for debuging
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write(grid);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Response.End();
}示例2: ServiceSelect
private bool ServiceSelect(string sm)
{
String sql = "";
conn = new Connection(System.Configuration.ConfigurationManager.ConnectionStrings["ConStrLANDCOMPLocal2"].ToString());
DataTable dt = new DataTable();
switch (sm)
{
case "l":
sql = "SELECT codessHeadss, codessCodess, codessDescs1, codessDescs2, codessStatss "
+" from almis.CODESS where codessCodess=0"
+ "";
dt = conn.sqlQuery(sql);
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
for (int i = 0; i < dt.Rows.Count; i++)
{
Response.Write("<row id=\"" + RemoveWhiteSpace(dt.Rows[i]["codessHeadss"].ToString()) + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessHeadss"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs2"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessStatss"].ToString()) + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
conn.myConnectionClose();
Response.End();
return false;
case "li":
idcodehead.Value = Request.Params["id"].ToString();
String idrow = Request.Params["id"].ToString();
sql = "SELECT codessHeadss,codessCodess,ISNULL(codessDescs1,'') codessDescs1,ISNULL(codessDescs2,'') codessDescs2,codessStatss FROM almis.CODESS where codessStatss!=0 and codessHeadss=" + idrow
+ "ORDER BY codessCodess";
dt = conn.sqlQuery(sql);
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
for (int i = 0; i < dt.Rows.Count; i++)
{
Response.Write("<row id=\"" + dt.Rows[i]["codessCodess"].ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>");
Response.Write("<cell>" + dt.Rows[i]["codessCodess"].ToString() + "</cell>");
Response.Write("<cell>" + dt.Rows[i]["codessDescs1"].ToString() + "</cell>");
Response.Write("<cell>" + dt.Rows[i]["codessDescs2"].ToString() + "</cell>");
Response.Write("<cell>" + dt.Rows[i]["codessStatss"].ToString() + "</cell>");
Response.Write("<cell>" + dt.Rows[i]["codessHeadss"].ToString() + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
conn.myConnectionClose();
Response.End();
return false;
case "s":
String id = Request.Params["id"].ToString();
sql = "SELECT codessHeadss,codessCodess,codessDescs1,codessDescs2,codessStatss FROM almis.CODESS where codessHeadss=" + Request.Params["codeid"].ToString()
+ " and codessCodess= " + id
+ "";
dt = conn.sqlQuery(sql);
Response.ContentType = "text/plain";
Response.Write(dt.Rows[0]["codessHeadss"].ToString() + "|");
Response.Write((dt.Rows[0]["codessCodess"].ToString()) + "|");
Response.Write((dt.Rows[0]["codessDescs1"].ToString()) + "|");
Response.Write(dt.Rows[0]["codessDescs2"].ToString() + "|");
Response.Write(dt.Rows[0]["codessStatss"].ToString());
dt.Dispose();
conn.myConnectionClose();
Response.End();
return false;
case "i":
String tipe = Request.Params["tipe"].ToString();
String codehead = Request.Params["id"].ToString();
String idcodes = Request.Params["idcodes"].ToString();
String codessDescs1 = Request.Params["codessDescs1"].ToString();
String codessDescs2 = Request.Params["codessDescs2"].ToString();
string user = (string)Session["userID"].ToString();
String output = "";
String idCLS = Request.Params["id"].ToString();
Response.ContentType = "text/plain";
if (tipe == "1")
{
sql = @"select codessCodess from almis.CODESS where codessHeadss='" + codehead + @"'
and codessDescs1='" + codessDescs1 + "' ";
DataTable dt0 = new DataTable();
dt0 = conn.sqlQuery(sql);
output = dt0.Rows.Count.ToString();
if (output != "0")
Response.Write("Nama Item tidak boleh sama");
}
//.........这里部分代码省略.........