[sql] Forum Topics

I have a form set up and on that form is a DataGridView, on that DataGridView I would like to display all of a customer's transactions. I am having a problem where the debugger is throwing me a "Syntax error in JOIN operation." and I can't proceed. [CODE] ' Select …

Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is …

I am trying to have a search bar where user will input a string ($var) which after i will search that sting in the field named: "itemname". i will search all the different tables in the database and create a new temporary database named: searchtable. seachtable should contain all the …

hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business …

I'm a very new developer (if you could even call me that), and I'm killing myself here. Essentially here's what I'm trying to do. A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on …

Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx

Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to …

guys How do you Create Database in MS Access Using Oledb in vb.net?

how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name')))

I need a timer that will change the text of a combobox which is binded to a database. My Application which is based on hospital management wherein a doctor has to visit rooms within 6 hours. If 6 hours elapse the combo should show "need......" and if not something "......" …

Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss

Hi I want to generate sequence number in C# window application I have got one link on Google, but I it is not helpful. I want that on click to add button an order sequence number should generate and stored in SQL Database i have written this code but it …

Hi I need to migrate an application from MS Access to SQL Server (2005), and i'm using the code bellow, but i'm getting an error when the compiler reaches the AddNew instruction. It gives me "Run-time error '3027': Can't update. Database or object is read-only". [code] Dim DBTesteSQL As Database …

I am trying to use a search script i found online and i am having a problem with the query. I am trying do a query from multi tables. I have 12 tables, all have the same fields: name, phone etc. each table is a different category of items: appliances, …

Hi all, i wonder is it possible to display my images from database into table with 4 rows and 4 column? How can i do that? [CODE] $dbConn = mysqli_connect(DBSERVER, DBUSER, DBPASS, DBNAME) or die(mysqli_connect_error()); $sql = "select * from products"; $result = mysqli_query($dbConn, $sql) or die(mysqli_error($dbConn)); echo "<table border …

i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button?

Hello everyone, before i ask this question i would like to say first that im a beginner in asp c#. I would like toask for a tutorial on making a download button for binary datas. My file upload is already working fine. I just need a download button so i …

Hello, I have run into a problem where I need to update multiple rows in an SQL table at once. I have found and tried to use the tutorials on setting an ID and then looping through the data that way ([url]http://www.daniweb.com/forums/thread35096.html[/url]) but my setup is a little different: The …

Hi, I have table structure as follows Table Name- facilities facility_id | hotel_code | facility_name 1 1 Parking 2 1 AC 3 2 Parking 4 3 Parking 5 3 AC 6 4 AC Now i have to find the 'hotel_code' that having 'Parking' and 'AC' both facilities ie 'hotel_code' as …

i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table …

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time. Not the user time because he might be …

i want to generate crystal report using vb6.0 using invoice table which have rate column and total should round up like 63.7 to 64.00 invoice table is in sqlserver 2005

I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September …

How do I replace 63 strings in a .sql via php. Im making a multiforum software and I can't figure this out.

Guyz i have this insert function that is supposed to help me insert data but somehow i dont know how to actullay call it and get it to insert data [CODE] Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click DataAccess.InsertNewRecord(txtName.Text, txtSurname.Text, txtID.Text) End Sub [/CODE] [CODE] …

hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute …

Hello, I made a PM system but the thing that makes it read isn't working. Can you take a look at it anybody? [code] $postid = $_GET['postid']; mysql_query("UPDATE pm SET read=1 where id=$postid") or die(mysql_error()); [/code] And it gives this error: You have an error in your SQL syntax; check …

Morning, Please a clever person help me, i am using VS2010, I have a form with a button with the following code. [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim cryRpt As New ReportDocument Dim crtableLogoninfos As …

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …