string strMod = "select ModuleID,ModuleName from tb_Module" + "where ModuleName='" + ddlModuleName.SelectedValue+ "'";
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
sqlcon.Open();
SqlDataAdapter myApter = new SqlDataAdapter(strMod, sqlcon);
DataSet myDS = new DataSet();
myApter.Fill(myDS, "tb_Module");
DataRowView rowView = myDS.Tables["tb_Module"].DefaultView[0];
string strModuleID = Convert.ToString(rowView["ModuleID"]);
string sqlstr = "insert into tb_Card ([User],ModuleID,CardName,CardContent)" + "values('" + Session["UserName"].ToString().Trim() + "','" + strModuleID.ToString().Trim() + "','" + txtCardTitle.Text.Trim() + "','" + txtCardContent.Text.Trim() + "')";
SqlCommand sqlcomm = new SqlCommand(sqlstr, sqlcon);
if (sqlcomm.ExecuteNonQuery() > 0)
{
Response.Write("<script language=javascript>alert('发帖成功!');location='javascript:history.go(-1)';</script>");
}
else
{
Response.Write("<script language=javascript>alert('对不起,发帖失败!');</script>");
}
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
sqlcon.Open();
SqlDataAdapter myApter = new SqlDataAdapter(strMod, sqlcon);
DataSet myDS = new DataSet();
myApter.Fill(myDS, "tb_Module");
DataRowView rowView = myDS.Tables["tb_Module"].DefaultView[0];
string strModuleID = Convert.ToString(rowView["ModuleID"]);
string sqlstr = "insert into tb_Card ([User],ModuleID,CardName,CardContent)" + "values('" + Session["UserName"].ToString().Trim() + "','" + strModuleID.ToString().Trim() + "','" + txtCardTitle.Text.Trim() + "','" + txtCardContent.Text.Trim() + "')";
SqlCommand sqlcomm = new SqlCommand(sqlstr, sqlcon);
if (sqlcomm.ExecuteNonQuery() > 0)
{
Response.Write("<script language=javascript>alert('发帖成功!');location='javascript:history.go(-1)';</script>");
}
else
{
Response.Write("<script language=javascript>alert('对不起,发帖失败!');</script>");
}