Re: How to use class for data accessing - Visual Basic Discussion Boards

Thanks mubashir, i will try n get bac to u, Thanks a lot dear to show ur concern.

Regards

Jennifer Wadhani
jenniferaahmed@yahoo.com

I want to write a Listening Music Program with VB.NET but I don't know what place I begin!

For playing sound...use the following

Public Const SND_ASYNC = &H1 ' play asynchronously
Public Const SND_LOOP = &H8 ' loop the sound until next sndPlaySound
Public Const SND_NOSTOP = &H10 ' don't stop any currently playing sound
Public Const SND_NOWAIT = &H2000 ' don't wait if the driver is busy

' Use the following library
Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long

' call

PlaySound("FilePath And Name", 0, SND_NOSTOP)

V.Gopi.
Easy Design Systems
Coimbatore
India

Hi guys.. ok, here is my situation. I am doing SQL database programming ith VS 2003. I did a sql database called 'test.adp'. In this DB there is two tables.. ONe is 'Customer', the other is 'Temp'. In both this tables is the field 'Name'.
Okay, let's say the field 'Name' under the table 'Customer' have only one data in text form called 'David' . In the 'Temp' table, there is no data in it.
Is it possible for me to create a button and put a command in it where it will open up the 'customer' table, extract that 'David' data and insert it into the 'Temp' table under the 'Name' Field? Can anyone give me a brief command example that can accomplish this? Thanz for your time..

OK I'm not trying to be a jerk, just being honest.

No one is going to answer this question because probably no one on this forum has the time or interest in teaching basic SQL and data access in VB.NET. If we did have the inclination, we would not have the time because we'd be busy with either teaching or writing a book.

That's just the basic truth.

Yes this is possible - you can use a SELECT query to get data from one table and an INSERT query to put it in the other. Or use about half a dozen other ways.

All of which require some basic understanding of SQL and data access. You have to learn that on your own.

Again I don't want to seem like a jerk, it's just reality. You can do it - nobody here will do it for you.

We all have to start somewhere, and I understand that the MSDN is not the place - it's just not useful until you reach a certain level.

But the same is true of this forum.

What you need at this point is a good reference book. A beginning book of any kind. If you feel like you are good with picking things up quickly, a beginner book may seem overly simple - in which case certification books often give more technical but useful overviews. To learn NET initially I used the MCSD 70-360 Exam book published by Que, authored by Mike Gunderloy. It is a great quick start. Costs you $50 new, but how much is your time worth?

If you don't have the money, or just want to look at something right now, here is freebie on the web - I don't think it is that great, but it is better than nothing:

http://www.interplat.com/VBNet.pdf[^]

Godd Luck .... seriously

Been through that book, it doesn't go through SQL database programming. Select and Insert Command.. We are getting somewhere eventually.. Beasically, I am not asking anyone to write the whole code down for me. as Mentioned on the starting thread, I gave a small example of what I am trying to do and hopefully, someone out there who is helpful enough and have some spare time in his hands can help out.. This is what this thread is for, after all..
So anyone else with some knowledge on this and is willing to help... Will appreciate your time...

hi all
in my project i have table emp.i want to put all my data accessing function add,delete,update in my class.in my form a will use this class object to accessing function.how i can do this.

use this function for retrival

Public Function FetchData(ByVal tableName As String, Optional ByVal sql As String = "", Optional ByVal Transaction As OleDb.OleDbTransaction = Nothing, Optional ByVal mAddWithKey As Boolean = True) As DataTable
Dim tblData As DataTable
If sql = "" Then
DADPTable = New OleDb.OleDbDataAdapter("Select * from " & tableName, DataConnection)
Else
DADPTable = New OleDb.OleDbDataAdapter(sql, DataConnection)
End If
If Not Transaction Is Nothing Then
DADPTable.SelectCommand.Transaction = Transaction
End If
DADPTable.AcceptChangesDuringFill = True
If mAddWithKey Then DADPTable.MissingSchemaAction = MissingSchemaAction.AddWithKey
tblData = New DataTable(tableName)
DADPTable.Fill(tblData)
FetchData = tblData
tblData = Nothing
End Function

Use this function for update :

Public Sub UpdateData(ByVal tableName As DataTable, Optional ByVal Transaction As OleDb.OleDbTransaction = Nothing)
Dim commandBuild As OleDb.OleDbCommandBuilder
DADPTable = New OleDb.OleDbDataAdapter("Select Top 1 * from " & tableName, DataConnection)
If Not Transaction Is Nothing Then DADPTable.SelectCommand.Transaction = Transaction
Dim tblAdd As DataTable = ds.Tables(tableName).GetChanges(DataRowState.Added)
Dim tblModify As DataTable = ds.Tables(tableName).GetChanges(DataRowState.Modified)
Dim tblDelete As DataTable = ds.Tables(tableName).GetChanges(DataRowState.Deleted)

