c#求助

zjyyxxzx 2012-05-11 02:12:31

前台有两个DROPDOWNLIST,我根据参数IDD的值0或者1来判断显示，取值，插入数据表

结果idd写进数据表了，dropdownlist的值aa却没写进去，麻烦大家帮我看看，谢谢了

代码如下
前台
<td width="183" height="28" valign="middle" >
<asp:DropDownList ID="DropDownList1"
Width="180px" Height="150px" runat="server"
DataSourceID="AccessDataSource1" DataTextField="text" DataValueField="text">

</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="App_Data/#db1.mdb" SelectCommand="SELECT [text] FROM [ts]">
</asp:AccessDataSource>

<asp:DropDownList ID="DropDownList2"
Width="180px" Height="150px" runat="server"
DataSourceID="AccessDataSource2" DataTextField="text" DataValueField="text">

</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource2" runat="server"
DataFile="App_Data/#db1.mdb" SelectCommand="SELECT [text] FROM [by]">
</asp:AccessDataSource>
</td>

后台

 

public partial class bd : System.Web.UI.Page

{



    public string aa;

    public string idd;

    public void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {



            if (Request["idd"] != null)//判断是否有接受值，如果有

            {

                idd = Request["idd"].ToString();



            }

            

             if (idd == "1")

            {

                DropDownList1.Visible = true;

                DropDownList2.Visible = false;

                aa = DropDownList1.DataValueField;





            }

            if (idd == "0")

            {

                DropDownList2.Visible = true;

                DropDownList1.Visible = false;

                aa = DropDownList2.DataValueField;





            }

            txtbt1.Text = idd;

            txtbt2.Text = DateTime.Now.ToString();







        }



    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {





        OleDbConnection conn = new OleDbConnection();

        conn.ConnectionString = "Provider = Microsoft.Jet.OleDb.4.0;" + "Data Source =" + Server.MapPath("App_Data/#db1.mdb");

        string strVal = "'" + aa + "','" + txtbt1.Text + "'";

        string strIns = "insert into tsby(tsby,type) values(" + strVal + ")";

        OleDbCommand insCom = new OleDbCommand(strIns, conn);

        OleDbDataAdapter da = new OleDbDataAdapter();

        conn.Open();

        da.InsertCommand = insCom;

        da.InsertCommand.ExecuteNonQuery();

 



   

        txtbt1.Text = "";

        txtbt2.Text = "";

        conn.Close();





    }



}