|
thanks for that friend,
I got it now.
I have new question, how can i add gridview header above header?..
Thanks
Bernie
|
|
|
|
|
You can try to use the gridview pager template for that sort of thing.
Ben
|
|
|
|
|
What are the settings to be change for me to show the header on load?. I found out that it depends on the number of rows.
Thanks
bernie
|
|
|
|
|
In the gridview prerender event you need this kind of code:
if (!GridView1.TopPagerRow.Visible)
{
GridView1.TopPagerRow.Visible = true;
}
Ben
|
|
|
|
|
this is a C# code right?how about in VB?. i tried to write as
if GridView1.TopPagerRow.Visible = false then
GridView1.TopPagerRow.Visible = true
but i got some error "Object reference not set to an instance of an object."
is that because my gridview was controlled by dropdown?.How can i do that?
Bernie
|
|
|
|
|
You need to turn paging on. Set the page size to be really big so you only have one page.
Ben
|
|
|
|
|
is that the only setting that i need? it will not display the next or previous?
Bernie
|
|
|
|
|
I set the page size to 10000 but it doesnt show the pager,
I got some error in pre render event. null reference. My gridview is controlled by dropdown
Bernie
|
|
|
|
|
You have to set up the next and previous settings for them to show up.
Ben
|
|
|
|
|
You do need to check for Nothing before you try to do anything. The pre render actually gets called early enough that sometimes the pager hasn't be created yet.
Ben
|
|
|
|
|
Hi,
I have a report viewer, I have tables on my report. I set the hideDuplicates to my dataSet, It hides the data but still adding row on below, any idea about that?. I dont want to display row without data below in my table
Thanks
Bernie
|
|
|
|
|
I would guess that some spaces are being returned or something like that so there is some data being returned. That is my best guess.
Ben
|
|
|
|
|
i have deployed my program in IIS, my report viewer works on my project but when i deployed it on IIS error was display,
An error occurred during local report processing.
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.
Any idea about this?
thank you very much..
Bernie
|
|
|
|
|
i found the solution friend. I put the data item in header or footer not in "details" and it works. my problem now is when i deploy it on IIS, the reportViewer does not work.
Bernie
|
|
|
|
|
My first guess would be that the crystel report view dlls were not distributed with your site. If they were distributed then it must be the format of the dataset itself. Perhaps the report is expecting a root level name of the dataset and isn't getting that. Perhaps the dataset it self is null. Hard to say for sure.
Ben
|
|
|
|
|
my report viewer is working project preview, but when i deploy it in IIS it does not work. but by the way lets forget about that. I am downloading SSRE, it has reporting options. '
I have questions about dateTime, my date Format is 2007-MARCH-23 yyyy-MONTH-dd,
I have 3 dates 2007-MARCH-23,2007-MARCH-24 and 2007-APRIL-01, i have query using BETWEEN,
SELECT * FROM table1 WHERE date BETWEEN '2007-MARCH-23' AND '2007-APRIL-01' but it returns no rows,
but if my query is
SELECT * FROM table1 WHERE date BETWEEN '2007-APRIL-01' AND '2007-MARCH-24'
it returns the rows.
Base on my query SELECT MAX(date),MIN(date) FROM table1, '2007-APRIL-01' is the minimum. any idea about that?.
How can i have between queries?
Bernie
|
|
|
|
|
Don't use between. I would use >= and <= since
between is > and <
SELECT * FROM table1 WHERE date >= '2007-MARCH-23' AND date <='2007-APRIL-01'
I don't know for sure if that will help or not.
Ben
|
|
|
|
|
Hi,
I am using Create User Wizard for membership. How can i add some fields like "FirstName" and "LastName" in CreateUser Wizard and Store it in Aspnet_Profile or in the other table. I want also to store userName and password in "Members" table.
Thank you and God Bless!
Bernie
|
|
|
|
|
Are you using the aspNet_membership tables? There is a standard membership group of tables that can be created automatically if you run a certain sql script. I would suggest using those tables since they were desiged to work with the create user wizard etc.
Ben
|
|
|
|
|
You can not validate time input with a range validator. It will only validate the date part.
In your gridview you need an EditItemTemplate. In that template you need a textbox.
The code would look like:
yourtxtbox.Text='<%# DateTime.Now %>'
Ben
|
|
|
|
|
I have a nightly process (SISS Package) that will do data dump from several tables used for order entry to tables used for reporting. My question is whether there is a general rule from a performance stand point that says wether it is faster to do an update on existing rows in the reporting table then insert new ones or just delete for a range then do a bulk insert. The number of records being updated/inserted would be anywhere from 2 records to 150,000.
Assume that appropriate indexes will be used for deletes and updates.
|
|
|
|
|
I think It's better to update to avoid fragmentation in index.
Unless you drop and rebuild the index after each bulk operation.
|
|
|
|
|
Thanks for the information. Do inserts always cause fragmentation or is this more of a problem with bulk inserts?
|
|
|
|
|
They always do if the new records are inserted between existing record unless there is a space according to a previously deleted record.
You can minimize this effect by configuring fill factor and padding for indexes.
If you use the clustered index as an identity column, fragmentation should not occur.
So there is no very direct do and don't in this case. You need to study your database structure carefully.
|
|
|
|
|
confused:
When I install my web site on D: drive, sql update query through ADO connection in ASP
fails with error message "Query not updatable" or
"Database is readonly", although I open it in write mode.
There is no such problem and it works well when web site is installed on C: drive.
My D: drive is NTFS formatted while C: drive is FAT.
Please help me!:
Balu Chettri
|
|
|
|