473,856 Members | 1,546 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

retrieving sql:datatype in xsd

hi all,

I need to read the xml schema file and retrieve the sql:datatype
element value in the xsd file.
The schema file format is below
<xsd:sequence >
<xsd:element name="safe_job" type = "xsd:string "
sql:datatype="v archar(255)" />
</xsd:sequence>

Can anyone give me a sample code to retrieve the value varchar(255)
from sql:datatype and store it in a string using vb.net. Any help would
be appreciated.
Thanks in advance

Apr 12 '06 #1
0 1449

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1350
by: himani | last post by:
hello, i m having a problem with the sql database.it does not accept 0(zero)as the first number in the integer field.whenever i insert 01 it takes it as 1.similarly for 02 and so on till 09.i want 01. can anyone suggest how to get.i m doing this on sql server.does sql server support?is this the problem of sql server?
4
10477
by: Dabbler | last post by:
Not sure what SQL datatype should be used with radiobuttons since MS SQL doesn't support a boolean datatype. I would like to bind radiobuttons to an SqlDataSource. Thanks for any suggestions on this.
0
338
by: Priya | last post by:
hi all, I need to read the xml schema file and retrieve the sql:datatype element value in the xsd file. The schema file format is below <xsd:sequence> <xsd:element name="safe_job" type = "xsd:string" sql:datatype="varchar(255)" /> </xsd:sequence>
2
1270
by: Alejandro Kwiatkowski | last post by:
How I can do to store and retrieve files to/from a fields in a SQL Server table using .NET 2.0 Thanks you in advance Alejandro
1
1337
by: Baal80 | last post by:
Hi, I have the following problem: I want to retrieve SQL data type of every column from database (means I want to retrieve bigint, varchar(20) etc. instead of System.Int32, System.String etc). I've written the following code: string datatype = new string ; int i=0; foreach (DataColumn column in myDataTable.Columns)
1
7472
by: Chris | last post by:
Hi, I'm using the following code DataTable tables = ((OleDbConnection)oleconn).GetOleDbSchemaTable( OleDbSchemaGuid.Tables, new object { null, null, null, "TABLE" }); foreach (DataRow r in tables.Rows) { string tableName = r as string; //
2
1389
by: huntco | last post by:
Need to grab an image off the disk, preview in a picturebox, then save in SQL database for later viewing, etc. Got the "grab/preview" part working fine, and *something* is being stored in the SQL database, but when I go to retrieve the image and place it in the picture box, the picture is blank. SQL datatype is image, and the tableadapter has an update query that accepts the image field and primary key. Image field is sent as a byte...
1
1830
by: mcolson | last post by:
I tables in Sql, which I am linking to in Access. I have a couple of fields which are using the data type "text". Why are these appearing as the data type "Memo" in Access.
2
1292
by: Darshini | last post by:
Hi im using SQL2000 in my query should contain column name date so i mention the datatype as datetime what's my doubt mean is any possible without displaying the time?Then is any possible to change the datatype range for int etc...other than nvarchar what's the datatype we will mention for phone no column.Advance thanks...
1
10795
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10390
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9536
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7934
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7098
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5962
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4581
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4177
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3203
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.