C# SQL 2005 Select Statement Help please

[timk25]

Hi,

I am new to programming and I am struggling with an sql select statement. I would really appreciate any help anyone can offer me!

What I am trying to do is populate a textbox (using code and without creating a dataset) with data retrieved from an sql database.

I have used the following code, but don't seem to be coming right:

String conn_String =
                "server=localhost;database=contacts_db;uid=sa;pwd=sqlsecret";

            SqlConnection mySqlconn =
                new SqlConnection(conn_String);

            mySqlconn.Open();

            String mySel_string =
                "SELECT firstName FROM contacts_tbl WHERE firstName = @fName";
            SqlCommand mySqlcmd =
                new SqlCommand(mySel_string, mySqlconn);

            SqlParameter myfNameParam =
                mySqlcmd.Parameters.Add("@fName", SqlDbType.NVarChar,50);
            myfNameParam.Value = textBox1.Text;
            
            mySqlcmd.ExecuteNonQuery();

I would really appreciate any help!

[majestic0110]

Hi there timk25 and welcome to DaniWeb!. First try changing the connection statement from:

String conn_String =
"server=localhost;database=contacts_db;uid=sa;pwd=sqlsecret";

To

String conn_String = "Data Source=localhost;Initial Catalog=contacts_db;User Id=sa;Password=sqlsecret;";

Then tell me what happens....hope that helps :)

[vinaya]

here wat info u want to populate into the textbox.. and when do u want to populate the text box on page load or on some event click.

[Jx_Man]

any error appear??

[timk25]

Hi There,

Thanks for your replies. I have tryed changing the connection string, but still no luck.

I would like to populate the text box on the click event of the button "button_addNew_Click"

My database that I created only has 1 table "contacts_tbl" with 3 columns "contactID, firstName, lastName"

The only column that I would like to populate to the textbox for now is firstName
The type of data I want to populate is text

When I run the program and click on the button nothing seems to happen and no error's

I appreciate your help guys. Is there anything else you can suggest?

Thanks

[corwing]

My SQL knowledge isn't great so I am assuming all other stuff is working.
Based upon what you said, I think you need to change what is on each side of the '='
You're putting data into the textbox retrieved from the database so it should be

textBox1.Text = myfNameParam.Value;

Hi,

I am new to programming and I am struggling with an sql select statement. I would really appreciate any help anyone can offer me!

What I am trying to do is populate a textbox (using code and without creating a dataset) with data retrieved from an sql database.

myfNameParam.Value = textBox1.Text; mySqlcmd.ExecuteNonQuery();

I would really appreciate any help!

[timk25]

Thanks for your input, but that unfortunately causes the following error:
Error 1 Cannot implicitly convert type 'object' to 'string'.

[idrissi]

Hi,

I am new to programming and I am struggling with an sql select statement. I would really appreciate any help anyone can offer me!

What I am trying to do is populate a textbox (using code and without creating a dataset) with data retrieved from an sql database.

I have used the following code, but don't seem to be coming right:

String conn_String = "server=localhost;database=contacts_db;uid=sa;pwd=sqlsecret";

SqlConnection mySqlconn = new SqlConnection(conn_String);

mySqlconn.Open();

String mySel_string = "SELECT firstName FROM contacts_tbl WHERE firstName = @fName"; SqlCommand mySqlcmd = new SqlCommand(mySel_string, mySqlconn);

SqlParameter myfNameParam = mySqlcmd.Parameters.Add("@fName", SqlDbType.NVarChar,50); myfNameParam.Value = textBox1.Text; mySqlcmd.ExecuteNonQuery();

I would really appreciate any help!

I know I am late but I think I can help you with it.
in this line:
String conn_String = "server=localhost;database=contacts_db;uid=sa;pwd=sqlsecret";

Please add @ and change the server to Data Source, this is the example:

String conn_String = @"Data Source= your computer name\SQLExpress; database=contacts_db; uid=sa; pwd=sqlsecret";

and if you still have problem post the error and let me know and I will help you.