0

Good Afternoon,
Im new here so Hi All.

I having a problem doing a thing in c# asp, trying to get data, when updating the db trough the datagrid, using c# on the code behind and im havin troubles, can anybody help.

The code that im using is this:

  protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {

            GridViewRow row = GridView1.SelectedRow;

            string Username = row.Cells[3].Text;
            string Password = row.Cells[4].Text; 
            string Email = row.Cells[5].Text;
            string ID_Inscricao = row.Cells[1].Text;

            SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["FormacaoConnectionString"].ToString());
            SqlCommand sqlComm = new SqlCommand();
            /*
            sqlComm = sqlConn.CreateCommand();
            sqlComm.Parameters.Add("@Username", SqlDbType.Text);
            sqlComm.Parameters.Add("@Password", SqlDbType.Text);
            sqlComm.Parameters.Add("@Email", SqlDbType.Text);
            sqlComm.Parameters.Add("@ID_Inscricao", SqlDbType.Text);
            */
            sqlComm.Parameters["@Username"].Value = Username;
            sqlComm.Parameters["@Password"].Value = Password;
            sqlComm.Parameters["@Email"].Value = Email;
            sqlComm.Parameters["@ID_Inscricao"].Value = ID_Inscricao;

            string sql = "INSERT INTO Utilizadores (Username, Password, Email,ID_Inscricao) VALUES (@Username, @Password, @Email, @ID_Inscricao)";
            sqlComm.CommandText = sql;
            sqlConn.Open();
            sqlComm.ExecuteNonQuery();
            sqlConn.Close();
        }
2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by maxpaine69
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.