Overload

[DaveRook]

Hello

I am getting a CS1502: The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapt er(System.Data.SqlClient.SqlCommand)' has some invalid arguments

I have no idea what I've done wrong!

string strConn = ConfigurationManager.ConnectionStrings["BoardToBoard"].ConnectionString;
 
        string strB2BSQL = "SELECT * FROM View_BoardToBoard";
 
        SqlConnection B2BConn;
        DataSet ds = new DataSet();
        SqlDataAdapter B2BDA;
 
        B2BConn = new SqlConnection(strConn);
        B2BDA = new SqlDataAdapter(strB2BSQL);
 
        try
        {
            B2BConn.Open();
 
            B2BDA.Fill(ds, "B2B");
 
            grdB2B.DataSource = ds;
            grdB2B.DataBind();
        }
 
        finally
        {
            B2BConn.Close();
        }

Thank you

Dave

[Meganutter]

try making a new SqlDataAdapter the moment you define it by adding

new SqlDataAdapter();

that should fix it

[DaveRook]

Thank you for the suggestion, but I've changed it a bit now and have something else.

I have used this lots with Acces databases, but this is the first SQL server I'm trying to connect to

[Meganutter]

what do you have now, could you paste some of the code and tell where the error points to?

[DaveRook]

Sorry, I updated my original Post. What you have at the top of the page is what I have. I will add changes to new posts from now on.

The error is on line 10: B2BDA = new SqlDataAdapter(strB2BSQL);


Thank you

[Meganutter]

to use a string in a new database you need to include a connection or connectionstring as well, try:

B2BDA = new SqlDataAdapter(strB2BSQL, B2BConn);

[DaveRook]

Thank you for your help. It worked fine. If you have a minute more, can you tell me why I needed both?

Line 9 B2BConn = new SqlConnection(strConn); already tells it what the connection is so I don't know why I needed to declare it in the SqlDataAdapter as well

Thank you again

[Meganutter]

(im also quite new to programming, but ill try my best)
a DataAdapter is the bridge between the application and the SQL server, so in order to get the data it needs to know how to connect. for that a connection string or connection object is used.
when you use or create a SqlCommand Object it also asks for a connection.

i hope to have explained it well

[DaveRook]

Superb. Thank you for your help.