|
devboycpp wrote: In two of my pages I have 6 roundtrips to sql server.In the other 3.Lets say in the worst case average of 3 roundtrips per page.All queries are simple queries that return records with few fields.and number of records are not more than 30.
Can problem be from my side ???? Is it that hard ?
First you need to identify the query that is throwing the timeout exception. Once you've identified the query, you can see if it is possible to optimize the query. If not, you can try setting the SqlCommand CommandTimeout[^] to a longer number of seconds.
|
|
|
|
|
Hi,
I am new to Crystal Report. I am having a problem with crystal reporting. When ever I try to connect the Report with Related data by Dataset, no data appears on Report.
But without related data it shows records on Report.
I am trying to follow the tutorials and Database expert to Generate my report
does any body have any clue?
|
|
|
|
|
The insurance Software is to be developed for a group that is acting as an intermediary for the provision of car rental worldwide.
insurance is a tool used by customer or general public to avail the facility of online car rental service. The system is also used by the executives of call Centre setup by the client to provide services to offline customers. The system shall also assist various agents in the travel industry to provide services to their customers.
Desktop application will be a powerful window based application. It will be implemented using VC# front end and SQL Server back end.
o Functionalities
· It should provide interface to Manage Suppliers, Product, Price, Vehicle, Customers, Agents, and Whitelabeller etc.
· It should be able to Manage Users their roles and permissions.
· It should provide an interface for bookings
· It should integrate with Payment application ( Servebase) for payment authorizations.
· It should be able to generate various reports for Admin, Management and Finance.
o Users : It can be used by
§ Call Centre at Central Office
§ Call Centre at regional office
There are two main components of the business the internet and the inhouse call Centre reservation system.
· Booking Engine : this can be used to make online booking
· Agent Interface : this can be used by registered agent to make bookings and to view their details.
· Admin Interface : this can be used by Admin members of the company to view some of the reports.
|
|
|
|
|
And? This reads like a homework assignment. Do you want us to do your homework for you? Or do you have an actual specific problem.
|
|
|
|
|
I was hoping for the homework-done-for-free thing.
Homework assignment completion fee: $300hr (note:5 hour minimum)
"When I get a little money, I buy books and if any is left, I buy food and clothes." --Erasmus
|
|
|
|
|
I have some tables
AccountTypes (1:m)Accounts (1:m)Transaction
AccountTypes
------------
ATypeID AType
---------------------
01 Expanses
02 Advance to Contractors
.
.
.
10 Banks, Sundry Accounts
Accounts
--------
AType AC AName OpDr OpCr Date
----------------------------------------------------------
01 001 Advertisements 0.0 100.0 20/10/2006
..
.
.
.
Transaction
-----------
VType VNo Date TsDesc AType AC Debit Credit
--------------------------------------------------------------------------------------
CP 101 20/10/2006 paid for newspapers 01 001 100.0 0.0
now I want to see all AType,whether their against transaction are occured or not, their Opening Credit and debit
(OpDr & OpCr) and sum of credit of all transaction against that Atype and Acode (AC).
My query only returns records of those which against some transaction are occured. But I also want to include
Opening Cr and Dr in my Reports for trial Balance.
My Query is this:
SELECT AccountTypes.ATypeID, AccountTypes.AType, Accounts.OpDr + SUM([Transaction].Debit) AS TDr, Accounts.OpCr <br />
<br />
+ SUM([Transaction].Credit) <br />
AS TCr<br />
FROM Accounts INNER JOIN<br />
[Transaction] ON Accounts.ATypeID = [Transaction].ATypeID AND Accounts.AC = [Transaction].AC <br />
<br />
INNER JOIN<br />
AccountTypes ON Accounts.ATypeID = AccountTypes.ATypeID<br />
GROUP BY Accounts.OpDr, Accounts.OpCr, AccountTypes.AType, AccountTypes.ATypeID<br />
I think there is some join Problems, Left join may be work.
but can any one help me.
Thanks
Syed Shahid Hussain
|
|
|
|
|
Hi Syed
You need to use an outer join:
SELECT AccountTypes.ATypeID, AccountTypes.AType, Accounts.OpDr +<br />
SUM([Transaction].Debit) AS TDr, Accounts.OpCr +<br />
SUM([Transaction].Credit) AS TCr<br />
FROM Accounts<br />
LEFT OUTER JOIN [Transaction]<br />
ON Accounts.ATypeID = [Transaction].ATypeID<br />
AND Accounts.AC = [Transaction].AC <br />
INNER JOIN AccountTypes<br />
ON Accounts.ATypeID = AccountTypes.ATypeID<br />
GROUP BY Accounts.OpDr, Accounts.OpCr, AccountTypes.AType, AccountTypes.ATypeID
Inner join only reports results where both of the source tables have matching rows - so you would only see accounts that have one-or-more transactions. Using an outer join means that you can see accounts that have no transaction too.
Hope this helps.
Andy
|
|
|
|
|
Hi,I have a small problem,first we used MySql as a database,The database contain realworld data,suddenly we have need to shift database to Sql Server
Is their any way to avoid refill data manually in SqlServer.
Plz,Help me in Solving the problem
Advanced Thanks,
Srilakshmi
|
|
|
|
|
You can use Enterprise Manager (if you have SQL 2000), or SQL Server Management Studio (if you have SQL 2005) to import your data (tables, columns, records) from MySQL.
The wizard to do import/export data should be simple enough to follow.
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
where can find A ADOConnection CLASS package?
i want a CADOConnection ,CADORecordSet ,CADOCommand CALSS ,THANKS For your help first!
my email :swgzj@sina.com
|
|
|
|
|
swgzj wrote: where can find A ADOConnection CLASS
A set of ADO classes - version 2.20
[^]
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
I've got a fairly simple bit of code which will call a stored proc with the following signature:
dbo.UpdateAssembler (@Id int, @Name char(20), @IsActive bit, @Stamp timestamp) I've created and initialized an SqlCommand object with the appropriate parameters setup, the relevant one in this case "Id" has it's IsNullable property set to true. When I try and execute the command I get the following exception:
Procedure or Function 'UpdateAssembler' expects parameter '@Id', which was not supplied. Hmm , I've set Id in the previous lines of code (which could be an int or null , the stored proc does something different if Id is null ).
Any ideas on what might be causing this exception, note that I have verified the following:
- A parameter by the name of 'Id' does exist in the command's parameters (C# side of things)
- Stored proc does want an Id parameter
- The stored proc works fine if I invoke it through the UI in either VS2005 or the Management Studio.
Sig cops got me...
|
|
|
|
|
Ed.Poore wrote: A parameter by the name of 'Id' does exist in the command's parameters (C# side of things)
Okay... But it is looking for a parameter called @Id . Do you supply that parameter?
You might want to post your code - It sounds like a really simple thing like a typo you just need a second pair of eyes to see.
|
|
|
|
|
Hmm, I seem to remember the last time I did something like this it didn't want the @ in the SqlParameter's name, but I shall check it, then I'll post the code if not successful since it's taking an age for VS to load.
Sig cops got me...
|
|
|
|
|
Ok here's the code (putting the @ in made no difference)
Stored Procedure:
ALTER PROCEDURE dbo.UpdateAssembler (@Id int, @Name char(20), @IsActive bit, @Stamp timestamp) AS
BEGIN
IF EXISTS(SELECT * FROM Assembler WHERE ID = @Id)
IF EXISTS(SELECT * FROM Assembler WHERE (ID = @Id AND Stamp = @Stamp))
UPDATE Assembler
SET Name = @Name,
IsActive = @IsActive
WHERE ID = @Id
ELSE
RAISERROR('Different TimeStamps',10,1)
ELSE
INSERT INTO Assembler
(Name, IsActive)
VALUES (@Name, @IsActive)
END Building the SqlCommand (in a semi-factory like method thingy-ma-bob):
SqlCommand command = new SqlCommand("UpdateAssembler");
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("Id", SqlDbType.Int);
command.Parameters.Add("Stamp", SqlDbType.Timestamp);
command.Parameters["Id"].IsNullable = true;
command.Parameters["Stamp"].IsNullable = true; Executing the command:
updateCommand.Parameters["Id"].Value = item.Id;
updateCommand.Parameters["Stamp"].Value = item.TimeStamp;
updateCommand.ExecuteNonQuery(); Note that certain irrelevant bits have been cut out.
Sig cops got me...
|
|
|
|
|
Could you do a check on item.Id and if it is null replace the value sent as the parameter to DBNull.Value ?
|
|
|
|
|
I think I tried that, but it was before I noticed a couple of other mistakes so when I get the chance in a couple of hours I shall do that.
Sig cops got me...
|
|
|
|
|
Yes that's cured it, thanks.
Sig cops got me...
|
|
|
|
|
Ed.Poore wrote: command.Parameters.Add("Id", SqlDbType.Int);
command.Parameters.Add("Stamp", SqlDbType.Timestamp);
command.Parameters["Id"].IsNullable = true;
command.Parameters["Stamp"].IsNullable = true;
If i'm not wrong the SqlParameters are prefixed with @ symbol, and the above lines should be like this:
command.Parameters.Add("@Id", SqlDbType.Int);
command.Parameters.Add("@Stamp", SqlDbType.Timestamp);
command.Parameters["@Id"].IsNullable = true;
command.Parameters["@Stamp"].IsNullable = true;
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
I've tried that and it doesn't seem to make any difference
Sig cops got me...
|
|
|
|
|
Please tell me how to fill null data in textbox or other form controls in VB.Net from Sql Server 2000. I found error in dataset on runtime the application.
Thanks
|
|
|
|
|
rehan_cop wrote: how to fill null data in textbox or other form controls in VB.Net
try following these steps.
1. check the retrieved data for null value, if it is Nothing then
2. set the textbox.Text to empty string or set the controls with suitable values.
rehan_cop wrote: I found error in dataset on runtime the application
what sort of error it is? its not clear.
AND
read this[^]
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
hello...
i am using crystal reports 9 to make a prescription of a patient from the patienttable and disease table.the disease table takes patient id as a foriegn key. now i have 2 problems:
1. i am unable to get patients name of the patient table using the foriegn key
2. how would i show multiple diseases with out getting the disease label printed time and again on the prescription page.
3. how would i use a view... if that is a better option.
thanx...
haseeb
|
|
|
|
|
I have a problem. Whenever we pass an insert statement against database table the exception can be cathced by using sqlexception parameter. I have done with exception where there is a problem with the primary key because i know the error code it genereates when there is a primary key error. But how can i do the same type of checking when there is an error related to foreign key. Wht is the error code for foreign key related errors. Something like below
try<br />
{<br />
insert into database;<br />
if (success)<br />
then do nothing;<br />
else<br />
check about the cause of exception<br />
}<br />
catch<br />
{<br />
if (primary key exception)<br />
dosomething;<br />
else if(foreign key exception)<br />
dosomething;<br />
else<br />
dosomething;<br />
}
any help will be wellcomed.
Any suggestion is well received. thanx in advance
|
|
|
|
|
If I have a problem like this I create a simple test application and experiment. I would create an INSERT that will cause a foreign key violation and see what it returns.
How did you find the value of the Primary Key error in the first place?
|
|
|
|