U can make use of SQL to generate random strings/numbers. I have patsted to sql query below; hope it helps.


CREATE procedure dbo.GenerateRandomString (@useNumbers bit, @useLowerCase bit,...

Though this ain't db design question I will help u out. When u make a transaction, subtract the transacted stock from the product. When doin' a stock take, simply, the product table will have the...

I believe the best way to learn is through challenge. If you have good database knowledge then you should not have a problem. You won't take time to know Sql server if you know access very well. Also...

You need to declare "CurrentOutLet" before the try...catch block. Good luck!

You need to declare "CurrentOutLet" before the try...catch block. Copy and paste the code below; Good luck!

public SqlDataReader Current_outletReport(string code, string startdate, string enddate)...

Check the type definition of "User ID" and make sure it is int, number...(not text). If it accepts text you'll have to restructure your statement; "Select * From Codes Where User ID = '" +...

I am trying to display a crystal, from an object report in asp.net using c#. Can anyone help me out. The idea, as much as I understand is, object -> table adapter -> Data table -> crystal report...

Try installing the full version of crystal XI. It must work. I had the same problem when I installed the trial version, from crystal IIX. Once I got the non-trial version, everything went back to...

When loading from a data object, point the DO to the table adapter -> data table -> crystal report viewer then populate it into the crystal reports file.