السلام عليكم ورحمة الله وبركاتة هو كيف يتم حفظ بيانات لة split بس مشكلة عندى عند تقطع اسم كل اسم على حدة وعمل اختبار لذلك من خلال response.write(txtsql))تظهر لة عملية تقطع كل شى على حدة مشكلة عندى تاخذ اول اسم عند حفظ فقط وتحفظ ولا تحفظ اسم التالى مختار معا الذى عمل لة split كود هو كالتالى فماهى زيادة على هذا الكود
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["User_Type"].ToString() != "Administrator")
{
if (Session["User_Type"].ToString() == "Guest")
{
Session["redirect"] = "compise";
Response.Redirect("login.aspx");
}
else
{
string connstring = ConfigurationManager.ConnectionStrings["MailSmc"].ToString();
SqlConnection conn = new SqlConnection(connstring);
Session["redirect"] = "";
//Label1.Text = Session["User_Name"].ToString();
//dep = int.Parse(Session["dep"].ToString());
//MOHP.NICHP.fillComboBox(cmbDeprament, "select * from admin", conn, "----");
user_name=Session["User_Name"].ToString();
userid=int.Parse(Session["user_id"].ToString());
Files = Session["mail"].ToString();
Files1 = Session["mail1"].ToString();
TextBox1.Text = Files.ToString();
TextBox2.Text = Files1.ToString();
files3 = Session["mail2"].ToString();
TextBox3.Text = Session["mail2"].ToString();
//files4 = Session["mail3"].ToString();
//TextBox4.Text = Session["mail3"].ToString();
//txtSujbet.Text = Request.QueryString[2].ToString();
//txtBody.Text = Request.QueryString[0].ToString();
//attment = Request.QueryString[1].ToString();
//HyperLink1.NavigateUrl = attment;
//HyperLink1.Text = attment.Substring(attment.LastIndexOf("/") + 1);
//TextBox1.Text = Request.QueryString["Files"].ToString();
}
}
}
}
protected void sent_Click(object sender, EventArgs e)
{
userid = int.Parse(Session["user_id"].ToString());
try
{
FileUpload1.SaveAs(Server.MapPath("Mailatt") + @"\" + FileUpload1.FileName);
}
catch (Exception ex)
{
}
string[] s = new string[2];
string connstring = ConfigurationManager.ConnectionStrings["MailSmc"].ToString();
SqlConnection conn = new SqlConnection(connstring);
StringBuilder sb = new StringBuilder();
TxtSearch.Text = DateTime.Now.ToShortDateString();
string[] separator = new string[] { ";" };
string[] strspiltArr = Files.Split(separator, StringSplitOptions.RemoveEmptyEntries);
string[] strspiltArr1 = Files1.Split(separator, StringSplitOptions.RemoveEmptyEntries);
string[] strspiltArr2 = files3.Split(separator, StringSplitOptions.RemoveEmptyEntries);
//string[] strspiltArr3 = files4.Split(separator, StringSplitOptions.RemoveEmptyEntries);
string txtsql1;
for (int i = 0; i <= strspiltArr.Length - 1 && i <= strspiltArr1.Length - 1 && i <= strspiltArr2.Length-1 ; i++)
{
TxtSearch.Text = DateTime.Now.ToString();
txtsql1 = "insert into Email(Customer_ID, Mail_From1, Mail_From, codAdmn, Date, Head, Forword, Body, Attament)";
txtsql1 += " VALUES(" +userid.ToString()+",";
txtsql1 += "'" + user_name.ToString()+"',";
txtsql1 += "" + strspiltArr2+",";
txtsql1 += "" + strspiltArr1+",";
//txtsql1 += "'" + TxtSearch.Text.ToString() + "',";
txtsql1 += "CONVERT(DATETIME, '" + DateTime.Now.ToShortDateString() + "', 102),";
txtsql1 += "'" + txtSujbet.Text + "',";
txtsql1 += "'" + false + "',";
txtsql1 += "'" + txtBody.Text + ",";
TxtSearch.Text = FileUpload1.FileName;
txtsql1 += @"' , 'Mailatt/" + TxtSearch.Text + "')";
SqlCommand cmd = new SqlCommand(txtsql1, conn);
conn.Open();
cmd.ExecuteNonQuery();
Response.Redirect("Mail.aspx");
Response.Write(txtsql1);
conn.Close();
}
}