glennt

I thought I would jump in here. If I have missed something and one of my questions has already been addressed, let me know. Why do you need to know a row number? If the main reason is to have a unique identifier for each row, I would change the …

I recently had a strange thing happen in an ASP.Net application I wrote in VB. When each session starts, one of the first thing it does is create a record in a SQL table and captures its ID value, which is an identity field. Two sessions were started very close …

If I am understanding correctly, I think that what you need is a where clause. Change your select statement to this: [CODE]SELECT TOP 1 [GrandTotal],[BoothID] FROM RetailerBalance WHERE [BoothID] = boothID ORDER BY TransactionDate DESC[/CODE] You will need to pass the booth id to this function like: [CODE]Public Function CreditBalance(byval …

I have an ASP.NET application that runs one way when I run it within Visual Studio 2010 (the way it should), but when I publish it onto the web server and run it there, it runs differently. I have reset IIS (iisreset), shutdown and restarted the web site, deleted the …

The problem is that you have declared @CityId as an integer but you are trying to set it to a string value: SET @CityId = ' AND CityId IN (23,45,85,86)' Anything in single quotes is considered to be a string value and unless it can be converted to an integer, …

I am not sure here but I think that what you are looking for is not help with SQL but help with your software. I no not know where you should look for this kind of help.

I have never seen the "remove" code in the connection strings area. What is this needed for? [QUOTE=kumar169;1360885]for creating the session "global.asax" file is right, when you creating the session u must wright the code "Session["sec"] = 0" inside the Session_Start () function. and for connection the web.config is right …

[code=sql]UPDATE farmlink.dbo.tblCattle SET curMartPrice = FarmData.dbo.tblFarmDetails.MartPric FROM FarmData.dbo.tblFarmDetails INNER JOIN farmlink.dbo.tblCattle ON strEartag =FarmData.dbo.tblFarmDetails.EarTagNo WHERE FarmData.dbo.tblFarmDetails.curMartPrice=0 Or FarmData.dbo.tblFarmDetails.curMartPrice Is Null;[/code] I assume that you are getting some kind of error. Please post. Your where clause can be rewritten as follows in case the nulls are giving you fits: [code=sql]WHERE isnull(FarmData.dbo.tblFarmDetails.curMartPrice,0)=0;[/code]

I have a users domain and user id. I would like to retrieve the full user name. The data is coming from a SQL table for display onto an asp.net page. Anyone know how to get the users name for someone other then the user who is using the asp.net …

The SQL looks correct after removing all of the VB code. But there is no way to know what the functions cbdebt, cbequity, cbmezzanine, and cbcredit are returning. I would recommend saving the insert command text into a variable and posting that back to this thread. When you have that …

[QUOTE=j_808;1163674]Not completely sure what you tried using Int32.TryParse and my code failed miserable. "txtStorageChargeFee" is an empty text box and when i click a button it calulates a 'storage charge' which is suppose to be displayed in the "txtStorageChargeFee" text box[/QUOTE] In your code you are using CINT. This assumes …

I understood that a string in VB .Net maximum length was quite large (could be way over 1000 characters) but do not know for sure. I keep having a problem when I concatenate one string to another and the result is the second string. Example: Str1 = “this is the …