ado dataset

[gundala_abhilash]

hi all..m new to the comm..please help..


when i wroking with ado dataset m getting an error "unrecognised sequence error"..pls\ease help me out...
this is my code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace datasetdem
{
public partial class datasetform : Form
{
SqlConnection con = new SqlConnection("Server=chinna\sqlexpress;database=MSNETDB1:User Id=sa;Password=dss;");

DataTable dt;
SqlDataAdapter daEmp;
DataSet ds;
DataRow dr;
public datasetform()
{
InitializeComponent();
}

private void datasetform_Load(object sender, EventArgs e)
{
SqlConnection Con = new SqlConnection();
Con.ConnectionString = Helper.ConnectionString;

try
{
con.Open();
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}

daEmp = new SqlDataAdapter("Select EmpId,EmpName,EmpSalary from Emp", con);
MessageBox.Show(daEmp.SelectCommand.CommandText);


ds = new DataSet();
daEmp.Fill(ds, "emp");
dt = ds.Tables[0];
dgEmp.DataSource = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
cmbEmpId.Items.Add(dr["EmpId"]);
}
}

private void dgEmp_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}


}
}

[gundala_abhilash]

thanx in advance..do help me out

[gundala_abhilash]

no one replying???plsss reply

[NightStalker-DNS]

You are closing your connection before you are using it. In the finally block and you do not have a catch block with your try. Should not give you that error, but sort that out and see what happens then.

[gundala_abhilash]

error is show in the red color

"Server=chinna\sqlexpress;database=MSNETDB1:User Id=sa;Password=dss;");

[gundala_abhilash]

same error coming..help me out

[gundala_abhilash]

Originally Posted by gundala_abhilash

hi all..m new to the comm..please help..


when i wroking with ado dataset m getting an error "unrecognised escape sequence error"..pls\ease help me out...
this is my code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace datasetdem
{
public partial class datasetform : Form
{
SqlConnection con = new SqlConnection("Server=chinna\sqlexpress;database=MSNETDB1:User Id=sa;Password=dss;");

DataTable dt;
SqlDataAdapter daEmp;
DataSet ds;
DataRow dr;
public datasetform()
{
InitializeComponent();
}

private void datasetform_Load(object sender, EventArgs e)
{
SqlConnection Con = new SqlConnection();
Con.ConnectionString = Helper.ConnectionString;

try
{
con.Open();
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}

daEmp = new SqlDataAdapter("Select EmpId,EmpName,EmpSalary from Emp", con);
MessageBox.Show(daEmp.SelectCommand.CommandText);


ds = new DataSet();
daEmp.Fill(ds, "emp");
dt = ds.Tables[0];
dgEmp.DataSource = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
cmbEmpId.Items.Add(dr["EmpId"]);
}
}

private void dgEmp_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}


}
}

.

[NightStalker-DNS]

Try putting the connection string in the web.config file.

<connectionStrings>
<add name="ConnectionString" connectionString="Server=chinna\sqlexpress;database=MSNETDB1:User Id=sa;Password=dss;" />
</connectionStrings>

Then reference it like this:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"]);

[gundala_abhilash]

@above

The name 'ConfigurationManager' does not exist in the current content


m getting this error

[gundala_abhilash]

this is my app configuration file::

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="csMSNETDB" connectionString="server=chinna\sqlexpress;database=MSNETDB1"/>

</connectionStrings>
</configuration>

[gundala_abhilash]

this is my helper class.....


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;


class Helper
{
public static string ConnectionString
{
get
{
return System.Configuration.ConfigurationManager.ConnectionStrings["csMSNETDB"].ConnectionString;

}
}
}

[NightStalker-DNS]

add:
using System.Configuration;

[gundala_abhilash]

hi nightstalker


yeah i idded using System.Configuration; bro..m getting 2 error messages if i add that::

Error 1 The best overloaded method match for 'System.Data.SqlClient.SqlConnection.SqlConnection(string)' has some invalid arguments .
Error 2 Argument '1': cannot convert from 'System.Configuration.ConnectionStringSettings' to 'string' ..


these r the errors m getting if i add System.Configuration;

wht should i do bro???

[NightStalker-DNS]

ConfigurationManager.ConnectionStrings["csMSNETDB"].ToString()

[gundala_abhilash]

ok bro..but i have build the project everything is fine but m getting
"object ref not set to an instance of an object" exception....

[gundala_abhilash]

any one der to help me

[NightStalker-DNS]

well, on what line are you getting that error? And what version of asp.net are you using?

[gundala_abhilash]

studio 2008 version 3.5..

nullrefexception ...@ helper.helper.get_connection string..


bro i have send u the helper.class n app. configuration also..pls look at it

[gundala_abhilash]

@nitestalker ....bro the above exception is rectified and my code is working...

but m getting "login failure for the user:the user is not associatd with a trusted sql server connection"...

bro is thr any mistake in ma connection creation???can u help me plssss

[gundala_abhilash]

any body thr

[NightStalker-DNS]

That is a SQL permission issue. Probably got something 2 do with your connection string. To get the correct connectionstring for you db. Go here: http://www.connectionstrings.com/

[gundala_abhilash]

iam using " microsoft sql server(sqlclient)"

server name = chinna\SqlExpress

and in log on to the server wch type i shld use:::use windows authentication or use sql server authentication?????

user name ==????

password ===????


if i use windows authentication n database name::MSNETDB!..m getting test connection succeded but when i run the application m getting login failer for the user..and the user not associated with trusted sql server

[NightStalker-DNS]

That is because your app is running on an ASPNET/IIS guest account which is not a trusted connection to SQL.

Either, add that user as trusted in SQL server, or impersonate a user that is trusted in your website.

To do that add this to your web.config:

<identity impersonate="true" userName="username" password="password" />

You can use any username and password there that is trusted to sql, such as the current user account ur logged in with.

[gundala_abhilash]

how to add that user as trusted in SQL server...can u tell me plss

[NightStalker-DNS]

http://www.hosting.com/support/vps/windows/mixedmode/

Then use your original connection string.