koi data base kae hawale se proram bana sikhaen plzz

[Munawer jinnah]

janab e aali aapki bari mehrbani hogi ke ager aap data base ka koi program banana sikhaen plzzzzzzzzzzzzzzzzzzzzzzz

[osama_is_cool]

u can contact me
*****

[UFONE_GSM]

Please Share Your knowledge here.

[FalconKha3]

Visual basic ko SQL se connect kerne k liye hum ADO (ActiveX data object) use kereinge...

aap ye reference se add kersakte hain.. "Microsoft ActiveX Data Objects 2.8 Library"

CODE LEVEL...

sab se pehle hum connection aur recordset k instances create kareinge..

Dim MyConnObj As New ADODB.Connection
Dim myRecSet As New ADODB.Recordset

Recordset mein hum record save kerte hain...

is k baad connection create hota hai...

MyConnObj.Open _
                "Provider = sqloledb;" & _
                "Data Source={ServerName};" & _
                "Initial Catalog={DatabaseName};" & _
                "User ID={UserName};" & _
                "Password={Password};"

serverName = your computer name/localhost/IP
DatabaseName = jis se aap link kerna chahte hain. jahan se record aayeinge.
username and password k baray mein to aap ko ilm hoga.. SQL ka username or password..


is ke baad hum ek string banayeinge jo k SQL QUERY hai..

dim sqlStr as string
sqlStr = "select * from tablename"

then we get records in record set...

myRecSet.Open sqlStr, MyConnObj, adOpenKeyset

is command se tamam record myRecSet mien save hojayeinge...

agar aap ko dekhna hai k kitne records save huay hain to simply aap type kareinge..

myRecSet.recordcount

aur agar tamam records aap ko dekhne hain to aap ko looping kerni paregi..

while Not myRecSet.EOF  'means jab tak records khatam nahi hotay..
    textbox.text = textbox & myRecSet(0) & myRecSet(1) and so on..
    myRecSet.movenext
wend

0,1,...... ; yeh sab columns hain.. 0->1st column, 1->2nd Column
phir movenext dooosre record pe chala jayega aur issi tarah saray records aap k saamne ajayeinge...


THANKYOU FOR VISITING...

REGARDS
ARSLAN
SOFTWARE DEVELOPER

[gulshan]

agr men acceesss database use karon to kya code hoga?or dosra sawal ye he k agr vb form men text box ki value access k table ki value se kese compare karwaenge???mjhe login form banana he....plzzz help me....men pareshaan hogai try kar kar k nahi solve horaha ye problem....

[FalconKha3]

Ek Control hota hai ADODC uski properties mein option hota hai link ka.. Woh her ek ko link kerta hai aur connection banadeta hai.. so aap access ko easily link kar sakte hain....

and login form banana mushkil nahi...

aap ka jo recordset hai us se field get kerlein aur easily use kerein...

textbox.text = recordset!username
like this...

[gulshan]

bohat bohat shukria apk response ka...men try kark aapko bataongiii...ok....

[gulshan]

bs ye btaden k is men condition kya lagaenge yehi wali jo apne likh jr di he ....ya EOF wali condition lagegi If k sath..plz kese chek karenge iski cding btaden...men charhi hon k agr username dtabase me ho to form2 men jae otherwise error ka msg dede..plzzz helpme...kya condition lagegi...?

[mr_bhm]

u can contact me
"osama_is_cool***********"

email id not allow

[gulshan]

salaaam
agr 2 condition lagana ho to kese karenge ,mjhe login form k lye username name or password dono ko chk karwana he...men dono sath likhti hon to error deta he jese
If textbox1.text=rs!username and text2.text=rs!password Then
form2.show

is per error deta he...jab k sql string ye he..
str="select username,password from login where username='" &textbox1.text &'" and password='" & textbox2.text & "'"


bataen kya hal he iskaaa???/plzzz

[FalconKha3]

aap Textbox.text k sath trim lagadein..

Trim(Txtbox.text)

[FalconKha3]

salaaam
agr 2 condition lagana ho to kese karenge ,mjhe login form k lye username name or password dono ko chk karwana he...men dono sath likhti hon to error deta he jese
If textbox1.text=rs!username and text2.text=rs!password Then
form2.show

is per error deta he...jab k sql string ye he..
str="select username,password from login where username='" &textbox1.text &'" and password='" & textbox2.text & "'"


bataen kya hal he iskaaa???/plzzz

Aap Complete data fetch kerlein.. string mein.. select * from table
aur phir checking kerein..

If trim(textbox1.text) = val(rs!username) then
if trim(text2.text)=val(rs!password) Then
from2.show
else
msgbox "invalid password"
end if
else
msgbox "Invalid user name"
end if


TRY THIS