|
As far as I know you cant pass parameters to a view. As an alternative what you can do is create a user defined function in sql server (2000 and later) where you can pass parameters to the function,do what ever the process or selections you want and then return a table from the function.
Rohitha M.Hewa
Senior IT Executive
Naturub Group of Companies - Sri Lanka
|
|
|
|
|
I am using .NET C# to program a database program. I am modifying a program that already exists, and it creates an "SDF" file on my Pocket PC. Be warned, I am a very big newbie, and I've been trying to read up on this question, but it seems the more I read, the less I am understanding it all.   
I have tried to install and use Microsoft Server 2000 (with Server CE), but I keep getting error messages 1069 and no matter waht I do, it doesn't seem to help.
So I was wondering if I could use a MySQL database for this program?
Furthermore, I have the database (with images/blobs) currently in MS-Access format, which was made on my PC. This is the database I would like to have on my PocketPC (I don't want to be able to edit it or anything. Just show it, with the pictures that go with the ID #.)
Thanks so much everyone. I'm really getting confused about this all.
|
|
|
|
|
Hi,
I want to create dynamic Microsoft Access Jet 4.0 database ( *.mdb) files and database schema ( tables (Data Definition Language ) ) using ADO connectivity.
For that I have come up with the solution to use ADOX technology which provides database and schema creation facility, for Microsoft Access Database.
So I want to know the latest version msadox.dll file thru which ADOX can be used to access database.
And also write feasibility of using ADOX technology instead of ADO technology.
Please be hurry...........
Its urgent....
Thanks and Regards,
Karnav
Thanks and Regards
Karnav Zaveri,
Prodcut Development Engineer,
Amtel Security Systems.
|
|
|
|
|
Hi I am developing and web app for my final year in college but I am having problems trying to keep my 2 databases up-to-date (one in college and the other at home) I’m just wondering if there is anyway to copy a single table from the college db to the home including the table design and data etc. So I’m just wondering if anyone has any ideas of how I would go about doing this
Thanks in advance
Tim
|
|
|
|
|
try to BackUp DataBase then in ur PC call it by Restore
hope helps???
|
|
|
|
|
no i need to copy one tables data from one database to another not the whole database
|
|
|
|
|
If it is just data, then you should be able to use some kind of Unload/Load utility for your database to do this. Additionally most databases also have some kind of Export/Import utility that will also include the the table design info that you are after.
Chris Meech
I am Canadian. [heard in a local bar]
Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer]
Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]
|
|
|
|
|
Hey folks,
i've run into a sort of brick wall this weekend, and can't find much that will work....here's the issue.
i need to do an insert into 2 tables, for an invetory control app,
I know this query is wrong, its just a description of what i want to do...
Insert into PC (PC_Service, PC_Serial, mon.mon_name, PC_Model, PC_Name, PC_Loc, PC_IP) <br />
values(1, 'SerialNujmber','SerialNujmber', 'Model1', 'deviceName', 1, '192.168.0.1') <br />
select *<br />
from mon inner join pc<br />
on pc.pc_id = mon.mon_to_pc <br />
where <br />
pc.pc_serial = '123456789'
or
"Insert into Mon ( Mon_loc, Mon_Serial, Mon_serial2, mon_service, mon_to_pc) <br />
values ('1', 'KR-032DVX-47602-19Q-ABKQ', 'kermit the frog', '1', (select PC_ID from PC where pc_serial = 'fasdf'))"
the first is the overall desire...the second is my last resort..
Any ideas will be helpful
thank!!!
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
You could do something like this:
INSERT INTO Mon (Mon_loc, Mon_Serial, Mon_serial2, mon_service, mon_to_pc)
(SELECT '1', 'KR-032DVX-47602-19Q-ABKQ', 'kermit the frog', '1', PC_ID
FROM PC where pc_serial = 'fasdf')Or if you are using a stored procedure, get the PC_ID into a variable, and use it in the INSERT. The above query will insert multiple records if the SELECT PC_ID FROM PC happens to return multiple records, although by looking at the name of the fields, I wouldn't think so for this particular case.
I hope this helps!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
That Worked!!!!
THANKS
string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";
Why is common sense such an un-common comodity?
|
|
|
|
|
You're welcome! I'm glad I could help! 
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
I am not that good in asp.net and sql.
I need a simple piece of code to see if a value is in a datatable.
Allready have this but how to proceed:
Dim LUConn As SqlConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=EventMngt")
Dim LUString As String = "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text
Dim objLUConnCommand As New SqlCommand(LUString, LUConn)
Dim objConnReader As SqlDataReader
Try
LUConn.Open()
objConnReader = objLUConnCommand.ExecuteReader()
Catch Err As Exception
MessageLabel.Text = "Horsename not found. Try again or use Passport number." & Err.Message
Horse_Name.BackColor = System.Drawing.Color.LightGoldenrodYellow
btnSubmitNext1.Visible = "false"
Finally
LUConn.Close()
MessageLabel.Text = LUString
Horse_Name.BackColor = System.Drawing.Color.LightGreen
btnSubmitNext1.Visible = "true"
End Try
Any help is welkom.
|
|
|
|
|
ExecuteReadering is not enough, you have to actually Read something:
objConnReader = objLUConnCommand.ExecuteReader()
If objConnReader.Read Then
' At least one record was returned
Else
' No records returned
End If If you want to process multiple records, then call Read in a loop
objConnReader = objLUConnCommand.ExecuteReader()
Dim counter As Integer
While objConnReader.Read Then
' Process the record
counter = counter + 1
Wend I hope this helps!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
LuisR thankx for the info and it helps.
Is it possible to use the retrieved valuas ore should one use a other aproach.
|
|
|
|
|
objConnReader = objLUConnCommand.ExecuteReader()
Dim counter As Integer
While objConnReader.Read
' Process the record
lstNames.Items.Add objConnReader.GetString(0) ' First column
counter = counter + 1
WendThe data reader has methodos for returning different types of data from a specified column index (GetInt32, GetString, and so on). Use GetOrdinal to get the column index from the column name.
See my reply to Albanian on why you should use parameters instead of concatenating strings for building a SQL query.
I hope this helps!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
-- modified at 12:44 Monday 19th December, 2005
|
|
|
|
|
It Does, Thanks for the help
|
|
|
|
|
Dim LUConn As SqlConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=EventMngt")
Dim LUString As String = "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"
Dim objLUConnCommand As New SqlCommand(LUString, LUConn)
Dim objConnReader As SqlDataReader
Try
LUConn.Open()
objConnReader = objLUConnCommand.ExecuteReader()
Catch Err As Exception
MessageLabel.Text = "Horsename not found. Try again or use Passport number." & Err.Message
Horse_Name.BackColor = System.Drawing.Color.LightGoldenrodYellow
btnSubmitNext1.Visible = "false"
Finally
LUConn.Close()
MessageLabel.Text = LUString
Horse_Name.BackColor = System.Drawing.Color.LightGreen
btnSubmitNext1.Visible = "true"
End Try
' "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"
|
|
|
|
|
Hi Albanian,
Cant see the difference between my code and your answer
|
|
|
|
|
a diffrence is here
"SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"
open the sql quote
& "'"
set query
& Horse_Name.Text
and close sql quote
& "'"
ur code:
"SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text
|
|
|
|
|
Albanian wrote: SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"
See this article on why concatenating SQL queries is a huge security risk:
http://www.codeproject.com/cs/database/SqlInjectionAttacks.asp[^]
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
I try this code to check if a name is on a table by cheking the name if this one is entered in a asp:TextBox. This is the code -->
Protected Sub Horse_Name_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
' Check if Horse_Name is in FEI file
Dim LUConn As SqlConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=EventMngt")
'Dim LUString As String = "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text
Dim LUComm As SqlDataAdapter
Try
LUConn.Open()
LUComm = New SqlDataAdapter("SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text, LUConn)
Catch Err As Exception
MessageLabel.Text = "Horsename not found. Try again or use Passport number." & Err.Message
Finally
LUConn.Close()
MessageLabel.Text = LUString
End Try
End Sub
The aboce code is executed without no error but the faulty name is not discovered, the catch statement is not catching a error. I cant see what is wrong.
|
|
|
|
|
"SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text should be
"SELECT * FROM C_Registered_horses WHERE Horse_Name = '" & Horse_Name.Text & "'"
No error is getting detected becuae you are not doing anything except opening a connection to the database. You need to execute your SQL for anything to happen.
Make your dataadapter a sqlcommand, and executereader on it (into a sqldatareader) then look inside your datareader and see if rows are returned
|
|
|
|
|
In addition to Andew's reply. You might also want to read up on SQL Injection Attacks[^] becuase your code is susceptable to attack.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I need some code in VB.Net that will get all the mac address
of all the network cards on our network. I beleive a broadcast
command would be the best way to do this. Does anyone know
where I can find some code to do this?
|
|
|
|
|
I'm not sure how to do this in VB.NET, but it would require some sort of extended procedure to do this in SQL Server. But, perhaps you posted this in the wrong forum? Oops! 
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
