Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Really Simple Question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Really Simple Question

 Post Reply Post Reply Page  <12
Author
otaku View Drop Down
Newbie
Newbie


Joined: 01 June 2003
Location: Canada
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote otaku Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2003 at 11:47am

try this web.config

<?xml version="1.0" encoding="iso-8859-1" ?>
<configuration>

<appSettings>
<add key="connBSS" value="Password=BSS_WClient;Persist Security Info=False;User ID=BSS_WClient;Initial Catalog=BSS;Data Source=bsswk1" />
</appSettings>

<system.web>
<customErrors mode="Off"/>
</system.web>

</configuration>

Back to Top
BigMeat View Drop Down
Newbie
Newbie


Joined: 29 May 2003
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote BigMeat Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 11:18am

Thanks guys.... you have been a great help.....

Im so glad i joined this forum

Back to Top
BigMeat View Drop Down
Newbie
Newbie


Joined: 29 May 2003
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote BigMeat Quote  Post ReplyReply Direct Link To This Post Posted: 05 June 2003 at 2:22am

Hi

Im try to get my head round datasets being typed and untyped and  had a query.  Am i write in saying that a typed dataset has to have a schema which comes .xsd file.  An untyped dataset does not have a schema and just contains tables, row and columns. 

So im just wondering how do I create a strongly typed dataset programmatically, i dont know how to create a .xsd file, however I notice I can write the dataset out to an xml file (does this make it strongly typed).  I notice that Visual Studio creates the .xsd file for  you easily enough but im trying to stay away from the GUI side of things and doing it all by hand code first.

So for example how would i make the below example typed?  And do I need to make sure every dataset I create is typed. 

Dim dsDetails As New DataSet()
Dim Conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("connBSS"))
Dim objAdapter As SqlDataAdapter = New SqlDataAdapter("SELECT SvpsName, SvpsID FROM Services", Conn)

objAdapter.Fill(dsDetails, "Details")

lblSvpsName.Text = dsDetails.Tables("Details").Rows(0).Item("SvpsName")
lblSvpsID.Text = dsDetails.Tables("Details").Rows(0).Item("SvpsID")

Thanks in advance

Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.