Problem With Fill

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

I am attempting to work through a walkthrough for building a datagrid that
can be edited on an ASP page, I modified the walkthrough to use my own SQL
Server connection and one of my tables. I created the sqladapter, the
connection and built the dataset. All seemed to go fine but when I try to
run the project I get an error on the Fill method

SqlDataAdapter1.Fill(DsMyDataSet)

Any suggestions on how to debug this?

Wayne
 
Natty;

I got it to work by manually changing the connection string within the Web
Form Data Designer code section to add the password information. If I added
that to the connection string in the properties of the connection it had no
effect?

I am left with 2 questions:

1. Why doesn't VSNET store my PW information in the connection string when a
PW is required (or give me a way to enter the PW at runtime)?

2. Why can't I modify the connection string via the SqlConnection properties

Wayne
 
Back
Top