Database

Colin Angus Mackay3-May-07 1:38

3-May-07 1:38

SQL Syntax will remain the same between VB6 and VB.NET as the SQL code is parsed by the database engine.

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Vimalsoft(Pty) Ltd3-May-07 2:27

3-May-07 2:27

thanks man thats good news, so do you have good link for newbies in Vb.net?"

Vuyiswa

Aaron VanWieren3-May-07 2:50

Aaron VanWieren

3-May-07 2:50

Your best bet is to get a good book on Ado.Net. There is one by Sahil Malik(sp) that I would highly recommend. You should also google for Ado and Net and you will find plenty (try using www.searchdotnet.com instead of straight Google). Ado .Net is quite different from classic Ado and will require a little getting used to.

Aaron

_____________________________________________________________________

Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.

The Enlightenment Project (paraphrased comment)

Visit Me at GISDevCafe

Vimalsoft(Pty) Ltd3-May-07 3:03

Re: database backup......

3-May-07 3:03

Thank you very much Aaron

Vuyiswa

database backup......

Xandip3-May-07 0:58

Xandip

3-May-07 0:58

hi everybody..
anyone here knows how to use the BACKUP DATABASE statement in SQL
please tell me the correct syntax..

thanx in advance..

sandeep..

Giorgi Dalakishvili3-May-07 1:10

Giorgi Dalakishvili

3-May-07 1:10

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

Finding difficulty in using SqlTransaction

kinnuP3-May-07 0:52

kinnuP

3-May-07 0:52

hi all ,

problem as follows ,
i am using method called
public void ExecuteNonQuery(string sql) inside Database Class .functionality of this method is takes the sql query and execute by using sqlcommand class here each method for example AddSubscriber() method is for inserting values into Subscriber table and AddSubscriberLogin() this is for inserting values into Subscribelogin Table and we have a link table called Subscribrsubscribelogin()
wihich containes both Subscriber and Suscriberlogin Id's so Due to Some problem like internet the values are not stored into SubscriberSubscriberlogintable so clint canot see all logins of Subscribers i got an idea of using sqltransactions i used as follows

Code:

