Data not updating without error I think.

Sorry if this is a dumb question but I am just learning ASP.NET. My database is on a server running SQL Server 2000 and I have used Dreamweaver to build sites. I am trying to convert to ASP.NET.

The problem I am having is that data is not updating when I change it in a GridView, DataList, etc. I have tried including the user name an password in the connection string without success. What did I miss?

connectionString

="Data Source=<ServerName>;Initial Catalog=<DatabaseName>;Integrated Security=True;Uid=sa;Pwd=<Password>;"

This is the string I use in Dreamweaver which works;
Driver={SQL Server};Server=<ServerName>;Database=<DatabaseName>;Uid=sa;Pwd=<Password>;

What are you doing to try and save the data? Please show your code.|||

I got my answer. I had to use SQL Server Authentication. Again I am sorry. I should have known this from my dreamweaver/sql site. My brain must have been fried towards the end of last week.

This brings up another question. Why did I not get some kind of error that the record could not be updated due to whatever?

Have a great one!

Data in Table not showing

I am just starting with Report Services, so this may be an easy or dumb
problem but here goes:
I am working in Visual Studio with a simple report based on a sproc with
several parameters that returns a result set. In the report I have set up a
table and the dataset for it, as well as the parameters. Everything works
great until I test the report, the report renders but the table shows as
having no data. I can go to the data tab and run the sproc and enter the
same parameters and I get data back.
I have checked all the places I could think of that might hide the data, but
nothing.
I'm hoping someone else has been through this or has some ideas on where I
could look.
TIA,
NancyHave you added a filter somewhere? Edit the dataset on the Data tab, click
the Filters tab and see. Also go to Properties of your table and check the
Filters tab. If your sproc returns data, the data should appear in the
report. I have a sproc in one of my reports and ti works just fine.
Charles Kangai, MCT, MCDBA
"Nancy Lytle" wrote:
> I am just starting with Report Services, so this may be an easy or dumb
> problem but here goes:
> I am working in Visual Studio with a simple report based on a sproc with
> several parameters that returns a result set. In the report I have set up a
> table and the dataset for it, as well as the parameters. Everything works
> great until I test the report, the report renders but the table shows as
> having no data. I can go to the data tab and run the sproc and enter the
> same parameters and I get data back.
> I have checked all the places I could think of that might hide the data, but
> nothing.
> I'm hoping someone else has been through this or has some ideas on where I
> could look.
> TIA,
> Nancy
>
>|||Thanks, I went ahead and I checked for filters and I can find none. I know
it must be something simple I am missing.
Any other ideas? Anyone?
TIA,
Nancy
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:53541C34-C4A7-4769-AB92-43C023605AFD@.microsoft.com...
> Have you added a filter somewhere? Edit the dataset on the Data tab, click
> the Filters tab and see. Also go to Properties of your table and check the
> Filters tab. If your sproc returns data, the data should appear in the
> report. I have a sproc in one of my reports and ti works just fine.
> Charles Kangai, MCT, MCDBA
> "Nancy Lytle" wrote:
> > I am just starting with Report Services, so this may be an easy or dumb
> > problem but here goes:
> >
> > I am working in Visual Studio with a simple report based on a sproc with
> > several parameters that returns a result set. In the report I have set
up a
> > table and the dataset for it, as well as the parameters. Everything
works
> > great until I test the report, the report renders but the table shows as
> > having no data. I can go to the data tab and run the sproc and enter
the
> > same parameters and I get data back.
> > I have checked all the places I could think of that might hide the data,
but
> > nothing.
> >
> > I'm hoping someone else has been through this or has some ideas on where
I
> > could look.
> > TIA,
> > Nancy
> >
> >
> >