|
Another point: you should not mix TSQL transacions (within an sproc) and ADO .Net transactions, as this can cause weird problems. Either do your transactions inside the sproc's, or use ADO .Net transactions, not both.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
-- modified at 18:26 Friday 10th March, 2006
|
|
|
|
|
I'm using VB.Net 2003.
I want to connect my client app to a SQL Server over the internet.
How do I send my connection request through the local proxy server?
The setup:
SQL Server --> Firewall -->>>>Internet<<<<-- Proxy Server <-- Client App
The neccesary port forwarding has already been set up.
It's not a HTTP request that I'm looking for. (I think)
/*Im not sure where this post is bet fitted so I put it at the VB.Net forum too*/
|
|
|
|
|
I saw a piece of code in a stored procedure:
DECLATE @ApplicationID uniqueidentifier<br />
SELECT @ApplicationID = NULL
Why did they use SELECT? Wouldn't SET @ApplicationID = NULL be just as good enough?
If I were to declare in my own code the following:
DECLARE @MemberID int
Can I set it to NULL as well?
SELECT @MemberID = NULL<br />
Basically what I would like to do is to get a MemberID based on the input parameter @Username:
-- Variable declaration<br />
DECLARE @MemberID int<br />
SET @MemberID = 0<br />
<br />
-- Get the member ID<br />
SELECT<br />
@MemberID = MemberID_PK<br />
FROM<br />
tblMember<br />
WHERE<br />
MemberUsername = @Username
If no member was found, what would be the value of @MemberID? Would it still be 0?
Regards,
ma se
|
|
|
|
|
ma se wrote: Why did they use SELECT? Wouldn't SET @ApplicationID = NULL be just as good enough?
You could look at it the other way around:
Why use SET? Wouldn't SELECT be good enough?
When you only set one value SELECT and SET are effectively synonyms for the same operation. But, if you want to assign several values at once then SELECT is the way to go because you can do things like this:
DECLARE @a int;
DECLARE @b int;
SELECT @a = 10, @b = 20;
This is faster than doing two separate SET operations, and the more things you need to SET at the same time, the bigger the benefit of using a SELECT.
Also, SET didn't used to be in the language, so the only way to SET values was to use SELECT, so maybe the guy is has been doing databases for many years. Or maybe he just wanted to be consistent accross all of his code and use SELECT everywhere rather than mix SET and SELECT.
ma se wrote: Can I set it to NULL as well?
Yes, but you would have discovered this in the Query Analyzer already, right?
ma se wrote: If no member was found, what would be the value of @MemberID? Would it still be 0?
Yes, it would still be 0, because the SELECT operation returned no rows at all it does not change @MemberID.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Thanks!!
When will your website be up and running? What is the URL again?
|
|
|
|
|
Hi,
I need to extract data from MSDE through ADO.net programmatically.
Can someone help me do this pls.
Thanks.
|
|
|
|
|
smadan wrote: I need to extract data from MSDE through ADO.net programmatically.
Well, that is the only way ADO.NET works....
smadan wrote: Can someone help me do this
Can you be more specific about what help you need? You may want to look up MSDN documentation for the classes in the System.Data.SqlClient[^] namespace. Particularly SqlConnection[^]and SqlCommand[^]
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Hi,
Thanks for replying to my message.
I've been able to solve my problem.
My problem was actually to acess MSDE through Outlook, the way it can be done through MSAccess. This requires the use of a Windows service or a tool that will interact with the database and return values like any other database.
Thanks.
|
|
|
|
|
Hi there,
I am very new to working with SQL Server 2005 and would like to configure it on my machine, but I have a problem. The application appears to be installed on my machine (it installed after VS2005) but I can't seem to create any databases or connect to any database servers from the configuration manager...its almost like its a stripped version
I open configuration manager and it lists Services, Network Config and Client configuration...there is no options for importing databases, connecting to databases, creating databases like I am used to with SQL Server 2000. Can you help please?
I can connect to the different SQL Servers using VS2005 though...its this just how SQL 2005 works or what?
-- modified at 2:25 Friday 10th March, 2006
|
|
|
|
|
Hi
I am using SQL server 2005 express edition.
For that there is a separate tool called SQL server management studio 2005.
Using that SQL server management studio 2005 I can do any thing like SQL 2000 server.
Regards,
Chandana.
|
|
|
|
|
Hi Chandana,
When I installed VS 2005, SQL Server 2005 Express installed aswell, but I do not have the server management studio, I just have:
-Configuration manager
-Surface area manager
-Error usage and reporting
Thats it, does this mean I have installed all the components properly?
|
|
|
|
|
hi
yes you need to install SQL server management studio
|
|
|
|
|
Thanks its all sorted now...the express technical community preview addition has some bugs i have found!
|
|
|
|
|
|
You need to install SQL Server Management System. You can download it from Microsoft.com.
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
Now, i have a formula, after solving some expression i want to assign a new value to a Parameter fields.
But i dont know how to do it.
Please help me!
superdragon
|
|
|
|
|
Hi,
I get the following type of error when using SQLSERVER2005 with databases with compatibility level 80(sql2000).
-OLE DB error: OLE DB or ODBC error
According to Microsoft help(http://support.microsoft.com/kb/907284), I should be able to do the following as a work around
-In SQL Server, explicitly add SQLNCL.1 to the list of providers that have in-process access
Any help on how to do this in SQLSERVER2005??
Thanks a lot..
k
|
|
|
|
|
I have never worked with databases before, and my C++ skills are only at the intermediate level. I have been asked to make a program which can store and keep track of students. My first attempt at this involved using Excel to store the data (records are imported from xls files), but this is proving a little more problematic than I care for. I have come to realise that I need a real Database.
I have been advised that SQLite would be ideal in my situation, so I went and downloaded it. Problem is I now have a dll and a lib, with no clue how to use them. I have searched the interent high and low for tutorials or examples showing how to incorporate SQLite into an MSVC project, but I have found nothing.
Could somebody please show me an example of how to use this, preferably in a non-MFC environment.
Also from what I understand there is one main database file which may hold several tables. I'm a little unsure how I should structure this. The end result would hold several thousand students, each divided by year and class. Then for each student I need to be a able to pull a performance record which would hold all the exam results for the students tenure in the school.
Any help with one or both of these matters would be greatly appreciated.
Thankyou
|
|
|
|
|
Eeek, I completely missed this[^] I was looking under the SQL subheading rather than the General. My bad.
My second question still stands though. I would appreciate any advice on how to structure my data.
|
|
|
|
|
How to map the data tables in a remote database to data tables in local memory, if using .net classes?
So, I can get some DataTable instance. thanks.
|
|
|
|
|
Use a SqlDataAdapter (assuming you are using SQL Server) to get the data from the remote database and Fill a DataSet/DataTable.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
If you don't like my previous answer then you might like to elaborate on your problem.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
-- modified at 12:09 Friday 10th March, 2006
|
|
|
|
|
Thank Colin Angus Mackay;P very much, i have gotten desired result according your answer.
|
|
|
|
|
I'm using MySQL on an ASP.net project, using the official .NET data provider to connect to my MySQL database.
What I want to do is get the final SQL command that my MySqlCommand object uses after I've set it's parameters and asked it to execute the query.
MySqlCommand.CommandText returns my original SQL with my parameter place holders, but I want to see the actual SQL used.
For example, I create my SQL queries by the following:
string _SQL = "SELECT name FROM users WHERE department = ?department; "; <br />
<br />
MySqlCommand DbCom = new MySqlCommand(_SQL, DbCon);<br />
DbCom.Parameters.Add("?department", MySqlDbType.VarChar, 25);<br />
DbCom.Parameters["?department"].Value = "engineering";<br />
MySqlDataReader DbRDR = DbCom.ExecuteReader(); <br />
<br />
[SNIP]... CODE HERE ...[/SNIP]<br />
<br />
DbRDR.Close(); <br />
DbRDR = null; <br />
DbCom.Dispose();
If I use "DbCom.CommandText" it will return "SELECT name FROM users WHERE department = ?department; ", but I want it to return the actual query which would be "SELECT name FROM users WHERE department = `engineering`; "
Can anyone please enlighten me on how to do this?
Thanks
|
|
|
|
|
The idea of using parameters in a command is to separate the actual command from the data used to modify the command. That is, it splits the parameters away from the actual command as a way of reducing the possibility of a SQL Injection Attack. It sends the two pieces of information to the database as command + parameters rather than concatenating the parameters into the command before being sent to the database.
Distinctive wrote: it will return "SELECT name FROM users WHERE department = ?department; "
That looks correct to me. That is your command text.
Distinctive wrote: but I want it to return the actual query which would be "SELECT name FROM users WHERE department = `engineering`; "
Look at it this way. If you have a line of C# code like this:
Console.WriteLine("Hello my name is {0}", name);Would you expect the compiler to be able to tell you what the "actual command" is? It can't until runtime, because until runtime name has an unknown value.
[DISCLAIMER: I've not used MySQL and the above is based on how other database data providers work in .NET and any provider produced by a third party may not operate in the same way.]
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
