data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
Thank you,
Alex
No, a data page contains data for a single table.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>
|||Page, No.
Extent, yes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>
|||No, pages are allocated to individual tables.
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
Thank you,
AlexNo, a data page contains data for a single table.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||Page, No.
Extent, yes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||No, pages are allocated to individual tables.
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

data pages

Hi everyone and thanks in advance for help.
May one data page contain data from different tables?
--
Thank you,
AlexNo, a data page contains data for a single table.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||Page, No.
Extent, yes.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>|||No, pages are allocated to individual tables.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Alex" <alex_removethis_@.healthmetrx.com> wrote in message
news:10q6u9j83g9uv03@.corp.supernews.com...
> Hi everyone and thanks in advance for help.
> May one data page contain data from different tables?
> --
> Thank you,
> Alex
>

data page structure

Hi all,
I found documentation once on the structure of a data
page. However, I am unable to find this documentation
now. Just to make sure I am referring to data types like
nvarchar, varchar, nchar, char and interger.There is a brief discussion in the BOL, but I know there
is a pretty good discussion on this in Kalen Delaney's
Inside SQL Server book.
Matthew Bando
BandoM@.CSCTechnologies.com
>--Original Message--
>Hi all,
>I found documentation once on the structure of a data
>page. However, I am unable to find this documentation
>now. Just to make sure I am referring to data types
like
>nvarchar, varchar, nchar, char and interger.
>.
>

Data Page details

Can we see the data reside inside the data Page?.
How to Idenfy Corrupted or damaged Pages of table?.
Google for DBCC PAGE. Not documented or supported...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegro ups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>
|||Hi
DBCC TRACEON (3604)
dbcc page (13,1,96,1)--dbid, fileno, pageno, option
http://www.sql-server-performance.co...structures.asp
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegro ups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>

Data Page details

Can we see the data reside inside the data Page?.
How to Idenfy Corrupted or damaged Pages of table?.Google for DBCC PAGE. Not documented or supported...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegroups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>|||Hi
DBCC TRACEON (3604)
dbcc page (13,1,96,1)--dbid, fileno, pageno, option
http://www.sql-server-performance.c..._structures.asp
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegroups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>

Data Page details

Can we see the data reside inside the data Page?.
How to Idenfy Corrupted or damaged Pages of table?.Google for DBCC PAGE. Not documented or supported...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegroups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>|||Hi
DBCC TRACEON (3604)
dbcc page (13,1,96,1)--dbid, fileno, pageno, option
http://www.sql-server-performance.com/gv_index_data_structures.asp
"Praveen" <apveen@.gmail.com> wrote in message
news:1141288503.616391.54220@.j33g2000cwa.googlegroups.com...
> Can we see the data reside inside the data Page?.
> How to Idenfy Corrupted or damaged Pages of table?.
>

Data on a given page

Givena database page (eg 1:25520), how can I see what data is on that page or
at least what table/indexes are using that page ?
Thanks in Advance,
Flora
you can use the command DBCC PAGE
http://support.microsoft.com/kb/q83065/
"Flora S" wrote:

> Givena database page (eg 1:25520), how can I see what data is on that page or
> at least what table/indexes are using that page ?
> Thanks in Advance,
> Flora

Data on a given page

Givena database page (eg 1:25520), how can I see what data is on that page o
r
at least what table/indexes are using that page ?
Thanks in Advance,
Florayou can use the command DBCC PAGE
http://support.microsoft.com/kb/q83065/
"Flora S" wrote:

> Givena database page (eg 1:25520), how can I see what data is on that page
or
> at least what table/indexes are using that page ?
> Thanks in Advance,
> Flora

Data on a given page

Givena database page (eg 1:25520), how can I see what data is on that page or
at least what table/indexes are using that page ?
Thanks in Advance,
Florayou can use the command DBCC PAGE
http://support.microsoft.com/kb/q83065/
"Flora S" wrote:
> Givena database page (eg 1:25520), how can I see what data is on that page or
> at least what table/indexes are using that page ?
> Thanks in Advance,
> Flora

Data not showing in ReportViewer but will display when exported

Hi again,

