data submit error RSS

• • Reply
  

  micahdavid20...

  Member

  3 Points

  73 Posts

  data submit error

  May 05, 2012 07:23 AM|LINK

  Please can someone help me with this code, is returning error connection public partial class _Default : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {     }     protected void SubmitButton1_Click(object sender, EventArgs e)     {        string name = TextName.Text;        string connString = ConfigurationManager.ConnectionStrings["Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Lagos.mdf;Integrated Security=True;User Instance=True"].ConnectionString;        System.Data.SqlClient.SqlConnection conn = null;        try        {        conn = new SqlConnection(connString);        conn.Open();        using (SqlCommand cmd = new SqlCommand())        {        cmd.Connection = conn;        cmd.CommandType = CommandType.Text;              cmd.CommandText = "INSERT INTO MoonTable(name) Values (@var)";        cmd.Parameters.AddWithValue("@var", name);        int rowsAffected = cmd.ExecuteNonQuery();        if (rowsAffected == 1)        {        //Success notification        }        else        {        //Erro notification        }        }        }        catch (Exception ex)        {        //Log error        //Display friendly error to user        }        finally        {        if (conn != null)        {        //cleanup connection i.e close        }        }
• • Reply
  

  Primillo

  Star

  8723 Points

  1677 Posts

  Re: data submit error

  May 05, 2012 07:29 AM|LINK

  Hi

  Please use the "Insert Code" button.

  That way we can read your code in a better way

  Best Regards
  Primillo
  http://www.facebook.com/programandopuntonet
• • Reply
  

  basheerkal

  Star

  10672 Points

  2426 Posts

  Re: data submit error

  May 05, 2012 10:10 AM|LINK

  micahdavid2011

  string connString = ConfigurationManager.ConnectionStrings["Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Lagos.mdf;Integrated Security=True;User Instance=True"].ConnectionString;

  This Should be

  ConfigurationManager.ConnectionStrings["Name of the Connection String  as saved in web.config"].ConnectionString'

  or

  string connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Lagos.mdf;Integrated Security=True;User Instance=True"

   

  Kindly mark this post as "Answer", if it helped you.
  
  (Talk less..Work more)
• • Reply
  

  micahdavid20...

  Member

  3 Points

  73 Posts

  Re: data submit error

  May 05, 2012 07:46 PM|LINK

  I use galaxy tap so i cant see the insert code button.
• • Reply
  

  micahdavid20...

  Member

  3 Points

  73 Posts

  Re: data submit error

  May 05, 2012 07:51 PM|LINK

  I use galaxy tap so i cant see the insert code button. You may give me your own example. All i want is a code in c# That will insert into a database through text field and another code that will select from a database through text Field and display it in a new page. Just write your own example On visual studio c# i can modify it. Thanks
• • Reply
  

  micahdavid20...

  Member

  3 Points

  73 Posts

  Re: data submit error

  May 05, 2012 08:21 PM|LINK

  Thanks there is no error on the code, but when i insert a name through The text field it will not enter my database. After entering data through the text field if i check my database i wont see it, why?. See my database query Database name Lagos Table name Moon Table Definition NameID Name Can you check why its not entering to the database Thanks
• • Reply
  

  superguppie

  All-Star

  48225 Points

  8679 Posts

  Re: data submit error

  May 11, 2012 02:11 PM|LINK

  Have you tried using the debugger to step through the code? Check the values of the SqlCommand, and the Parameter.

  Superguppie.
  Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
  When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.