sql

:confused:Hello All, I have the following SQL query that runs against an Excel datasource and I'm getting the infamous "No value given for one or more required parameters" because of a join. It's erroring on the where t1.[trnVendorName] = v.[Vendor] part. It is acting like it can't see the...

I am trying to write data from an excel spread sheet to a SQL Database. I have been able to connect to the Excel Spreadsheet and read the data but I am unable to get the data to insert into the SQL DB table. the current code is as follows any help most appreciated. Dim plmExcelCon As...

Hey, so I am a new programmer, and I am trying to receive data from an odbc connection. I would like this data to be filtered before it comes in, and then I would like to view it in a datadgrigview. Below is some code I adapted from an example and it is getting an error that reads: ERROR...

Nevron Gauge for SQL Server Reporting Services (SSRS) 2005/2008 is an advanced report item, which delivers a complete set of gauge types, highly customizable axes, tight data integration and unmatched visual effects to your reports. It will also improve your report authoring experience, with its...

Hello! I am attempting to create a punch clock for my business and I am running into a little bit of a problem that I was hoping to get a little help with. What do you believe is the best way to have the program find the same row it created for a "Punch-In" for a single user. To clear this up...

What is the eayest and shortest way to save an SQL SELECT output in to a local XML file and retrieve it back as table rows by another program ? Thanks, adh

Hi, I've written a small auction app and I'd like to know the best way to connect several instances of the auction app to a single DB on the 'main' machine. All clients will have .NET 3.5 installed, XP or Vista OS, and a local version of my Winform application. I'd prefer not to have to...

Technologies used - Neodynamic ImageDraw (2.0 or later) for ASP.NET - Microsoft .NET Framework (2.0 or later) - Microsoft Visual Studio .NET (2005 or later - Visual Web Developer Express Edition) This white paper describes some of the built-in features of ImageDraw controls when working with...

You often need users to provide some pictures to your application – even if it is not database-driven. Its quite time-consuming task to develop a good functionality for end users – and you leave it at some basical stage (like “press-a-button...

Hi i currently have a listview on my form that is set to "details" view and is popoulated by a table in my sql database. what i want to be able to do is when i double click on a selected row i want all the details in that row to appear in another form so that i can edit them. how do i populate...

I have loaded a .csv file into a dataset and now i'd like to import from that dataset into a table in SQL server using VB .net. Is there a quick easy way to do this? Also this will be importing over 13,000+ records. ***JUST SAW I POSTED IN THE WRONG PLACE******

Hello, Please forgive any lack of correct terminology, I have had no formal training and I may get lots of things wrong! My question is this: I have built a sort of intranet, and it contains various request forms, which currently just send emails. I would now like the contents of the forms to...

Hi All, I am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It...

Hi everyone i am trying to save the data from the text boxes on my form to my sql database but im not having any luck please can someone help me? ive simply got 4 text boxes and a save button the code for my save button is as follows. Private Sub btnSave_Click(ByVal sender As System.Object...

Hi All, I have a SQL table with XML Data Type (FormXML). Please see the attached picture 1 of the SQL table for your review. The SQL table displays data fields with values: Name: John Mark CodeNum: 88 Data: 3/19/2009 12:00:00 AM FormXML: <FormXML> <DocInfo> <Check>...

Imports Microsoft.SqlServer Public Class Form1 'How do I use the SQL database? End Class I'm wondering what the class name in the SQL database DLL is. Can anyone help me? :(

Greetings all. Thank you for looking at my post. Please forgive me if I posted this in the wrong area. I am looking for assistance with a homework project in which I am struggling with and very stressed out about. I have spent the last 2 weeks doing a great deal of studying and reading and I am...

Hi, I am trying to return results from an ACCESS database using ASP where all of the search terms are in one of the fields. The query I am using is: SELECT photos.photoid, photos.landscape FROM photos INNER JOIN tblKeywords ON photos.photoid = tblKeywords.photoid WHERE gwlad = true AND...

The first release of Eloquera, the fusion database, is out. Eloquera's architecture and technology specifically targets at the Web developer. It provides the desired objectives of speedier development and maintenance. At the same time, it provides the seemingly contradictory benefit of...

Aspose.Total for Reporting Services Q3 2008 release includes many new and improved features in this suite of Microsoft SQL Server Reporting Services Rendering Extensions. Now you can export RDL reports to multiple file formats like DOC, DOCX, HTML, RTF, WordML, PDF, PPT, PPS, XLS, XLSX and...