Database Discussion Boards

Re: layout query

srinandan..4-Sep-06 2:40

srinandan..

4-Sep-06 2:40

Thanks a lot to you Sebastian,
you have solve my problem. Smile | :)

thanks n regard,
srinandan

Which one's the best----Relational or non-relational DB structure?

kamalika_kk4-Sep-06 0:07

kamalika_kk

4-Sep-06 0:07

Though I might be asking a very foolish question, but it's important for me to know what's the current trend and the reason for that.
My question is-----
What is better-----
1. Tables with relations (pk and fks created through script during design time) maintained at the DB.
2. Tables without relations(pk and fks) should be maintained at the DB and accessed with appropriate query as and when needed?

Please some one help me with this.....I heard that the 2nd method is the current trend...if it is so then why is it?

Re: Which one's the best----Relational or non-relational DB structure?

Colin Angus Mackay4-Sep-06 0:51

Colin Angus Mackay

4-Sep-06 0:51

kamalika_kk wrote:
1. Tables with relations (pk and fks created through script during design time) maintained at the DB.
2. Tables without relations(pk and fks) should be maintained at the DB and accessed with appropriate query as and when needed?

All your tables should have a primary key.

If you have related tables then they should have foreign keys.

kamalika_kk wrote:
I heard that the 2nd method is the current trend...if it is so then why is it?

That is news to me.

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Which one's the best----Relational or non-relational DB structure?

Paul Conrad4-Sep-06 7:18

Paul Conrad

4-Sep-06 7:18

Colin Angus Mackay wrote:
kamalika_kk wrote:
I heard that the 2nd method is the current trend...if it is so then why is it?

That is news to me.

Same here. Haven't even considered using tables with out relations. Any data model I've worked with has some kind of relationship between entities.

That's no moon, it's a space station. - Obi-wan Kenobi

sql 2000 installing problem

yazan_zahi3-Sep-06 22:27

yazan_zahi

3-Sep-06 22:27

a service control operation failed for the mssqlserver service :2
the system cannot find the file specified
can you help fast pls

Re: sql 2000 installing problem

yahao9-Oct-06 23:58

yahao

9-Oct-06 23:58

plz see sqlsetup.log for detail information in %windows% folder.

mod div

TAREQ F ABUZUHRI3-Sep-06 22:02

TAREQ F ABUZUHRI

3-Sep-06 22:02

i want to make sql statment that use mod % Div /

i have tow colum

tt | time
---------
1 | 1
2 | 2
3 | 9

i want to make list for all record if (time % 5 = 0)

* how can make this

Palestine

Re: mod div

Eric Dahlvang5-Sep-06 3:23

Eric Dahlvang

5-Sep-06 3:23

SELECT * FROM MyTableName WHERE time % 5 = 0

--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

Upgrading an SQL Database via one click

Martin J Evans3-Sep-06 22:02

Martin J Evans

3-Sep-06 22:02

I have three salesmen out on the road demonstrating our latest product on their laptops - an asp.net (1.1) application installed locally on their machine that talks to a SQL Server database instance also installed on their machine.(MSDE 2000)

I would like to send upgrades to them and make the process as simple as possible for them (I can't sell - they can't program!). Carrying out the upgrade via one click would be ideal.

The updates could be anything from appending a single stored procedure to creating new tables etc.

Can anyone suggest a good way of doing this?

Many thanks in advance. Smile | :)

Re: Upgrading an SQL Database via one click

Eric Dahlvang5-Sep-06 3:20

Eric Dahlvang

5-Sep-06 3:20

I'd write a little .NET exe that has all sql database updates within it. Have a field in a table that keeps track of the database version number. In your little DBUpdate.exe, first thing you do is check the version of their database (If the table or field you keep the version number in isn't there, then you know to start at the beginning...and create the table or field). Then, just run through the updates that are less than their database version number, and update their database version number as you go.

--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

how to (stored procedures)

yazan_zahi2-Sep-06 22:28

yazan_zahi

2-Sep-06 22:28

how to execute tow procedure in one procedure
his job is to add data

Re: how to (stored procedures)

Michael P Butler2-Sep-06 23:02

Michael P Butler

2-Sep-06 23:02

exec <sp_name>

A quick google returns this example[^].

Michael

CP Blog [^] Development Blog [^]

Cast from string "28/09/2006" to type 'Date' is not valid.

bpavan_22-Sep-06 7:33

bpavan_2

2-Sep-06 7:33

help me to sort out this problem

