|
hie again
=)
yea i had added the stored procedure with the parameters above, but i cant get u bout to supply them when i call the procedure
any example??
*_*
amygal
|
|
|
|
|
It depends on where you are executing it from. If you call it from the SQL Query Analyzer, then:
declare @iIdentity int<br />
<br />
exec InsertStaffAccount 'John Smith','Male','123 5th Street','CEO',@iIdentity out<br />
<br />
print @iIdentity
Are you trying to call it from C++,C#,VB.Net,ASP.NET???
----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
yeah, I'm trying to call it from VB.NET is there any difference?
|
|
|
|
|
@myg@l wrote: yeah, I'm trying to call it from VB.NET is there any difference?
Not much...
Dim conn As New SqlConnection
conn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=mytestdb;" & _
"Integrated Security=SSPI"
Dim cmd As New SqlCommand
cmd.Connection = conn
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "InsertStaffAccount"
Dim prm1 As New SqlParameter("@StaffName", SqlDbType.VarChar, 20)
prm1.Direction = ParameterDirection.Input
cmd.Parameters.Add(prm1)
prm1.Value = "MyStaffName"
Dim prm2 As New SqlParameter("@Gender", SqlDbType.Char, 10)
prm2.Direction = ParameterDirection.Input
cmd.Parameters.Add(prm2)
prm2.Value = "MyGender"
Dim prm3 As New SqlParameter("@Address", SqlDbType.VarChar, 50)
prm3.Direction = ParameterDirection.Input
cmd.Parameters.Add(prm3)
prm3.Value = "MyAddress"
Dim prm4 As New SqlParameter("@Position", SqlDbType.VarChar, 20)
prm4.Direction = ParameterDirection.Input
cmd.Parameters.Add(prm4)
prm4.Value = "MyPosition"
Dim prm5 As New SqlParameter("@Identity", SqlDbType.VarChar, 20)
prm5.Direction = ParameterDirection.Output
cmd.Parameters.Add(prm5)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
MsgBox("Returned ID=" + prm5.Value)
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Hey Eric, I thankss alot. It works perfectly.....Thanks for the hessle all the way. It is rather fun to try out !!
tc and hav a nice day
see ya around
=)
best regards
amygal
|
|
|
|
|
sir i want to learn xml i am familier with ado.net and sql server please guide me with starting stage i am totaly known with xml please help me
|
|
|
|
|
|
If you just want a general introduction into XML and it's related technologies check out W3Schools.com[^]
|
|
|
|
|
i use this code to store image in my database
*********************
Dim DR As DataRow
DR = Ds_products1.employees_dir_sp.NewRow
SqlInsertCommand1.Parameters("@emp_fname").Value = txtfname.Text
SqlInsertCommand1.Parameters("@emp_mname").Value = txtmname.Text
SqlInsertCommand1.Parameters("@emp_photo").Value = PictureBox1.Image
DR("emp_fname") = SqlInsertCommand1.Parameters("@emp_fname").Value
DR("emp_mname") = SqlInsertCommand1.Parameters("@emp_mname").Value
DR("emp_photo") = SqlInsertCommand1.Parameters("@emp_photo").Value
Ds_products1.employees_dir_sp.Rows.Add(DR)
da_empdir.Update(Ds_products1.employees_dir_sp)
************************************************
so when i click the save button that message apeear
"object must implement iconvertible"
ma_refay
|
|
|
|
|
|
Hi there,
Is it possible to get the last value updated in a table after an update operation has been conducted
Any help would be greatly appreciated
leo
Kathmandu, Nepal
|
|
|
|
|
Begin tran
update statement.....
.....
rollback tran
vivek
|
|
|
|
|
anj1983 wrote: Is it possible to get the last value updated in a table after an update operation has been conducted
A column of type TIMESTAMP can be used for it, because each time when a row is modified, the timestamp's value get chnged. Moreover it stores value in binary number. Alternately you can use a column of type DATETIME, and programmatically modifiy its value when updation takes place. Using this technique you trace recent update operation.
Regards.
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
I'm having a problem pulling data from sql 2005 on my local machine in an asp.net 2 project. I've set up sql with windows authentication, and i've tried adding logins with sql authorization and rights etc. but to no avail. The connection finds the server, db etc. but gives an security/auth error when executing the query. Do I have to reinstall sql or what???
Regards,
Tintin
|
|
|
|
|
Hi!
You have to set your SQL 2005 service to mixed mode authentication (do that in the property window of your server in management studio: Right-click your server in object explorer, Properties, Security, SQL Server and Windows Authentication mode).
If you do not change to mixed mode you cannot use sql authentication.
Regards,
Rainer.
Rainer Stropek
Visit my blog at http://www.cubido.at/rainers
|
|
|
|
|
Hi ,
pls help me out with this code
insert into chk values('notwking',convert(datetime,getdate(),101))
the row gets inserted into the table(type varchar, type datetime).
but if i try to retrive that record by this query
select * from chk where dt between getdate() and getdate()+20
i dont get that tuple
but i get the same with this query
select * from chk where dt between getdate()-1 and getdate()+20
i thnk the problem is with the time part which is inserted during insertion.
is there any solution.Pls help me out
Thnks in advance
|
|
|
|
|
Always use DateDiff when working with date.
Syntax: DATEDIFF([datepart], [firstdate], [seconddate])
where datepart can be day, month, year, etc.
Example:
WHERE DATEDIFF( dd, GETDATE(), @myDate )
BETWEEN DATEDIFF( dd, GETDATE(), @dateFrom )
AND DATEDIFF( dd, GETDATE(), @dateTo )
Does that help?
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
try this out ...
i.e. insert into chk values('notwking',convert(char,getdate(),105)
the time part will be removed.
vivek
|
|
|
|
|
Hi,
thks fr the advice but insert into chk values('notwking',convert(char,getdate(),105) is actually trying to insert char datatype into datetime field right.
regards
-- modified at 5:25 Wednesday 21st June, 2006
|
|
|
|
|
hi,
obviously yessssss..............
vivek
9868079257
delhi
vivek
|
|
|
|
|
I am about to start working on a little web application that will run with an Oracle database as the backend. Since I won't have control of the database, I was thinking of embedding PL/SQL queries inside my data layer, so that I will only have to ask for the DBA to create 4 or 5 tables (yeah, that small!).
Knowing that Oracle doesn't support identity columns, and that you must use sequences (which as far as I know require me to write stored procedures), I thought about GUIDs as primary keys for my tables (specially since I can use them just like ints in C#).
But a quick search on the web didn't reveal any information on Oracle 10g having a built-in GUID datatype. If it isn't so, then I am worried that a few joins on an array of bytes will be very slow. 
What do you all think?
Luis Alonso Ramos
Intelectix
Chihuahua, Mexico Not much here: My CP Blog!
|
|
|
|
|
Hi,
I am Vijay I want to know How to Read Data From Password Protected Acces Database Using VB Program.If Any One has Solution fort this Problem...Please send Reply in the Following Mail; Address.
Vijaykrishnanv@rediffmail.com or viju.nvidia@gmail.com
|
|
|
|
|
You just need to pass the password into your connection string.
See this link[^].
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
* i have a column that store simages in my database
i make the image column type is (image)
so when i try to insert image into my data base message appear " u must use iconvertible"
what is that "iconvertible" and how to use it?!!!!!!!
* i make image column allow null so if i try to insert row without image message apear meaning i can't use null i must use dbnull.
what is the dbnull and how allow image column to be allow null with errors?!!
ma_refay
|
|
|
|
|
ma_refay wrote: * i have a column that store simages in my database
i make the image column type is (image)
so when i try to insert image into my data base message appear " u must use iconvertible"
what is that "iconvertible" and how to use it?!!!!!!!
I've never seen that error message - Are you passing the data as a byte array: byte[]
ma_refay wrote: * i make image column allow null so if i try to insert row without image message apear meaning i can't use null i must use dbnull.
what is the dbnull and how allow image column to be allow null with errors?!!
DBNull is used to signify a null in the database. In certain situations a null can be ambiguous. For example: I use ExecuteScalar and the result is null. Is it null because there is no data being returned, or is it null because the data I requested is a null value in the database? To disambiguate, all nulls from the database are DBNull.Value
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
