نوشته شده توسط
hamid67fathi
دوست عزيز لطفاً کدت رو بزار ، شايد گذاشتن کل متن خطا هم مفيد باشه.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;
using System.Globalization;
using System.Runtime.InteropServices;
namespace WindowsFormsApplication5
{
public partial class Form2 : Form
{
string strCon;
string strSQL;
SqlCommand cmd;
SqlConnection con;
SqlDataAdapter dataAdapter;
SqlCommandBuilder commandBuilder;
DataTable table;
BindingSource dbBindSource;
int ReportIndex;
bool RestoreFlag1;
bool RestoreFlag2;
bool UpdataFlage1;
bool UpdataFlage2;
bool UpdataFlage3;
bool DeleteListFlag1;
bool DeleteListFlag2;
bool DeleteSysFlag1;
bool DeleteSysFlag2;
bool DeleteSysFlag3;
string LocationPic;
public Form2()
{
InitializeComponent();
}
private void taghvim()
{
string[] week = { "شنبه", "يك شنبه", "دوشنبه", "سه شنبه", "چهار شنبه", "پنج شنبه", "جمعه" };
string[] months = { "فروردين", "ارديبهشت", "خرداد", "تير", "مرداد", "شهريور", "مهر", "آبان", "آذر", "دي", "بهمن", "اسفند" };
short d = 0;
DateTime a = DateTime.Now;
DayOfWeek tempdayofweek = a.DayOfWeek;
switch (tempdayofweek)
{
case DayOfWeek.Saturday: d = 0; break;
case DayOfWeek.Sunday: d = 1; break;
case DayOfWeek.Monday: d = 2; break;
case DayOfWeek.Tuesday: d = 3; break;
case DayOfWeek.Wednesday: d = 4; break;
case DayOfWeek.Thursday: d = 5; break;
case DayOfWeek.Friday: d = 6; break;
}
label26.Text = week[d];
}
private void Form2_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'database1DataSet7.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter5.Fill(this.database1DataSet 7.book1);
// TODO: This line of code loads data into the 'database1DataSet5.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter4.Fill(this.database1DataSet 5.book1);
// TODO: This line of code loads data into the 'database1DataSet4.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter3.Fill(this.database1DataSet 4.book1);
// TODO: This line of code loads data into the 'database1DataSet3.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter2.Fill(this.database1DataSet 3.book1);
// TODO: This line of code loads data into the 'database1DataSet2.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter1.Fill(this.database1DataSet 2.book1);
// TODO: This line of code loads data into the 'database1DataSet1.book1' table. You can move, or remove it, as needed.
this.book1TableAdapter.Fill(this.database1DataSet1 .book1);
comboBox1.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox1.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox2.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox2.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox3.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox3.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox4.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox4.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox5.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox5.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox6.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox6.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox7.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox7.SelectedItem = "..مورد مناسب را انتخاب کنید";
comboBox8.Items.Add("..مورد مناسب را انتخاب کنید");
comboBox8.SelectedItem = "..مورد مناسب را انتخاب کنید";
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new CultureInfo("FA"));
PersianCalendar pc = new PersianCalendar();
int year = pc.GetYear(DateTime.Now);
int month = pc.GetMonth(DateTime.Now);
int day = pc.GetDayOfMonth(DateTime.Now);
label22.Text = year + "/" + month + "/" + day;
taghvim();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox9.Text == "" || maskedTextBox1.Text == "" || maskedTextBox2.Text == "0000/00/00" || maskedTextBox3.Text == "0000/00/00" || maskedTextBox5.Text == "0000/00/00" || textBox6.Text == "" || textBox10.Text == "" || textBox11.Text == "" || comboBox8.Text == "" || textBox14.Text == "" || comboBox2.Text == "" || textBox7.Text == "" || textBox12.Text == "" || maskedTextBox4.Text == "0000/00/00")
MessageBox.Show("فیلدهای خالی و گزینه های انتخاب را پر کنید ", "پیغام سیستم", MessageBoxButtons.OK, MessageBoxIcon.Information);
/* ------------------------------*/
else if (MessageBox.Show("آیا مایل به ذخیره اطلاعات هستید؟", "پیغام سیستم", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\database1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
string x = textBox1.Text;
string a = textBox2.Text;
string b = textBox3.Text;
string c = comboBox1.SelectedItem.ToString();
string d = comboBox3.SelectedItem.ToString();
string y = comboBox2.SelectedItem.ToString();
string ab = comboBox6.SelectedItem.ToString();
string ac = comboBox7.SelectedItem.ToString();
string ad = comboBox8.SelectedItem.ToString();
string ae = textBox14.Text;
int x1 = int.Parse(textBox10.Text);
int x2 = int.Parse(textBox11.Text);
int x3 = int.Parse(textBox12.Text);
string h1 = maskedTextBox4.Text;
string g1 = textBox15.Text;
string g2 = textBox16.Text;
string f = textBox4.Text;
int g = int.Parse(textBox5.Text.Trim());
string h = maskedTextBox1.Text;
string i = maskedTextBox2.Text;
string j = maskedTextBox3.Text;
string k = comboBox4.SelectedItem.ToString();
string l = comboBox5.SelectedItem.ToString();
int p = int.Parse(textBox9.Text);
string q = maskedTextBox5.Text;
int w = int.Parse(textBox6.Text);
int sa = int.Parse(textBox7.Text);
/* SqlCommand cm = new SqlCommand("select priod from book1");
cm.Connection = con;
con.Open();
SqlDataReader sdr = cm.ExecuteReader();
while (sdr.Read())
{
aa += int.Parse(sdr["priod"].ToString());
}
con.Close();
if (comboBox1.SelectedItem == "see" && aa > 30)
MessageBox.Show("!به اتمام رسیدن استراحت ", "پیغام سیستم", MessageBoxButtons.OK, MessageBoxIcon.Information);*/
string cmd2 = string.Format(" INSERT INTO book1 (id,name,family,[user],sex,yegan,ill,priod,date1,date2,date3,free,darman ,[current],num,dateday,doctor,status,submit,subfree,nofree,n umrade,daterade,sader,kom,khala,sum) values ({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8 }','{9}','{10}','{11}','{12}','{13}','{14}','{15}' ,'{16}','{17}','{18}','{19}','{20}','{21}','{22}', '{23}','{24}','{25}','{26}')", x, a, b, c, d, y, f, g, h, i, j, k, l, w, p, q, ab, ac, ad, x1, x2, x3, h1, ae, g1, g2, sa);
cmd.CommandText = cmd2;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show(textBox2.Text + " " + textBox3.Text + " " + " با شماره شناسایی " + " " + textBox1.Text + " " + "با موفقيت اضافه شد ");
if (MessageBox.Show("آیا مایل به صدور گواهی هستید؟", "چاپ گواهی", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
reoform rep = new reoform();
rep.Show();
this.Hide();
}
}
}