fetch coloumn's value from sqlserver and bind to textobox

Question

how to fetch the data from table by using storeprocedures from asp.net and how to bind result value to textbox?

Khargesh Rajput · Answer

SqlConnection con = new SqlConnection(connstring); con.Open(); SqlCommand comm=new SqlCommand ("SP_name",con); comm.CommandType=CommandType.StoredProcedure; SqlDataAdapter da= new SqlDataAdapter(comm); DataSet ds = new DataSet(); da.Fill(ds); txtbx.Text = ds.Tables[0].Rows[0]["columnname"].ToString(); con.Close();

Tanmay Mule · Answer

check the following example these two lines are enough to bind the data from database to dropdownlist " SelectCommand="SELECT * FROM [Dept]">

Dawood Abbas · Answer

DataSourceID="SqlDataSource1" DataTextField="PackageName" DataValueField="PackageName" onselectedindexchanged="ddlPackNameEdit_SelectedIndexChanged" AutoPostBack="True" ontextchanged="ddlPackNameEdit_TextChanged"> --Select Package Name-- ConnectionString=" " SelectCommand="SELECT [PackageName] FROM [Packages] WHERE ([PackagePeriod] = @PackagePeriod)"> PropertyName="SelectedValue" Type="String" /> above is my code then where to bind 'select' value

Tanmay Mule · Answer

In selectedIndexChanged() Event of first dropdownlist write a code whatever you want to do after the "select value" is changed.... like displaying it in textbox or filling the items in another dropdownlist

Dawood Abbas · Answer

Thank you Mr. Khargesh Rajput .I got what I need exactly, but same 'select' value issuing.

Dawood Abbas · Answer

I did autopostback to it but how to display 'select' value to another dropdown list when iam cascading this second dropdownlist by sqlDataSource from dropdownlist option '>'

Tanmay Mule · Answer

You need to make AutoPostBack property of Dropdownlist to true

Dawood Abbas · Answer

iam getting by this 'txtPackPriceEdit.Text = command.ExecuteScalar().ToString();' but when first value binded in dropdownlist not getting when selecting other item then its getting in textbox. so how to bind 'select' value to dropdownlist when this dropdownlist binding from 'sqlDataSource'

Tanmay Mule · Answer

here is link of MSDN for ADO.NET: https://msdn.microsoft.com/en-us/library/e80y5yhx%28v=vs.110%29.aspx But actual tutorial you will get from here http://www.pragimtech.com/Free-aspnet-video-tutorial.aspx

Dawood Abbas · Answer

I already gone through MSDN.. so can u plz send me link of that

Tanmay Mule · Answer

You can use ADO.net, LINQ to SQL or Enity Framewok to fetch data from SQL Sever Database. Please Refer MSDN for more detail.

fetch coloumn's value from sqlserver and bind to textobox

Answers (11)