Skip navigation links

MySQL Forums :: MySQL Query Browser :: Column can not be null


Advanced Search

Re: Column can not be null
Posted by: Guy Shen ()
Date: January 12, 2010 05:22PM

Hey Chad.

The ASP.NET code goes like this :

MySqlConnection mycon = new MySqlConnection...);
MySqlCommand mySqlCommand = mycon.CreateCommand();
mySqlCommand.CommandText = "create_new_cust";
mySqlCommand.CommandType = CommandType.StoredProcedure;
mySqlCommand.Parameters.Add("CN", MySqlDbType.String).Value = TextBox1.Text;
mySqlCommand.Parameters.Add("CS", MySqlDbType.String).Value = TextBox2.Text;
mySqlCommand.Parameters.Add("CC", MySqlDbType.String).Value = TextBox3.Text;


//THE FUNCTION SHOULD RETURN 1 FOR SUCCESFUL INSERTION //
MySqlDataReader DR;
mycon.Open();
DR = mySqlCommand.ExecuteReader();
DR.Read();
Label4.Text = DR.GetInt32(0).ToString();

mySqlCommand.Connection.Close();

Thanks for you HElp

Options: ReplyQuote


Subject Written By Posted
Column can not be null Guy Shen 01/11/2010 04:37PM
Re: Column can not be null Chad Bourque 01/11/2010 07:53PM
Re: Column can not be null Guy Shen 01/12/2010 03:07AM
Re: Column can not be null Chad Bourque 01/12/2010 09:03AM
Re: Column can not be null Guy Shen 01/12/2010 05:22PM
Re: Column can not be null Guy Shen 01/12/2010 06:39PM
Re: Column can not be null Chad Bourque 01/13/2010 05:44PM
Re: Column can not be null Guy Shen 01/14/2010 09:44AM
Re: Column can not be null Guy Shen 01/14/2010 06:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.