双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒,抽取你的专属好礼

— 惊喜奖品抢先看 —

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

zjyyxxzx zjyyxxzx 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
前台
<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();




}

}



...全文

相关推荐

评论 11
收藏 已收藏
分享
返回顶部
zjyyxxzx
C# 111,129 成员 642,540 内容