title: Storing the url in SQLSERVER 2005 using C# code(data sets)
body: <p>I was trying to store the url on button click using the following code.There were no error but the required url is not sroeing in my column field (i used ntext data tpe for this).Please help me if there was some mistake in my code</p>
  
  <pre><code>public partial class _Default : System.Web.UI.Page
  {
      protected void Page_Load(object sender, EventArgs e)
      {
  
      }
  
      public void Storetxt(String txt)
      {
  
  
          //connection to the database
  
          string connection = "Data Source=.\\sqlexpress2005;Initial Catalog=PtsKuratlas;Integrated Security=True";
          SqlConnection conn = new SqlConnection(connection);
  
         //dataset object to store and manipulating data
  
          DataSet myDataSet = new DataSet();
  
          //data adapters to execute SQL
  
          SqlDataAdapter myDataAdapter = new SqlDataAdapter("SELECT * FROM gti_analytics", conn);
          myDataAdapter.Fill(myDataSet, "gti_analytics");
          myDataAdapter.InsertCommand = new SqlCommand("INSERT INTO gti_analytics [links] VALUES [txt]");
  
  
  
  
      }
  
      protected void Button1_Click(object sender, EventArgs e)
      {
          String text = "http://google.com";
          Storetxt(text);
      }
  }
  </code></pre>