I'm having a funky problem with the ReportViewer control. When I load the report page, the ReportViewer will come up with my blank rdlc file with no data being displayed. However, when I choose to export the data, it will show in the excel or pdf. It was working fine on a test server, and all of a sudden this happened.

I am having the same issue. It was working fine using Atlas. I switched my project to Ajax, and now it's broke. My ReportViewer is inside an UpdatePanel. I removed the updatepanel tags, and I now get an Error "Execution '' cannot be found".

Data not posting to SQL Database

I have a asp.net page that is supposed to post data to a sqlserver 2000 database. The page opens fine and let's you enter the data and submit it, but the data never appears in the database. I've set up exception handling to catch duplicate records, invalid date/time format and then general sql exceptions and general system exceptions. Either something is going wrong before the try...catch or it's not throwing an exception and I don't get any runtime or designtime errors>>>
'This code adds values to the fields to be submitted
SqlConnection1.Open()
SqlInsertCommand1.Parameters("@.Site").Value() = Server.HtmlEncode(ddlSite.SelectedValue)
SqlInsertCommand1.Parameters("@.RepMonth").Value() = Server.HtmlEncode(ddlMonth.SelectedValue)
SqlInsertCommand1.Parameters("@.SerDate").Value() = Server.HtmlEncode(txtDate.Text)
SqlInsertCommand1.Parameters("@.VolName").Value() = Server.HtmlEncode(txtName.Text)
SqlInsertCommand1.Parameters("@.SSNum").Value() = Server.HtmlEncode(txtSSNum.Text)
SqlInsertCommand1.Parameters("@.ArtCraftHrs").Value = Server.HtmlEncode(Val(txtArt.Text))
SqlInsertCommand1.Parameters("@.TransHrs").Value = Server.HtmlEncode(Val(txtTrans.Text))
SqlInsertCommand1.Parameters("@.EscortHrs").Value = Server.HtmlEncode(Val(txtEscort.Text))
SqlInsertCommand1.Parameters("@.InfoRefHrs").Value = Server.HtmlEncode(Val(txtInfo.Text))
SqlInsertCommand1.Parameters("@.ProgAsstHrs").Value = Server.HtmlEncode(Val(txtProgAsst.Text))
SqlInsertCommand1.Parameters("@.SHopAsstHrs").Value = Server.HtmlEncode(Val(txtShopAsst.Text))
SqlInsertCommand1.Parameters("@.FoodAidHrs").Value = Server.HtmlEncode(Val(txtFoodAid.Text))
SqlInsertCommand1.Parameters("@.HomeDelHrs").Value = Server.HtmlEncode(Val(txtDelAid.Text))
SqlInsertCommand1.Parameters("@.SubmitDate").Value = Server.HtmlEncode(Now().ToShortDateString)

'This code creates a sqlcommand to return data to the datagird

Dim sqlstr As String
sqlstr = "declare @.Date as char(12)set @.Date=(select rtrim(cast(datepart(mm,getdate()) as c" & _
"har(2)))+'/'+cast(datepart(dd,getdate()) as char(2))+'/'+cast(datepart(yy,getdat" & _
"e()) as char(4)))SELECT Site, RepMonth, SerDate, VolName, SSNum, ArtCraftHrs, Tr" & _
"ansHrs, EscortHrs, InfoRefHrs, ProgAsstHrs, ShopAsstHrs, FoodAidHrs, HomeDelHrs," & _
" SubmitDate FROM dbo.VolDetailReport where submitdate = @.Date and Site = '" + ddlSite.SelectedItem.Text + "'"
Me.SqlSelectCommand1.CommandText = sqlstr
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
Try

