Date:         Wed, 22 Oct 2003 07:56:54 -0700
Reply-To:     rama <addanki143@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         rama <addanki143@YAHOO.COM>
Organization: http://groups.google.com
Subject:      how to send form values from asp.net webform to sas
              system(backend)
Content-Type: text/plain; charset=ISO-8859-1

hi,
my problem is to update dataset which resides on sas system by
collecting form values like testbox etc
 Me.connectionstring = "provider=SAS.IOMProvider.1; SAS Workspace ID="
+ obWS.UniqueIdentifier
            Dim oConn As New
OleDb.OleDbConnection("provider=SAS.IOMProvider.1; SAS Workspace ID="
+ obWS.UniqueIdentifier)
            'Dim catCMD As OleDbCommand = oConn.CreateCommand()
            'catCMD.CommandText = "create table test3.newtable ( i
num, name char(40), age num );"
            ' oConn.Open()

            'Dim myReader As OleDbDataReader = catCMD.ExecuteReader()
            Dim catCMD As OleDbCommand = oConn.CreateCommand()
            Dim catCMD1 As OleDbCommand = oConn.CreateCommand()
            'catCMD.CommandText = "create table test3.codes (  dir
char(40));"
            Dim str As String
            str = "kime"
            catCMD1.CommandText = "insert into test3.codes values
('@str');"
            ' catCMD1.Parameters.Add("@str1", SqlDbType.Char, 40)
            ' catCMD1.Parameters("@str1").Value = "kime"


            oConn.Open()

            'Dim myReader As OleDbDataReader = catCMD.ExecuteReader()
            oConn.Close()
            oConn.Open()

            Dim myReader1 As OleDbDataReader = catCMD1.ExecuteReader()
            oConn.Close()

            Dim oDA As New OleDb.OleDbDataAdapter(sql, oConn)
            Dim sql3 As String
            sql3 = "select * from test3.codes"

            Dim oDa3 As New OleDb.OleDbDataAdapter(sql3, oConn)
            Dim ds3 As New DataSet
            oDa3.Fill(ds3)
            DataGrid3.DataSource = ds3
            DataGrid3.DataBind()
iam using the above code,
iam able to create a dataset from .net on sas system
and iam able to send data using sql insert by using insert into
datasetname values(""aaa"")
but i want to send textbox1.text value to sas dataset
pls help me urgent
thanks in advance