|
|
I'm making assumptions here it not very clear what you require
Run an update with two tables :
-------------------------------
update user_ref
SET user_ref.clientCode = Client.clientCode
from user_ref client
WHERE user_ref.USERID = Client.USERID
|
|
|
|
|
I have this:
With Me.daNumCourses.SelectCommand
.CommandText = "SELECT Section.Section_ID, Section.InstructorID, Instructor.ID FROM Section INNER JOIN Instructor ON Section.InstructorID = Instructor.ID AND Section.InstructorID = '" & Me.instr.ID & "'"
intCount = .ExecuteNonQuery()
End With
Me.dsNumCourses.Clear()
Me.daNumCourses.Fill(Me.dsNumCourses)
Me.txtNumberCourse.Text = intCount
I keep getting -1 so what am I doing wrong?
Thanks
|
|
|
|
|
Why are you doing this? Why not just fill the data set and get a count of the rows in the DataTable? e.g. dsNumCourses.Tables[0].Rows.Count
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I just want to get the count of the classes that a certain instructor teaches. I tried the .count property and that counts all of the rows in a particular table.
Thanks for your reply. If you have a suggestion on how to do that please post back.
|
|
|
|
|
Why don't you have your SQL as:
SELECT COUNT(*) FROM ....
Also, the way you build your SQL is suscepatable to a SQL Injection Attack and you should try and use parameterised queries where ever possible. You can read more on how to improve the security of your application here: SQL Injection attacks and tips on how to prevent them[^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
How do you return the number of rows from the query? In other words if I have a variable intCount how do I set intCount to the "count" of the query?
Thanks for your reply. We've noticed a few security holes in our application in a few places and we are fixing those right now.
|
|
|
|
|
Dim cmd As SqlCommand
cmd = SqlCommand.New()
cmd.CommandText = "SELECT COUNT(*) FROM MyTable WHERE someColumn=@someValue"
cmd.Connection = myConnection
Dim numRows As Int
numRows = cmd.ExecuteScalar()
numRows will contain the number of rows that match the given filter (i.e. what is filtered in the WHERE clause). COUNT() is an aggregate function that returns a count, when COUNT(*) is used it returns the number of rows. If you use COUNT(columnName) then it will count the number of rows where the column value is not null.
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
This is the correct way. ExecuteNonQuery should be used for Insert/Update/Delete statements. If the CommandText is "SELECT" statment, then it will always return -1. When it is DML statement, then it will return the number of rows affected by that DML statement.
|
|
|
|
|
I have a program that converts excel to mssql. Does anyone know how to properly use it step-by-step?
|
|
|
|
|
vandread1 wrote: I have a program that converts excel to mssql. Does anyone know how to properly use it step-by-step?
I think you win the prize for the most vague question of the day.
vandread1 wrote: a program
"A program"? The indefinite article? Could you tell us to which program you are referring?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
vandread1 wrote: I have a program that converts excel to mssql. Does anyone know how to properly use it step-by-step?
Peers over your screen looks, I don’t see any program running that converts an Excel file to SQL server. 
Is that you need to create a program that inserts data into a SQL table? What language are you planning on using? Which data connectivity model do you need to use? 
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
Please im working on smart devices application on C# and i want to know how i can connect a database with it as the windows application.
im trying to use Using System.data.oledb
or Using System.data.sql
But no response.
so please please help me.
thanx and wish u solve me this problem
tedy
|
|
|
|
|
Follow this
http://www.csharphelp.com/archives3/archive586.html
Hope this helps
|
|
|
|
|
Hi all,
i am developing the website in ASP.NET using MS Access database, in this project client require ,at the end of every day the database should send a report via email of the upated record , means new user, new transaction etc to client automatically....
so any idea for this...
thanx
|
|
|
|
|
You can write a script (Javascript or vbscript) that sends the mail, and then schedule that script to run every day.
Wout Louwers
|
|
|
|
|
thanx for reply,
but how i can schedule that script to run every day in asp.net, its a main problem......
|
|
|
|
|
How can I return a set of records that are the result of different row operations
I have a table:
Mileage
(totalMiles id ...)
How can I get a result set of:
Row diff
1 (row1-row2)
2 (row2-row3)
-Steven Hicks
CPACodeProjectAddict
|
|
|
|
|
Assuming your ID represents sequential order, you can use correlated sub queries to solve the problem. Something like this may work for you:
SELECT
id,
ISNULL(
totalMiles - (SELECT totalMiles
FROM Mileage
WHERE id= (SELECT MIN(id)
FROM Mileage
WHERE id > BaseMiles.id)),0) AS diff
FROM Mileage BaseMiles
ORDER BY id ASC
|
|
|
|
|
Hello Dears
>>>insert into tablename select * from DBName..TABLENAMEby using this Query i can insert datas from another database in the same machine. But when i am connect to remote machine using the following Query
insert into LOCAL SYSTEM TABLENAME select * from REMOTE SYSTEM NAME.REMOTE SYSTEN DATABASE..REMOTE SYSTEM TABLE NAME
i am getting error
"Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' does not contain table '"DBNAME"."TABLE NAME"'"Please any one give me idea....
N.Rajakumar B.E.,
Application Developer,
|
|
|
|
|
When you are using a remote connection you have to specify the table-owner. Default this is dbo
So, what you can try is:
<br />
insert into tablename select * from [Remote System Name].[Remote Database].dbo.[TableName]<br />
Wout Louwers
|
|
|
|
|
Hi
I have a table which contains member_id as string field. In this field the values will be like
1.1.2
1.1.2
1.1.2.1
1.1.2.2.1
1.1.2.2.2 etc....
When i want to insert a new member i want to isert existig member's id + 1 .
Eg: if i select 1.1.2 as my manager my id should 1.1.2.3. Do you have any idea about this. Expectng your earliest reply
UK_Nair
|
|
|
|
|
You can do this in an preatty way :
In the server side of your application set the ID manually like this :
1) querry the database to return a single ID (TOP 1 if I remeber right) and sort the return descending.
Select member_id Top 1 From myTable Order By memberId DESC
2) do your stuff with the old ID an et the new intém's ID
3) add your new item
I hope you understand...because is a rough world out there...
|
|
|
|
|
This is probably a very simple problem but it's kicking my ass so I'll get right to it
I have a database table running of ms sql server 2000 which contains amoung other things three columns:
a DateTime which should hold only the date
a DateTime which should only hold a time
a DateTime which should also only hold a time
I need the three seperate DateTimes since the first is used in a storedprocedure to extract records based on the current day
the other two to be displayed in a datagrid as a start and stop time for an event or appointment.
now i can open enterprise manager and open the table directly and the start and stop datetime columns show the time just as i imputed it.
however as soon as my data adapter fills the dataset the datagrid displays an arbitray date (30/12/1899) but does not display the times.
is this something i have to fix on the database side with some input formating or can i control how a datagrid displays dates and times
any help would be seriously appreciated
Ryan
"It's nice to know if I ever need attention all I have to do is die."
|
|
|
|
|
Your problem may be because your faulty way of inserting data into the data base.
Perhaps some code example on how you insert and querry the data base wold help.
I hope you understand...because is a rough world out there...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
