Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

using strongly typed datasets with textboxes

Posted on 2009-04-11
16
Medium Priority
?
404 Views
Last Modified: 2013-11-26
Hi, i have a strongly typed dataset and would like to use the data with textboxes in a web application. how do i get the data from the dataset into the textboxes?
I am using visual studio 2008 and asp.net (visual basic)

thanks
Mick
0
Comment
Question by:Mick_Buckley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
16 Comments
 
LVL 10

Expert Comment

by:Espavo
ID: 24123258
Is this what you're asking for?
(I run this on Page_Load... )

            If Not IsPostBack Then
                Dim CatAdaptor As New SQLDataSetTableAdapters.CatalogueTableAdapter
                Dim cItems As SQLDataSet.CatalogueDataTable = CatAdaptor.GetItem(Request.QueryString("cID"))
                If cItems.Rows.Count > 0 Then
                    Dim cItem As SQLDataSet.CatalogueRow = cItems.Rows(0)
                    cWidthTextBox.Text = cItem.cWidth
                    cLengthTextBox.Text = cItem.cLength
                    cSquareTextBox.Text = cItem.cSquare
                    cDepthTextBox.Text = cItem.cDepth
                    cHeightTextBox.Text = cItem.cHeight
                End If
            End If

Open in new window

0
 

Author Comment

by:Mick_Buckley
ID: 24123630
when i type SqlDatasettableadapter.SiteTableAdapter it is underlined in blue and says it is not defined.
what could cause this?

Thanks
Mick
0
 
LVL 10

Expert Comment

by:Espavo
ID: 24124661
SqlDatasettableadapter. is the name of MY DataSet...

(I use a single DataSet and I add all my DataTables to the one DataSet for ease of use...)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Mick_Buckley
ID: 24124797
thanks for the reply,
what i've got at the moment is an xsd file (Site.xsd) and a class file Site.vb i've attached the class file.
i can use this with a grid view no problems with the following code
 Dim objSite As New SiteBLL()
        gvSite.DataSource = objSite.GetData()
        gvSite.DataBind()
that works fine, what i would like to do is use the same datasource for a form contailning textboxes.
what i've got so far from your code is:

Dim CatAdapter As New SiteTableAdapter
        Dim citems = CatAdapter.GetDataBySiteID(57)
        If citems.Rows.Count > 0 Then
            txtSiteName.Text = citems.SiteNameColumn.ToString()
            txtAddress1.Text = citems.Address1Column.ToString()
            txtAddress2.Text = citems.Address2Column.ToString()
            txtAddress3.Text = citems.Address3Column.ToString()
        End If
but that just gives me the column names in the text boxes, where am i going wrong

Thanks
Mick

Imports Microsoft.VisualBasic
Imports SiteTableAdapters
 
 
<System.ComponentModel.DataObject()> Public Class SiteBLL
 
    Private _SiteAdapter As SiteTableAdapter
    Protected ReadOnly Property Adapter() As SiteTableAdapter
        Get
            If _SiteAdapter Is Nothing Then
                _SiteAdapter = New SiteTableAdapter
            End If
            Return _SiteAdapter
        End Get
    End Property
 
    <System.ComponentModel.DataObjectMethodAttribute(ComponentModel.DataObjectMethodType.Select, True)> _
    Public Function GetData() As Site.SiteDataTable
        Return Adapter.GetData()
    End Function
 
    <System.ComponentModel.DataObjectMethodAttribute(ComponentModel.DataObjectMethodType.Select, False)> _
    Public Function GetDataBySiteID(ByVal SiteID As Int32) As Site.SiteDataTable
        Return Adapter.GetDataBySiteID(SiteID)
    End Function
 
End Class

Open in new window

0
 
LVL 10

Expert Comment

by:Espavo
ID: 24125134
You've missed the line of code that GETS the data:
                   Dim cItem As SQLDataSet.CatalogueRow = cItems.Rows(0)

0
 

Author Comment

by:Mick_Buckley
ID: 24125256
it doesn't recognise SQLDataSet.CatalogueRow (underlined in Blue)
Do i need to import or declare anything to use this

Mick
0
 
LVL 10

Expert Comment

by:Espavo
ID: 24125386
I'm a bit confused as to the way that you are calling the data from the vb class... (And all I did was copied the line from my code to show you what was missing...
Try substituting SQLDataSet. with SiteDataSet. and see what you get...
0
 

Author Comment

by:Mick_Buckley
ID: 24125496
I get the same using SiteDataSet. I've attached the class file i'm using (Site.vb)
if i use this with a gridview and use the following code it works fine
 Dim objSite As New SiteBLL()
        gvSite.DataSource = objSite.GetData()
        gvSite.DataBind()
