6,934 Topics
 | |
| | Hi, I'm having some trouble with SQL Compact Edition, it's popping up with this error when passing a string: "The token specified is too long. The maximum length is 128 characters. [Maximum size of token (if Known) = 128, Token (if known) =" The data type for the field that … |
| | Hi Im using visual studio .net 2003 (not 2005) and I'm looking for a good database to work at and also helpful articles to help me, a newbie to c# and database, start creating a database and linking my forms' data from visual studio to the database. 1) If it … |
| | Good day! I just need to pull all the records in table named "cusname" in sql server to an existing excel worksheet which is located in the folder where my program reside.The name of the existing excel worksheet is "excelcusname". I need to put the records in column C, row … |
| | Hi, As a requirement of one of my assignments, we have to upload images, videos and audio files in a column called fileContents. Earlier I had set the data type for the column as 'Image'. But my professor says that I wont be able to upload Audio or video to … |
| | Hi good day.! Im so confused why my code to get the total records in a certain table in sql server returns false. Im already connected to sql server and set-up a table named "loanlist".This table contains 10 records. But when i want to get the recordcount, it will returned … |
| | |
| | can anyone tell me about sql transcation with example..what are the types are there ?  |
| | Hey all, I'm trying to insert a bunch of rows from an xml document into an SQL database. I have a stored procedure that I'm calling from my program after I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I … |
 | Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER JOIN MTM_ACTV_STAFF MTN ON S.ID = … |
| | |
| | [code] Public Sub add_emp(ByVal emp As EmployeeObj) Dim con As New SqlConnection Dim sqlcmd As SqlCommand 'Dim sqlrdr As SqlDataReader Try If is_emp(emp.Id) = False Then con.ConnectionString = My.Resources.ConnString con.Open() sqlcmd = New SqlCommand("INSERT INTO [Employees] (" _ & "[Id], [SocialSecurity], [FirstName], " _ & "[MiddleName], [LastName], [Suffix], " _ … |
| | I've designed a class diagram for my business entity library, in visual studio 2005, now I was wondering if theres any way to export it to a SQL Script to generate the corresponding tables ... I hope that it can be done... Omar |
| | Hai, Am Using SQL SERVER - 2000 Table Structure CARDEVENTDATE CARDEVENTTIME CARDNO 20090224 92007 485 20090224 92345 321 20090225 163932 168 20090225 164630 471 20090225 165027 488 20090225 165137 247 20090225 165147 519 20090225 165715 518 20090225 165749 331 20090303 162059 240 20090303 162723 518 20090303 155029 386 20090303 155707 …  |
| | I am developing an application an am intrested in having to be able to backup and restore the full SQLServer database from the front end. i have succesfully done the the back up module using the code below [ICODE] Try Using dc As New SqlClient.SqlConnection(My.Settings.TRONICALConnectionString) dc.Open() Using dcom As New …  |
| | I am trying to connect to a sql server using login which accepts the username and password, instead of storing the credentials in the connection string. But whenevr I pass the variable in the connection string I am getting an error which says login failed for the user. Is it … |
| | Hi, I already create connection to sql database and successfull. I need to know how to run two command together?...This is my problem:- [CODE] sqlcmd = New Sqlcommand ( "Select * from Staff_Main where Staff_id like '"&textbox1.text&"'",cn) dr = sqlcmd.executereader while dr.read() label1.text = dr.item(1) 'item 1 is name sqlcmd … |
 | Hi, everyone this is my issue I have to read a binary record from the database and concatenate another string to it, the thing is that is just working one way, I ll put some code to explain better. [ICODE] buffer = rdGetBinary.GetInt32(3);//this is the length of the actual row … |
