6,934 Topics
 | |
| | The following is the complete coding for moving data from sql to access, I get an error saying that Microsoft JET Database Engine missing (;) at the end of sql statement!!!! Could you tell me what I am doing wrong? Imports System.Data.OleDb Imports System.Data.SqlClient Public Class frmMain Inherits System.Windows.Forms.Form Private … |
| | I'm trying to restore previously backup text file into sql server on specified database. Could it be possible using VB.NET? if possible please help me.. |
| | i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE. |
| | Hello all, First off I am using VB.net I have a dropdown list in the Item template. I would like the user to select a value and update the database without clicking an update button. Here is the Code for the DDL [CODE]<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="provider" DataValueField="provider" AutoPostBack="True" AppendDataboundItems="true" … |
| | Hello, I am trying to connect a VB.NET 2003 Oledbdataadapter through the wizard to a SQL Server 2005 Database, but i get an error message during the wizard. These are my steps: New Connection, Select provider (Microsoft OLE DB Provider for SQL Server), Select Connection: server name, log on: use … |
 | Hi Flocks.... I am developing a web site by using Joomla And I need to get a data from data base under the following criteria 1. item should be a published (in my module published is 1 and unpublished is 0) 2. and selected data should be a shorting under …  |
| | hai all, i am working on a project, my project have 3(bronze, silver, gold) types of payments, payments are done through the paypal the expiry date is one month. if user reach the expirydate we must send email to him, after expirydate is passed his payment type change to bronze(it …  |
| | Ok I am currently learning php through wordpress and I have a small project to create a running website which displays the results. CUrrently I can display the results for a certain race that I hard code: [code] <?php // Connects to your Database mysql_connect("XX.XX.XX.XX", "admin", "pwd") or die(mysql_error()); mysql_select_db("db") … |
| | I'm trying to make an .aspx page which would allow me to change values in the database. It has a datagrid which shows everything from one database table, and allows me to edit the data row by row. Everything goes smoothly as anything, but when I try i update the … |
| | Hi there, I’m very new to ColdFusion and I’m still going through the learning process. I have a report to create in CF and I don’t know how to start: I have three tables in 2 databases: tblEmployeID with EMPLOYEEID, EMPNAME, MGRName (this is in SQL 2000) tblCategories with CODEID, … |
| | I am very new to writing sqls in visual foxpro 9 but have managed to write the script below to provide sales information. This sql works and even dumps the result into Excel, BUT I would like to enter a subtotal of sales and cogs after each product code, while … |
 | Hello, Just need quick help in PHP + SQL SERVER 2005 DB CONNECTION ...i having problem while connection SQL SERVER 2005 WITH PHP APPLICATION WHICH WORKING PERFECTLY IN LOCALHOST AT MY PC BUT IT NOW NOT WORKING ON THE SERVER SO DON'T KNOW WHATS WRONG ? I THINK ANY SERVER … |
 | I have a form that has multiple text boxes, check boxes etc... The question is, instead of writing out: [CODE=c#] cmd.Parameters.Add(new SqlParameter("@myparam", (object)textbox.Text));[/CODE] a million times for each parameter, is it possible to load all of the names of the objects on a form into an array and just do … |
| | hey, i need both the import.sql.date; and import.util.date, at the moment im importing them like import.sql.*; import.util.*; How do i specify which library i want for any particular Date object?  |
| | [code] string sqlInsert = "INSERT INTO Transaction " + "(VIN, Price, TranDate, TranType) " + "VALUES('" + VIN + "', '" + price + "', '" + aDate + "', '" + transType + "')"; // check SQL string in Output window for debugging Console.WriteLine(sqlInsert); myDataAdapter = new OleDbDataAdapter(); //insert … |
| | Hi, This should be a simple query but I am not able to figure out how to get the result I want. I have two tables A and B and want A left Join B however, I do not want all of table A. I want to restrict table A … |
| | I have created a DLL file using VB6.0 and the registered the DLL into another server. Now I have created a DTS Package (ActiveX Task) which will create object of the DLL and call a particular function. The problem is when I execute the DTS task from my ID, everything … |
| | Does anybody out there know of any VB.Net tutorials regarding pulling and adding records out of a sql database? I am trying to figure this out on my own, but I just need an example program to show me how to do it. I have figured out how to connect …  |
 | Hi friends..... As when i am doing this task and found know help .............. here i am putting steps for importing data from Excel sheet into SQL Server 2003. How to Import data from excel sheet to SQL Server Note : - Sheet should be exactly same as Table in …  |
| | I have binded a textbox to a column in a SQL Server 2005 Database, when i fill the dataset it displays the data, but when i click the save button it doesn not save the changes to the database. I used this same code to do a Datagridview and it … |
| | Hi, I have designed a front end screen for a simple login page with two fields username and password in ASP.net/VB.net. I want the data that I enter into the textboxes to be populated into the database, on click of submit button and a confirmation message like 'Your data has … |
| | How to create Database connectivity for sql server express edition 2008? plz Help me.. i am confused so much... |
| | Hi Guys, I have a problem connecting to a SQL Server from Windows 7 - this particular server I can only connect to by using the named instance from Win XP - I can connect to other servers that does not require you to connect to the named instance eg: …  |
| | Hi Folks: I am still having trouble moving data between sql and ms access databases. Has anyone got any idea? Bob Ghodsi |
| | i want to display a selected record from my database to the data report in VB6. i used the foll. code, where cuno is the value of a textbox. i m passing the value of cuno through a module. SELECT * FROM Bill WHERE ID=cuno but when i run it, … |
| | i enter 3 identical records in an sql database table. Normally this should not have happened and the dbms is to check for identical records. Now when i try to delete or update any record, an error message is displayed and the record is neither deleted nor updated. any help … |
| | Hi. my name is srikar.......and my query is How to differentiate system databases and user created databases in sql server 2005?????????????? |
| | Hi I want to add the table names from a database in sql server to a combobox with vb.net windows programming. Its a customer accounts database where for instance I add a new Account holder which creates a new Table and when I want to view a specific account holder …  |
| | I hope you can help me. I'm working on a program that will open any Access database that might be on the system. The problem I'm having is that I cant get get the SQL statement to show all the tables within the database. The code im using is as … |
| | [B]I enter 3 identical records in an sql database table. Normally this should not have happened as the DBMS must check for identical records. Now when I try to delete or update these records, an error message is shown. What to do?[/B] |
| | Does anyone use it? Seems kind of scary to me the thought that I would allow a mysterious command to alter data in my tables. Is it better to write your own update strings and execute them or use the command builder? Does it matter? Edit: PS the new site … |
| | HEy everyone. I've been workign on this for a few days now and it's due tomorrow, so I thought I would ask a developer community for any input. Here is what is supposed to be happening. The Server starts. The Client Starts. The user enters a table name into the … |
| | i'll attach a little snippet: [CODE] comd = New OdbcCommand("INSERT INTO news (new_title, new_content) VALUES (@newTitle, @newContent)", conn) comd.Parameters.Add("@newTitle", OdbcType.Text) comd.Parameters("@newTitle").Value = newsTitle.Text comd.Parameters.Add("@newContent", OdbcType.Text) comd.Parameters("@newContent").Value = FCKeditor1.Value conn.Open() comd.ExecuteNonQuery() Response.Redirect("default.aspx") [/CODE] this code executes, and my database is updated, but the new_title and new_content fields are still NULL. i've … |
| | HI Everyone, I have designing a desktop application with SQL SERVER 2005. I have one form where user can take a full backup of SQL Database in one File. I have following controls : 1. txtSQLServerName 2. txtSQLDBName 3. txtSQLSQUserID 4. txtSQLSAPassword 5. txtBackupLocation 6. btnStart 7. btnCancel When user … |
| | ** database table in visual foxpro ver.7 db2, fields: pid,fl1,fl2,fl3 ** database table in MS SQL database1 database1 fields: field1,field2,field3 Code in fox: SET DATE GERMAN uz1=ALLTRIM(db2.fl1) uz2=ALLTRIM(db2.fl2) uz3=ALLTRIM(db2.fl3) pMySQLstr="DRIVER=SQL Server;SERVER="path+"\SQLEXPRESS;"+"UID="+name+";PWD="+pwd+";Database="+database1" pMySQLhandle=sqlstringconnect(pMySQLstr) SQLSETPROP(pMySQLhandle, 'Transactions', 1) && Automatic transactions SQLEXEC(pMySQLhandle, "update database1 set field1=?uz1, field2=?uz2,field3=?uz3 where id=?pid") SQLDisconnect(pMySQLhandle) ** end sql … |
| | Plz help me out to resolve a conflict. I have made untiring efforts to resolve but coudln't. I have showed my data in gridivew now in windows forms now i want that when i make chages on the gridview using it like an excel sheet. These changes should also be … |
| | i have a textbox to upload .csv file. after i click upload it insert the .csv file into sql server database how to insert .csv file using vb.net into sql server |
| | Hi all, been working on this problem for a while now but having little success finding a satisfactory solution. I have a DTS package which contains two connections. one for SQL, the other for AS4000. I would like to pull records from the AS400 table using Account numbers stored in … |
| | Hi, I'm developing this query for a dashboard using System Center Config Manager Dashboard. The query needs to produce a table which shows the number of computers which have Office 2007 Standard edition in one row, and the next row should show the number of computers which do not have … |
 | Hello guys, I am asking a very simple thing to be done in my project (May be I've forgotten the syntax)......... I've taken a drop-down list in which diff. user-names are coming and added a delete button to delete the full row which contains the selected drop-down list user-name. I've … |
| | [code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" … |
| | I have to add a not null column in a table. I am using [code]IF NOT EXISTS(SELECT * FROM information_schema.columns WHERE column_name = 'xyz' AND table_name = 'abc') BEGIN ALTER TABLE abc WITH NOCHECK ADD xyz MONEY NOT NULL END[/code] It gives me error ALTER TABLE only allows columns to … |
| | Hi folks: I get the following error when I try to convert sql to access: Microsoft JET Database Engine missing (;) at end of sql statement. The first part works fine but I get the error running second part. Below is the complete coding in vb.net for data transfer. [code] … |
| | Allo all, I'm using a DataSet to collect a random comparison from a database, and then passing those values to Public Variables, then constructing two Insert Statements (which shows on screen, and is valid). With the [B]two Insert Statements[/B], I'm using two buttons (in an ASP.NET Page) that Call a … |
| | hi how can i add data to a unbound datagridview in C#. i have columns with a combo box column and a check box column and a calender control column. how can i add data to these columns in a datagrid view in C# please help me thanx appriciate a …  |
| | Is there a difference between regular SQL and Scalable/Pervasice SQL? |
| | Hi All, I am new to SQL and I want to know how I can run loops in SQL such that for every element in one table I want to extract all elements from another table. i.e. If we have Table-A and Table-B then for every element in column1 of … |
| | Hi, I was wondering what is the "cleanest" way of combining two datasets by taking all the values from one data set and only the values from a second data set that have an index that does not appear in the first. Both data sets have the same columns. Even … |
| | Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | … |
| | Hello Can someone get me started in the effert to fix this SQL statement to be excepted to create a table in a derby embeded db? [code] public boolean createTables(Connection conn) throws FileNotFoundException, IOException { System.out.println("in createTables:"); boolean createdTables = false; Statement stmt=null; try { String thisTable=ModelUtils.getXMLResource("createAdminTable"); System.out.println("thisTable sql String: … |
The End.