110,566
社区成员
发帖
与我相关
我的任务
分享
string name = this.lbl_welcome.Text;
//创建连接字符串
string conn = "server=.;user id=sa;pwd=wokofo;database=wkf_oa";
SqlConnection con = new SqlConnection(conn);
//创建SQL语句
string sql = string.Format("select a.comname as [公司名称],b.lianxi as [联系人],b.owner as [拥有人] from wkf_crm_news b left join wkf_crm_comname a on a.cataid=b.cataid where isdelete=0 and owner='{0}'",name);
//初始化dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, con);
//初始化dataset
DataSet ds = new DataSet();
//填充dataset
da.Fill(ds, "");//这里不知道些那个表名
this.dgv_Info.DataSource = ds.Tables("");//这里也不知道写那个表名
private void Form2_Load(object sender, EventArgs e)
{
this.skinEngine1.SkinFile = "./skin/MSN.ssk";
this.ActiveControl = text_Mail_F;
//绑定datagrivdview
string name = this.lbl_welcome.Text;
//创建连接字符串
string conn = "server=.;user id=sa;pwd=wokofo;database=wkf_oa";
SqlConnection con = new SqlConnection(conn);
//创建SQL语句
string sql ="select a.comname ,b.lianxi,b.owner from wkf_crm_news b left join wkf_crm_comname a on a.cataid=b.cataid where isdelete=0 and owner='zengjuan.li'";
con.Open();
//初始化dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, con);
//初始化dataset
DataSet ds = new DataSet();
//填充dataset
da.Fill(ds);
this.dgv_Info.DataSource = ds;
private void Form2_Load(object sender, EventArgs e)
{
this.skinEngine1.SkinFile = "./skin/MSN.ssk";
this.ActiveControl = text_Mail_F;
//绑定datagrivdview
string name = this.lbl_welcome.Text;
//创建连接字符串
string conn = "server=.;user id=sa;pwd=wokofo;database=wkf_oa";
SqlConnection con = new SqlConnection(conn);
//创建SQL语句
string sql ="select a.comname ,b.lianxi,b.owner from wkf_crm_news b left join wkf_crm_comname a on a.cataid=b.cataid where isdelete=0 and owner='zengjuan.li'";
con.Open();
//初始化dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, con);
//初始化dataset
DataSet ds = new DataSet();
//填充dataset
da.Fill(ds);
this.dgv_Info.DataSource = ds.Tables[0];
private void Form2_Load(object sender, EventArgs e)
{
this.skinEngine1.SkinFile = "./skin/MSN.ssk";
this.ActiveControl = text_Mail_F;
//绑定datagrivdview
string name = this.lbl_welcome.Text;
//创建连接字符串
string conn = "server=.;user id=sa;pwd=wokofo;database=wkf_oa";
SqlConnection con = new SqlConnection(conn);
//创建SQL语句
string sql ="select a.comname ,b.lianxi,b.owner from wkf_crm_news b left join wkf_crm_comname a on a.cataid=b.cataid where isdelete=0 and owner='zengjuan.li'";
con.Open();
//初始化dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, con);
//初始化dataset
DataSet ds = new DataSet();
//填充dataset
da.Fill(ds,"abc");
this.dgv_Info.DataSource = ds.Tables["abc"];
//窗体加载
private void PhotoShow_Load(object sender, EventArgs e)
{
dbs.DataSource = dbLists().Tables["tables"];
}
private static string dbconn = "server=.;database=ImgWindb;uid=sa;pwd=";
public DataSet dbLists()
{
DataSet ds = new DataSet();
SqlDataAdapter sda;
string sql = "select id,imgname from img";//这里是查询数据表的语句 表名是 img
sda = new SqlDataAdapter(sql, new SqlConnection(dbconn));
sda.Fill(ds, "tables");//这里的表名是自定义的!
return ds;
}