Search:

aargh..thanks for that info Krzemo

i never used trigger in my DB, so never run into any trouble :D..will change it to SCOPE_IDENTITY() ASAP ;)

now the trend is move from desktop to Web app..web.config is the right file for this

right now i'm using .ini file too and it's great

or u can used RETURN @@IDENTITY but it's for all ur scope based on the documentation

i believe Access DB Linking is usefull when u use VBA code..

u have form in Access and it use linking DB which mean user can't see "the real DB" or u want to hide "the path to the real DB"

PS:...

i'm using Users, Banks, etc

for a while i used tbl prefix..but i ended using above for now coz it easier to read :D

check this out http://vyaskn.tripod.com/object_naming.htm

Does anyone can give example regarding ParentChild OO ?

ex: Manajer have direct employee like Supervisor, Supervisor have direct employee like Staff

so i can set the something like this...

i think u can't do something like that..u'll end up searching entire network..

maybe what u ask is instead changing the DBPath inside the program, u want it to be dynamic so u don't need to...

try this one

SELECT c.sorid, c.startdate, c.cost
FROM table2 AS c
WHERE c.startdate <= getdate() AND c.contractorid = 1
GROUP BY C.Sorid, c.startdate, c.cost
HAVING c.StartDate = (SELECT...

agree with Thread1

if it use to populate grid it must use ClientSide cursor
in example #2 u didn't set CursorLocation so i think it's on Client as default otherwise u'll get an error

for the...

let say i have this value in my Table1

Table1 = Date + EnteredNumber

1/Dec/2006 | 2
3/Dec/2006 | 1
5/Dec/2006 | 3
7/Dec/2006 | 2
8/Dec/2006 | 2
9/Dec/2006 | 5

something strange with the Treeview

ok, i found some way to produce the error

say the node will have this kind


Menu
- Logout
- Quit

The Treeview object, is it dynamically created ¿ -> yes..it populate with an xml file as the source..

Is the Treeview object on another form that's being disposed -> i'm not disposing any...

i got this message when try to .Close a form in MDI environment

An unhandled exception of type 'System.ObjectDisposedException' occurred in system.windows.forms.dll

Additional information:...

thx umararif but i'm afraid that's not what i mean

i already found an answer..

use DBCC CheckIndent

see BOL for further explanation

thx

i have an identity column with value 1, 2, 3

if i delete the #3..the new record will inserted using 4 as the identity..

is there a way to use 3 as the identity since it's not there yet?
and...

i guest it need to set up the textbox to be not wider than the datagrid column..so if it reached its width, the text will wrapped it instead of make it wider..

have anyone got a solution for...

textbox can have multiline feature..

the datagrid's column width is just dynamically changed..

thx jasonli

Of course text in textbox isn't wrapped up in edit mode -> are u sure? coz i've seen an example that wrapped

TextArea? can u elaborate more?

as u all see at the attachment..

i'm at editing mode and the text of the textbox si not wrapping up hence it display beyond the Browser width (which i choose 800 x 600)

why this happened?

thx exterminator

well, i try using SPROC yesterday..

already try View and it can used SELECT ID FROM View_Name

gonna try Function though

need to catch up a bit now :)..thanks

let say i have one query


SELECT [id]
FROM table1

and have 2nd query


SELECT [Desc]

have a table parent child record something like this
Table1 = @ID + Desc + RefID
1 + Manager + 0
2 + Assistant Manager + 1
3 + Supervisor + 2
4 + Secretary + 1
...

so my plan is displaying...

thx RD

here is the solution i have


Dim a as new ClassA

Dim b As SqlDataReader = a.Retrieve(CInt(DescriptionList.SelectedItem.Value))

' Dimensions an array of ListItems that are...

i can populate one using this method


'a is other Class that use Retrieve method to populate data against Database
Dim b As DataSet = a.Retrieve

DropDown.DataSource = b
...

found an answer at other forum

you can give the asp.net textbox a javascript event

this.TextBox1.Attributes.Add("onKeyDown","javascript:functionToClearThisTextBox();");
it's in C#..

ps:...