Unable to insert contents into the database

Question

0.00/5 (No votes)

See more:

I have created a sql server database in godaddy and created a table named property manually.i also successfuly connected my application to the database using connection string.But i am unable to insert any values to the table using my c# code Below is my C# code

string strQuery = "INSERT INTO property(name,email,phone,heading,description,location,image1,image2,image3,image4) VALUES('" + name + "','" + email + "','" + phone + "','" + title + "','" + description + "','" + district + "',@data,@data2,@data3,@data4);";
SqlCommand cmd = new SqlCommand(strQuery);


cmd.Parameters.Add("@data", SqlDbType.Binary).Value = bytes;
cmd.Parameters.Add("@data2", SqlDbType.Binary).Value = bytes2;
cmd.Parameters.Add("@data3", SqlDbType.Binary).Value = bytes3;
cmd.Parameters.Add("@data4", SqlDbType.Binary).Value = bytes4;
SqlConnection con = new SqlConnection(constr);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
try
{
    con.Open();
    cmd.ExecuteNonQuery();
    return true;
}
catch (Exception ex)
{
    Response.Write(ex.Message);
    return false;
}
finally
{
    con.Close();
    con.Dispose();
}

when i tried to insert value in sql server web admin, i am getting error-Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Please help me

Posted 4-Jan-14 1:19am

faizel s

Updated 6-Jan-14 4:04am

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)

OriginalGriff · Answer 1 · 2014-01-04T01:39:00

Solution 1

First off, stop mixing styles and use parametrized queries throughout: concatenating strings is wide open to SQL injection attack which could damage or destroy your database. This may sovle your problem anyway.
Second, look at any error message you get via the catch - it should give you a clue as to what is wrong.

At the moment, there are far too many possibilities for error here, that we can't even begin to guess which one of they you have caused without better information.

C#

string strQuery = "INSERT INTO property(name, email, phone, heading, description, location, image1, image2, image3, image4) VALUES(@NM, @EM, @PN, @HD, @DS, @LO, @D1, @D2, @D3, @D4)";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.Parameters.AddWithValue("@NM", name);
cmd.Parameters.AddWithValue("@EM", email);
cmd.Parameters.AddWithValue("@PN", phone);
cmd.Parameters.AddWithValue("@HD", title);
cmd.Parameters.AddWithValue("@DS", description);
cmd.Parameters.AddWithValue("@LO", district);
cmd.Parameters.AddWithValue("@D1", bytes);
cmd.Parameters.AddWithValue("@D2", bytes2);
cmd.Parameters.AddWithValue("@D3", bytes3);
cmd.Parameters.AddWithValue("@D4", bytes4);
SqlConnection con = new SqlConnection(constr, con);
try
   {
   ...

Posted 4-Jan-14 1:39am

OriginalGriff

Comments

faizel s 4-Jan-14 7:49am

i tried this but still not working.it does'nt show any error.but when i load contents of databse onto datatable after inserting it says zero row for datatable

OriginalGriff 4-Jan-14 7:52am

If you didn't get any error, then they problem is more likely to be with how you load the datatable from the database - show the code you use for that as well.

faizel s 4-Jan-14 7:59am

DataTable dt = new DataTable();

// SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\work\boatsite - Copy\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
string query = "SELECT * FROM property WHERE id = (SELECT MAX(id) FROM property);";
if (cn.State == ConnectionState.Closed)
cn.Open();
SqlCommand cmd = new SqlCommand(query, cn);

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
cn.Close();

faizel s 4-Jan-14 7:53am

DataTable dt = new DataTable();

// SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\work\boatsite - Copy\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
string query = "SELECT * FROM property WHERE id = (SELECT MAX(id) FROM property);";
if (cn.State == ConnectionState.Closed)
cn.Open();
SqlCommand cmd = new SqlCommand(query, cn);

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
cn.Close();

faizel s 4-Jan-14 7:55am

Thnk you for trying to help me.Coding i wrote ws perfectly working in local server

OriginalGriff 4-Jan-14 8:08am

And there is the answer: "working in local server"

Your connection string is almost certainly wrong: you need to contact your hosting provider and find out what connection string you should be using - it is almost certainly not going to include SQLEXPRESS or Integrated Security!

faizel s 4-Jan-14 8:21am

the connection string i have shown in the code has been commented out.i have been using connetion string given by hosting server

OriginalGriff 4-Jan-14 9:28am

Which is? (edit out the username and password)

faizel s 5-Jan-14 10:27am

i also did that

OriginalGriff 5-Jan-14 10:56am

No, what I meant was "what is the connection string the hosting service gave you".
Sorry for the confusion - "which is?" is colloquial English I should not have used, and the "edit out..." part was to ensure that you don't publish your login info across the internet when you posted the connection string, not a suggestion for how to fix your problem.

faizel s 6-Jan-14 10:23am

Data Source=countydata.db.12049298.hostedresource.com; Initial Catalog=countydata; User ID=username; Password='password'

OriginalGriff 6-Jan-14 11:08am

OK: there is a database there (It responds to me when I try to connect using SSMS) - and it gives me a authorisation failure error which is good.

And I see you are now getting an error message! (I don't know what you changed to get that, but...

That error is a different matter - you can connect, but...a quick check on the internet says that this is normally a result of a 64 bit app trying to access a 32 bit DLL. So you need to go back to your host and talk it through with them - I can't do anything about that!

faizel s 7-Jan-14 9:56am

Thanks for helping me i have solved this problem wth the help of you god bless you

OriginalGriff 7-Jan-14 10:10am

You're welcome!

Kishor Deshpande · Answer 2 · 2014-01-04T02:04:00

Solution 2

Try with below link, might be an issue with the connection string you specified.
Link

Posted 4-Jan-14 2:04am

Kishor Deshpande