nothing data selected from the database

Question

0.00/5 (No votes)

See more:

Dear All,

i want to select the data from database in a textbox area but its nothing select and show me my exception what is wrong in my code please tell me. i want to creates it with enter event so how it is possible.

i m using this code.

C#

  private void txtPriceGold_Enter(object sender, EventArgs e)
        {
            string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=ABJDATABASE;Integrated Security=True; Max Pool Size=100";
            string strSql = "select txtPriceGold from PriceTable Where txtPriceGold=@txtPriceGold";
            SqlConnection conn = new SqlConnection(connstr);

            try
            {
                conn.Open();
                SqlCommand objCommand = new SqlCommand(strSql, conn);
                using (SqlDataReader dr = objCommand.ExecuteReader())
                {
                    bool success = dr.Read();
                    if (success)
                    {
                        txtPriceGold.Text = dr.GetString(0);
                    }
                }

                conn.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("error");
            }
}

Posted 1-Sep-13 16:48pm

Manish Arya

Updated 1-Sep-13 18:08pm

Sushil Mate

v2

Add a Solution

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)

Priyanka Bhagwat · Accepted Answer · 2013-09-01T20:45:00

Solution 3

hi Replace your Query with this

C#

string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold +"";

if txtPriceGold is your Textbox Field then

C#

string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold.Text+"";

Remember:
case1:when your datatype is string or varchar2
we need to pass the value with '"+ +"'i.e single Quote,then Double Quote and then +
for example

C#

"select name from Customer Where name ='"+name+"'";

case2 :when your datatype is numeric or integer
we need to pass the value with "+ +"

C#

string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold +"";

Hope this helped
Happy Coding:)

Posted 1-Sep-13 20:45pm

Priyanka Bhagwat

Updated 1-Sep-13 20:50pm

v3

Comments

Manish Arya 2-Sep-13 3:26am

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+ txtPriceGold.Text + "";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}
conn.Close();

error is:

Incorrect syntax near ','.

Priyanka Bhagwat 2-Sep-13 3:55am

???can u please tell me on which line is this error??

Manish Arya 2-Sep-13 4:13am

Incorrect syntax near '='.

line is:

using (SqlDataReader dr = objCommand.ExecuteReader())

Priyanka Bhagwat 2-Sep-13 3:59am

you can also declare your connection string in Web Config file if it is an web application.so that you don't need to declare it always

Priyanka Bhagwat 2-Sep-13 4:20am

try this
using (SqlDataReader read = objCommand .ExecuteReader())
{

while(reader.Read())
{
txtPriceGold.Text = reader["txtPriceGold "].ToString();
}

Manish Arya 2-Sep-13 5:02am

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold=" + txtPriceGold.Text + "";
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);

using (SqlDataReader reader = objCommand .ExecuteReader())
{
while(reader.Read())
{
txtPriceGold.Text = reader["txtPriceGold "].ToString();
}
}
conn.Close();
}

Incorrect syntax near '='.

same problem.

Priyanka Bhagwat 2-Sep-13 4:20am

go through this link as well
http://www.c-sharpcorner.com/forums/thread/150572/retrieving-data-from-database-into-textbox-in-c-sharp-using-asp.aspx

Herbisaurus 2-Sep-13 10:30am

5+!

ArunRajendra · Accepted Answer · 2013-09-01T17:18:00

Solution 1

Change this line to

C#

string strSql = "select txtPriceGold from PriceTable Where txtPriceGold=@txtPriceGold";

C#

string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='"+txtPriceGold +"'";

If you want to use @txtPriceGold then pass the value for the parameter.

Posted 1-Sep-13 17:18pm

ArunRajendra

Comments

Manish Arya 2-Sep-13 0:37am

same problem

ArunRajendra 2-Sep-13 0:51am

Can you post your modified code?

Manish Arya 2-Sep-13 1:12am

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='" + txtPriceGold + "'";

SqlConnection conn = new SqlConnection(connstr);

try
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}

conn.Close();
}
catch (Exception)
{
MessageBox.Show("error");
}

ArunRajendra 2-Sep-13 1:22am

Try this
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='" + txtPriceGold.Text + "'";

If you get the error then post the error.

Manish Arya 2-Sep-13 2:10am

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='" + txtPriceGold.Text + "'";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}
conn.Close();

error is
"Error converting data type varchar to numeric."

ArunRajendra 2-Sep-13 6:16am

try after removing the "'".

Herbisaurus 2-Sep-13 10:30am

5+!