any ideas?
Imports Microsoft.VisualBasic
Imports SiteTableAdapters
 
 
<System.ComponentModel.DataObject()> Public Class SiteBLL
 
    Private _SiteAdapter As SiteTableAdapter
    Protected ReadOnly Property Adapter() As SiteTableAdapter
        Get
            If _SiteAdapter Is Nothing Then
                _SiteAdapter = New SiteTableAdapter
            End If
            Return _SiteAdapter
        End Get
    End Property
 
    <System.ComponentModel.DataObjectMethodAttribute(ComponentModel.DataObjectMethodType.Select, True)> _
    Public Function GetData() As Site.SiteDataTable
        Return Adapter.GetData()
    End Function
 
    <System.ComponentModel.DataObjectMethodAttribute(ComponentModel.DataObjectMethodType.Select, False)> _
    Public Function GetDataBySiteID(ByVal SiteID As Int32) As Site.SiteDataTable
        Return Adapter.GetDataBySiteID(SiteID)
    End Function
 
End Class

Open in new window

0
 
LVL 10

Expert Comment

by:Espavo
ID: 24125852
The piece that seems to be missing is where you request the values from ONE ROW only...
You need to pull a DataSet... (As opposed to a DataTable)
0
 

Author Comment

by:Mick_Buckley
ID: 24125894
do you have any code to show me how this is done?
The function I call from the class does  only return a single row
Thanks
Mick
0
 
LVL 10

Expert Comment

