update problem

  • Thread starter Thread starter rama
  • Start date Start date
R

rama

Hi,
I am using Oledbadapter to create sas datasets in unix box.
what i have to do is take an excel sheet and convert into .net dataset
and iam using Oledbadapter myoledbadapter.update(mydataset)(this is
not original code)
but iam unable to update my sas dataset ,can u tell me what is the
problem
thanks in advance
 
There are a whole lot of possibilities and without seeing the code, it'd be
pretty hard to guess at the nature of the problem.

If you can post the code or the critical snippets, I can probably be of more
help.

HTH,

Bill
 
hi,
i want form values from asp.net form has to be sent to sas using below
code
iam able to send data like
insert test.codes values(""aaa"")
but i want testbox1.text to be send in place of "aaa"

William Ryan said:
Me.connectionstring = "provider=SAS.IOMProvider.1; SAS Workspace ID=" + obWS.UniqueIdentifier
Click to expand...
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()

'sp.Execute("list", "")

oDA.Fill(oDS, "aaa")
Me.Label1.Text = ds3.Tables(0).TableName


There are a whole lot of possibilities and without seeing the code,
it'd be
 
Back
Top