现在有两个值插不进去，"IDD","aa" 麻烦大家帮忙看看

zjyyxxzx 2012-05-09 05:00:32

前台
<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 string ksmc;

    public string brxm;

    public string jtdh;

    public string ygbh;

    public string ygxm;

    public string times;

    public void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {



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

            {

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



            }

            

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

            {

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



            }

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

            {

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

            }

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

            {

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

            }

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

            {

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

            }

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

            {

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

            }



            if (idd == "1")

            {

                DropDownList1.Visible = true;

                DropDownList2.Visible = false;

                Image9.Visible = true;

                Image2.Visible = false;

                aa = DropDownList1.DataValueField;





            }

            if (idd == "0")

            {

                DropDownList2.Visible = true;

                DropDownList1.Visible = false;

                Image2.Visible = true;

                Image9.Visible = false;

                aa = DropDownList2.DataValueField;





            }

            txtbt1.Text = ksmc;

            txtbt2.Text = ygxm;

            txtbt3.Text = ygbh;

            txtbt4.Text = brxm;

            txtbt5.Text = jtdh;

            txtbt6.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 = "'" + txtbt1.Text + "','" + txtbt2.Text + "','" + txtbt3.Text + "','" + txtbt4.Text + "','" + txtbt5.Text + "','" + txtbt6.Text + "','" + aa + "','" + idd + "'";

        string strIns = "insert into tsby(ksmc,ygxm,ygbh,brxm,jtdh,tstime,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 = "";

        txtbt3.Text = "";

        txtbt4.Text = "";

        txtbt5.Text = "";

        txtbt6.Text = "";

        conn.Close();









    }



}