Click here to Skip to main content
15,898,222 members

Comments by Muhammad0001 (Top 9 by date)

Muhammad0001 28-Feb-15 12:29pm View    
sir i want to store a location i a form of longitude and latitude
Muhammad0001 26-Jan-15 12:00pm View    
sir i got error in that part
private bool ExecuteSP(string SPName, List SPParameters)
{
string CS = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(SPName, con);
cmd.CommandType = CommandType.StoredProcedure;

foreach (SqlParameter parameter in SPParameters)
{
cmd.Parameters.Add(parameter);
}

con.Open();
return Convert.ToBoolean(cmd.ExecuteScalar());
}
}
how to apply catch block thier
Muhammad0001 26-Jan-15 11:42am View    
sir how i handle the excetion of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: String or binary data would be truncated.
Muhammad0001 26-Jan-15 11:36am View    
private bool ExecuteSP(string SPName, List SPParameters)
{
string CS = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(SPName, con);
cmd.CommandType = CommandType.StoredProcedure;

foreach (SqlParameter parameter in SPParameters)
{
cmd.Parameters.Add(parameter);
}

con.Open();
return Convert.ToBoolean(cmd.ExecuteScalar());
}
}
how to apply catch block thier
Muhammad0001 26-Jan-15 6:58am View    
kindly solve this problem that is when i am changing the password the exception arise i that part private bool ExecuteSP(string SPName, List<sqlparameter> SPParameters)
{
string CS = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(SPName, con);
cmd.CommandType = CommandType.StoredProcedure;

foreach (SqlParameter parameter in SPParameters)
{
cmd.Parameters.Add(parameter);
}

con.Open();
return Convert.ToBoolean(cmd.ExecuteScalar());
}
}