by:Espavo
ID: 24126159
The code that I posted in the beginning of this discussion is all that I use...
I simply create my DataSet... then pull it as shown above... (no need to go through a second VB class... which is where I'm getting confused...)
0
 

Author Comment

by:Mick_Buckley
ID: 24126167
is your dataset an xsd file?
0
 
LVL 10

Expert Comment

by:Espavo
ID: 24126207
Yes...
0
 

Author Comment

by:Mick_Buckley
ID: 24126259
hi, thanks for you patience. I've attached the code for my xsd file, is there anything in here that you think may be giving me problems?
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Site" targetNamespace="http://tempuri.org/Site.xsd" xmlns:mstns="http://tempuri.org/Site.xsd" xmlns="http://tempuri.org/Site.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="MarketIntelligenceConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MarketIntelligenceConnectionString2 (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.MarketIntelligenceConnectionString2.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SiteTableAdapter" GeneratorDataComponentClassName="SiteTableAdapter" Name="Site" UserDataComponentName="SiteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketIntelligenceConnectionString2 (Web.config)" DbObjectName="MarketIntelligence.dbo.Site" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Site] WHERE (([SiteID] = @Original_SiteID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Site] ([fnAgencyID], [SiteName], [WebSite], [Google], [Address1], [Address2], [Address3], [Address4], [PostCode]) VALUES (@fnAgencyID, @SiteName, @WebSite, @Google, @Address1, @Address2, @Address3, @Address4, @PostCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fnAgencyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fnAgencyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SiteName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SiteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Google" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Google" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SiteID, fnAgencyID, SiteName, WebSite, Google, Address1, Address2, Address3, Address4, PostCode FROM dbo.Site</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Site] SET [fnAgencyID] = @fnAgencyID, [SiteName] = @SiteName, [WebSite] = @WebSite, [Google] = @Google, [Address1] = @Address1, [Address2] = @Address2, [Address3] = @Address3, [Address4] = @Address4, [PostCode] = @PostCode WHERE (([SiteID] = @Original_SiteID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fnAgencyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fnAgencyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SiteName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SiteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Google" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Google" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SiteID" DataSetColumn="SiteID" />
              <Mapping SourceColumn="fnAgencyID" DataSetColumn="fnAgencyID" />
              <Mapping SourceColumn="SiteName" DataSetColumn="SiteName" />
              <Mapping SourceColumn="WebSite" DataSetColumn="WebSite" />
              <Mapping SourceColumn="Google" DataSetColumn="Google" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="Address2" DataSetColumn="Address2" />
              <Mapping SourceColumn="Address3" DataSetColumn="Address3" />
              <Mapping SourceColumn="Address4" DataSetColumn="Address4" />
              <Mapping SourceColumn="PostCode" DataSetColumn="PostCode" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MarketIntelligenceConnectionString2 (Web.config)" DbObjectName="MarketIntelligence.dbo.Site" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBySiteID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteID" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT SiteID, fnAgencyID, SiteName, WebSite, Google, Address1, Address2, Address3, Address4, PostCode FROM dbo.Site where SiteID = @SiteID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SiteID" ColumnName="SiteID" DataSourceName="MarketIntelligence.dbo.Site" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SiteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SiteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Site" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Site" msprop:Generator_DataSetName="Site">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Site" msprop:Generator_UserTableName="Site" msprop:Generator_RowDeletedName="SiteRowDeleted" msprop:Generator_TableClassName="SiteDataTable" msprop:Generator_RowChangedName="SiteRowChanged" msprop:Generator_RowClassName="SiteRow" msprop:Generator_RowChangingName="SiteRowChanging" msprop:Generator_RowEvArgName="SiteRowChangeEvent" msprop:Generator_RowEvHandlerName="SiteRowChangeEventHandler" msprop:Generator_TablePropName="_Site" msprop:Generator_TableVarName="tableSite" msprop:Generator_RowDeletingName="SiteRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SiteID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="SiteID" msprop:Generator_ColumnPropNameInRow="SiteID" msprop:Generator_ColumnVarNameInTable="columnSiteID" msprop:Generator_ColumnPropNameInTable="SiteIDColumn" type="xs:int" />
              <xs:element name="fnAgencyID" msprop:Generator_UserColumnName="fnAgencyID" msprop:Generator_ColumnPropNameInRow="fnAgencyID" msprop:Generator_ColumnVarNameInTable="columnfnAgencyID" msprop:Generator_ColumnPropNameInTable="fnAgencyIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SiteName" msprop:Generator_UserColumnName="SiteName" msprop:Generator_ColumnPropNameInRow="SiteName" msprop:Generator_ColumnVarNameInTable="columnSiteName" msprop:Generator_ColumnPropNameInTable="SiteNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WebSite" msprop:Generator_UserColumnName="WebSite" msprop:Generator_ColumnPropNameInRow="WebSite" msprop:Generator_ColumnVarNameInTable="columnWebSite" msprop:Generator_ColumnPropNameInTable="WebSiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Google" msprop:Generator_UserColumnName="Google" msprop:Generator_ColumnPropNameInRow="Google" msprop:Generator_ColumnVarNameInTable="columnGoogle" msprop:Generator_ColumnPropNameInTable="GoogleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address1" msprop:Generator_UserColumnName="Address1" msprop:Generator_ColumnPropNameInRow="Address1" msprop:Generator_ColumnVarNameInTable="columnAddress1" msprop:Generator_ColumnPropNameInTable="Address1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address2" msprop:Generator_UserColumnName="Address2" msprop:Generator_ColumnPropNameInRow="Address2" msprop:Generator_ColumnVarNameInTable="columnAddress2" msprop:Generator_ColumnPropNameInTable="Address2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address3" msprop:Generator_UserColumnName="Address3" msprop:Generator_ColumnPropNameInRow="Address3" msprop:Generator_ColumnVarNameInTable="columnAddress3" msprop:Generator_ColumnPropNameInTable="Address3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address4" msprop:Generator_UserColumnName="Address4" msprop:Generator_ColumnPropNameInRow="Address4" msprop:Generator_ColumnVarNameInTable="columnAddress4" msprop:Generator_ColumnPropNameInTable="Address4Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostCode" msprop:Generator_UserColumnName="PostCode" msprop:Generator_ColumnPropNameInRow="PostCode" msprop:Generator_ColumnVarNameInTable="columnPostCode" msprop:Generator_ColumnPropNameInTable="PostCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Site" />
      <xs:field xpath="mstns:SiteID" />
    </xs:unique>
  </xs:element>
</xs:schema>

Open in new window

0
 
LVL 10

Accepted Solution

by:
Espavo earned 1000 total points
ID: 24126306
I just dropped your DataSet code into a new "site.xsd" file on my project...
And generated this code... please see if this works...

   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Dim SiteAdaptor As New SiteTableAdapters.SiteTableAdapter
            Dim Sites As Site.SiteDataTable = SiteAdaptor.GetDataBySiteID(57)
            If Sites.Rows.Count > 0 Then
                Dim Site As Site.SiteRow = Sites.Rows(0)
                txtSiteName.Text = Site.SiteName.ToString
                txtAddress1.Text = Site.Address1.ToString
                txtAddress2.Text = Site.Address2.ToString
                txtAddress3.Text = Site.Address3.ToString
            End If
        End If
    End Sub

Open in new window

0
 

Author Closing Comment

by:Mick_Buckley
ID: 31569219
Got it working in the end, i think i may have some issues with naming, i have a few items with the same name (different extensions)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question