updating sqlexpress database from drop down menus

Thanks for your time. I will try that.

David

Hi David,

I have had a look at your code, unfortunately, I have not and will not use third party data bound controls  in any of my sql work (Except those that I have written my self) I have always found them to be lacking in functionality with my requirements.

I generally do things manually with a framework I have developed which allows me to maintain SQL databases just as easily as having data bound controls but with full control over all aspects of record handling.

Simplistically, in my case I would do this (within my frame work class)


            System.Data.SqlClient.SqlConnection objCon;
            objCon = new System.Data.SqlClient.SqlConnection();
            objCon.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog = EmployeeProjects; Integrated Security=True;";
            objCon.Open();

then depending on editmode

switch(editmode)
  {
  case 1:
     string sql = "INSERT INTO table (field,field,field) values(@a, @b, @c)"
   
     break;

  case 2:
     string sql = "UPDATE table SET field1=@a,field2=@b,field3=@c WHERE id = id of record being edited"
   
     break;

  }
try
 {

     objCon.Parameters.AddWithValueS("a", value);
     objCon.Parameters.AddWithValueS("b", value);
     objCon.Parameters.AddWithValueS("c", value);
     objCon.CommandText = sql;
     objCon.ExecuteNonQuery();
 }
catch(Exception e)
   {
   }

This is my preferred way of SQL management, there are people on this forum who would be able to assist you with the data bound controls way of doing the same.

Sorry I cant help you any further than this,

Good luck.

Thanks for your input. I am new to doing this. Sorry that I am not following you. Do you have a sample that I can use? I will try uploading my code.