glennt

Hi group, I'm still learning Visual Basic and SQL. Please overlook my inabilities. I'm writing a module that is meant to write a small amount of data to a database. I've named these fields 'PrinterID', 'PrinterName', 'PrinterNumber', 'PrinterLocation' and 'PrinterAddress'. The user will eventually have 30 or 40 records to …

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 …

hi, below is my code. i want to get grand total based on boothID but i seems my code does not functioning. I still get same GRANDTOTAL even i have different BoothId in the sql. How do i do that. Do i need to add something in my code. PLEASE …

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 …

Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND CityId IN (23,45,85,86)' …

I am using BIDS 2005 to write a report. The report takes a begin date, end date, and the parameter for salesperson names are filled by a query based on the date range entered. The report generates the stats for the salesperson when one is selected individually great. My task …

Where should I keep connection object to database like ISession or SQLConnection? What's the best solution and why ? Is it Application, Session or Items ?

Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is …

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 …

Here's the code: [code] Private Sub btdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btdAdd.Click 'Sets up the connection to the database 'Dim myConn As New OleDb.OleDbConnection() 'Dim sql As String con.Open() Dim cmd As New OleDb.OleDbCommand ("INSERT INTO Contacts(Company, First, Last, Title, Address, City, State," & _ "ZipCode, …

Sub CalculateStorageCharge() Dim datedue, datecollected As Date Dim daysoverdue As Integer Dim storagechargetotal As Integer Dim storagechargefeeperday As Integer = 5.0 daysoverdue = DateDiff("d", datedue, datecollected) If (daysoverdue) > 0 Then storagechargetotal = (storagechargefeeperday * daysoverdue) Else : storagechargetotal = (0 * storagechargefeeperday) End If storagechargetotal = CInt(txtStorageChargeFee.Text) End Sub …

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 …