dotyell

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 stock on hand.

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 = '" + txtSearchID.Text + "'". Jus restructure your sql statement like I just did. It must work.

U can make use of SQL to generate random strings/numbers. I have patsted to sql query below; hope it helps. [code]CREATE procedure dbo.GenerateRandomString (@useNumbers bit, @useLowerCase bit, @useUpperCase bit, @charactersToUse as varchar(100), @passwordLength as smallint, @password varchar(100) OUT) As Begin if @passwordLength <= 0 raiserror('Cannot generate a random string of …

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) { SqlDataReader CurrentOutLet; try { SqlConnection con; string str = "SELECT SUM(Active_Outlet) AS ............"; con = DbCon.create_sqlconnection(); con.Open(); SqlCommand cmd = new SqlCommand(str, con); CurrentOutLet …

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 if your client wants the solution like yesterday, I suggest you make …

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 viewer then population of the report file. I want to populate the …

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 normal. Gd luck.

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.