private void GetMyContactUserList()
{
try
{
//创建一个SqlConnection对象
string strCon = "Initial Catalog='HMMISDATA';Server='192.168.1.251';User ID='XQF222';Password='hao123';Persist Security Info=True";
SqlConnection myConn = new SqlConnection ( strCon ) ;
myConn.Open ( ) ;
//定义数据查询命令
SqlCommand selectCommand=myConn.CreateCommand();
selectCommand.CommandType=CommandType.Text;
selectCommand.CommandText="SELECT ID,UserQQ,RealName,isContacted,ContactQQStatus,ContactWorkStatus,ContactResult,QQFileContent,ContactUserIP,ContactTime,ContactUserName FROM ContactUserList where isContacted=1 and ContactUserName='"+GlobalUserClass.GlobalUserName+"' Order by ContactTime Desc" ;
//读取全部数据到DATASET对象中
SqlDataAdapter myAdapter = new SqlDataAdapter (selectCommand) ;
myDataSet=new DataSet();
myAdapter.Fill(myDataSet);
DataTable myDataTable=new DataTable();
myDataTable=myDataSet.Tables[0];
this.dataGrid1.SetDataBinding(myDataTable,"");
DataGridTableStyle myDataGridStyle = new DataGridTableStyle();
myDataGridStyle.MappingName =myDataTable.TableName;
//设置dataGrid样式
myDataGridStyle.RowHeadersVisible = false;
myDataGridStyle.HeaderBackColor = Color.LightSteelBlue;
myDataGridStyle.AllowSorting = false;
myDataGridStyle.HeaderBackColor = Color.FromArgb(8,36,107);
myDataGridStyle.RowHeadersVisible = false;
myDataGridStyle.HeaderForeColor = Color.White;
myDataGridStyle.HeaderFont = new System.Drawing.Font("Microsoft Sans Serif", 9F,System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
myDataGridStyle.GridLineColor = Color.DarkGray;
myDataGridStyle.PreferredRowHeight = 22;
myDataGridStyle.BackColor=Color.White;
dataGrid1.TableStyles.Add(myDataGridStyle);
//设置dataGrid列的宽度
GridColumnStylesCollection myDataGridColStyle = dataGrid1.TableStyles[0].GridColumnStyles;
myDataGridColStyle["ID"].Width = 40;
myDataGridColStyle["UserQQ"].Width = 80;
myDataGridColStyle["RealName"].Width = 80;
myDataGridColStyle["isContacted"].Width = 80;
myDataGridColStyle["ContactWorkStatus"].Width = 80;
myDataGridColStyle["ContactQQStatus"].Width = 80;
myDataGridColStyle["ContactResult"].Width = 80;
myDataGridColStyle["QQFileContent"].Width = 80;
myDataGridColStyle["ContactUserIP"].Width = 80;
myDataGridColStyle["ContactTime"].Width = 80;
myDataGridColStyle["ContactUserName"].Width = 100;
//设置dataGrid列的标题
myDataGridColStyle["ID"].HeaderText ="序号";
myDataGridColStyle["UserQQ"].HeaderText ="QQ号码";
myDataGridColStyle["RealName"].HeaderText = "真实姓名";
myDataGridColStyle["isContacted"].HeaderText ="资料状态";
myDataGridColStyle["ContactWorkStatus"].HeaderText ="联系状态";
myDataGridColStyle["ContactQQStatus"].HeaderText ="QQ状态";
myDataGridColStyle["ContactResult"].HeaderText ="工作结果";
myDataGridColStyle["QQFileContent"].HeaderText ="联系内容";
myDataGridColStyle["ContactUserIP"].HeaderText = "提交IP";
myDataGridColStyle["ContactTime"].HeaderText ="提交时间";
myDataGridColStyle["ContactUserName"].HeaderText = "提交用户";
//设置dataGrid列的显示内容 :比如设置BOOL字段显示成是或否
myConn.Close ( ) ;
}
catch ( Exception ex0 )
{
//statusBar1.Text="连接远程SQL数据库失败";
MessageBox.Show ( "连接数据库时候发生错误:" + ex0.ToString ( ) , "错误!" ) ;
}
}
{
try
{
//创建一个SqlConnection对象
string strCon = "Initial Catalog='HMMISDATA';Server='192.168.1.251';User ID='XQF222';Password='hao123';Persist Security Info=True";
SqlConnection myConn = new SqlConnection ( strCon ) ;
myConn.Open ( ) ;
//定义数据查询命令
SqlCommand selectCommand=myConn.CreateCommand();
selectCommand.CommandType=CommandType.Text;
selectCommand.CommandText="SELECT ID,UserQQ,RealName,isContacted,ContactQQStatus,ContactWorkStatus,ContactResult,QQFileContent,ContactUserIP,ContactTime,ContactUserName FROM ContactUserList where isContacted=1 and ContactUserName='"+GlobalUserClass.GlobalUserName+"' Order by ContactTime Desc" ;
//读取全部数据到DATASET对象中
SqlDataAdapter myAdapter = new SqlDataAdapter (selectCommand) ;
myDataSet=new DataSet();
myAdapter.Fill(myDataSet);
DataTable myDataTable=new DataTable();
myDataTable=myDataSet.Tables[0];
this.dataGrid1.SetDataBinding(myDataTable,"");
DataGridTableStyle myDataGridStyle = new DataGridTableStyle();
myDataGridStyle.MappingName =myDataTable.TableName;
//设置dataGrid样式
myDataGridStyle.RowHeadersVisible = false;
myDataGridStyle.HeaderBackColor = Color.LightSteelBlue;
myDataGridStyle.AllowSorting = false;
myDataGridStyle.HeaderBackColor = Color.FromArgb(8,36,107);
myDataGridStyle.RowHeadersVisible = false;
myDataGridStyle.HeaderForeColor = Color.White;
myDataGridStyle.HeaderFont = new System.Drawing.Font("Microsoft Sans Serif", 9F,System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
myDataGridStyle.GridLineColor = Color.DarkGray;
myDataGridStyle.PreferredRowHeight = 22;
myDataGridStyle.BackColor=Color.White;
dataGrid1.TableStyles.Add(myDataGridStyle);
//设置dataGrid列的宽度
GridColumnStylesCollection myDataGridColStyle = dataGrid1.TableStyles[0].GridColumnStyles;
myDataGridColStyle["ID"].Width = 40;
myDataGridColStyle["UserQQ"].Width = 80;
myDataGridColStyle["RealName"].Width = 80;
myDataGridColStyle["isContacted"].Width = 80;
myDataGridColStyle["ContactWorkStatus"].Width = 80;
myDataGridColStyle["ContactQQStatus"].Width = 80;
myDataGridColStyle["ContactResult"].Width = 80;
myDataGridColStyle["QQFileContent"].Width = 80;
myDataGridColStyle["ContactUserIP"].Width = 80;
myDataGridColStyle["ContactTime"].Width = 80;
myDataGridColStyle["ContactUserName"].Width = 100;
//设置dataGrid列的标题
myDataGridColStyle["ID"].HeaderText ="序号";
myDataGridColStyle["UserQQ"].HeaderText ="QQ号码";
myDataGridColStyle["RealName"].HeaderText = "真实姓名";
myDataGridColStyle["isContacted"].HeaderText ="资料状态";
myDataGridColStyle["ContactWorkStatus"].HeaderText ="联系状态";
myDataGridColStyle["ContactQQStatus"].HeaderText ="QQ状态";
myDataGridColStyle["ContactResult"].HeaderText ="工作结果";
myDataGridColStyle["QQFileContent"].HeaderText ="联系内容";
myDataGridColStyle["ContactUserIP"].HeaderText = "提交IP";
myDataGridColStyle["ContactTime"].HeaderText ="提交时间";
myDataGridColStyle["ContactUserName"].HeaderText = "提交用户";
//设置dataGrid列的显示内容 :比如设置BOOL字段显示成是或否
myConn.Close ( ) ;
}
catch ( Exception ex0 )
{
//statusBar1.Text="连接远程SQL数据库失败";
MessageBox.Show ( "连接数据库时候发生错误:" + ex0.ToString ( ) , "错误!" ) ;
}
}