This is my
aspx.cs code for the "Application Form":
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace PrintersInkWebApplication
{
public partial class Orders : System.Web.UI.Page
{
SqlConnection con = new SqlConnection
("server=HLCLITBIRRISH\\MSSQLSERVERAYB ;Initial Catalog=PrintersInk;
User ID=asdfs;Password=2342453");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlCommand cmd_mang = new SqlCommand
("Select Mangment_Name from Employee_Data", con);
SqlDataAdapter da = new SqlDataAdapter(cmd_mang);
DataSet ds = new DataSet();
da.Fill(ds);
drpdl_mang.DataTextField =
ds.Tables[0].Columns["Mangment_Name"].ToString();
drpdl_mang.DataSource = ds.Tables[0];
drpdl_mang.DataBind();
SqlCommand cmd_dep = new SqlCommand
("Select L_nam3 from Employee_Data", con);
SqlDataAdapter dad = new SqlDataAdapter(cmd_dep);
DataSet dsd = new DataSet();
dad.Fill(dsd);
drpdl_dep.DataTextField =
dsd.Tables[0].Columns["L_nam3"].ToString();
drpdl_dep.DataSource = dsd.Tables[0];
drpdl_dep.DataBind();
SqlCommand cmd_unt = new SqlCommand
("Select L_nam4 from Employee_Data", con);
SqlDataAdapter dau = new SqlDataAdapter(cmd_unt);
DataSet dsu = new DataSet();
dau.Fill(dsu);
drpdl_unt.DataTextField =
dsu.Tables[0].Columns["L_nam4"].ToString();
drpdl_unt.DataSource = dsu.Tables[0];
drpdl_unt.DataBind();
SqlCommand cmd_pt1 = new SqlCommand
("Select O_PrinterName from Printers_Table", con);
SqlDataAdapter dp1 = new SqlDataAdapter(cmd_pt1);
DataSet dsp1 = new DataSet();
dp1.Fill(dsp1);
drpdl_pt1.DataTextField =
dsp1.Tables[0].Columns["O_PrinterName"].ToString();
drpdl_pt1.DataSource = dsp1.Tables[0];
drpdl_pt1.DataBind();
SqlCommand cmd_pt2 = new SqlCommand
("Select O_PrinterName from Printers_Table", con);
SqlDataAdapter dp2 = new SqlDataAdapter(cmd_pt1);
DataSet dsp2 = new DataSet();
dp2.Fill(dsp2);
drpdl_pt2.DataTextField =
dsp2.Tables[0].Columns["O_PrinterName"].ToString();
drpdl_pt2.DataSource = dsp2.Tables[0];
drpdl_pt2.DataBind();
SqlCommand cmd_pt3 = new SqlCommand
("Select O_PrinterName from Printers_Table", con);
SqlDataAdapter dp3 = new SqlDataAdapter(cmd_pt3);
DataSet dsp3 = new DataSet();
dp3.Fill(dsp3);
drpdl_pt3.DataTextField =
dsp3.Tables[0].Columns["O_PrinterName"].ToString();
drpdl_pt3.DataSource = dsp3.Tables[0];
drpdl_pt3.DataBind();
SqlCommand cmd_pt4 = new SqlCommand
("Select O_PrinterName from Printers_Table", con);
SqlDataAdapter dp4 = new SqlDataAdapter(cmd_pt4);
DataSet dsp4 = new DataSet();
dp4.Fill(dsp4);
drpdl_pt4.DataTextField =
dsp4.Tables[0].Columns["O_PrinterName"].ToString();
drpdl_pt4.DataSource = dsp4.Tables[0];
drpdl_pt4.DataBind();
SqlCommand cmd_pt5 = new SqlCommand
("Select O_PrinterName from Printers_Table", con);
SqlDataAdapter dp5 = new SqlDataAdapter(cmd_pt5);
DataSet dsp5 = new DataSet();
dp5.Fill(dsp5);
drpdl_pt5.DataTextField =
dsp5.Tables[0].Columns["O_PrinterName"].ToString();
drpdl_pt5.DataSource = dsp5.Tables[0];
drpdl_pt5.DataBind();
}
}
protected void imgbtn_save_Click(object sender, ImageClickEventArgs e)
{
string cbx = "";
string cbx2 = "";
if (cb_printer.Checked) cbx += "طابعة";
else
cbx += null;
if (cb_ink.Checked) cbx2 += "حبر";
else
cbx2 += null;
string sql = "insert into Oreders_Table
values(@empname,@odate,@mang,@dep,@unt,@pcheck,
@purpose,@pcolor,@numpaper,@icheck,@pt1,@pt2,@pt3,
@pt4,@pt5,@nw1,@nw2,@nw3,@nw4,@nw5)";
SqlCommand cmn_add_order = new SqlCommand(sql, con);
cmn_add_order.Parameters.AddWithValue("@empname", txt_empname.Text);
cmn_add_order.Parameters.AddWithValue("@odate", txt_date.Text);
cmn_add_order.Parameters.AddWithValue
("@mang", drpdl_mang.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@dep", drpdl_dep.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@unt", drpdl_unt.SelectedValue);
cmn_add_order.Parameters.AddWithValue("@pcheck", cbx);
cmn_add_order.Parameters.AddWithValue
("@purpose", txt_purpose.Text);
cmn_add_order.Parameters.AddWithValue
("@pcolor", rbl_pcolor.SelectedItem.Text);
cmn_add_order.Parameters.AddWithValue
("@numpaper", txt_numpaper.Text);
cmn_add_order.Parameters.AddWithValue("@icheck", cbx2);
cmn_add_order.Parameters.AddWithValue
("@pt1", drpdl_pt1.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@pt2", drpdl_pt2.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@pt3", drpdl_pt3.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@pt4", drpdl_pt4.SelectedValue);
cmn_add_order.Parameters.AddWithValue
("@pt5", drpdl_pt5.SelectedValue);
cmn_add_order.Parameters.AddWithValue("@nw1", txt_nw1.Text);
cmn_add_order.Parameters.AddWithValue("@nw2", txt_nw2.Text);
cmn_add_order.Parameters.AddWithValue("@nw3", txt_nw3.Text);
cmn_add_order.Parameters.AddWithValue("@nw4", txt_nw4.Text);
cmn_add_order.Parameters.AddWithValue("@nw5", txt_nw5.Text);
con.Open();
cmn_add_order.ExecuteNonQuery();
con.Close();
lbl_message.Text = "done";
}
}
}
What I have tried:
All the solutions that I've found are how to send plain text.