SqlInsertCommand1.ExecuteNonQuery()
SqlDataAdapter1.Fill(DataSet11, "VolDetailReport")
dgDisplay.DataBind()
SqlConnection1.Close()
Dim volSubmitDate As String
volSubmitDate = DatePart(DateInterval.Month, Now()) & " / " & DatePart(DateInterval.Day, Now()) & " / " & DatePart(DateInterval.Year, Now())
Response.Cookies("VolSubmitted").Value = volSubmitDate
Response.Cookies("VolSubmitted").Expires = DateTime.MaxValue
Catch ex As SqlClient.SqlException When ex.Number = 242
'Checks for improper format of the data fields
lblSqlError.Visible = "True"
lblSqlError.Text = "The Date is not in the form m/d/yyyy"
Catch ex As SqlClient.SqlException When ex.Number = 2627
'Checks for Primary Key violation ie(Already existing record)
lblSqlError.Text = "This Record has already been submitted"
Catch ex As Exception
lblSqlError.Text = ex.Message
End Try

Reset_Page()Can you run SQL Profiler and see what is actually being passed to SQL Server? I have found this to be very helpful.|||I don't have sysadmin rights to create a trace in SQL Profiler. What I did was do a step into debug and setup a break in the button click procedure. It didn't find a problem and when I checked the database the data was there!!!! I don't know what the problem was, but it seems to have fixed itself.

Thanks for the info

data in the header

It is my understanding that data items can not exist in a header (or
footer). Yet in multi page reports it is often a requirement to reprint a
heading that has data in it. What is the best way to address this issue?
Thanks,
Garycreate read-only parameter with default value from query and then to use
this parameter in the page header textbox.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary D." <Dean@.nospam.com> wrote in message
news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> It is my understanding that data items can not exist in a header (or
> footer). Yet in multi page reports it is often a requirement to reprint a
> heading that has data in it. What is the best way to address this issue?
> Thanks,
> Gary
>|||Lev:
Sorry, but I've looked through the docs (no search capability) and I just
can't figure out what you mean. could you pleas elaborate on what a
read-only parameter is? I have never worked with reporting software before
where putting data in the heading was problem.
Thanks,
Gary
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
> create read-only parameter with default value from query and then to use
> this parameter in the page header textbox.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Gary D." <Dean@.nospam.com> wrote in message
> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> > It is my understanding that data items can not exist in a header (or
> > footer). Yet in multi page reports it is often a requirement to reprint
a
> > heading that has data in it. What is the best way to address this
issue?
> > Thanks,
> > Gary
> >
> >
>|||Here is some info about adding parameters :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
You need to create a parameter with no prompt (If the prompt is left blank,
and a default parameter value is specified, the default value is used, and
the input box for the parameter is not displayed when the user runs the
report), set default value to "From query" and select dataset and field for
default value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary D." <Dean@.nospam.com> wrote in message
news:O8oRF2ghEHA.2620@.TK2MSFTNGP10.phx.gbl...
> Lev:
> Sorry, but I've looked through the docs (no search capability) and I just
> can't figure out what you mean. could you pleas elaborate on what a
> read-only parameter is? I have never worked with reporting software
> before
> where putting data in the heading was problem.
> Thanks,
> Gary
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
>> create read-only parameter with default value from query and then to use
>> this parameter in the page header textbox.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Gary D." <Dean@.nospam.com> wrote in message
>> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
>> > It is my understanding that data items can not exist in a header (or
>> > footer). Yet in multi page reports it is often a requirement to
>> > reprint
> a
>> > heading that has data in it. What is the best way to address this
> issue?
>> > Thanks,
>> > Gary
>> >
>> >
>>
>|||It works great, but you must add the RS parameter in the stored procedure.
Without this, you'll have an error.
"Lev Semenets [MSFT]" wrote:
> Here is some info about adding parameters :
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
> You need to create a parameter with no prompt (If the prompt is left blank,
> and a default parameter value is specified, the default value is used, and
> the input box for the parameter is not displayed when the user runs the
> report), set default value to "From query" and select dataset and field for
> default value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Gary D." <Dean@.nospam.com> wrote in message
> news:O8oRF2ghEHA.2620@.TK2MSFTNGP10.phx.gbl...
> > Lev:
> > Sorry, but I've looked through the docs (no search capability) and I just
> > can't figure out what you mean. could you pleas elaborate on what a
> > read-only parameter is? I have never worked with reporting software
> > before
> > where putting data in the heading was problem.
> > Thanks,
> > Gary
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:uvsl$ZVhEHA.2784@.TK2MSFTNGP09.phx.gbl...
> >> create read-only parameter with default value from query and then to use
> >> this parameter in the page header textbox.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Gary D." <Dean@.nospam.com> wrote in message
> >> news:%23F1%233OVhEHA.1768@.TK2MSFTNGP10.phx.gbl...
> >> > It is my understanding that data items can not exist in a header (or
> >> > footer). Yet in multi page reports it is often a requirement to
> >> > reprint
> > a
> >> > heading that has data in it. What is the best way to address this
> > issue?
> >> > Thanks,
> >> > Gary
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Data in Page Header...

