Hi,
your question is not clear to me.Kindly explain in details.
what do u mean by available data base?...
User Profile
Collapse
-
-
ok buddy now I am giving u some hints.1st u try youself ,if requered i will give u the sample code.
1)add reference of ActiveX data objects 2.6.library
2)add connection object(ADODB)
3)set the connection string to the connection object.
4)add recordset .
recordset object is very powerfull.it will add,delete,upda te your records in database table.
try it first....Leave a comment:
-
I have give a pices of code
Code:daHeader.Item("TOTAL_AMOUNT") Is System.DBNull.Value 'daHeader is a datareader
Leave a comment:
-
you can use Pkzip/Pkunzip ...I have use it & its works fine.I gave the sample code for this earlier.for further information plz check my threads....Leave a comment:
-
-
Yes it can be achieved easily.
Now I have Just Give u the Hints.ok First Try Yourself. if not possible then i will
give u the Details Code.
1)First Populate the Combo in Form Load event.
2)Now write code(searching desire recor) in combo_change event.
a) select the fields that u want to display in textbox through recordset filter by combo.text
b) if recordset recordcount >0 i.e if u will find...Leave a comment:
-
in VB.NET everything treated as object.
So, when you call form1.showdialo g() ,you do not create object for Form1. i.e why the error occur.
I just change the code. Please Check it.
Code:dim tmpMain as new Form1 tmpMain.ShowDialog() Me.Close()
Leave a comment:
-
Actually it is a custom Button use in VB designing(third party control).
click here...Leave a comment:
-
Plz Do Not Post the Same Question. It will very difficult for everyone to Keep track.
I have already give my openion in your another post. check it.
I kindly suggest u if U r Problem Have been Solved then then Make an End of Tag ....Leave a comment:
-
Actually Microsoft DTS package Comes with SQL Server Database or Desk top Engine.
I think the project You have Copied. The Back end is SQl Server. & currently SQL server not installed in your M/C. So First Install SQL Server. then the DLL will Automatic install in your system directory.After that your Project will find the corrosponding DLL....Leave a comment:
-
hi,
here is the sample code to demonstrate how to retrieve data from table
I assume that that UserId or FormNo both are Unique Key.
Code:Dim rsTemp As New ADODB.Recordset Dim conTemp As New ADODB.Connection If rsTemp.State = adStateOpen Then rsTemp.Close rsTemp.Open "Select * from [TABLE NAME] where formNo=' " & txtformNo.Text & " ' ", conTemp, adOpenDynamic,
Leave a comment:
-
-
-
-
Ok Frnd
it is not so hard. to Populate Data in a Combo.
I am giving U a simple pieces of code to demonstrate how to populate data in combo/list box.
Code:Dim rsTemp As New ADODB.Recordset Dim conTemp As New ADODB.Connection If rsTemp.State = adStateOpen Then rsTemp.Close rsTemp.Open "Select vendorname from vendors ", conTemp, adOpenDynamic, adLockOptimistic while
Leave a comment:
-
I think there r two Problems in this code.
1)U can't say whether the File Exist in specific Path or not.
if the file doesn't exist in specific Path then U will get a runtime error. for Both
Statement.
2)the requirement is to copy the file, not to move the file so the Kill statement is
not required...Leave a comment:
-
Use the property of Form
Set Moveable=false
Windowstate=Max imize.
2nd Question???? conffusing.Plz Explain in Details....Leave a comment:
-
ADD reference to your Project "Microsoft Scripting Runtime"
Use FilesystemObjec t in Ur Project.
Check The Different Property & method of filesystemobjec t.
U will get u r Ans.Good Luck.
1st U try find out the sol by yourself.if not possible I will give U the Solve in Details ok?...Leave a comment:
-
No activity results to display
Show More
Leave a comment: