Hi Reyadh, Believe me there are A LOT !! The first one that I would like to suggest you is watching C-SharpCorner Videos on Youtube. you'll find many interesting videos on their youtube channel . Lots of other players are there in the market who offer video tutorials but I personally suggest to use Pluralsight.com. It has a plethora of tutorials of excellent quality. Visit the link below.... from C-SharpCorner Youtube channel for C# Insert, Update and Delete Operations... nice tutorial. http://www.youtube.com/watch?v=SJ-RyDl5E7U Hope this will let you Go.

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.OleDb; namespace Insert_update_delete_navigate { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; byte flag; BindingManagerBase bm; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from student"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "student"); textBox1.DataBindings.Add("Text", ds, "student.id"); textBox2.DataBindings.Add("Text", ds, "student.name"); bm = this.BindingContext[ds, "student"]; con.Close(); bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from student"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "student"); dataGridView1.DataMember = "student"; dataGridView1.DataSource = ds; con.Close(); } private void btn_first_Click(object sender, EventArgs e) { bm.Position = 0; } private void btn_next_Click(object sender, EventArgs e) { bm.Position += 1; } private void btn_previous_Click(object sender, EventArgs e) { bm.Position -= 1; } private void btn_last_Click(object sender, EventArgs e) { bm.Position = bm.Count - 1; } private void btn_add_Click(object sender, EventArgs e) { textBox1.Text = ""; textBox2.Text = ""; textBox1.Focus(); flag = 1; } private void btn_modify_Click(object sender, EventArgs e) { flag = 2; } private void btn_save_Click(object sender, EventArgs e) { if (flag == 1) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "insert into student(id,name) values (@id,@name)"; com = new OleDbCommand(str, con); com.Parameters.AddWithValue("@sid", textBox1.Text); com.Parameters.AddWithValue("@sname", textBox2.Text); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records Successfuly Inserted"); bindgrid(); } if (flag == 2) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "update student set name='" + textBox2.Text.Trim() + "' where id='" + textBox1.Text.Trim() + "'"; com = new OleDbCommand(str, con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records Successfuly Updated"); bindgrid(); } } private void btn_delete_Click(object sender, EventArgs e) { DialogResult result; result = MessageBox.Show("Are You sure want to Delete?", "Conformation", MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { OleDbConnection con = new OleDbConnection(ConnectionString); str = "delete from student where id=@id"; com = new OleDbCommand(str, con); com.Parameters.AddWithValue("@id", textBox1.Text); con.Open(); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records Successfuly Deleted"); bindgrid(); } else { MessageBox.Show("No action"); } } } }

Answers

Is there videos to learn how can I save from c# to databas?

reyadh khalifeh

12y

1.4k

1 Localization

tanks

Is there videos to learn how can I save from c# to databas?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)