Group,
I would like to have a value (basically a scalar from a stored proc) in my
header but I keep getting the compile error:
'The value expression for the textbox 'LastSale' refers to a field. Fields
cannot be used in page headers or footers.'
I tried putting a subreport in the header and that does not work either. It
would be very limiting to not allow database data in the header of a report!
(Very easy to do in Crystal Reports)
Also keep in mind that I do not want my header in the 'body' region.
Thanks everyone.Place the field in any of the textbox(say textbox10) in body section
Then use =ReportItems!textbox10.value in pageheader section
Ponnurangam
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
> Group,
> I would like to have a value (basically a scalar from a stored proc) in my
> header but I keep getting the compile error:
> 'The value expression for the textbox 'LastSale' refers to a field.
> Fields cannot be used in page headers or footers.'
> I tried putting a subreport in the header and that does not work either.
> It would be very limiting to not allow database data in the header of a
> report! (Very easy to do in Crystal Reports)
> Also keep in mind that I do not want my header in the 'body' region.
> Thanks everyone.
>|||Hi, Ponnurangam..
This way only can show the field value in first page,
the second page, cause the textbox doesn't exist,
so the value of reportitems become null...
I want the value of reportitems can keep in whole report,
no mattter report has how many pages!
Any idea about this?
Thanks!
Angi
"Ponnurangam" <ponnurangam@.trellisys.net> ¼¶¼g©ó¶l¥ó·s»D
:eTA7VcKwEHA.2908@.tk2msftngp13.phx.gbl...
> Place the field in any of the textbox(say textbox10) in body section
> Then use =ReportItems!textbox10.value in pageheader section
> Ponnurangam
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
> news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
> > Group,
> > I would like to have a value (basically a scalar from a stored proc) in
my
> > header but I keep getting the compile error:
> >
> > 'The value expression for the textbox 'LastSale' refers to a field.
> > Fields cannot be used in page headers or footers.'
> >
> > I tried putting a subreport in the header and that does not work either.
> > It would be very limiting to not allow database data in the header of a
> > report! (Very easy to do in Crystal Reports)
> > Also keep in mind that I do not want my header in the 'body' region.
> >
> > Thanks everyone.
> >
> >
>|||Hi,
(1) You can have a textbox that exists for all pages(by making this textbox
visible false) or
(2) Try using Parameters
Hope this Helps
Ponnurangam
"angi" <angi@.microsoft.public.sqlserver.olap> wrote in message
news:um99qaLwEHA.4048@.TK2MSFTNGP15.phx.gbl...
> Hi, Ponnurangam..
> This way only can show the field value in first page,
> the second page, cause the textbox doesn't exist,
> so the value of reportitems become null...
> I want the value of reportitems can keep in whole report,
> no mattter report has how many pages!
> Any idea about this?
> Thanks!
> Angi
> "Ponnurangam" <ponnurangam@.trellisys.net> ¼¶¼g©ó¶l¥ó·s»D
> :eTA7VcKwEHA.2908@.tk2msftngp13.phx.gbl...
>> Place the field in any of the textbox(say textbox10) in body section
>> Then use =ReportItems!textbox10.value in pageheader section
>> Ponnurangam
>> "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
>> news:en7UJiFwEHA.728@.TK2MSFTNGP11.phx.gbl...
>> > Group,
>> > I would like to have a value (basically a scalar from a stored proc) in
> my
>> > header but I keep getting the compile error:
>> >
>> > 'The value expression for the textbox 'LastSale' refers to a field.
>> > Fields cannot be used in page headers or footers.'
>> >
>> > I tried putting a subreport in the header and that does not work
>> > either.
>> > It would be very limiting to not allow database data in the header of a
>> > report! (Very easy to do in Crystal Reports)
>> > Also keep in mind that I do not want my header in the 'body' region.
>> >
>> > Thanks everyone.
>> >
>> >
>>
>

