Advice on how to connect to SQL Server

Hello,
I feel this code must solve your query

using System.Data.SqlClient; //use this namespace

SqlConnection con = new SqlConnection();
//setting the connection string property
con.ConnectionString = "Data Source=.;Initial Catalog=RJIT;Integrated Security=True";
//open the connection
                    con.Open();
//query
string mycommand = "insert into receipt values(@student_id,@amount_paid,@student_name)";

       SqlCommand cmd = new SqlCommand(mycommand, con);
                    
 cmd.Parameters.AddWithValue("@student_id", comboBox1.Text);
 cmd.Parameters.AddWithValue("@amount_paid", txtreceiptstudamount.Text);
  cmd.Parameters.AddWithValue("@student_name", txtreceiptstudname.Text);

                    int x = cmd.ExecuteNonQuery();
                    if (x != 0)
                    {
//show message box when data is inserted 
                       MessageBox.Show("Data added");
                                  

                    }
//close the connection
                    con.Close();

Do rate my answer once you find it useful
Thanks & Regards
Radix :rose:

SqlConnection your connection name = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\your Database_name.mdf;Integrated Security=True;User Instance=True");




this is the connection string for sql server database 2005