LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page