|
i wanna add a new record into a access file by using sql "INSERT INTO". i wrote the following code in my project but i have an error message "Syntex error in INSERT INTO statement." Please tell me the correct syntex of INSERT INTO statement.My code is
Private Sub pbLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles pbLogin.Click
Try
xConn = New sqlConn
xConn.connectMe("INSERT INTO tblSave (UserName, Password) VALUES ('" & txtUser.Text & "'," & txtPassword.Text & "');")
Try
xConn.OLEComm.Connection = xConn.OLEConn
xConn.OLEComm.ExecuteNonQuery()
xConn.OLEConn.Close()
MsgBox("Record Added")
Catch err As System.Exception
MsgBox(err.Message)
End Try
Try
xConn.OLEConn.Close()
Catch err As System.Exception
MsgBox(err.Message)
End Try
Catch err As System.Exception
MsgBox(err.Message)
End Try
End Sub
|
|
|
|
|
phowarso wrote: xConn.connectMe("INSERT INTO tblSave (UserName, Password) VALUES ('" & txtUser.Text & "'," & txtPassword.Text & "');")
Your SQL statement is missing an apostrophe. It should read:
xConn.connectMe("INSERT INTO tblSave (UserName, Password) VALUES ('" & txtUser.Text & "','" & txtPassword.Text & "');")
Regards
Paul
|
|
|
|
|
i have been inserted your code. but i get the same error message.please give me another way...
|
|
|
|
|
I don't know why it isn't working. Try debugging your code, copying the SQL statement generated into Query Analyser and running the query. You should be able to see then what the problem is.
Paul
|
|
|
|
|
Don't use direct SQL such as this. You leave yourself wide open to Sql Injection attacks. See this[^] article. BTW - doing this the proper way makes code like this easier to write as well.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
Please don't cross-post.
Paul
|
|
|
|
|
Hari Om Prakash Sharma wrote: Is there from_unixtime() function in c#.net
No.
Errm. You do realise that this is a SQL forum don't you. I can only assume that you have undertaken a massive attack of cross posting here.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi guys
Im transfering data from sql server 2005 to
comapact framework database (*.sdf)
My way to do so is :
Export the table into an XML file (using DataTable)
dt.WriteXml(FName, System.Data.XmlWriteMode.IgnoreSchema)
And on the mobile device I load the XML and save the Dataset
dt.ReadXml(FileName)
da.Update(DataSet11)
Everything is working only my table contains about 1500 records (20 fields)
and it takes about 6 minutes to load and save.
Is there any way or Method to do this any faster ?
Thanks in Advance
Pam.
|
|
|
|
|
Have you solved this problem?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I want to backup an SQL Database that I already have a connection to. The Solutions Ive found on Code projects creates a new connection but I dnt need to do since I already got connection to Data source, I have dataset of the database on my project..I need help to modify the code below so it does not re-connect but uses current datasource and backs it up...
//class variable which came with solution
private static Server srvSql ;
private void btnConnect_Click(object sender, EventArgs e)<br />
{<br />
<br />
<br />
<br />
ServerConnection srvConn = new ServerConnection("juji");<br />
<br />
srvConn.LoginSecure = false;<br />
<br />
<br />
srvSql = new Server(srvConn);<br />
foreach (Database dbServer in srvSql.Databases)<br />
{<br />
<br />
}<br />
private void btnCreate_Click(object sender, EventArgs e)<br />
{<br />
if (saveBackupDialog.ShowDialog() == DialogResult.OK)<br />
{<br />
Backup bkpDatabase = new Backup();<br />
bkpDatabase.Action = BackupActionType.Database;<br />
<br />
bkpDatabase.Database = "kofle";<br />
<br />
BackupDeviceItem bkpDevice = new BackupDeviceItem(saveBackupDialog.FileName, DeviceType.File);<br />
bkpDatabase.Devices.Add(bkpDevice);<br />
}<br />
}
Thanks in Advance
Is this chair taken
|
|
|
|
|
Have you solved this problem?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I created a certificate in the master database so that my endpoint could use the certificate.
I dropped the endpoint and dropped the certificate and added a new one and created a new endpoint because the earlier one had a weak password.
This is SQL 2005 service pack 1.
Everything has been fine till we restarted the server. Master, model start up fine but now I am getting these errors.
(1.) FallBack certificate initialization failed with error code: 1.
(2.) Warning:Encryption is not available, could not find a valid certificate to load.
(3.) TDSSNIClient initialization failed with error 0x7e, status code 0x60.
(4.) TDSSNIClient initialization failed with error 0x7e, status code 0x1.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
(5.) SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
Is there a way to just start sql with master only? Ive tried moving the certificates to another location, renaming the database mdf file that uses the endpoint so it would go suspect.
|
|
|
|
|
Hi
I am currently developing hostel management software for a local hostel. I am trying to find a way of identifying those residents who have outstanding rent payments.
The hotel/ youth hostel requires that its guests pay their rentals at the beginning of the month. The residents often stay at the hostel for periods that are often over 5 months.I need to find a way of finding out which residents have paid their renatals, and which ones have not paid their rents. This is further complicated by the fact that some residents will make one large payment at the beginning of their session and this is meant to cover them for the duration of their stay.
Each session has one account, and the total payments made are stored in the acount. I have also included the rate charged per day and the startdate of the session into the table, such that it is possible to calculate the amount that is owed and this figure can be some how be compared to the amount that has been paid.
Given these circumstances, how can I find the residents who have outstanding rents.
I havce included the table defs below.
Please do feel free to help me.
create table sessions
( sessionNumber int Identity Not null Primary Key,
startdate smalldatetime not null,
enddate smalldatetime not null,
sessionType char(15) not null,
duration int not null,
roomNumber char(5) not null references Rooms (roomNumber),
idNumber char(15) Not null references guestinfo (idnumber),
)
create table accounts
(
receiptNumber int Identity Not Null primary key,
amountpaid money not Null,
datepaid smalldatetime not null,
roomNumber char(5) not null references rooms(roomNumber),
sessionNumber int Not null references sessions(sessionNumber),
paymentType char(10),
userName char(15) Not Null references users (username),
)
---create table accpayments---
( accountNumber int identity Not Null primary key,
sessionNumber int not null references sessions(sessionNumber),
totalpaymentsmade money not null,
amountowing money not null,
rate money not null
)
twsted f8
|
|
|
|
|
You would need to write a query that returns:
i) the total rent incurred thus far by each guest. This would presumably be the the number of days elapsed since the guest began their stay, multiplied by their daily rate
ii) the total amount paid by the guest thus far
Subtracting ii) from i) should give you the total amount currently owed by each guest.
Regards
Paul
|
|
|
|
|
Hi,
I have 2 tables with same fields like event, venue, date and cost. Table 1 has 5 records and Table 2 has 100 records. How can i match a record from Table 1 with Table 2 to get the exact match record of Table 1 record. Event Venue fields are string datatypes which will not have same records. I need the nearest match .Please help me out. Thanks in advance.
Jebin
|
|
|
|
|
SELECT t1.venue
FROM Table1 t1
LEFT JOIN Table2 t2 ON t1.[ID] = t2.[ID]
WHERE t2.venue IS NOT NULL
|
|
|
|
|
I have several hundred tables that I need to do stuff with... problem is I do not have anything even close to a direct connection to the database. They have two layers of "stuff" between the app. and the datasource.
So, I'm wondering, is it possible to write SQL like commands against a DataSet without having a connection? All the examples I've looked at so far do something allong the lines of:
SqlConnection conn = new SqlConnection("blah, blah”);
conn.Open();
SqlDataAdapter dataadapter = new SqlDataAdapter("SELECT * FROM whatever", conn);
Is there a way around the connection thing?
Any recommended readings?
Thank you.
|
|
|
|
|
You want to populate a dataset without a connection?
You can certainly create a dataset and manually code rows and tables. If you have an already populated dataset, you can manipulate the data inside it to your hearts content, but you do need a DB connection to persist the data to the database.
|
|
|
|
|
Yeah, this is strictly for presentational purposes... they have Load and Post proxies I can use to update.
What I want to do is create a “Display Table” from 2 or 3 existing tables without writing an excessive amount of code. There are a minimal amount of common columns in the existing tables, so I need to take like 4 or 5 columns from one, and 4 or 5 from another, based on 1 primary in a 3rd.
I'm really new to C# and the whole .NET thing, but this seams like it should be a no-brainer of a task.
|
|
|
|
|
I'm guessing you have a number of datasets each containing a single table?
You might be best to copy all these tables to within a single dataset, and you can then set up relationships between these tables (within the dataset). You can then set about coding what you want to see relatively easily.
|
|
|
|
|
DataTable has a Select method. You can use DataRelations between DataTables to navigate between parent and child tables (using the ParentRelations and ChildRelations properties). Unfortunately there's no built-in Join implementation, and no indexing other than by primary key.
.NET Framework 2.0 offers a DataTableReader class which provides the IDBDataReader interface over a DataTable. This might be handy if you have code that can work with either live data coming direct from the database or cached data in a DataSet or DataTable.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
i try to create trigger on table to insert values in another table but
the is syntax error
(Msg 1046, Level 15, State 1, Procedure MoveStudentInfo, Line 20
Subqueries are not allowed in this context. Only scalar expressions are allowed.)
here is the trigger script
create trigger MoveStudentInfo on Temp_Code
after insert
as
declare @Stu_ID bigint ,@Stu_Code nvarchar(50)
select @Stu_ID=Stu_ID from inserted
select @Stu_Code=Stu_Code from inserted
insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address
,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type
,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image
,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice
,First_Lang,Second_Lang)
values(@Stu_Code,(select Stu_Name,Sex,Nationality,Relagion
,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type
,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image
,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice
,First_Lang,Second_Lang from Student_Registry where Student_ID=@Stu_ID))
thnx for help
MD_NADA
|
|
|
|
|
You must use the inserted table for your insert so your code should be something like:
Forum SQL / ADO / ADO.NET
Subject: Re: problem with create trigger
Sender: md_nada
Date: 8:28 24 Sep '07
i try to create trigger on table to insert values in another table but
the is syntax error
(Msg 1046, Level 15, State 1, Procedure MoveStudentInfo, Line 20
Subqueries are not allowed in this context. Only scalar expressions are allowed.)
here is the trigger script
create trigger MoveStudentInfo on Temp_Code
after insert
as
insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address
,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type
,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image
,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice
,First_Lang,Second_Lang)
select i.Stu_Code, Stu_Name,Sex,Nationality,Relagion
,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type
,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image
,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice
,First_Lang,Second_Lang from inserted i
join Student_Registry sr on sr.Student_ID= i.Stu_ID
Ben
|
|
|
|
|
i dont get the data from the table i add the trigger for him
i get the data from another table
so i cant use inserted
MD_NADA
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
