?? dataoperate.cs
字號:
?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// DataOperate 的摘要說明
/// </summary>
public class DataOperate
{
public DataOperate()
{
}
DataCon dataCon = new DataCon();
public bool DataCom(string sqlstr)
{
SqlConnection sqlconn = dataCon.getCon();
sqlconn.Open();
SqlCommand sqlcomm = new SqlCommand(sqlstr, sqlconn);
try
{
sqlcomm.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
sqlconn.Close();
}
}
public bool gvBind(GridView gv, string sqlstr)
{
SqlConnection sqlconn = dataCon.getCon();
sqlconn.Open();
SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstr, sqlconn);
DataSet mydataset = new DataSet();
sqldataadapter.Fill(mydataset);
gv.DataSource = mydataset;
try
{
gv.DataBind();
return true;
}
catch
{
return false;
}
finally
{
sqlconn.Close();
}
}
public bool dataBind(DataList dl,string sqlstr)
{
SqlConnection sqlconn = dataCon.getCon();
sqlconn.Open();
SqlDataAdapter myadapter = new SqlDataAdapter(sqlstr, sqlconn);
DataSet mydataset = new DataSet();
myadapter.Fill(mydataset);
dl.DataSource = mydataset;
try
{
dl.DataBind();
return true;
}
catch
{
return false;
}
finally
{
sqlconn.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -