Database

Eddy Vluggen21-Jun-09 9:43

Eddy Vluggen

21-Jun-09 9:43

I'm guessing that you won't get a number until the record is saved.

I are troll Smile | :)

Vimalsoft(Pty) Ltd21-Jun-09 21:41

Vimalsoft(Pty) Ltd

21-Jun-09 21:41

Datagridview is not an SQL table. Until the Record is Saved and the Grid is Refreshed you will not get an Identity number. If you made a gridview to generate the number , it does not mean the Database will do the same thing. If your Application is a multi-user application you will have problems e.g lets say a user assumes that the ID is the 10 and the user user does an insert somewhere and faster that the user that assumed it was 10 and the other user will get the identity of 10 and the assumer will get 11.

Hope it helps

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.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Md. Marufuzzaman22-Jun-09 0:07

Md. Marufuzzaman

22-Jun-09 0:07

Hi,
I do agree.. you can add an external col into your grid.

Md. Marufuzzaman

Getting Message : "Could not Update , currently locked" .?

galil45030-Jun-09 7:42

galil450

30-Jun-09 7:42

In some grids I get the right number, in one grid I get a minus number which saves ok afterwards but in the grid I'm working on now I don't get any number at all

honeyashu19-Jun-09 20:31

honeyashu

19-Jun-09 20:31

Hi,
I am developing an application in which i use to select data from one grid remove that & display it to the second grid.
I store those data in a local mdb file . when i am selecting rows in bulk(around 50-70 at a time)and then wanted to cut and display in the second grid i am getting this error .
Please help.

Re: Getting Message : "Could not Update , currently locked" .?

Henry Minute20-Jun-09 1:06

20-Jun-09 1:06

Are you forgetting to close your connections, between operations? Or forgetting to close something that you have opened. A DataReader, or something like that.

Without seeing the code you are using, it is difficult for me to offer more than that. Others might be more helpful.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

remotely accessing sql

shankbond19-Jun-09 19:28

shankbond

19-Jun-09 19:28

Hi,
I am a newbie in programming and all the IT stuff,currently I am developing a webapplication to enhance my knowledge . I am using visual studio 2008,Sql server management studio 2005;in my application I am simply adding names and passwords in a table in Sql.

1)The application works fine when both Sql and published webappliaction on IIS are on same machine!

2)now I want the Sql database to be on other machine, and my published application on other system so that there are two different servers in LAN one the application server and other the database.

please help!

Thanks
shankbond

Mycroft Holmes20-Jun-09 0:05

Mycroft Holmes

20-Jun-09 0:05

shankbond wrote:
he application works fine

So you have a working connection string already in your app, it will probably have "localhost" in the string. Change "localhost" to the remote server name.

You will probably need to change from integrated security (using your windows logon) to a SQL userid and password for the app to connect ans include them in the connection string.

A good research site is connectionstrings.com/[^]

Never underestimate the power of human stupidity
RAH

shankbond20-Jun-09 0:45

shankbond

20-Jun-09 0:45

Hi,

Mycroft Holmes wrote:
You will probably need to change from integrated security (using your windows logon) to a SQL userid and password for the app to connect ans include them in the connection string.

the above solution will help my application to use a sql id and sql passsword fine

but what other changes(or configure) will I have to do in sql server itself?

Thanks
shank

Eddy Vluggen20-Jun-09 1:09

Eddy Vluggen

20-Jun-09 1:09

"Allow SQL Server to accept remote connections"

Quoted, since it is a common search-phrase on Google Smile | :)

I are troll Smile | :)

Mycroft Holmes20-Jun-09 3:52

Mycroft Holmes

20-Jun-09 3:52

You will need to set up the SQL user with adequate permissions on your database. That's it.

Never underestimate the power of human stupidity
RAH

shankbond21-Jun-09 23:32

shankbond

21-Jun-09 23:32

Mycroft Holmes wrote:
You will need to set up the SQL user with adequate permissions on your database. That's it.

ok I m trying; any good resources you know except msdn?

shankbond

Totaling previous months figures

Md. Marufuzzaman22-Jun-09 0:03

Md. Marufuzzaman

22-Jun-09 0:03

Hi,
Actually when you remotely perform any SQL request (using OPENROWSET , BLOB type data) SQL server
need the AuC first. That you have the permission to perform this operation.

Md. Marufuzzaman

Muammar©19-Jun-09 12:30

19-Jun-09 12:30

Hey,
I have this table:

JAN    FEB    MAR   APR
---    ---    ---   ---
10     10     10    10

Suppose I'm in March now, how would I total the values of the two previous months (ie. JAN and FEB) to have 20

Please help.

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Henry Minute19-Jun-09 12:59

19-Jun-09 12:59

Well, if that was what I wanted to do, I wouldn't start from there.
Has this design been forced on you, or are you free to choose your own?

Muammar©19-Jun-09 21:21

19-Jun-09 21:21

It is forced on me, here's the big picture:

         Jan   Feb   Mar   Apr
         ---   ---   ---   ---
Budget   10    10    10    10
Actual   10    5     10    0
...      0     0     0     0
...      0     0     0     0
...      0     0     0     0

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Henry Minute20-Jun-09 1:03

20-Jun-09 1:03

Sorry to be so long in replying.

I'm with Luc here, unless somebody else comes up with a viable solution I'd be investigating PIVOT. I have never used it, so I can't be of much help.

Good Luck! Smile | :)

Muammar©20-Jun-09 3:18

20-Jun-09 3:18

Thanks Henry, Yes, it can be solved using pivot tables or the decode function but my problem is far more complicated to be solved by either of them alone!
Thanks for your time mate!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Jerry Hammond21-Jun-09 4:50

Jerry Hammond

21-Jun-09 4:50

Is that a SQL table or a flatfile table such as Excel?

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

21-Jun-09 5:31

Hey Jerry,
It's a SQL Table, but dont worry, I've already found another way round, although it's not professional but it solves my problem. It was for a crystal report file and I figured out I can simply create a typed dataset with the exact names and data types of those of the generated query, generate the datatable fields from the invoking form using ado and set the datasource of the report to the dataset I just created.

Thank you for your time Jerry!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Luc Pattyn19-Jun-09 13:10

Luc Pattyn

19-Jun-09 13:10

Hi,

the natural way a datatable grows is by adding rows, not columns. So a more natural design would have only two columns/fields, say "month" and "total", hence it would look like:

 MONTH   TOTAL
200901    10
200902    10
200903    10
200904    10

and now it becomes very easy to:
- add another month
- select some months and perform calculations on their data

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

19-Jun-09 21:23

Hey Luc,
Thanks but I'm kinda forced to this table structure:

         Jan   Feb   Mar   Apr
         ---   ---   ---   ---
Budget   10    10    10    10
Actual   10    5     10    0
...      0     0     0     0
...      0     0     0     0
...      0     0     0     0

Is there any way to do it with this structure??

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Luc Pattyn20-Jun-09 0:41

Luc Pattyn

20-Jun-09 0:41

Muammar© wrote:
Is there any way to do it with this structure??

Anything is possible, however I have never chosen such hard way of doing things, so I don't know any details.
FWIW: there is a PIVOT command that rotates a table.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

20-Jun-09 3:15

Thanks Luc, Yes, it can be solved using pivot tables or the decode function but my problem is far more complicated to be solved by either of them alone!
Thanks for your time mate!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Henry Minute20-Jun-09 1:00