If Not tblAdd Is Nothing Then
If tblAdd.Rows.Count > 0 Then
commandBuild = New OleDb.OleDbCommandBuilder(DADPTable)
DADPTable.InsertCommand = commandBuild.GetInsertCommand()
If Not Transaction Is Nothing Then DADPTable.InsertCommand.Transaction = Transaction
DADPTable.Update(tblAdd)
End If
End If
If Not tblModify Is Nothing Then
If tblModify.Rows.Count > 0 Then
commandBuild = New OleDb.OleDbCommandBuilder(DADPTable)
DADPTable.UpdateCommand = commandBuild.GetUpdateCommand()
If Not Transaction Is Nothing Then DADPTable.UpdateCommand.Transaction = Transaction
DADPTable.Update(tblModify)
End If
End If
If Not tblDelete Is Nothing Then
If tblDelete.Rows.Count > 0 Then
commandBuild = New OleDb.OleDbCommandBuilder(DADPTable)
DADPTable.DeleteCommand = commandBuild.GetDeleteCommand()
If Not Transaction Is Nothing Then DADPTable.DeleteCommand.Transaction = Transaction
DADPTable.Update(tblDelete)
End If
End If
DADPTable = Nothing
commandBuild = Nothing
End Sub

V.Gopi.
Easy Design Systems
Coimbatore
India

Hi,

Can someone please brief me on how to save 'pdf' files(there are about 15 files) into a SQL database and retrieve/open it from a datagrid?

I have about 15 pdf files on my webserver and need to save it in the SQL database, so every pdf file saved in the database will have a primary key and the file will be saved either as 'ntext' or 'binary' type...I just have this rough idea.

If someone has a ready code in VB.net then nothing better( i know thats a shortcut Smile | :)

but it will help me like a tutorial. C# code will do too, I can then convert the code to Vb.net

Thanks a ton.

Aartee.
...HE is watching Us All!

Does anyone know how to write help files for a VB program I wrote?

I need to add help files to the program, but I've got no idea how to do this.

Thanks alot

I don't know if there are new way of doing it but I use the HTMLHelp Workshop (easy to search and DL for free from MS). You write html pages and then you compile them into a .chm help file.

Hi Friends,
I came to know that there r skins availale for .NET. I mean if we attach that skin to out .NET intsallation then then whatever UserID we design will automatically be as per that skin rather than the default style. We can then change that appereance but at the first time when we add new control or form in our application it will appear as per the theme that we have attached with the .net installation.

So any one can tell me from where I can get these themes and how can I attach that to my .NET?

Plz send me reply soon.
Thank u all.

Hi all,

I am new to .Net. I have created a windows application in vb.net.

Now the problem is that

I want my application to be a piracy free so that
1)no one can copy from CD to any other medium and
2)no one can setup my application more than once from the CD.

Is there any possibility.If yes please tell me

Thanks in advance

Anonymous wrote:
1)no one can copy from CD to any other medium and

There is no language on earth that can do this for you.

Anonymous wrote:
2)no one can setup my application more than once from the CD.

Again, there is no language on earth that can do this for you. This can't be done at all.

Anonymous wrote:
I want my application to be a piracy free so that

This is the pipe-dream of copy protection. You will NEVER be able to make anything "piracy free". If that was possible, we'd all be paying $5 for video games and $20 for MS Windows, MS Office, ...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

hi,
i want to shutdown another pc in my LAN kindly help me.
bye

basanta

Step 1: Go to the PC
Step 2: Pull the plug out of the wall socket; or switch it off.
Laugh | :laugh:

Yes it can be done programatically, but I don't intend to outline the procedure in this forum.

Apart from the hacking reasons I can think of, why would you want to do this?

...Steve

pls send the code how run the .avi,.dat file in using asp

ok after this year 2004

You've gotta be joking !?

...Steve

Hi all..

I am a very new person in developing this web application using vb.net. Just wondering something, hope someone out there could reply to my question. Well.. in the aspx form, the html code, sometimes i'd see vb coding in <%.. %> tags.. when do the codes in the coding be trigger? how do you use it?

Thanks..

a very confused new starter Dead | X|

Thoese characters are the asp code delimiters, meaning they were/are used in "ordinary" asp development to tell what is script-code and thus needs to be handled by the server before the document is created and sent to the browser.

---------------------------
127.0.0.1 - Sweet 127.0.0.1

Somebody knows some function to generate the numbers of the bar codes EAN13? With 12 characters of data and the 13th digit as check digit. How the code EAN13 is generated?

What's wrong with typing "VB.NET EAN13" into Google?
Here, let me do it for you...clicky[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Hi all,
I want to interact with OS (Windows)'s buffer, exp: write, read or manager OS's buffer. What is code in VB.Net or C# to do it.
Thanks.

Huh?

This does not make sense. Which buffer are you talking about?

...Steve

LOTS more explaination is needed here! What buffer? Which API are you using? If this buffer part of your app or another app? What are you trying to do with this buffer?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome