how to search particular date data and the data is display at gridview in asp.net using c#

Question

1.00/5 (1 vote)

See more:

Hello,

I am develop on web application using c#and asp.net and using sqlserver2008
these web application has one textbox one command button and one gridview
sql server2008 table also one table i.e. svf the svf has the coloumns sno
rdate and amount .i am entered the date in textbox the gridview display
rdate data so please give the code and i writed some code

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True");
con.Open();
string strQuery = "select * from stv where rdate =@Textbox6.Text";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvuser.DataSource = dt;
gvuser.DataBind();
con.Close();
but i got error while on web run at command buttom click event

Fill: SelectCommand.Connection property has not been initialized.

Posted 24-Oct-13 23:10pm

Raghavendra Guptha

Updated 25-Oct-13 0:09am

v2

Add a Solution

Comments

Thanks7872 25-Oct-13 5:13am

please give the code

No one will. Its your responsibility to implement. We are here to help you if you face any problem with that code.

Raghavendra Guptha 25-Oct-13 6:00am

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True");
con.Open();
string strQuery = "select * from stv where rdate =@Textbox6.Text";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
cmd.Parameters.AddWithValue("@rdate", TextBox6.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvuser.DataSource = dt;
gvuser.DataBind();
con.Close();

but i got error on web application run error is "Fill: SelectCommand.Connection property has not been initialized."

Thanks7872 25-Oct-13 6:07am

See the updated answer.

Tom Marvolo Riddle 25-Oct-13 5:26am

Frequent Question here.Search it and you will get it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Answer 1 · 2013-10-25T00:02:00

Solution 1

Your code should be like this:

C#

//connections
string strQuery = "select * from stv where rdate =@something";

SqlCommand cmd = new SqlCommand(strQuery,con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@something", TextBox6.Text);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
sda.Fill(dt);
gvuser.DataSource = dt;
gvuser.DataBind();
con.Close();

Regards..

Posted 25-Oct-13 0:02am

Thanks7872

Updated 25-Oct-13 0:08am

v3

Comments

Raghavendra Guptha 25-Oct-13 6:33am

but not showing gridview what is problem here is given the asp page code

<asp:GridView ID="gvuser" runat="server" AutoGenerateColumns="False" PageSize="10"
Width="1017px" Caption="Settlement vouchers Feeding Details" AllowPaging="true"
>
<columns>
<asp:TemplateField HeaderText="S.No">
<itemtemplate>
<asp:Label ID="label1" Visible="true" runat="server" Text='<%# Eval("sno") %>'>

<asp:TemplateField HeaderText="RDATE">
<itemtemplate>
<asp:Label ID="label2" Visible="true" runat="server" Text='<%# Eval("rdate") %>'>

<asp:TemplateField HeaderText="ACNO">
<itemtemplate>
<asp:Label ID="label3" Visible="true" runat="server" Text='<%# Eval("acno") %>'>

<asp:TemplateField HeaderText="NAME">
<itemtemplate>
<asp:Label ID="label4" Visible="true" runat="server" Text='<%# Eval("name") %>'>

<asp:TemplateField HeaderText="VNO">
<itemtemplate>
<asp:Label ID="label5" Visible="true" runat="server" Text='<%# Eval("vno") %>'>

<asp:TemplateField HeaderText="AMOUNT">
<itemtemplate>
<asp:Label ID="label6" Visible="true" runat="server" Text='<%# Eval("amt") %>'>

<asp:TemplateField HeaderText="EDATE">
<itemtemplate>
<asp:Label ID="label7" Visible="true" runat="server" Text='<%# Eval("edate") %>'>

<asp:TemplateField HeaderText="CHNO">
<itemtemplate>
<asp:Label ID="label8" Visible="true" runat="server" Text='<%# Eval("chno") %>'>

C For Code!!! · Answer 2 · 2013-10-25T00:37:00

Use below mentioned code snippet

SqlConnection con = new SqlConnection("Data Source=NSYS1\\SQLEXPRESS;Initial Catalog=agfl;connect timeout=30;Integrated Security=True");
string strQuery = "select * from stv where rdate="+"'"+Textbox6.Text+"'";
SqlCommand cmd = new SqlCommand(strQuery);
SqlDataAdapter sda = new SqlDataAdapter(cmd ,con);
DataSet ds = new DataSet();
ds.clear();
sda.Fill(ds);
gvuser.DataSource = ds;
gvuser.DataBind();

For your information when using data adapter no need to provide con.open or close it will manage itself.

Hope This Helps!!!