Data Header on every page

I have a report grouped by accounts. Can I generate something like this:-
Joe Blogs Inc... [Header]
--
Client: Microsoft Group Page 1/5
Total Page 1/25
Account No:- 123456 Address :- 123 Infinate Loop
Account Name : MSFT Location :- Competition Headquarters
Name | Date | Item | Code | Desc | Qty | Price
MSFT 6/7/05 123 3456 Netscape 1 $2
________________________________________________ [5 pages later]
Client :- GOOGLE Group Page 1/20
Total Page 6/25
Account No:- 876543 Address :- 678 Google Valley
Account Name : GOOG Location :- Googlville
Name | Date | Item | Code | Desc | Qty | Price
GOOG 6/7/05 123 3456 Netscape 1 $2
--
Page 6 - 25 [Footer]
Above shows 2 groups, each group has a small synopsis before the detail data
begins. I have been racking my brains trying to get RS to do just this. I
intend to have 1 dataset which contains all this data(joined in the sql),
however I have no problems having 2 datasets, 1 for Detail and 2 for Synopsis
if it is so requried - I just need directions on how to join the 2.
Hope ya'll can help...It would probably be best to use only one dataset. It looks like you can do
all of this in a single table with groups and merged columns. If not, then
a list with an embedded table.
Paul Turley
"d pak" <dipakb@.exchnage.ml.com> wrote in message
news:414D274C-BB96-42DD-9BD0-B5DE142EC79A@.microsoft.com...
>I have a report grouped by accounts. Can I generate something like this:-
> Joe Blogs Inc... [Header]
> --
> Client: Microsoft Group Page 1/5
> Total Page 1/25
> Account No:- 123456 Address :- 123 Infinate Loop
> Account Name : MSFT Location :- Competition Headquarters
> Name | Date | Item | Code | Desc | Qty | Price
> MSFT 6/7/05 123 3456 Netscape 1 $2
> ________________________________________________ [5 pages later]
> Client :- GOOGLE Group Page 1/20
> Total Page 6/25
> Account No:- 876543 Address :- 678 Google Valley
> Account Name : GOOG Location :- Googlville
> Name | Date | Item | Code | Desc | Qty | Price
> GOOG 6/7/05 123 3456 Netscape 1 $2
> --
> Page 6 - 25 [Footer]
> Above shows 2 groups, each group has a small synopsis before the detail
> data
> begins. I have been racking my brains trying to get RS to do just this. I
> intend to have 1 dataset which contains all this data(joined in the sql),
> however I have no problems having 2 datasets, 1 for Detail and 2 for
> Synopsis
> if it is so requried - I just need directions on how to join the 2.
> Hope ya'll can help...

Data from the database does not seems to load on screen...pls help

everything is ok.. the connection is on..the page can be loaded... no error...

BUT the data from the database cannot be retrieved... as in.. it just didnt load on screen...

i dont know whats wrong... i have follow all the steps show on a book.. can anyone pls help me?? thks

Two common possibilities. First, do a CTRL-Refresh on the page and make sure you're not just seeing the data your browser cached. Second, your code isn't working. Can't help with the second, since I don't know what book you used or what your code is.

Jeff

|||

ok this is my code:

private

void Page_Load(object sender, System.EventArgs e){

sqlConnection1.Open();

dsCustomers1.Clear();

sqlDataAdapter1.Fill(dsCustomers1, "Customers");

if (sqlConnection1.State == ConnectionState.Open)

Label4.Text = "SQL Connection is open";

else

Label4.Text = "SQL Connection is closed";

}

i used the dataAdapter wizard to configure everything, do the dataset and binding too...

|||Where is the code to show content from dsCustomers1? If you're binding it to something like GridView, make sure to?call?Page.DataBind()?or?GridView.DataBind()?before?you?want?to?see?the?data.