C# windows form tutorial insert/save text-box data to MS SQL database

stat

SqlConnection konekcija = new SqlConnection(" ");
konekcija.Open();
SqlCommand komanda = new SqlCommand("SELECT TOP(5) Univerzitet,count(IgracID) as [Broj Igraca] FROM dbo.Igrac INNER JOIN dbo.Univerzitet ON dbo.Igrac.UnvID = dbo.Univerzitet.UnvID group by Univerzitet order by [Broj Igraca] desc", konekcija);
SqlDataAdapter da = new SqlDataAdapter(komanda);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
konekcija.Close();
Chart1.DataSource = dt;
Chart1.Series["Series1"].XValueMember = "Univerzitet";
Chart1.Series["Series1"].YValueMembers = "Broj Igraca";

***izmena

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection konekcija = new SqlConnection(" ");
konekcija.Open();
SqlCommand komanda = new SqlCommand("UPDATE Igrac SET Ime = @Ime,UnvID=@UnvID,TimID=@TimID WHERE IgracID = @IgracID", konekcija);
komanda.Parameters.AddWithValue("@IgracID", Convert.ToInt32(DropDownList1.SelectedValue));
komanda.Parameters.AddWithValue("@Ime", TextBox1.Text);
komanda.Parameters.AddWithValue("@UnvID", Convert.ToInt32(DropDownList2.SelectedValue));
komanda.Parameters.AddWithValue("@TimID", Convert.ToInt32(DropDownList3.SelectedValue));
komanda.ExecuteNonQuery();
konekcija.Close();
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection konekcija = new SqlConnection(" ");
konekcija.Open();
SqlCommand komanda = new SqlCommand("SELECT * FROM Igrac WHERE IgracID = @IgracID", konekcija);
komanda.Parameters.AddWithValue("@IgracID", Convert.ToInt32(DropDownList1.SelectedValue));
SqlDataAdapter da = new SqlDataAdapter(komanda);
DataTable dt = new DataTable();
da.Fill(dt);
TextBox1.Text = dt.Rows[0][1].ToString();
DropDownList2.SelectedValue = dt.Rows[0][2].ToString();
DropDownList3.SelectedValue = dt.Rows[0][3].ToString();
konekcija.Close(); ;
}

SqlConnection konekcija = new SqlConnection();
konekcija.ConnectionString = @" ";
konekcija.Open();
SqlCommand komanda = new SqlCommand();
komanda.Connection = konekcija;
komanda.CommandText = "INSERT INTO Igrac VALUES(@id,@ime,@idu,@idt)";

komanda.Parameters.AddWithValue("@id", Convert.ToInt32(TextBox1.Text));
komanda.Parameters.AddWithValue("@ime", (TextBox2.Text));
komanda.Parameters.AddWithValue("@idu", Convert.ToInt32(DropDownList1.SelectedValue));
komanda.Parameters.AddWithValue("@idt", Convert.ToInt32(DropDownList2.SelectedValue));

komanda.ExecuteNonQuery();
konekcija.Close();

Thanks so much!

Add videos for Update, access and Delete in C# windows form app

Thank you so so so much kind human , ive been banging my head against a wall for days trying to figure this out.

Thanks a lot sir!

data is not saving only showing saved message

Works great, but what if a textbox has a single qoute in it like O'Brian. I get an error when trying to use '.

Thank you for this video, it helped me. Did you learn to write in C# from a particular textbook?

Thanks Sir

I think you need a new hard disk :p

int i = cmd.ExecuteNonQuery(); theres an error in this i cant save them

how if i got multiple data from arduino? can i save it to database?