|
Hi,
If I have a dataset with a couple tables, is it possible to take one of these tables and copy it over to another dataset? I just want one table in my dataset.
Regards
ma se
|
|
|
|
|
use clone - copy the structure
you can either copy the rows manually or use writexml/readxml to transfer the rows.
|
|
|
|
|
Hi,
My XML format looks like this:
<?xml version="1.0" encoding="utf-8"?>
<Products>
<Product>
<ID>5555</ID>
<ProductName>My Product</ProductName>
<Price>50</Price>
</Product>
</Products>
I need to know how to get this into a dataset, then I will have more control of the data. I know there is a function that saves the XML into a datast, but how does it know that I want the fields in the <Product></Product> hierarchy?
Or how should this be done?? I just want the <ID>, <ProductName> and <Price> to be the column names, and the values in tags the values of the fields in the row.
Regards
Brendan
|
|
|
|
|
It looks like you have the right structure to just to a ds.ReadXml("c:\temp\filename.xml")
So <Products> would be your dataset
You table would be <Product>
so multiple rows would look like:
<Products>
<Product>
<ID>5555</ID>
<ProductName>My Product</ProductName>
<Price>50</Price>
</Product>
<Product>
<ID>6666</ID>
<ProductName>My Product2</ProductName>
<Price>60</Price>
</Product>
</Products>
So I don't think you will have to do much to get this working.
Ben
|
|
|
|
|
How can i backup the database from SQL server 2000 from my application using vb2005
plz this us urgent
thanks
|
|
|
|
|
Execute the BACKUP DATABASE Statement from the FrontEnd
The name is Sandeep
|
|
|
|
|
Just to expand, the syntax is
BACKUP DATABASE myDatabase
TO DISK = 'c:\backup\myDatabase.bak'
|
|
|
|
|
thanks for u reply but i don't get it
would u plz give me example ??
|
|
|
|
|
Didn't you see the Syntax above? Just try with it and see.
The name is Sandeep
|
|
|
|
|
i saw it
but here what i typed
If cn.State = ConnectionState.Closed Then<br />
cn.ConnectionString = "provider=SQLOLEDB;server=maged;database=ceasr;user id=sa;pwd=magedhv"<br />
cn.Open()<br />
cmd.Connection = cn<br />
cmd.CommandType = CommandType.Text<br />
cmd.CommandText = "BACKUP DATABASE ceasr to disk = d:\backup\myDatabase.bak"<br />
End If
but it didn't worked
|
|
|
|
|
See this posting I made previously [^]
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
i want to override a button property?is it possible? how can i delete a existing property from a button
|
|
|
|
|
dear anujose,
you can add the code like this
btn.attributes.add("OnMouseOver",someCode())
All The Best
Sathesh Pandian
|
|
|
|
|
i want to override a button property in winform not an event
|
|
|
|
|
Would you not have to inherit the button control into your own class and expand on it from there?
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
You'd have to create your own Button class and override the property. To make the Text property disappear and have the Text on the button be forced to something:
Imports System.ComponentModel
Public Class MyButton
Inherits System.Windows.Forms.Button
<Browsable(False)> _
Public Overrides Property Text() As String
Get
Return "This is my custom button!"
End Get
Set(ByVal value As String)
' Just don't do anything with this
End Set
End Property
End Class
|
|
|
|
|
i want to make a size property with a + .when i click in + i want to open height and width property.how can i do this?...........
|
|
|
|
|
You need a new Class called size with properties for X and Y etc.
Then on your control create a property to type Size
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
In addition to what Steve said, if you want to learn a bit about custom property editors, take a look at this[^] article.
|
|
|
|
|
i would like to make form contain textbox
required:
i would like the user after typing spacefic word in this textbox and PRESS ENTER THEN FORM2.show
in vb6
i can do this
if keyascii = 13 then
form2.show
end if
how can i do this in vb2005
that's urgent plz
thanks
|
|
|
|
|
If (e.KeyCode = Keys.Enter) Then
End If
|
|
|
|
|
hi,
suppose textbox name is txtfocus then use following code
Private Sub txtFocus_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtFocus.KeyPress<br />
If e.KeyChar = Chr(Keys.Enter) Then 'or if e.keychar=chr(13)<br />
form2.show<br />
End If<br />
End Sub
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
thanks so much it works well
it was helpful
|
|
|
|
|
Why not uses the Leave event of the TextBox control.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Hi everyone,
I am having problems with the crystal report viewer. It cant load any report saying 'load report failed'. I have never used the control before. I am using vs2005 pro, could it be a bug in the software? Please help.
|
|
|
|