110,538
社区成员
发帖
与我相关
我的任务
分享
string cmdstr = "select id,Uname,Upwd,CreatTime from Users";
string connstr = @" server =**;database = ** ; uid = sa; pwd = sa";
try
{
SqlDataAdapter oda = new SqlDataAdapter(cmdstr, connstr);
DataSet ds = new DataSet();
oda.Fill(ds, "test");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//设置标题文本位置
dataGridView1.DefaultCellStyle.ForeColor = Color.Blue;//设置前景色
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //设置列标头高度
dataGridView1.ColumnHeadersHeight = 35;//设置列标头高度
dataGridView1.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;//设置列文本自动换行
dataGridView1.Columns[0].ToolTipText = "ID";
dataGridView1.Columns[1].ToolTipText = "用户帐号";
dataGridView1.Columns[2].ToolTipText = "用户密码";
dataGridView1.Columns[3].ToolTipText = "创建日期";
dataGridView1.Columns[0].HeaderCell.Value = "ID";
dataGridView1.Columns[0].Width = Convert.ToInt16(0);
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].HeaderCell.Value = "帐 号";
dataGridView1.Columns[1].Width = Convert.ToInt16(70);
dataGridView1.Columns[2].HeaderCell.Value = "密 码";
dataGridView1.Columns[2].Width = Convert.ToInt16(70);
dataGridView1.Columns[3].HeaderCell.Value = "创建日期";
dataGridView1.Columns[3].Width = Convert.ToInt16(100);
dataGridView1.Columns[3].ReadOnly = true;
}
catch
{
MessageBox.Show("读取失败.....", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
<%="课程"+int.parse(Eval("t1").ToString()).ToString()%>