i had taken a date time picker and changing the format to dd/mm/yy
Cry | :((

sdf

Re: Cast from string "28/09/2006" to type 'Date' is not valid.

Sage2-Sep-06 9:03

Sage

2-Sep-06 9:03

set dateformat dmy

Re: Cast from string "28/09/2006" to type 'Date' is not valid.

Michael P Butler2-Sep-06 23:08

Michael P Butler

2-Sep-06 23:08

bpavan_2 wrote:
help me to sort out this problem

i had taken a date time picker and changing the format to dd/mm/yy

Are you wanting to do this in .NET code or in SQL.

In .NET you'll need to use the ParseExact method of the DateTime class[^]

Michael

CP Blog [^] Development Blog [^]

Re: Cast from string "28/09/2006" to type 'Date' is not valid.

Hesham Amin3-Sep-06 1:23

Hesham Amin

3-Sep-06 1:23

If you use SqlCommand with parameters..This an solve alot of problems like formats and sql injection.

Business Logic problem ...

devboycpp2-Sep-06 0:38

devboycpp

2-Sep-06 0:38

Assume that I have two tables in my database,one is Catgeory and the other is Item.These tables are related; Items can belong to categories. I want to have a business class for categories that represent a record in the category table. I also want this class to contain all information about items belonging to the category. My question is which class is suitable for storing the list for items information.(e.g. Collection,ArrayList,...).I fetch item records in my Data layer as a DataSet. Please show me how I can place data contained in DataSet to the class you think is suitable(e.g. Collection).I need to use this help me please

Hope you undrestand.

Re: Business Logic problem ...

Hesham Amin3-Sep-06 1:26

Hesham Amin

3-Sep-06 1:26

With .net 2.0 and generics..I would use List<Item>
In .net 1.1 I make a class that inherits CollectionBase as a specialized collection for Items.
Also I fill the collection using a datareader not a dataset..This should be faster.

Re: Business Logic problem ...

Brendan Vogt3-Sep-06 20:42

Brendan Vogt

3-Sep-06 20:42

Have you managed with this??

I also had a similar problem an no-one helped on any where so I tried fixing this myself, and it is working so far.

It's a very confusing subject, and you have to "study" to understand, I don't fully understand the concept, but what I am doing works so far.

I can send you screen shots of my code if you like.

Regards
Brendan
brcvogt@yahoo.com

Access a database on a LAN server from a client app. [modified]

mrgruby1-Sep-06 8:46

mrgruby

1-Sep-06 8:46

Hey. I want to develop a little archive application (Windows Forms 2.0, and C#). I want to be able to install the application on one or more client machines, and have them access a database located on a server in a LAN.

I will be using either MS Access or SQL server 2005 Express Edition. My question is, where and how do I place the database so that it can be used by the clients? What is the smartest approach? Stored procedures? Web services?

I'm having a hard time finding an answer to this. I just need a few pointers to get started Smile | :)

Maybe someone has some experience in writing client/server apps, and could tell me how they usually establish the connection between the client apps, and the database.

If, for example, I use MS Access, would I place the .MDB file in a shared folder on the server, and write the path in the connection string in the client app? Could I do this in any way with SQL server express?

What would be the "correct" way to go about this?

Thank you Smile | :)

-- modified at 3:51 Saturday 2nd September, 2006

Re: Access a database on a LAN server from a client app.

Colin Angus Mackay1-Sep-06 22:58

Colin Angus Mackay

1-Sep-06 22:58

mrgruby wrote:
I will be using either MS Access or SQL server 2005 Express Edition. My question is, where and how do I place the database so that it can be used by the clients? What is the smartest approach? Stored procedures? Web services?

I would say SQL Server 2005 on the LAN with Stored Procedures. If you want to ever access it outwith the LAN then Web Services would be a better bet (but the web services would still use stored procedures - one is not a replacement for the other)

mrgruby wrote:
how they usually establish the connection between the client apps, and the database.

With an appropriate connection string (like any other way to connect to the database). I'm really not sure what you expected of this answer. Perhaps you need to rephrase your question.

mrgruby wrote:
Could I do this in any way with SQL server express?

SQL Server 2005 is a proper database server product. It is not like Access. SQL Server is designed to be accessed by potentially thousands of processes, unlike Access. Therefore, there is no concept of putting SQL Server files in a shared folder as external applications cannot and do not need access to them. They access the SQL Server via various communication mechanisms and the SQL Server process will manage all requests made to ensure efficient access to the database(s)

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Access a database on a LAN server from a client app.

mrgruby2-Sep-06 4:04

mrgruby

2-Sep-06 4:04

Thanks for answering Smile | :)

Colin Angus Mackay wrote:
With an appropriate connection string (like any other way to connect to the database). I'm really not sure what you expected of this answer. Perhaps you need to rephrase your question.

When I look around, I find that there are alot of ways to accomplish the same thing. Some argue that one way is better than the other, and vise versa. But I feel that there must be a way that is appropriate and sufficient, without any fancy hacks Big Grin | :-D

All I need is to be able to access a data store, located on a server in a LAN, from any number of client machines. Just like I would access a database on a webserver from an asp.net app. I just don't know how to do it in a windows forms app, where the database is located on a LAN server. Maybe it's a simple answer, that makes me want to hide in shame. I just haven't been able to find it, and I have been looking around alot. Maybe my search criteria is bad, I don't know...

And don't worry, I'm not looking for a finished solution here, where is the fun in that? I just need to know a good way to establish a connection between a windows forms app and a database, in an environment such as the above mentioned.

No reason to walk down a dead end, if I can get the right directions from someone who's been there... Wink | ;)

Re: Access a database on a LAN server from a client app.

Paul Conrad2-Sep-06 7:14

Paul Conrad

2-Sep-06 7:14

mrgruby wrote:
ust like I would access a database on a webserver from an asp.net app. I just don't know how to do it in a windows forms app, where the database is located on a LAN server.

You just specify the name of the machine on the LAN. www.connectionstrings.com[^] may be of help for you.

Paul

That's no moon, it's a space station. - Obi-wan Kenobi

Re: Access a database on a LAN server from a client app.

Colin Angus Mackay2-Sep-06 12:08

Colin Angus Mackay

2-Sep-06 12:08

mrgruby wrote:
But I feel that there must be a way that is appropriate and sufficient, without any fancy hacks

I've never come across any "hacks" for getting database connections to work.

mrgruby wrote:
Just like I would access a database on a webserver from an asp.net app. I just don't know how to do it in a windows forms app, where the database is located on a LAN server

Since connecting to the database is the responsiblity of ADO.NET (the part of the .NET Framework that deals with databases) it is the same in a windows application as for an ASP.NET application. Remeber the .NET Framework is divided neatly into areas that can be used on their own to build a whole application. Unfortunately many samples and wizard generated code likes to mash all the different components together so that it is difficult for a person new to .NET to see where one bit ends and another bit starts.

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Problem inserting xml string into temp table (inserting only a part of string not complete)

sandeep kumar pundhir1-Sep-06 2:18

sandeep kumar pundhir

1-Sep-06 2:18

hi Can anyone resolve my problem> I create a temp table and inserts data into it through Xml String
, spliting it by the character '|' . The data is inserted into the table fine but for last row it inserts only a part of it and does not inserts (" Remarks=""></item>|) of the xml string.

Can anyo please help or modify...the input xml string will be as given below.

{TO KNOW THE PROBLEM PRACTICALLY COPY THIS CODE IN NEW QUERY EDITOR AND EXECUTE}

--Declaring a temporary @TempTable
declare @TempTable table
(
AutoId int identity,
items varchar(max)
)
--Decaring a Variable
Declare @ExcelDataInXml varchar(max)

Set @ExcelDataInXml='<item TimeStamp="7/22/2006 12:00:00 AM" BlockName="s1" JobcodeId="80" UserInitial="amar" Error1="24" Error2="12" Error3="1" Error4="1" Error5="1" Error6="1" Error7="" Error8="1" Error9="" Error10="1" Remarks=" This is Test Data"></item>|<item TimeStamp="7/23/2006 12:00:00 AM" BlockName="s2" JobcodeId="80" UserInitial="amar" Error1="23" Error2="6" Error3="7" Error4="8" Error5="" Error6="7" Error7="" Error8="" Error9="" Error10="" Remarks="Second remark"></item>|<item TimeStamp="7/23/2006 12:00:00 AM" BlockName="s3" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="8" Error4="8" Error5="1" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s4" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="9" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s5" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="10" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s6" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="11" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s7" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="12" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s8" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="13" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s9" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="14" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="7/22/2006 12:00:00 AM" BlockName="s10" JobcodeId="80" UserInitial="amar" Error1="24" Error2="12" Error3="1" Error4="1" Error5="1" Error6="1" Error7="" Error8="1" Error9="" Error10="1" Remarks=" This is Test Data"></item>|<item TimeStamp="7/23/2006 12:00:00 AM" BlockName="s11" JobcodeId="80" UserInitial="amar" Error1="23" Error2="6" Error3="7" Error4="8" Error5="" Error6="7" Error7="" Error8="" Error9="" Error10="" Remarks="Second remark"></item>|<item TimeStamp="7/23/2006 12:00:00 AM" BlockName="s12" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="8" Error4="8" Error5="1" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s13" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="9" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s14" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="10" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s15" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="11" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s16" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="12" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2006 12:00:00 AM" BlockName="s17" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="13" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|<item TimeStamp="9/1/2007 12:00:00 AM" BlockName="sandeep" JobcodeId="80" UserInitial="amar" Error1="25" Error2="12" Error3="13" Error4="8" Error5="8" Error6="9" Error7="" Error8="1" Error9="1" Error10="1" Remarks=""></item>|'

--insert into TempTable
insert into @TempTable select * from SPLIT(@ExcelDataInXml,'|')

select * from @TempTable

thanx
sandeep

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.