in subscriber class
class Subscriber
{
AddSubscriber()
{
string sql="";//insert query
ExecuteNonQuery(sql);
}

but this code is not working. i need like to add All methods like AddSubscribeLogin() And AddSubscriSubscribeLogin() After that only i have to Commit other wise rollback all table values.
}
public void ExecuteNonQuery(string sql)
{
SqlConnection connection = new SqlConnection(databaseConnection);
try
{

connection.Open();
transaction=connection.BeginTransaction();
SqlCommand command = new SqlCommand(sql, connection);
command.Transaction=transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
catch(Exception ex)
{
transaction.Rollback();
}
finally
{
connection.Close();
}
}

but when i am calling in each method it is commit always can u suggest any solution please .

Thanks And Regards,
Kinnu

Re: Finding difficulty in using SqlTransaction

PIEBALDconsult3-May-07 18:06

PIEBALDconsult

3-May-07 18:06

You want to execute both statements in the same try/catch, rioughly:

try
{
  t=begintransaction
  cmd1.t=t
  cmd2.t=t

  cmd1.execute
  cmd2.execute

  commit
}
catch
{
  rollback
}
finally
{
close
}

problem with export

daviperke2-May-07 23:13

daviperke

2-May-07 23:13

my problem: i can't see tables or views of my database in Visual Studio when i export that database to another computer.

i make a sql database in SQL server management studio 2005, everything works fine, i make a connectionstring in my windows application project, also that works fine.

i export my database.. i import the database on another computer (with exactly same settings) but when i make a connectionstring, i don't see any tables or views in visual studio.. in SQL server management studio i do see the tables and vieuws

can anyone help me with this problem?

How to update Records and Give the Current time and date

Vimalsoft(Pty) Ltd2-May-07 22:21

Re: How to update Records and Give the Current time and date

2-May-07 22:21

How do i set a column to Current time and date? SQl ofcause

Vuyiswa

Colin Angus Mackay2-May-07 22:53

Re: How to update Records and Give the Current time and date

2-May-07 22:53

UPDATE MyTable
SET SomeColumn = GETDATE()

Vimalsoft(Pty) Ltd2-May-07 23:32

Re: How to update Records and Give the Current time and date

2-May-07 23:32

Thank you Man

at first i used it like
update property
set archive_date = GETDATE() and ARCHIVE_USER_ID= '107'
where Num_key = '0063'

then i wasnt sure if there is something wrong with Getdate, so i removed the "And" and put a Comma and its working mam , i wanted to make sure that am using the correct function.
update property
set archive_date = GETDATE() ,ARCHIVE_USER_ID= '107'
where Num_key = '0063'

thanks Rose | [Rose]

Vuyiswa

Mike Dimmick3-May-07 0:02

Mike Dimmick

3-May-07 0:02

UPDATE table SET column = GETDATE() WHERE condition

GETDATE() returns the current local date and time. If you're trying to perform calculations on the difference between two values, it may be better to use GETUTCDATE() (returns current UTC date and time) as that will not have the discontinuities of the local date and time if the local time zone uses daylight saving. It might also be better if you have users in multiple time zones and you want to display the time in the user's zone - it's easier to compute this from the UTC time.

Having said that, Windows (at least before Windows Vista) only stores the current time zone information. If the time zone data (e.g. daylight savings start date, end date) changes, the displayed local time for historical data, before the last change, could be incorrect if converting from UTC. You'll have to weigh these issues up against each other.

If you're trying to use the date and time for uniqueness, be aware that the system clock ticks in rather large intervals - normally around 15ms - and it's quite possible for multiple events to occur in one timer tick period.

Stability. What an interesting concept. -- Chris Maunder

Re: How to update Records and Give the Current time and date

Vimalsoft(Pty) Ltd3-May-07 1:12

Re: How to update Records and Give the Current time and date

3-May-07 1:12

Thank you very much,i understand

Vuyiswa

PIEBALDconsult3-May-07 18:09

PIEBALDconsult

3-May-07 18:09

Mike Dimmick wrote:
You'll have to weigh these issues up

... before deciding whether or not DST is a good idea in the first place. (It isn't.)

Re: How to update Records and Give the Current time and date

AshikRahman16-May-07 20:35

AshikRahman

16-May-07 20:35

set the value as getdate() into that column Rose | [Rose]

Re: How to update Records and Give the Current time and date

Vimalsoft(Pty) Ltd16-May-07 20:40

Export DB from Sql Server 2005 Express

16-May-07 20:40

Hi Thank man,tell me Do you know how can i take input from a vb and insert into a table using stored Procedure. i have created the Stored Procedure, i have connected to the Sqldb, i have created the parameter object i have a problem in Appending

can you help

Vuyiswa

kallileo2-May-07 21:35

kallileo

2-May-07 21:35

I have Sql Server 2005 Express installed in my PC and have some database in it. I also have a Laptop where I installed Sql Server 2005 Express too. Is possible to transfer the databases from the my desktop PC to the laptop Sql Server 2005 Express?

Colin Angus Mackay2-May-07 22:54

2-May-07 22:54

Make a backup on your PC then restore it to the laptop.

Jerry Hammond4-May-07 17:06

Jerry Hammond

4-May-07 17:06

Colin Angus Mackay wrote:
Make a backup on your PC then restore it to the laptop.

Is this a better method than detach and attach?

"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information."
- Neal Stephenson

Colin Angus Mackay4-May-07 22:28

4-May-07 22:28

Jerry Hammond wrote:
Is this a better method than detach and attach?

I would say so. Apart from anything else, you only have one file to transfer.

Jerry Hammond5-May-07 4:20

Jerry Hammond

5-May-07 4:20

Thanks. My knee-jerk thought was to detach and attach, but upon reading your explanation further down in this thread I undertsand now why it would not be the optimum choice of action.

"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information."
- Neal Stephenson

Aaron VanWieren3-May-07 3:13

Aaron VanWieren

3-May-07 3:13

You could also detach the database and then copy the mdf and ldf files over to the new machine. You will have to reattach the files on the main machine and the laptop. The whole point of detach and reattach is to provide a means to share databases and it is allot simpler than backing up and restore method.

Colin Angus Mackay3-May-07 4:13