请帮助...我想选择“公司名称"从下拉菜单中 [英] pls help...... i want to select the "company name" from the dropdown but

问题描述

嗨

我想从下拉列表中选择公司名称"，但是……当我单击提交"按钮时，公司代码"应保存在数据库中....


请使用SqlDataAdaptor类在C#(针对Web应用程序)中提供代码.


谢谢.

解决方案

尝试一下

  strsql = "select companyname,companycode from company"

           
''execute query and save it in datatable
              dt = objdb.getTable(strsql)
          

            combo1.DataSource = dt ;
            combo1.DataValueField = tblfunction.Columns(1).Caption;
            combo1.DataTextField = tblfunction.Columns(0).Caption;
            combo1.DataBind();
            combo1.Text = "select";

它会在下拉列表中显示公司名称，并将其值显示为公司代码
对于例如
combo1.text =公司名称
combo1.SelectedValue =公司代码

在页面加载时使用此

 dropdown.DataSource = GetData();可以是数据表
dropdown.DataTextField =名称列;
dropdown.DataValueField =代码列;
dropdown.DataBind(); 

当您想使用

 字符串 company = dropdown.SelectedValue; 

公共 字符串 str = " ;

           cmd = 新 SqlCommand(str，cn);

           cmd.Parameters.Add(" ，SqlDbType.Int).Value = Convert.ToInt32( txtEmpCode.Text);
          //  cmd.Parameters.Add("@ emp_id"，SqlDbType.Int).Value = 1; 
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = txtEmpName.Text;
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = txtPwd.Text;
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = txtDomainName.Text;
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = DDLDeptName.SelectedValue;
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = DDLDeptName.Text;
           cmd.Parameters.Add(" ，SqlDbType.VarChar).Value = txtEmail.Text;
           cmd.Parameters.Add(" ，SqlDbType.Int).Value = Convert.ToInt32( DDLRole.SelectedIndex);
            cmd.Parameters.Add(" ，SqlDbType.Int).Value =转换.ToInt32(DDL_CompName.DataValueField = " );  这是我正面临问题的那一行....请告诉我在这里做什么

它 给出错误 as  " 输入的字符串格式不正确."

       cmd.ExecuteNonQuery();

           LBLSuccessfullySaved.Text = " ;

           // 调用"blankall"方法以删除所有条目
           blankall();


   } 

hi

I want to select the "company name" from the dropdown but...... "company code" should be saved in the database as i click on the submit button....


please provide the code in C# (for web application) using SqlDataAdaptor class


thanks.

解决方案

try this

  strsql = "select companyname,companycode from company"

           
''execute query and save it in datatable
              dt = objdb.getTable(strsql)
          

            combo1.DataSource = dt ;
            combo1.DataValueField = tblfunction.Columns(1).Caption;
            combo1.DataTextField = tblfunction.Columns(0).Caption;
            combo1.DataBind();
            combo1.Text = "select";

it ll display company name in drop down and value as company code
for eg
combo1.text=company name
combo1.SelectedValue = company code

On page load use this

dropdown.DataSource = GetData(); can be DataTable
dropdown.DataTextField = Name Column;
dropdown.DataValueField = Code Column;
dropdown.DataBind();

when you want to use

string company = dropdown.SelectedValue;

public void SaveDetails()
   {

       string str = "insert into temp (emp_code,emp_name,paswrd,domain_name,dpt_code,dpt_name,email,role,CompCode) values (@emp_code,@emp_name,@paswrd,@domain_name,@dpt_code,@dpt_name,@email,@role,@CompCode)";

           cmd = new SqlCommand(str, cn);

           cmd.Parameters.Add("@emp_code", SqlDbType.Int).Value = Convert.ToInt32(txtEmpCode.Text);
          // cmd.Parameters.Add("@emp_id", SqlDbType.Int).Value = 1;
           cmd.Parameters.Add("@emp_name", SqlDbType.VarChar).Value = txtEmpName.Text;
           cmd.Parameters.Add("@paswrd", SqlDbType.VarChar).Value = txtPwd.Text;
           cmd.Parameters.Add("@domain_name", SqlDbType.VarChar).Value = txtDomainName.Text;
           cmd.Parameters.Add("@dpt_code", SqlDbType.VarChar).Value = DDLDeptName.SelectedValue;
           cmd.Parameters.Add("@dpt_name", SqlDbType.VarChar).Value = DDLDeptName.Text;
           cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = txtEmail.Text;
           cmd.Parameters.Add("@role", SqlDbType.Int).Value = Convert.ToInt32(DDLRole.SelectedIndex);
           cmd.Parameters.Add("@CompCode", SqlDbType.Int).Value = Convert.ToInt32(DDL_CompName.DataValueField="comp_code");    // this is the line where i m faceing the problem.... please tell me what to do here

it is givin the error as "Input string was not in a correct format."

       cmd.ExecuteNonQuery();

           LBLSuccessfullySaved.Text = "Data Saved Successfully";

           // calling the "blankall" method to remove all the entrys
           blankall();


   }

这篇关于请帮助...我想选择“公司名称"从下拉菜单中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！