Posted on: 7/7/2014 8:52:01 PM | Views : 433

now if i want to store a data in data table i use Parameters.AddWithValue now in case if i want to make the contrary to get the data from table and give each element in my page a value from behind code how i can do that.
for example the code below inserting value from elements in the page 
SqlConnection cn = new SqlConnection(sc); SqlCommand cmd = new SqlCommand(); string sqlstatment = "INSERT INTO UserInfo (UID, FN, LN, Password, RePass, Email,Country, State,City, Post, Img, Logo,RegDate) VALUES (@UID,@FN,@LN,@Password,@RePass,@Email,@Country,@State,@City,@Post,@Img,@Logo,@RegDate)"; cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlstatment; //Insert the parameters first cmd.Parameters.AddWithValue("@UID", UsrNme.Text); cmd.Parameters.AddWithValue("@FN&quo ...

Go to the complete details ...