G
Guest
Hi
I have created a website that I want to feed content in from a database to populate the site
Question 1: If I have a several different tables I want to connect to that are all used for different things with in the page, should I create several OleDbDataAdapters or just use the same one for all my DataSets
Question 2: If I want to show simply a header row and a content row in a table should I use a DataGrid, DataList or what? In ASP I just did a response.write (Content) or what ever. What is the best way to do this in ASP.NET using VS
Question 3: I have a menu that I want to create dynamically from a database. I have created the Data Set for the menu but everytime I try and create the DataBindings I get an error saying ArgumentNullException: Value cannot be Null??? WHY
I would really be grateful if someone could help me with these questions..
...:: CODE ::.
#Region " Web Form Designer Generated Code
'This call is required by the Web Form Designer
<System.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent(
Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapte
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnectio
Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbComman
Me.DsMenu11 = New CPNiNet.dsMenu
CType(Me.DsMenu11, System.ComponentModel.ISupportInitialize).BeginInit(
'OleDbDataAdapter
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbSelectCommand
Me.OleDbDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "tblMenu", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("menuName", "menuName"), New System.Data.Common.DataColumnMapping("menuURL", "menuURL"), New System.Data.Common.DataColumnMapping("menuLevel", "menuLevel"), New System.Data.Common.DataColumnMapping("parentID", "parentID"), New System.Data.Common.DataColumnMapping("accessID", "accessID"), New System.Data.Common.DataColumnMapping("contentID", "contentID"), New System.Data.Common.DataColumnMapping("description", "description"), New System.Data.Common.DataColumnMapping("header", "header"), New System.Data.Common.DataColumnMapping("content", "content"), New System.Data.Common.DataColumnMapping("Expr1", "Expr1"), New System.Data.Common.DataColumnMapping("menuID", "menuID"), New System.Data.Common.DataColumnMapping("groupID", "groupID"), New System.Data.Common.DataColumnMapping("Expr2", "Expr2")})}
'OleDbConnection
Me.OleDbConnection1.ConnectionString = "Integrated Security=SSPI;Packet Size=4096;Data Source=""SERVER""" &
";Tag with column collation when possible=False;Initial Catalog=DBCMS;Use Proced" &
"ure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLO" &
"LEDB.1"";Workstation ID=PC;Use Encryption for Data=False
'OleDbSelectCommand
Me.OleDbSelectCommand1.CommandText = "SELECT tblMenu.menuName, tblMenu.menuURL, tblMenu.menuLevel, tblMenu.parentID, tb" &
"lMenu.accessID, tblContent.contentID, tblContent.description, tblContent.header," &
" tblContent.content, tblContent.accessID AS Expr1, tblContent.menuID, tblGroups." &
"groupID, tblGroups.accessID AS Expr2 FROM tblMenu INNER JOIN tblContent ON tblMe" &
"nu.menuID = tblContent.menuID CROSS JOIN tblGroups
Me.OleDbSelectCommand1.Connection = Me.OleDbConnection
'DsMenu1
Me.DsMenu11.DataSetName = "dsMenu1
Me.DsMenu11.Locale = New System.Globalization.CultureInfo("en-US"
CType(Me.DsMenu11, System.ComponentModel.ISupportInitialize).EndInit(
End Su
Protected WithEvents Menu1 As skmMenu.Men
Protected WithEvents OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapte
Protected WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnectio
Protected WithEvents OleDbSelectCommand1 As System.Data.OleDb.OleDbComman
Protected WithEvents DsMenu11 As CPNiNet.dsMenu1
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
If (Page.IsPostBack = False) Then
Dim submenu1 As New skmMenu.MenuItem("<img src=""images/menublip.gif"" align=""absmiddle"">Home", "")
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 1", "page1.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 2", "page2.html"))
Dim submenu3 As New skmMenu.MenuItem("Sub Item 3 ->", "")
submenu3.SubItems.Add(New skmMenu.MenuItem("Sub Item 3 - 1", "page1.html"))
submenu3.SubItems.Add(New skmMenu.MenuItem("Sub Item 3 - 2", "page2.html"))
submenu1.SubItems.Add(submenu3)
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 4", "page4.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 5", "page5.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 6", "page6.html"))
Menu1.Items.Add(submenu1)
Dim submenu2 As New skmMenu.MenuItem("<img src=""images/menublip.gif"" align=""absmiddle"">Office", "")
submenu2.SubItems.Add(New skmMenu.MenuItem("Sub Item 1", "page3.html", "tooltip1"))
submenu2.SubItems.Add(New skmMenu.MenuItem("Sub Item 2", "page4.html", "tooltip2"))
Menu1.Items.Add(submenu2)
Menu1.CssClass = "menustyle"
Menu1.DefaultCssClass = "menuitem"
Menu1.DefaultMouseOverCssClass = "mouseover"
Menu1.HighlightTopMenu = True
Menu1.Opacity = 75
Menu1.zIndex = 100
End If
End Sub
I have created a website that I want to feed content in from a database to populate the site
Question 1: If I have a several different tables I want to connect to that are all used for different things with in the page, should I create several OleDbDataAdapters or just use the same one for all my DataSets
Question 2: If I want to show simply a header row and a content row in a table should I use a DataGrid, DataList or what? In ASP I just did a response.write (Content) or what ever. What is the best way to do this in ASP.NET using VS
Question 3: I have a menu that I want to create dynamically from a database. I have created the Data Set for the menu but everytime I try and create the DataBindings I get an error saying ArgumentNullException: Value cannot be Null??? WHY
I would really be grateful if someone could help me with these questions..
...:: CODE ::.
#Region " Web Form Designer Generated Code
'This call is required by the Web Form Designer
<System.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent(
Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapte
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnectio
Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbComman
Me.DsMenu11 = New CPNiNet.dsMenu
CType(Me.DsMenu11, System.ComponentModel.ISupportInitialize).BeginInit(
'OleDbDataAdapter
Me.OleDbDataAdapter1.SelectCommand = Me.OleDbSelectCommand
Me.OleDbDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "tblMenu", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("menuName", "menuName"), New System.Data.Common.DataColumnMapping("menuURL", "menuURL"), New System.Data.Common.DataColumnMapping("menuLevel", "menuLevel"), New System.Data.Common.DataColumnMapping("parentID", "parentID"), New System.Data.Common.DataColumnMapping("accessID", "accessID"), New System.Data.Common.DataColumnMapping("contentID", "contentID"), New System.Data.Common.DataColumnMapping("description", "description"), New System.Data.Common.DataColumnMapping("header", "header"), New System.Data.Common.DataColumnMapping("content", "content"), New System.Data.Common.DataColumnMapping("Expr1", "Expr1"), New System.Data.Common.DataColumnMapping("menuID", "menuID"), New System.Data.Common.DataColumnMapping("groupID", "groupID"), New System.Data.Common.DataColumnMapping("Expr2", "Expr2")})}
'OleDbConnection
Me.OleDbConnection1.ConnectionString = "Integrated Security=SSPI;Packet Size=4096;Data Source=""SERVER""" &
";Tag with column collation when possible=False;Initial Catalog=DBCMS;Use Proced" &
"ure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLO" &
"LEDB.1"";Workstation ID=PC;Use Encryption for Data=False
'OleDbSelectCommand
Me.OleDbSelectCommand1.CommandText = "SELECT tblMenu.menuName, tblMenu.menuURL, tblMenu.menuLevel, tblMenu.parentID, tb" &
"lMenu.accessID, tblContent.contentID, tblContent.description, tblContent.header," &
" tblContent.content, tblContent.accessID AS Expr1, tblContent.menuID, tblGroups." &
"groupID, tblGroups.accessID AS Expr2 FROM tblMenu INNER JOIN tblContent ON tblMe" &
"nu.menuID = tblContent.menuID CROSS JOIN tblGroups
Me.OleDbSelectCommand1.Connection = Me.OleDbConnection
'DsMenu1
Me.DsMenu11.DataSetName = "dsMenu1
Me.DsMenu11.Locale = New System.Globalization.CultureInfo("en-US"
CType(Me.DsMenu11, System.ComponentModel.ISupportInitialize).EndInit(
End Su
Protected WithEvents Menu1 As skmMenu.Men
Protected WithEvents OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapte
Protected WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnectio
Protected WithEvents OleDbSelectCommand1 As System.Data.OleDb.OleDbComman
Protected WithEvents DsMenu11 As CPNiNet.dsMenu1
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
If (Page.IsPostBack = False) Then
Dim submenu1 As New skmMenu.MenuItem("<img src=""images/menublip.gif"" align=""absmiddle"">Home", "")
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 1", "page1.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 2", "page2.html"))
Dim submenu3 As New skmMenu.MenuItem("Sub Item 3 ->", "")
submenu3.SubItems.Add(New skmMenu.MenuItem("Sub Item 3 - 1", "page1.html"))
submenu3.SubItems.Add(New skmMenu.MenuItem("Sub Item 3 - 2", "page2.html"))
submenu1.SubItems.Add(submenu3)
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 4", "page4.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 5", "page5.html"))
submenu1.SubItems.Add(New skmMenu.MenuItem("Sub Item 6", "page6.html"))
Menu1.Items.Add(submenu1)
Dim submenu2 As New skmMenu.MenuItem("<img src=""images/menublip.gif"" align=""absmiddle"">Office", "")
submenu2.SubItems.Add(New skmMenu.MenuItem("Sub Item 1", "page3.html", "tooltip1"))
submenu2.SubItems.Add(New skmMenu.MenuItem("Sub Item 2", "page4.html", "tooltip2"))
Menu1.Items.Add(submenu2)
Menu1.CssClass = "menustyle"
Menu1.DefaultCssClass = "menuitem"
Menu1.DefaultMouseOverCssClass = "mouseover"
Menu1.HighlightTopMenu = True
Menu1.Opacity = 75
Menu1.zIndex = 100
End If
End Sub