Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection con = new SqlConnection("Data source=(local);initial catalog=HesabDariDB;integrated security=true");
- SqlCommand cmd = new SqlCommand();
- private void FrmTanzimat_Load(object sender, EventArgs e)
- {
- }
- private void btnSave_Click(object sender, EventArgs e)
- {
- cmd.Connection = con;
- cmd.Parameters.Clear();
- cmd.CommandText = "insert into Tanzimat (NameFroshqah,Tel,Mobile,Address.Tozih)values(@a,@b,@c,@d,@e)";
- cmd.Parameters.AddWithValue("@a", txtNameFroshgah.Text);
- cmd.Parameters.AddWithValue("@b", txtTel.Text);
- cmd.Parameters.AddWithValue("@c", txtMobile.Text);
- cmd.Parameters.AddWithValue("@d", txtAddress.Text);
- cmd.Parameters.AddWithValue("@e", txtTozih.Text);
- con.Open();
- cmd.ExecuteNonQuery();
- con.Close();
- MessageBox.Show("done");
- }
- }
- CREATE TABLE [dbo].[Tanzimat] (
- [idTanzimat] INT IDENTITY (1, 1) NOT NULL,
- [NameFroshgah] NVARCHAR (50) NULL,
- [Tel] NVARCHAR (50) NULL,
- [Mobile] NVARCHAR (50) NULL,
- [Address] NVARCHAR (MAX) NULL,
- [Tozih] NVARCHAR (MAX) NULL,
- CONSTRAINT [PK_Tanzimat] PRIMARY KEY CLUSTERED ([idTanzimat] ASC)
- );
Add Comment
Please, Sign In to add comment