PDA

View Full Version : گفتگو: مشکل در ذخیره اطلاعات



h.rezaee
چهارشنبه 23 اسفند 1391, 12:43 عصر
سلام. بنده اومدم برای برنامه یه فایل setup بسازم با کلی مشکل مواجه شدم.
مجبور شدم کانکشن رو عوض کنم و با sqlexpress بزنم. حالا مشکلم اینجاست برنامه میزنه که اطلاعات با موفقیت ثبت شد ولی تو دیتابیس هیچ چیز ثبت نمیشه!!!!!!!!!!!!!
این هم کدهام :

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.Data.SqlClient;
using System.Globalization;

namespace Fajr
{
public partial class savefrm : Form
{
public savefrm()
{
InitializeComponent();
}

private void savefrm_Load(object sender, EventArgs e)
{
PersianCalendar pc = new PersianCalendar();
int j=0;
int i = pc.GetYear(DateTime.Now) + pc.GetMonth(DateTime.Now) + pc.GetDayOfMonth(DateTime.Now) + j++;
labelX1.Text = pc.GetYear(DateTime.Now) + "/" + pc.GetMonth(DateTime.Now) + "/" + pc.GetDayOfMonth(DateTime.Now);

}

private void buttonX1_Click(object sender, EventArgs e)
{

SqlConnection objconnection = new SqlConnection(textBoxX1.Text);
DataSet das = new DataSet();
DataView objdataview = new DataView();
SqlCommand com = new SqlCommand();


if (nametxt.Text == string.Empty & lnametxt.Text == string.Empty & fnametxt.Text == string.Empty & shnumtxt.Text == string.Empty)
{
MessageBox.Show("عبارت خود را وارد کنید.");
}
else
{

objconnection.Open();
com.Connection = objconnection;
com.CommandText = "Insert INTO nametbl " +
"(idname, name, lname, fname) " +
"VALUES(@idname, @name, @lname, @fname);" +
"Insert INTO numtbl " +
"(idnum, shnum, mnum, birthday) " +
"VALUES(@idnum, @shnum, @mnum, @birthday);" +
"Insert INTO phonetbl " +
"(idphone, phonenum, mobilenum) " +
"VALUES(@idphone, @phonenum, @mobilenum);" +
"Insert INTO informationtbl " +
"(idinformation, job, education, army) " +
"VALUES(@idinformation, @job, @education, @army);" +
"Insert INTO addresstbl " +
"(idaddress, address) " +
"VALUES(@idaddress, @address);" +
"Insert INTO membertbl " +
"(idmember, dateozv, hozename, paygahname, filenum) " +
"VALUES(@idmember, @dateozv, @hozename, @paygahname, @filenum);" +
"Insert INTO codetbl " +
"(idcode, byganicode) " +
"VALUES(@idcode, @byganicode)" +
"Insert INTO maintbl " +
"(id, nameid, numid, phoneid, informationid, addressid, memberid, codeid, datasave) " +
"VALUES(@id, @nameid, @numid, @phoneid, @informationid, @addressid, @memberid, @codeid, @datasave)";
com.Parameters.AddWithValue("@idname", shparvande.Text);
com.Parameters.AddWithValue("@name", nametxt.Text);
com.Parameters.AddWithValue("@lname", lnametxt.Text);
com.Parameters.AddWithValue("@fname", fnametxt.Text);
//Insert into NUMTBL
com.Parameters.AddWithValue("@idnum", shparvande.Text);
com.Parameters.AddWithValue("@shnum", shnumtxt.Text);
com.Parameters.AddWithValue("@mnum", mnumtxt.Text);
com.Parameters.AddWithValue("@birthday", yearbirthtxt.Text + '/' + monthbirthtxt.Text + '/' + datebirthtxt.Text);
//Insert into phonenum
com.Parameters.AddWithValue("@idphone", shparvande.Text);
com.Parameters.AddWithValue("@phonenum", phonenumtxt.Text);
com.Parameters.AddWithValue("@mobilenum", mobilenumtxt.Text);
//Insert into informationtbl
com.Parameters.AddWithValue("@idinformation", shparvande.Text);
com.Parameters.AddWithValue("@job", jobtxt.Text);
com.Parameters.AddWithValue("@education", educationtxt.Text);
com.Parameters.AddWithValue("@army", armytxt.Text);
//Insert into addresstbl
com.Parameters.AddWithValue("@idaddress", shparvande.Text);
com.Parameters.AddWithValue("@address", addresstxt.Text);
//Insert into membertbl
com.Parameters.AddWithValue("@idmember", shparvande.Text);
com.Parameters.AddWithValue("@dateozv", yearozvtxt.Text + '/' + monthozvtxt.Text + '/' + dateozvtxt.Text);
com.Parameters.AddWithValue("@hozename", hozenametxt.Text);
com.Parameters.AddWithValue("@paygahname", paygahnametxt.Text);
com.Parameters.AddWithValue("@filenum", filenumtxt.Text);
//Insert into biyganicode
com.Parameters.AddWithValue("@idcode", shparvande.Text);
com.Parameters.AddWithValue("@byganicode", biyganinum.Text);
//Insert into membertbl
com.Parameters.AddWithValue("@id", shparvande.Text);
com.Parameters.AddWithValue("@nameid", shparvande.Text);
com.Parameters.AddWithValue("@numid", shparvande.Text);
com.Parameters.AddWithValue("@phoneid", shparvande.Text);
com.Parameters.AddWithValue("@informationid", shparvande.Text);
com.Parameters.AddWithValue("@addressid", shparvande.Text);
com.Parameters.AddWithValue("@memberid", shparvande.Text);
com.Parameters.AddWithValue("@codeid", shparvande.Text);
com.Parameters.AddWithValue("@datasave", labelX1.Text);


try
{
com.ExecuteNonQuery();
MessageBox.Show("اطلاعات با موفقیت ثبت شد");
}
catch(SqlException sqlERR)
{
MessageBox.Show(sqlERR.Message);
}
}

}
}
}