Click here to Skip to main content
16,005,241 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how to do "Lucene- WildCard Search" Pin
R.Prabha Devi3-May-06 1:57
R.Prabha Devi3-May-06 1:57 
QuestionCreate Directory..... Pin
NeverHeardOfMe2-May-06 22:27
NeverHeardOfMe2-May-06 22:27 
AnswerRe: Create Directory..... Pin
Jakob Farian Krarup2-May-06 23:54
Jakob Farian Krarup2-May-06 23:54 
GeneralRe: Create Directory..... Pin
NeverHeardOfMe3-May-06 0:07
NeverHeardOfMe3-May-06 0:07 
GeneralRe: Create Directory..... Pin
J4amieC3-May-06 0:45
J4amieC3-May-06 0:45 
GeneralRe: Create Directory..... Pin
NeverHeardOfMe3-May-06 1:10
NeverHeardOfMe3-May-06 1:10 
QuestionAddhandler to a dynamic control not working -- VS 2003 Pin
Rizwan Bashir2-May-06 21:59
Rizwan Bashir2-May-06 21:59 
QuestionData Relations Pin
kuwl_mark2-May-06 21:44
kuwl_mark2-May-06 21:44 
I am defining relationship between datatables by using oracle as the backend.
It works fine in sql but in oracle it prompts an error "OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT"

my code for SQL is
Imports System.Data
Imports System.Data.SqlClient

Dim conn1 As New SqlConnection("Server=ibmserver;database=Northwind;User id=ADMINISTRATOR;Password=ADMIN")
conn1.Open()
Dim ds1 As New DataSet
Dim str1 As String = "select * from_categories"
Dim str2 As String = "select * from products"
Dim adapter1 As New SqlDataAdapter(str1, conn1)
adapter1.Fill(ds1, "categories")
adapter1.SelectCommand = New SqlCommand(str2, conn1)
adapter1.Fill(ds1, "products")
ds1.Relations.Add("categories_products", ds1.Tables("categories").Columns("categoryID"), ds1.Tables("products").Columns("categoryid"))
Dim categories As DataTable = ds1.Tables("categories")
DataGrid1.DataSource = ds1.Tables("categories")
DataGrid1.DataBind()
DataGrid2.DataSource = ds1.Tables("categories.categories_products")
DataGrid2.DataBind()
******************************************************************************
my code for oracle is

imports system.data.oledb

dim myConn as OledbConnection
dim myDa as oledbDataAdapter
dim myDa1 as oledbDataAdapter

dim drowParent as datarow
dim drowchild as datarow

dstDT = new dataset()
myConn=New OleDbConnection("Provider=MSDAORA.1;User ID=jewellman;password=jewellman;Data Source=orcl;Persist Security Info=False")
myDa = new oledbdataadapter("Select * from designTransactions",myConn)
myConn.open()
myda.fill(dstDT,"designtransaction")

myDa.selectcommand=new oledbcommand("Select * from designcustomerapprovel",myconn)
myda.fill(dstDT,"designcustomerapprovel")


dstDt.relations.add("DesignApprovel",dstDT.tables("designtransactions").columns("id"),dstDt.Tables("designcustomerapprovel").columns("categoryid"))
myConn.close()

QuestionButton with dinamic text Pin
papa19802-May-06 21:27
papa19802-May-06 21:27 
AnswerRe: Button with dinamic text Pin
CWIZO2-May-06 21:37
CWIZO2-May-06 21:37 
GeneralRe: Button with dinamic text Pin
papa19802-May-06 22:14
papa19802-May-06 22:14 
GeneralRe: Button with dinamic text Pin
CWIZO2-May-06 22:58
CWIZO2-May-06 22:58 
GeneralRe: Button with dinamic text Pin
papa19802-May-06 23:49
papa19802-May-06 23:49 
GeneralRe: Button with dinamic text Pin
CWIZO2-May-06 23:53
CWIZO2-May-06 23:53 
Questiondropdownlist Pin
Balwan2-May-06 20:39
Balwan2-May-06 20:39 
AnswerRe: dropdownlist Pin
CWIZO2-May-06 21:37
CWIZO2-May-06 21:37 
QuestionEnabled/Disabled dropdownlist Pin
MissionSuccess2-May-06 19:52
MissionSuccess2-May-06 19:52 
AnswerRe: Enabled/Disabled dropdownlist Pin
R.Prabha Devi2-May-06 21:57
R.Prabha Devi2-May-06 21:57 
GeneralRe: Enabled/Disabled dropdownlist Pin
MissionSuccess3-May-06 0:10
MissionSuccess3-May-06 0:10 
QuestionDrop down list Pin
Balwan2-May-06 19:47
Balwan2-May-06 19:47 
AnswerRe: Drop down list Pin
CWIZO2-May-06 21:38
CWIZO2-May-06 21:38 
Questionbinding slides to grid Pin
sandip manoj2-May-06 18:53
sandip manoj2-May-06 18:53 
Questionuser/role management with atlas Pin
silverP2-May-06 15:04
silverP2-May-06 15:04 
AnswerRe: user/role management with atlas Pin
minhpc_bk2-May-06 15:53
minhpc_bk2-May-06 15:53 
Questiondelete row in dataset Pin
janetb992-May-06 11:37
janetb992-May-06 11:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.