sql

Ok I have a hosted SQL server 2008 that I am using for an update server for a product catalog. The products table has a column DateModified (dateType) for each product (row) The application uses a local Access 2003 table that contains a table that stores the last date (also dateType) the...

Hello, i'm really stuck on a apparently simple statement. I'm working on a DBF table. When I open the file in a program called "DBF Viewer 2000", it states that the file is a "FoxBase+/dBASE III PLUSE, no memo". If i run this VB.NET code Dim ConnectionString As String =...

I have a database setup and connected as a datasource for use in a simple shop system. The way that i have it is that when the form loads it loads the stock levels of each item into variables, then when an order has been filled update said variables. Then on exiting the form i want it to...

Hi guys, After getting dataset's datatable by using wizard ,we can update those tables rows or table by calling that table's adapter. Like blow: Me.Validate() Me.DepartmentBindingSource.EndEdit() Me.DesignationBindingSource.EndEdit()...

Hi guys , I want to create manual update , delete and insert command... I am curious why ms create those line of commands: UPDATE Department SET ID = ?, Department = ? WHERE (ID = ?) AND (? = 1) AND (Department IS NULL) OR (ID = ?) AND...

Hi folks, I have a form on a page called exports.aspx with a textbox called txtBarcode where I type in a barcode. On the page postback I have the SQL statement below to count how many rows in the DB that has the Barcode. A short version of my codebehind is...

I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect...

Hi All, I was create a project with vb.net and sql server 2005. I was used oledb connection string for database connection. With my sql server database it work properly But i don't know how to connect mdf file using oledb connection string. But I was tried following way but it got error...

Hey Guys, Good day! I just want to learn how to join 3 tables in my SQL Database? Here is the structure: Table Name: Section1 Fields: Student Number Table Name: New Student Fields: Student Number Last Name First Name...

Hi guys, I'm not sure if I posted this in the right area but here goes. I want to connect to a SQL Database remotely located on my website (eg. abc.net) and this is the code I am using Imports System.Data.SqlClient Private Sub OK_Click(ByVal sender As System.Object, ByVal e As...

First post here.. So here is the thing, I'm working on a school project which is a fleet-management system with GPS-devices. No problems so far, the GPS etc is working like a charm. I'm currently working on charts, to which i need to fill a xml file from a datatable. The chart I want to make...

i want to use the data adapter for standard login and registration procedures. my first form is a login window contaning 2 textboxes,one for username and one for password.. i used a table adapter to connect to database.. using sql statement.in the adapter "SELECT COUNT(*) AS Result...

I got this in my SQL statement. I "BOLDED" the problem. SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID = @CustomerID I saw a video tutorial...

Hi, [Scroll down for the real question] I've been challenged by my college tutor to create a program that allows employees to "clock in" and "clock out" when they arrive and leave work. My general idea is that I could create a VB.Net application for staff to "log in" with. This would then...

How to create Crystal Reports featuring barcode images using SQL Stored Procedure in ASP.NET Prerequisites - Neodynamic Barcode Professional 3.0 (or greater) for ASP.NET (WebControl) - Microsoft .NET Framework 2.0 (or greater) - Microsoft Visual Studio 2005 - Microsoft SQL Server 2000 (or...

Technologies used - Neodynamic Barcode Professional 3.0 for Reporting Services - Microsoft .NET Framework 1.1 or greater - Microsoft Visual Studio .NET 2003, Microsoft Visual Studio 2005 or SQL Server Business Intelligence Development Studio - Microsoft SQL Server 2000/2005 Reporting Services...

Confused!! I am trying to fill a DataTable with a DataSet using a SQL query with one parameter. The parameter is the Node text of a treeview whose checkbox has been checked. It will retrieve Products from one table and any associated Packages from a different table. I am using a FOR loop to...

I have spent the day on this and still can't get it to give me the results I want. Here is my data: InvLocation (30,000 recs): ID Location InvAvail 9005 22BULK 1 9004 22BULK 1 9004 22BULK 2 9004 22BULK 1 9006 22BULK 1 Items (80,000 recs): ID Sku...

We use JOIN in the SELECT statement often to retrieve data from multiple related tables. But, some times we can get into a situation where we may need to use UPDATE statement by joining multiple tables. Consider a situation: A table named as USER_DATA is there which contains user details. This...

Basically, I want to create a timer for each row of data that will get returned by a SQL query: SELECT * FROM Projects I would want the timers to be called "Compteur" & ROWID. This really is necessary. I need them to have different Ticks and so that some can be enabled all at once. Basically...