|
Hey
Can you not just iterate through each row checking the content of the third column?
Or maybe look at this:
http://msdn2.microsoft.com/en-us/library/system.data.datatable.primarykey(VS.80).aspx
Try looknig at datasets in msdn also they may be more suitable for the job as I am sure they retain the schema.
Hope this is of use
Dan
|
|
|
|
|
|
That article says if it's not being returned it's because you've done something wrong!
Whats your code in the client for getting the output param?
|
|
|
|
|
|
|
|
No probs 
|
|
|
|
|
|
I gathered that  You seemed pretty switched on so I took it your SP was right
|
|
|
|
|
In a report I want to check if a picture exists before showing it.
I put this function in the Report Properties:
Function DoesFileExist(PathnFileName As String) As Boolean
DoesFileExist = My.Computer.FileSystem.FileExists(PathnFileName)
End Function
And in the Visibility property of the image placeholder I call the DoesFileExist function.
Inside the MS Visual Studio Development Editor everything works fine, but when I deploy the report to the IIS Server and run it from there it doesn't work:
the DoesFileExist function always return "False" even if the pictures exist.
I'm 100% sure it's a permission problem, I tried to correctly set the permissions both on IIS and on NTFS Folder with no luck.
Please help.
Thank you,
Roberto
|
|
|
|
|
Hello
I have a network running tcp/ip on 4 networked pc’s with windows xp home.
In my network places I can see the server(Windows xp pro) and all clients, I have created a user account in the Login sections in SQL management studio express , yet how do I access the databases from the client computers
What setting do I need to edit to allow my users to connect to the Server and its databases?
What permissions do I need to set I o the users?
What shares should be done?
Please can some one assist me.
Please email me on Ozzyrocsdbn@yahoo.com
Regrads Ozer
|
|
|
|
|
ozzyrocsdbn wrote: Please email me on Ozzyrocsdbn@yahoo.com
Emailing the answer is bad, it means the answer isn't here for everyone else to benefit from.
ozzyrocsdbn wrote: What setting do I need to edit to allow my users to connect to the Server and its databases?
What permissions do I need to set I o the users?
What shares should be done?
Please can some one assist me.
If your compleatly starting from scratch I'd recommend getting a good book on the subject. I don't personally know of any good beginner books sorry.
ozzyrocsdbn wrote: What setting do I need to edit to allow my users to connect to the Server and its databases?
Here's how to configure Sql Server 2005 Express for remote access:
http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
ozzyrocsdbn wrote: What permissions do I need to set I o the users?
Google:http://www.google.co.uk/search?hl=en&q=creating+a+user+in+sql+server+2005&meta=[^]
ozzyrocsdbn wrote: What shares should be done?
You don't need any shares. Sql Server is network based not file based.
|
|
|
|
|
THANK YOU THE WEB ADDRESS ROCK MY NETWORK UP
btw. MY NETWORK IS AT HOME AND WE CODING A PROJECT FREE LANCE STYLE.
REGRARDS OZER
MICROSOFT ROCKS 
|
|
|
|
|
|
I wanna include my SQL Server 2000 to my Project. So people needn't to install SQL Server 2000. They just install my software. It will automatic attach the database into a very-small SQL Server on my Disc. Could i do that?
If not, can you give me a solution that solve my problem???
The problem is Install software and its database without requiring the SQL Server.
Thanks
John
JohnJone
|
|
|
|
|
Take a look at SQL 2005 Mobile / Compact Edition.
|
|
|
|
|
I have done this with an application that uses SQL2000 as its database. There are a few steps and a couple of small apps to write to run teh scripts to attache the database.
But I am having problems making this work with Sql2005 due to the network connection default to dis-allow network connections to SQL2005 after it is installed so the out of the box experiemce does not work.
Email me if you want info on what we did for SQL2000. ron@arian.co.nz
Cheers
|
|
|
|
|
Thank you. I send you a mail and hope to receive the solution soon.
JohnJone
|
|
|
|
|
Can anyone give me some help regarding Creation of Indexes in SQL Server. I also need to know its advantages and most importantly, its difference when compared to Primary Key Constraints.
The name is Sandeep
|
|
|
|
|
Hello Sandeep,
Indexes are created for faster retrival of data. Its like searching a topic in a book with the help of index in book. Imagine if have to search the topic in a book without an index. It will be slower as you have to browse through each an every page to check for the topic.
Indexes are of two types
1) Clustered index
2) Non clustered index.
For more information about these two type index you can check books online of sql server
Everytime you create a primary key using enterprise manager, it by default creates a clustered index. But thats not mandatory. You can have a primary key without any index.
Its because its recommened to have a clustered index on a unique column.
I hope I answered your question.
please let me know incase of any query.
Rahul Goel
Microsoft Cerfied Solution Developer .Net
Contact me at : rahul.g2510@gmail.com
|
|
|
|
|
Hello Rahul,
Thnx for your reply. Let me tell you what I have understood by Indexes. Please verify my points.
Indexes should be only used in tables used for data retrieval and not in tables where frequent INSERT & UPDATE take place.
When an Index is created over a table, then there is no need for defining a PrimaryKey for that table.
Indexes are best suited for Views.
Are these correct?
The name is Sandeep
|
|
|
|
|
Xandip wrote: Indexes should be only used in tables used for data retrieval and not in tables where frequent INSERT & UPDATE take place.
When an Index is created over a table, then there is no need for defining a PrimaryKey for that table.
Indexes are best suited for Views.
No. Indexes can be used in tables which perform frequent insert/update/deletes. They are used to speed up retrieval of information, so if you need to select information from these tables you should consider whether or not they should be used.
A primary key is not intended to act as an index. Just because a primary key normally has an index associated with it does not mean that having an index on a table negates the need for a primary key. The PK is normally used to provide a mechanism to allow you to reference a row in another table. This is because the PK is unique, so it uniquely identifies a row.
Indexes can be used in views (DB dependent), but they are not best suited for them.
|
|
|
|
|
sometimes oracle gives error "unable to get oracle connection".
how to solve that?
vijaya
|
|
|
|
|
first, did you start the listener in database server?
goto controlPanel/services and start the listener of the concerned sid (databse).
from the client your installing forms,
use net8 easy config asstnt to create services or connectstrings.
check the availability of listener from comand prompt
using
tnsping < yourServiceName >
And then run your application.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I have been reading and attempting to use a data table for a side project I am working on and I am looking at using a dataview in addition to the data table. I think I have the basics about both but if anyone can see any misconceptions I would appreciate you point them out.
The columns collection makes up the schema of the DataTable and the rows make up the actual data in the DataTable. A DataView is a bindable, customized view of a DataTable. You can create multiple DataView's off one DataTable, each one can contain different data sorted in different order. Does the first row actually, row(0), contain the row header (column name from the database)?
I have found BindingSource.Find to narrow my selection to a particular string in the DataTable. I am also wanting to make sure that I am doing this in the most efficient way, does anyone have a better way of narrowing results in a DataTable? I am under the impression that SQL statements cannot be used to query the DataTable. Please correct me if I am wrong.
Dan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
