hello!!!

i'm having the code of data inserting (database "sqlserever")..i'm writing this code in .vb file(creating classes,so can be used in any form)....in that i wrote a class for database connection & for other things..BUT i'm having a problem like...the values that has to be inserted in database..are taken from another aspx form.
so how do i take values form that aspx page & assign to .vb files insert query

[u]HOW DO I LINK THESE VALUES?</u>

Thanku!!

You can add properties to your class and pass these values in this properties collection

Regards
Ganesh

something like this...

public string Name
{
    get{return txtName.Text;}
}
public string Email
{
    get{return txtEmail.Text;}
}
public string Phone
{
    get{return txtPhone.Text;}
}

Yes... U can use properties to enter values in the database. U can also pass the values using method signatures.
Like u hav a method:
public function UpdateEmployee(ByVal EmpId,ByVal EmpFName,...)
End function
But if u need to pass values from one form to another form, there are several ways...
So tell me, what exactly you wanna know..

I'M giving my code with this..

i want is get the values from mypage.aspx page & pass it to insert query in .vb file..like
insert into mytable(name,id) values(textbox1 value & text box2 value) so these text box value..how can i get these values in .vb file..i want these values from my aspx page

thanx!!!!
the follwing code in .vb file is wrong..i'm just checking it!!!


Public Class InsertData
        Inherits System.Web.UI.Page


        Public Function Insert(ByVal email, ByVal fname)
            Dim sqlconn As SqlConnection
            Dim comm As SqlCommand
            Dim sql As String
            sqlconn = New SqlConnection("data source=SHANTASOFTDC;initial catalog=traveldb;password=sa;persist security info=True;user id=sa;")
            sqlconn.Open()
            sql = "INSERT INTO user_profile_info(email,fname)VALUES ('fname',fname)"
            comm = New SqlCommand(sql, sqlconn)
            Return email
            comm.ExecuteNonQuery()
            sqlconn.Close()
        End Function

    End Class

NitinJoshi,

Why are you sending me e-mail with technical questions directly? Posting on this forum is the best way to get a quick answer....


Cheers,

Imar

Nitish,
U have a function named "Insert" inside the class InsertData defined in a seperate .VB file, so how do u expect the Request.Form("email") thing goin to work while your textboxes are defined in mypage.aspx?
U have defined a function and u have no return types defined for the function? U also need to modify function signature like...

Function Insert(ByVal FName AS String, ByVal LName As String, ByVal Email As String) As Integer
.....
End Function
U need to create an instance of the 'InsertData' class in the mypage.aspx code-behind. When you r submitting this page, create an instance of the class in the Submit event and access the 'Insert' function like..
Dim myobj As New InsertData
Dim val as Integer
val = myobj.Insert(Request.Form("fname"),Request.Form("l name"),Request.Form("email"))
...
I guess u need to learn a lot before u start using a class man

Hey man thanx for u r reply!!!
i submitted the little edited code after that..even i told u the code is not proper..i was experimenting on it!!!

Basically i'm new to .NET Tech.. i've started work on it directly...i'm in learning stage...right now i'm working on a project in a firm...so things like this happens...

but any way thank you very very much for u r Reply!!!

NitinJoshi,
your vb files just interacts with your datasource so there is no need to derive it from System.Web.UI.Page,
you can write your DataAccess layer in a simple class then in your ASP.NET page you can use it(instantiate it and use its desirable functions).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.