| | Hi over there, is it possible to execute several SQL Statements with one(!) command? For example something like that: [code] Statement s = con.createStatement(); sql= "CREATE DATABASE MeineDb+ SHOW databases+ USE MeineDb+ CREATE TABLE MeineTestTabelle ( i INT, c CHAR(3), s VARCHAR(8), dt DATE )+ CREATE TABLE MeineAdressen ( Name … |
| | [code] try { //1.Load the database Driver class Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //2.Make a connection to the database Connection conn = DriverManager.getConnection( "jdbc:odbc:MyDataSource"); Statement stmt = conn.createStatement(); String x = jTextField1.getText().toString(); [COLOR="Red"] String sqll ="UPDATE Patient_Comp SET taken='Taken'WHERE ID="+x ; ResultSet rs = stmt.[COLOR="Green"]executeQuery[/COLOR](sqll);[/COLOR] [/code] This is what i wrote to update a …  |
| | Hi all Sorry- The title was wrong, My problem is when I type a the ID number in the text box for updating the record, it gives me an error "Data type mismatch in criteria expression." Could anyone help me please in solving this problem? This is my update code. … |
| | I have Sql server 2000 personal edition which i always use.But today when i tried to copy the while CD to my system,every files are copied except (msolap which is 97.1 MB size).Can anyone please tell me the link where i can get msolap fresh copy for this particular Personal … |
| | Hi All, Can't insert data into SQL database... Keep getting error i dont know how to solve... Plz help Grtz Tiello [B]CODE:[/B] -------------------------------------------------------------------------------------- [code] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As SqlConnection Dim adapter As New SqlDataAdapter Dim … |
 | Please any one help me... I want to insert data automatically to the table while installing an application. how can i do this? Can I generate sql script for this??? Regards Jineesh  |
| | |
| | Hello to everyone !!! I have a problem with query in sql. Look in the photo and you will find details about my problem. Why i cant add a new record. When i will add ID, Emri and Cmimi i want to show them automatically... Does any one have idea … |
| | I want to get the row number of a specific row in the table. Also is this legal? [code] INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........ [/code]  |
| | |
| | Hello All. I am having doubt that, is MS SQL works on Apple Mac Os X AND ".NET" too ?? |
| | Hi, I have 1 textbox and button to insert value into sql server database 2008. But the problem is in database it not appear correctly when had zero front of value....example :- 00001.....in database just appear 1...i try to use nvarchar,varchar,nchar but still same...] Can anyone guide me...tq |
| | I am helping a friend with a project in Visual Basic, it is a program that uses a SQL database. There are some rows in the database, we can review them just fine. So the SELECT quesries are fine, it is the INSERT queries that we are having problems with. … |
| | I have created Table in SQL server with visual studio 2005 Table name Student and table data ID,name, surname, indeks, years, I have this code in C# [CODE]protected void Button1_Click(object sender, EventArgs e) { // try //{ SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\db_lab8.mdf\";Integrated Security=True;Connect Timeout=30;User Instance=True"); // ("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\db_lab8.mdf\";Integrated Security=True;Connect … |
| | I am having a problem with some of this code: [code=php]<?php $q = "SELECT * FROM entries"; $r = mysql_query($q); if(mysql_num_rows($r)>0): while($row = mysql_fetch_assoc($r)): $net_vote = $row['votes_up'] - $row['votes_down']; $row_id = $row['id']; ?> <div class='entry'> <span class='link'> <a href='<?php echo $row['link']; ?>'> <?php echo $row['title']; ?> </a> </span> <span class='votes_count' … |
| | Hi All, I have four different tables in my database with following structure: //=================================================================== 1. [B][U]customer[/U][/B] [I][INDENT]customer.CustomerName, customer.CustomerHouseNo, customer.AreaID, customer.CustomerID, customer.CustomerType, customer.CustomerBalance, customer.CustomerAdvance, customer.CustomerMonthlyFee, customer.Remarks, customer.CustomerConnectionDate, customer.CustomerStatus, customer.CustomerTelephone, customer.EUserID, customer.USerID, customer.EditDate, customer.CDDate, customer.DisRemarks, customer.CtypeID, customer.CIP, customer.CMAC[/INDENT][/I] 2. [B][U]payments[/U][/B] [I][INDENT]payments.Amount, payments.PaymentMonth, payments.PaymentDate, payments.CustomerID, payments.PaymentYear, payments.CustomerAReaID, payments.ReceiptNo, payments.USerID[/INDENT][/I] 3. [B][U]area[/U][/B] a[I][INDENT]rea.AreaID, area.AreaDesc … |
| | [QUOTE=Richy321;880968]Thanks for looking btw.[/QUOTE] Hi I also try to connect sql with c++. Please if you connect than tell me how you connect it. And explain these two lines,I found only two errors of these lines. 4.import "C:\Program Files\Common Files\System\ADO\msado15.dll" \ 5.no_namespace rename("EOF", "EndOfFile") Thanks in advance. |
| | Hi, Im trying to connect to my sql database and generally play around but I get the following error: [ICODE]error C3867: '_com_error::Description': function call missing argument list; use '&_com_error::Description' to create a pointer to member[/ICODE] I think it has something to do the import of the msado15.dll. Obviously if I … |
| | hello guys.! I just have 1 problem right here. I have a variable declaration below: [code=vb] myVar ="Argie's" "Select * from [my Table] where [my Field] ='" & myVar & "';" [/code] When i execute the query, it returns error because the myVar value contains Quotes and sql server does … |
| | Hi, I'm pretty new to the whole SQL thing, and i'm basically self teaching using manuals, online help and the fact i pick things up quickly. I'm having a bit of trouble picking data up from 2 tables and i think i'm just beign really thick. This is what i'm … |
| | Hi I faced a very serios problem when I connect c++ with orcale. This is our project. I use c++ at front end and orcale at the backend. If someone know how to create a connection between them Please tell me. Advance Thanks. |
 | Hi, I've managed to piece together an SQL query (not literate in the language), but it isn't giving quite the data I expected. Here is the code: [CODE]SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter FROM products_description INNER JOIN ( products, salemaker_sales ) ON ( products_description.products_id = products.products_id AND products.master_categories_id = salemaker_sales.sale_categories_selected … |
| | I am having trouble with one thing on my project. I have already created the following table and inserted all of the information into it. Items ItemID Description BidFloor 100 1943 Monopoly game 80 101 1972 Ford Pinto Station Wagon 80 102 1.5 L 1921 Chateau Neuf du Pape 1,000 … |
| | Note, some of the code could be hard to understand as a bit is in Swedish. Hi! I am trying to learn some sql/java. I created some tables in an sql-database, and a java-program to access and modify the tables. I am not that experienced in programming so I might …  |
| | I'm trying to set the selected value from a combo box that is populated from my database, i cant seem to find a way to do that. I'm using this to populate my combo box: [I]Private Sub PopulateCountry() Dim country As New Client Dim contryList As OdbcDataReader = country.mpopulateCountry() Dim … |
| | Hello everyone, How can I convert this format using Java? 2009-05-20T18:19:23+08:00 I was able to convert this using the SQL Statement below. select cast('' as xml).value('xs:dateTime('2009-05-20T18:19:23+08:00')', 'datetime'); I would like to know how Java handle this format. Any suggestions are greatly appreciated. Thanks in advance, Jamojo |
| | Hi everyone! I work for a public university and need to create a new forum. Never done this before and was hoping you experts out there could give me some advice. We have our own website, servers, etc... so that isn't an issue. Our online community will include university employees …  |
| | Hi, What is wrong with this sql? It fails in php but doesn't fail in phpmyadmin! Thanks [code] <?php $connection=mysql_connect("localhost", "root", ""); if(!$connection) { die('Could not connect: ' . mysql_error()); } else { mysql_select_db("test", $connection) or die('Could not select the table.'); $sql="BEGIN;\n"; $sql.="SET AUTOCOMMIT=0;\n"; $sql.="INSERT INTO table1 (id, name) values … |
| | Hi, This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable? Thanks [code] CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN username_in varchar(15), password_in varchar(40), name_in varchar(25), surname_in varchar(25), dob_in date, address_in varchar(50), postcode_in varchar(8), city_in varchar(20), phone_in varchar(14), email_in varchar(50)) BEGIN … |
| | Hello. I am a beginner to programming. I would like to use a form to populate my sql database. Can somebody tell me where to find information on doing this? I have my database and I'm able to display the information from from the database but I don't know how … |
| | I'm trying to calculate a column from a database called rogaine.mdb. I've been using an SQL statement to do this as I only want to calculate the points for certain teams. This is the code I've been using: Dim teams As DataTable Dim da As OleDb.OleDbDataAdapter Dim sql, connStr, teamName … |
| | hi, how to find and open the backup file .sql in mysql... |
| | I'm just starting to get into some Service programming (WCF). I've successfully tried out the Microsoft WCF tutorial and got mathematical results from the service. Now I'm trying to set up a SQL Server Express database on the Service side so that it can allow the client to either retrieve … |
The End.