|
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
|
|
|
|
|
I think it has nothing to do with drivers but permissions for the specific directory. Therefore, whereever you placed the databsse, give (RW)permissions both to directory and the database.
I think that will solve the problem.
|
|
|
|
|
Can anybody tell me command for updating database using odbc. I am working with asp.net/c#.
|
|
|
|
|
The same as the command for updating directly "UPDATE..."
Do you mean, which class should you use? If so, you would use the OdbcCommand class and perform an ExecuteNonQuery().
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks
No it is showing error to connect to the database
i had given code like this
OdbcConnection c = new OdbcConnection("connectionstring");
OdbcCommand c2 = new OdbcCommand("UPDATE OUTSTANDING SET feild1 =?,feild2 =? WHERE (feild3 =?)", c);
c2.Parameters.Add("@feild1", OdbcType.VarChar, 255).Value = TextBox1.Text.Trim();
.....
can you tell me if there is any mistake.
|
|
|
|
|
Im guessing where you add the parameter but have you tried debugging? Where does it break at?
Cleako
|
|
|
|
|
thanks cleako
i tried with try catch method. it is loading data from the database when I have selected it.but not able to update.
|
|
|
|
|
Oh my mistake, it's so obvious now. You are setting the parameters in the Update command and then adding parameters to the command which works with stored procedures. If you are doing the field1=? etc... you have to post the values at the end as comma delimited values I believe so it should be "UPDATE SET field1=?, field2=? WHERE field3=?", value1, value2, value3
ClEakO
|
|
|
|
|
I am totally confused. I am so sorry. I am very new to this.
I am not using any stored procedure. all the data's are coming to the textboxes(different textboxes) and from there I am updating. so value means value from the textbox.
Thanks a lot again.
|
|
|
|
|
|
|
Is it possible to generate Insert, Update methods for my view.
The view is only a sub-view of one table.
_____________________________
...and justice for all
APe
|
|
|
|
|
yes its possible. And it will store in the real table
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Ok, that sounds good.
Right now I don't get any Delete, Insert or Update methods in my dataadapter. What can I have done wrong?
_____________________________
...and justice for all
APe
|
|
|
|
|
Hi Guys!
I'm working with SQL Server 2000 and I have only started working with it for the last 3 weeks now. I'm basically teaching myself how to use it. Therefore, lots of trial and error  Here are the porblems:
When I create a report and try to run it by pressing the play button, I get a Cannot find TargetServer URL error message. What am I supposed to enter for TargetServer URL, please explain with as little jargon as possible.
Second problem: After I allow the report to continue its execution, the report will show the desired output, but, if I copy the rdl file to the server location that I want the report to be stored in, the report will not run. It gives me the following error message:-
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'XXXXX'. (rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied."
Whats going on? Please explain with as little computer jargon as possible.
Please note that I am working for a company that requires me to work with this software and there is no time to go for a course to learn the software, I need to urgently solve this problem asap. Please help me somebody, or else I'm fired!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
