程序段://绑定DATAGRID
//连接数据库
myConnection = new System.Data.SqlClient.SqlConnection
(System.Configuration.ConfigurationSettings.AppSettings["connectionstring"]);//connectionstring是在WEB.CONFIG中设定的,这样不用每段程序都修改
myConnection.Open(); myDataSet = new System.Data.DataSet();
myDataSet.CaseSensitive = true; myCommand = new System.Data.SqlClient.SqlCommand();
myCommand.Connection = myConnection; myCommand.CommandText = "Select ptf_ptfinfo.cptf_no as PTF编号," +
"ptf_system.csys_cname as 系统名称," +
"ptf_ptfinfo.cptf_manager as 负责人," +
"convert(char(10),ptf_ptfinfo.dptf_testsend,120) as 发送测试日期," +
"convert(char(10),ptf_ptfinfo.dptf_testend,120) as 要求测毕日期," +
"ptf_level.cptf_levelname as 紧急程度," +
"ptf_state.cptf_statename as 状态" +
" from ptf_ptfinfo,ptf_level,ptf_state,ptf_system" +
" where ptf_ptfinfo.cptf_level = ptf_level.cptf_level" +
" and ptf_ptfinfo.csys_no = ptf_system.csys_no" +
" and ptf_ptfinfo.cptf_state = ptf_state.cptf_state" +
" and ptf_ptfinfo.cptf_state <> '0'" +
" and ptf_ptfinfo.cptf_state <> '4'" +
" order by ptf_ptfinfo.cptf_no"; dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = myCommand;
dataAdapter.TableMappings.Add("Table","ptf_ptfinfo");
dataAdapter.Fill(myDataSet); DataGrid_undispose.DataSource = myDataSet.Tables["ptf_ptfinfo"].DefaultView;
DataGrid_undispose.DataBind();
//web.config<configuration> <appSettings>
<add key="connectionstring" value="server=localhost;uid=sa;pwd=password;database=ptfdata" />
</appSettings>
//连接数据库
myConnection = new System.Data.SqlClient.SqlConnection
(System.Configuration.ConfigurationSettings.AppSettings["connectionstring"]);//connectionstring是在WEB.CONFIG中设定的,这样不用每段程序都修改
myConnection.Open(); myDataSet = new System.Data.DataSet();
myDataSet.CaseSensitive = true; myCommand = new System.Data.SqlClient.SqlCommand();
myCommand.Connection = myConnection; myCommand.CommandText = "Select ptf_ptfinfo.cptf_no as PTF编号," +
"ptf_system.csys_cname as 系统名称," +
"ptf_ptfinfo.cptf_manager as 负责人," +
"convert(char(10),ptf_ptfinfo.dptf_testsend,120) as 发送测试日期," +
"convert(char(10),ptf_ptfinfo.dptf_testend,120) as 要求测毕日期," +
"ptf_level.cptf_levelname as 紧急程度," +
"ptf_state.cptf_statename as 状态" +
" from ptf_ptfinfo,ptf_level,ptf_state,ptf_system" +
" where ptf_ptfinfo.cptf_level = ptf_level.cptf_level" +
" and ptf_ptfinfo.csys_no = ptf_system.csys_no" +
" and ptf_ptfinfo.cptf_state = ptf_state.cptf_state" +
" and ptf_ptfinfo.cptf_state <> '0'" +
" and ptf_ptfinfo.cptf_state <> '4'" +
" order by ptf_ptfinfo.cptf_no"; dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = myCommand;
dataAdapter.TableMappings.Add("Table","ptf_ptfinfo");
dataAdapter.Fill(myDataSet); DataGrid_undispose.DataSource = myDataSet.Tables["ptf_ptfinfo"].DefaultView;
DataGrid_undispose.DataBind();
//web.config<configuration> <appSettings>
<add key="connectionstring" value="server=localhost;uid=sa;pwd=password;database=ptfdata" />
</appSettings>
表名字叫loaduserinfo 字段 username password最好能给我解释一下你们给我的语句,上面这个仁兄,
噼里啪啦一堆代码,我是初学,看不明白的,
帮帮我啊,耐心点,好人会有好报的,哈哈
SqlConnection sqlcon=new SqlConnection(sqltxt);
try
{
sqlcon.Open();
SqlCommand sqlcom=new SqlCommand("select * from product_class where fatherid='5'",sqlcon);
SqlDataReader dr=sqlcom.ExecuteReader();
while(dr.Read())
{
comboBox10.Items.Add(dr.GetValue(2).ToString());
}
}
catch(System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlcon.Close();
}