Click here to Skip to main content
15,886,104 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
public string InsertDB(ShortCodeBO objShortCodeBO)
       {

           string message = string.Empty;
           try
           {

               string CommonDatabaseName = ConfigurationSettings.AppSettings["CommonDatabaseName"].ToString();
               string ConName = CommonDatabaseName;

               //ConnectionString_Initialize(StoredProcedure.InsertDB, ConName);
               Initialize(StoredProcedure.InsertDB);
               UserCmd.Parameters.Clear();
               UserDB.AddInParameter(UserCmd, Parameter.UserName, DbType.String,objShortCodeBO.UserName);
               UserDB.AddInParameter(UserCmd, Parameter.Password, DbType.String,objShortCodeBO.Password);
               UserDB.AddInParameter(UserCmd, Parameter.FirstName, DbType.String,objShortCodeBO.FirstName);
               UserDB.AddInParameter(UserCmd, Parameter.LastName, DbType.String,objShortCodeBO.LastName);
               UserDB.AddOutParameter(UserCmd, Parameter.ERROR, DbType.String, 100);

               UserDB.ExecuteNonQuery(UserCmd);
               message = (string)UserCmd.Parameters["@ERROR"].Value;
           }
           catch (SqlException)
           {
               throw;
           }
           catch (Exception)
           {
               throw;
           }
           return message;
       }
Posted
Comments
sureshsankar 25-Jun-13 5:31am    
help with me

1 solution

objShortCodeBO is null???
UserCmd is null???
UserDB is null???

Impossible to say when you don't mention in what line you get the error...
 
Share this answer
 
Comments
sureshsankar 25-Jun-13 5:51am    
string CommonDatabaseName = ConfigurationSettings.AppSettings["CommonDatabaseName"].ToString();
string ConName = CommonDatabaseName;----- here null exception
Johnny J. 25-Jun-13 6:30am    
In that case you probably don't have an app setting named "CommonDatabaseName" - I would try to check that first.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900