sql

  1. P

    Question No value given for one or more required parameters on join

    :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...
  2. D

    Importing Excel to a SQL DB table visual basic

    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...
  3. S

    Question Connecting to ODBC then parsing data, then viewing in datagridview

    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...
  4. nevron

    Nevron Gauge for SQL Server Reporting Services Now Available

    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...
  5. J

    Question Creating a punch clock?

    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...
  6. A

    Save SQL data in xml and retrieve back

    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
  7. M

    Question Connecting multiple clients to single DB

    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...
  8. Neodynamic

    How To: SQL BLOB Composite Images Data Binding using ASP.NET and ImageDraw

    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...
  9. Max D

    AccessImagine - make inserting pictures in your app or DB easy

    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...
  10. R

    Question getting data from a listView

    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...
  11. tommyready

    Question Dataset inserted into SQL table

    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******
  12. V

    Question Trying to integrate my page with SQL

    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...
  13. A

    Create Database Connection String Builder like SQL Connect to Server interface

    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...
  14. R

    Resolved save text box info into sql database?

    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...
  15. S

    Display XML Select Node values in the asp.net label

    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>...
  16. T

    Question How do I use the database?

    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? :(
  17. D

    Create homework project called Cream Delights, an order form/inventory program.

    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...
  18. S

    Multiple LIKE clauses

    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...
  19. B

    First .NET database that targets Web & Web 2.0 is released

    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...
  20. A

    Aspose.Total for Reporting Services Q3 2008 Released

    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...
Back
Top