Reply to thread

Message: <blockquote data-quote="nuni" data-source="post: 12149472" data-attributes="member: 168835">Something like signup right. Easiest way is create a stored procedure in your SQL database.Ex:- CREATE PROCEDURE WhatEverName @fname VARCHAR (15),@lname VARCHAR (30),@address VARCHAR (80),@telenum CHAR (14),@email VARCHAR (30),@pass VARCHAR (25)ASBEGINWhatEverName = UserRegistration or your preferenceThen in your registration button click or whatever function you have,Ex:- SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["YourConnectionStringName"].ConnectionString);        SqlCommand com = new SqlCommand();        com.CommandText = "YourProcedureName";         com.CommandType = CommandType.StoredProcedure;        com.Connection = con;        SqlParameter fname      = new SqlParameter("@fname", SqlDbType.VarChar, 15);        SqlParameter lname      = new SqlParameter("@lname", SqlDbType.VarChar, 30);        //Include every table fields like that        fname.Direction     = ParameterDirection.Input;        lname.Direction     = ParameterDirection.Input; //Samehere ... Continue like this for your entire table           fname.Value      = txtfirstname.Text;        lname.Value      = txtlastname.Text;     //Samehere ... Continue like this for your entire table           com.Parameters.Add(fname);        com.Parameters.Add(lname);//Samehere ... Continue like this for your entire table           con.Open();        SqlDataReader dr = com.ExecuteReader();//Then you can close connection <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" />Hope this will help you ... or to get an idea <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" />For your webconfig confusion = add your connection string under the connection string TAGs in your webconfig <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" />.</blockquote>

Verification: Dawasata paya keeyak thibeda?

Top Bottom