|
You might find it better and more efficient to plug those values into the query rather than get everything in the table and compare them on the client end.
SELECT COUNT(*) FROM Traders WHERE UserName = @UserName AND Password = @Password
You then add Parameters to the command for @UserName and @Password
Then you can use:
int count = (int)thisCommand.ExecuteScalar();
A value of 0 indicates no match, or 1 indicates a match. If the value is anything else your database contains duplicated UserName/Password combinations.
Does this help?
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!
|
|
|
|
|
Thanks, its less complicated than I thought it would be!
Regards,
|
|
|
|
|
Hi,
can someone help me before I or my coputer go throw the window.
I'm trying to make a console VB.Net program that need to access to a SQL Server.
The console run on computer A and the SQL Server on computer B.
Everytime I try to open the sqlconnection or the oledbconnection, I'va got an error about system.security.permissions or something like this.
So can any1 give me a little code that can just do what I want.
Regards
Sybux
|
|
|
|
|
whether it is console app or web app or win app, connecting to sql server is gonna be same. check your connection string
Bhaskara
|
|
|
|
|
I'm sure about my connectionString "server=myserver;userID=sqluser;password=itspassword"
|
|
|
|
|
i think you are missing Database. When the user is created in SQL Server, we can setup the default db also. If you dont, it will be 'MASTER' db. I think that is why you get Permission error. Include database also in the connection string.
Bhaskara
|
|
|
|
|
A sample of your code would be helpful. Your connection string is missing the database name "Data Source = 'Server Name';Initial Catalog = 'Database name';User =;Password ="....
Is the server set up for mixed/SQL security? if not this will fail...
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
Hi,
here is my connect code :
<br />
Dim cObjConn As SqlClient.SqlConnection<br />
cObjConn = New SqlClient.SqlConnection("Initial Catalog=myCatalog;UID=:) ; Password=:((;Data Source=MySQLServer")<br />
cObjConn.Open()<br />
And I still got the error
type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089.
at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted
Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT
oken)
at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
unrestrictedOverride)
at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S
tackCrawlMark& stackMark)
at System.Security.CodeAccessPermission.Demand()
at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString const
r)
at System.Data.SqlClient.SqlConnection.Open()
type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089.
at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted
Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT
oken)
at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
unrestrictedOverride)
at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S
tackCrawlMark& stackMark)
at System.Security.CodeAccessPermission.Demand()
at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString const
r)
at System.Data.SqlClient.SqlConnection.Open()
I really don't where I'm wrong. I'm using the same connection string in an ASP application which is also running on another computer than the sqlserver and all is ok for it ???
|
|
|
|
|
I've found the error.
It wasn't in the connection string.
The fact was that I was running my application from a network drive and it seems that permissions are not the same.
Solution : run all from local hard drive !
Sybux is now happy
|
|
|
|
|
I've inherited a somewhat old system with a large number of SQL queries. In a number of these queries, there are SELECTs within INNER JOINs. For example, here are two INNER JOINs that are part of the same query:
INNER JOIN
( SELECT * FROM Schema_types
) Schema_types ON Schema_types.Schema_typeID = Schemas.Schema_typeID
INNER JOIN
( SELECT * FROM Marketeers WHERE MarketeerID = 7
) Marketeers ON Marketeers.MarketeerID = Shipments.MarketeerID
This looks rather peculiar to me. Is there merit in doing it this way, or is this just wrong?
|
|
|
|
|
This does look peculiar. It may have been the result of never cleaning up after intial development. I don't know any benefit of writing them this way. There may not be any benefit in cleaning them up - except for readablity.
INNER JOIN
Schema_Types
ON (Schema_types.Schema_typeID = Schemas.Schema_typeID)
INNER JOIN
Marketeers
ON ((Marketeers.MarketeerID = Shipments.MarketeerID) AND
(MarketeerID = 7))
|
|
|
|
|
Using subqueries (the SELECT statements you speak of) in INNER JOINS can be very useful. However, here it looks stupid because it is just doing a SELECT * FROM... and I guess this would be sub-optimal because it has to create an internal set of data for the subquery that contains every field and they may not all be used once the data gets into the main query.
It would be better to do:
INNER JOIN Schema_types ON Schema_types.Schema_typeID = Schemas.Schema_typeID
INNER JOIN Marketeers ON Marketeers.MarketeerID = Shipments.MarketeerID
If my understanding of the query optimiser is correct then this should also speed up your query.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!
|
|
|
|
|
plz tell me as early as possible that how to bind a report with dataset of sql password protected database at runtime.
it is urgently required
|
|
|
|
|
can you try to be more specifc!
give us an example of what you are doing, a part of your code or somthing...
sony speed
|
|
|
|
|
Private Sub ShowReport()
Dim rpt As New CrystalReport1() 'The report you created
Dim dsReport As New Dataset1() 'The dataset that you created for this report
'We need a report object that is fully populated to display, so declare one
Dim objReport As Object
objReport = prepareReport(rpt, dsReport, "SELECT * FROM MyTable")
rpvReport.ReportSource = objReport
End Sub
'To get a report from Table
Public Overloads Function prepareReport(ByVal rpt As Object, ByVal dsReport As Object, ByVal tblName As String) As Object
Dim myConnection As SqlConnection
Dim MyCommand As New SqlClient.SqlCommand()
Dim MyDA As New SqlDataAdapter()
Try
myConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _
"Initial Catalog=northwind;")
MyCommand.Connection = myConnection
MyCommand.CommandText = tblName
MyCommand.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand
MyDA.Fill(dsReport, “MyTable”)
rpt.SetDataSource (dsReport)
Return rpt
Catch ReportErr As Exception
Reponse.write("Prepare Report Error:" & ReportErr.Message)
Finally
MyDA.Dispose()
MyCommand.Dispose()
myConnection.Dispose()
End Try
End Function
Things to do before Coding.
1.Create a dataset (named dataset1) which has to bind the
necessary table or view (in this case it is MyTable)in the integrated environment.
2.Create a Report (in this eg -CrystalReport1) and bind the report with the dataset you have created(Dataset1)
3.Drag and drop the necessary fields
4.Use the code
5.Ur Report is ready
Things To Ensure:
Check whether you have 2 import statements in your vb
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Regards,
CVP
|
|
|
|
|
Hi all,
i want to prepare an installation package in microsoft SMS installer,
and i want to install the SQL Server 2000 Desktop Engine through that script.
how can i do that ? i read that we can install the MSDE through commandline, if so i can do that by using the script without knowing the user about the SQL Server 2000 Desktop Engine.. but how.??
from where i get the SQL Server 2000 Desktop Engine for that purpose , and how can i do that from command line..? is there any further constrains in that ..?
please replay
regards
renjith
programming in VB is like riding a kiddy bike, while programming in C++ is like driving a Formula 1 racing car
|
|
|
|
|
no one here to answer this..!!!
i found the solution...!!!
i think i will post an article regarding this..
thank you
programming in VB is like riding a kiddy bike, while programming in C++ is like driving a Formula 1 racing car
|
|
|
|
|
Download the MSDE2000A.EXE from microsoft.
You run thiw first, and it will decompress to C:\MSDERelA folder.
If you run it with /s it will not display a user interface.
Then you can run the Setup.Exe using some fo the arguments documented in the readme.
A word of caution, even though the documentaiton says that the targedir must end with a backslash, this is just not true
You can read/process the log file to see how successful setup was, if the exit code from the process is 0.
|
|
|
|
|
What is the advantage of using procedures over sql queries?
Sumit Domyan
TeraByte Solutions
|
|
|
|
|
1. Security - underlying tables need not be given permisions
2. Precompiled cache - so execution is fast
3. Application need not be recompiled completely if any query needs to be changed
Bhaskara
|
|
|
|
|
4. Can cut way down on network traffic. Lengthy query code is already stored on the server. One small call can process a lot of tables with multiple transactions.
5. Cross table/db validation is easier/faster at the data store.
6. Stronger protection from bad parameters (sql injection).
7. Job security - less people know TSQL.
#2 isn't quite as true as it used to be. SQL Server has certainly improved its speed and caching ability over the years.
|
|
|
|
|
use of procedure decrease the trefic over network....as a result u get better speed.
store procedures are precompiled quries ..it help server to not compile again and again..it prevents the server resource overhead.
easy to call in code..instead of writing long quries.
easy to manage code...while haveing procedures instead of large quries.
easy to check quries error...either syntax or logical...it helps a lot to make quries error free....cool use and enjoy.
|
|
|
|
|
Hey all. I'm having a problem getting a connection to a SQL Server to timeout. What is happening is I am using CDatabase::OpenEx (code below). If the computer is disconnected from the network, or the database server is down, the program just hangs forever. It never even times out after five or ten minutes and I have to manually end the process.
Here's what I'm using to connect:
CString DBCONNECT = "Driver={SQL Server};Connection Timeout=10;Server=DSC\\DAVEINSTANCE;Database=Master;Uid=sasd;Pwd=blah;"
CDatabase myDB;
myDB.SetLoginTimeout(10);
TRY {
myDB.OpenEx(DBCONNECT,CDatabase::noOdbcDialog);
.... If the server is there, it works great, connects instantly. If the server is not running, or the computer is not plugged into the network, the program just sits forever (it does not even time out after 5 or 10 minutes!).
I've tried without "Connection Timeout=10;" in the connection string, and only using myDB.SetLoginTimeout ... and vice versa ... without SetLoginTimeOut. I've also tried "Connect Timeout=10" Neither of these are working. I saw in the MSDN that some connections do not allow SetLoginTimeout, but I'm guessing there has to be a way to time out the connection for SQL Server instead of having the program hang on myDB.OpenEx().
Any help is appreciated!
|
|
|
|
|
Hi,
never posted anything with "very urgent" in the subject but this time I'm having a serious problem. I've got a customer which called me to tell me that his sql server doesn't start. I had a look and decided to reinstalled the server and it works fine now. The problem has been somewhere in the master table. I found this out when I copied the old data files (mdf, ldf) over the newly created ones and restarted the server. The sql service doesn't even start. Obviously, the master table is not in a good condition. Now the problem is, the client has got his bookholding in one database. Unfortunately, he doesn't have a backup, neither of the master table nor of the bookholding one (don't even ask). So all I have are his latest data files (say mybookholding.mdf and the corresponding ldf file + master.mdf, etc. But as mentioned, master.mdf is of little use). Question is now, how can I get his bookholding database up and running again if I only have the mdf/ldf files?
Thanks in advance!!
Matthias
If eell I ,nust draw to your atenttion to het fakt that I can splel perfrectly well - i;ts my typeying that sukcs.
(Lounge/David Wulff)
www.emvoid.de
|
|
|
|
|
Hi Matthias,
Have you tried attaching the client's mybookholding.mdf file to a new sql server?
Get sql server running on a server.
Copy mybookholding.mdf and .ldf to the data folder
Use query analyzer: go into the master db on the new server and try this,
EXEC sp_attach_db @dbname = N'MyBookHolding',
@filename1 = N'c:\mssql7\data\mybookholding.mdf',
@filename2 = N'c:\mssql7\data\mybookholding.ldf'
Note: the code above is for Sql 7.0, but hopefully it'll get you started...
Just brainstorming,
Bill
|
|
|
|