Database

Re: database connectivity in vb .net using Acces

2-Jan-09 0:01

Try connectionstrings.com

Search through the articles here and on Google, there are plenty of excellent samples around. Learn to do some research before dropping such an open question into a forum. When you run into a specific problem we will be more than happy to help.

Never underestimate the power of human stupidity
RAH

Vimalsoft(Pty) Ltd4-Jan-09 19:50

Vimalsoft(Pty) Ltd

4-Jan-09 19:50

use oledb.

But i suspect that you did not buy a Book Smile | :)

try and get a Book that will guide you step by Step.

http://www.apress.com/book/view/143021614x[^]

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za

how to solve this senario in sql

prasadbuddhika1-Jan-09 15:44

prasadbuddhika

1-Jan-09 15:44

i've a table contains name,cardid and the cardstatus.there are many cards for i customer,i want to check for each customer if he has a card with the cardstatus="bad" and if so need to return false.
can any one suggest me how to do this .

Re: how to solve this senario in sql

PIEBALDconsult1-Jan-09 16:30

PIEBALDconsult

1-Jan-09 16:30

SELECT CASE ISNULL(COUNT(*),0) WHEN 0 THEN True ELSE False END FROM table WHERE Name=@name AND CardStatus='bad'

Or something like that?

Remote SQL Server Database Connection

VikashGohil31-Dec-08 20:28

VikashGohil

31-Dec-08 20:28

Hello,

I have a Question related to SQL Server Connectivity .

I have my database on another PC and using the software created using VB.net 2005 on another PC, i.e. like Client Server.

I want to know whether connecting the SQL Server database directly from my application would give faster results or by creating a DSN connection on client machine and accessing the Data using Datasource would be faster.

Please anyone having idea about this.

Thank in Advance.

Re: Remote SQL Server Database Connection

Wendelius1-Jan-09 3:55

Question about how to rearrangement the DB Ms Access? [modified]

1-Jan-09 3:55

I think using .Net Framework's SqlConnection gives the best result as it is designed natively against Sql Server. It also provides more functionality than ODBC-based connections.

The need to optimize rises from a bad design.My articles[^]

Mangore7531-Dec-08 0:53

Mangore75

31-Dec-08 0:53

I'm using vb2005 connection to DB Ms Access.
If I have Columns in that DB it's typed Date/Time.Is it possible to rearrangement the Data(rows) in DB according the History.

it's mean if I have these Data

this is DB in Ms Access

A---B----C----H<br />
ZZ---FF---GG---2/12/2008<br />
QQ---UU---TT---1/12/2008<br />
RR---OO---PP---3/12/2008

To make this data like this

A---B----C----H<br />
QQ---UU---TT---1/12/2008<br />
ZZ---FF---GG---2/12/2008<br />
RR---OO---PP---3/12/2008

modified on Wednesday, December 31, 2008 6:59 AM

Re: Question about how to rearrangement the DB Ms Access?

Jon_Boy31-Dec-08 2:40

Jon_Boy

31-Dec-08 2:40

do a ORDER BY on the 'H' (date) column.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Question about how to rearrangement the DB Ms Access?

Mangore7531-Dec-08 4:55

Mangore75

31-Dec-08 4:55

This will work when I select the data and showed in DataGridView example
but I want to rearrangement inside the Table of DB.

Re: Question about how to rearrangement the DB Ms Access?

Jon_Boy31-Dec-08 5:10

Jon_Boy

31-Dec-08 5:10

Performance wise there shouldn't be much of a hit for performance. If performance goes down the dumper, add a WHERE clause or an index.

For whatever odd reason, if you really wanted to resort the data based on the data column. Create a temp copy of the table, copy the data into it, delete the data from the orig, and then insert the databack into the orig and use the order by. Again, why you would want to do this is beyond me and really isn't needed.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

How to make a student database for the time table in VS 2008

Member 404872630-Dec-08 21:40

Member 4048726

30-Dec-08 21:40

Hey guys i am in confusion for VS 2008
i was using VS 2005 before
now i move to make new enhancement
please help me for making a student database for the timetable

Re: How to make a student database for the time table in VS 2008

Mycroft Holmes31-Dec-08 0:16

Re: How to make a student database for the time table in VS 2008

31-Dec-08 0:16

download and setup SQL express
Create your database
create your tables
create your relationships
create your CRUD procedures

Nothing to do with VS

Never underestimate the power of human stupidity
RAH

Vimalsoft(Pty) Ltd4-Jan-09 20:15

Vimalsoft(Pty) Ltd

4-Jan-09 20:15

Are you doing a Homework ?

SQL Profiler in SQL 2005?

devvvy30-Dec-08 15:21

devvvy

30-Dec-08 15:21

hello

SQL Profiler been replaced in SQL 2005?

Thanks

dev

Mycroft Holmes30-Dec-08 16:58

30-Dec-08 16:58

Nope look under tools, first menu item!

Never underestimate the power of human stupidity
RAH

devvvy30-Dec-08 18:39

devvvy

30-Dec-08 18:39

That's SQL2000

What about 2005? I go Management Studio there's nothing there except:
1. External Tools
2. Customize
3. Options

Where is it in 2005?

dev

dan!sh 30-Dec-08 19:22

dan!sh

30-Dec-08 19:22

The very first item under Tools menu is Profiler.

C isn't that hard: void (*(*f[])())() defines f as an array of unspecified size, of pointers to functions that return pointers to functions that return void

"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live." - Martin Golding

Mycroft Holmes30-Dec-08 21:31

30-Dec-08 21:31

I suggest you have a dodgy installation, it is there for both 2005 and 08.

Never underestimate the power of human stupidity
RAH

Jon_Boy31-Dec-08 2:42

Jon_Boy

31-Dec-08 2:42

Trace Start...

Yes.......profiler is in 2005.....agreed with Holmes that your install is probably hosed if you don't see it there.

Run the setup again and add it.

Trace Paused...

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Wendelius31-Dec-08 3:20

31-Dec-08 3:20

Do you have Express Edition of the Management Studio. If I remember correctly, profiler isn't included in that version.

The need to optimize rises from a bad design.My articles[^]

devvvy31-Dec-08 15:24

devvvy

31-Dec-08 15:24

o darn... that's the reason!! Many thanks!

dev

Wendelius1-Jan-09 2:20

Re: Sql Reporting Services

1-Jan-09 2:20

You're welcome.

The need to optimize rises from a bad design.My articles[^]

Sql Reporting Services

member2730-Dec-08 1:15

member27

30-Dec-08 1:15

Hi all,
Iam Using Sql reporting Services and I want to keep a page break for each 10 records in a group...from 11 th record it should come in next page...How to do tat..i gave searched in net and wrote a expression in formula field of group

Int((RowNumber(Nothing)-1)/1)..it is displaying only one record in each page ..

how to do tat??Can anyone Help me..

Wendelius30-Dec-08 4:35