|
I have a populated data set (loaded from an XML file) that I want to put in a SQL database.
Most of the tables in the DataSet are related, so I can't use a DataAdapter to update because I don't know the update order.
All the examples I've seen about updating an SQL database only target one table or know the 'reverse-order' in which to update.
Is there an easy way to store a .NET multi-table DataSet to a SQL database.
|
|
|
|
|
hi all !!im new to vb.net..
actually i did a module in my project and executed ,it worked properly then i closed the application ...again i opened & did some modification to my project module its accepting nicely but while executing its showing the previous one results ...moreover i changed the startup form its not accepting ..
i changed from form1 to form3 like this
(project->properties->application ->startupform->form3)
VERY FUNNY im not able understand the problem
plzzzzzzzzzzzzzz help me out!!!
swathiiiiiii
|
|
|
|
|
go to Project -> solution explorer --> Right Click on form3.aspx and set startupform
Cheer
Pavan Pareta
|
|
|
|
|
hey its nuthing but wat i did !!!
project->properties->application ->startupform->form3)
Project -> solution explorer --> Right Click on form3.aspx and set startupform
both r same!!!
|
|
|
|
|
LET ME KNOW WHAT IS THE TYPE OF YOUR APPLICATION ???
A) DESK TOP Application or
B) Web Application
Pavan Pareta
|
|
|
|
|
its window based application..my module is DataEntryModule where operator can upload n' retrieve the data..This includes login page,admin page, operator page,.....(here authentication is thru database)
thanq in advance
|
|
|
|
|
if your Application is window based then how do you set your page like Form.aspx in window based Application you have to set in the project property..
Give me fully details of your project !!!
Pavan Pareta
|
|
|
|
|
hey im not at all related to asp.net...only vb.net thats it.. asp.net n' vb.net differs in setting start up form
project->properties->application ->startupform->form3 this is how v set the startup form in vb.net
|
|
|
|
|
if (Project in VB.net)
+ Solution Explorer
+ VBProject(Right Click on it) then --> Go Property option & click then open a dialog box now you will go Startup Object from this comboBox.
Pavan Pareta
|
|
|
|
|
thanq pavan i tried that one already..
|
|
|
|
|
swathiiiiiiiiii wrote: asp.net n' vb.net differs in setting start up form
VB.NET and ASP.NET are two incomparible things.
ASP.NET is a framework that targets the CLR.
VB.NET is a language. You can write Windows Forms applications in it. You can write Windows Mobile Applications in it. You can write ASP.NET applications in it.
|
|
|
|
|
This is set in the Program class, in the Main method (at least it is in C# - and I don't expect VB.NET will be that much different).
|
|
|
|
|
hii colin wat shud i do now plz tell me!!!
|
|
|
|
|
For a start, don't talk txt spk. It's very irritating and wastes time.
Look through your project for a method called Main. This will have something in it that says something like this:
Application.Run(new Form1());
While this is the C# version, I'm sure that the VB.NET version will be similar.
Here you need to change the name of the form to the one you want, so if it was Form3 this would read
Application.Run(new Form3());
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
my code
<br />
<br />
#using <System.dll><br />
<br />
using namespace System;<br />
using namespace System::Net;<br />
using namespace System::Net::NetworkInformation;<br />
void AddressChangedCallback( Object^ , EventArgs^ )<br />
{<br />
array<NetworkInterface^>^adapters = NetworkInterface::GetAllNetworkInterfaces();<br />
System::Collections::IEnumerator^ myEnum = adapters->GetEnumerator();<br />
while ( myEnum->MoveNext() )<br />
{<br />
NetworkInterface^ n = safe_cast<NetworkInterface^>(myEnum->Current);<br />
Console::WriteLine( " {0} is {1}", n->Name, n->OperationalStatus );<br />
}<br />
}<br />
<br />
<br />
<br />
ThreadFunction()<br />
{<br />
NetworkChange::NetworkAddressChanged += gcnew NetworkAddressChangedEventHandler( AddressChangedCallback );<br />
Console::WriteLine( "Listening for address changes. Press any key to exit." );<br />
Console::ReadLine();<br />
}<br />
In another thread function I want to cancel the NetworkAddressChangedEventHandler delegate.
How to do?
thanks.
|
|
|
|
|
In C# you add a delegate with someEvent+=new SomeEventHandler(...)
and you remove it with someEvent-=new SomeEventHandler(...)
Yes, it's magic, you create a new object to throw away an old one !
I guess it's the same in all CLR languages...
Luc Pattyn
|
|
|
|
|
|
I'm receiving reports from my users that my application is handling dates incorrectly. I've confirmed that this is indeed happening for users outside of my network, but doesn't seem to be occurring with users on my local network.
My application is a .NET 2.0 distributed app using .NET 2.0 web services for data access. It seems that any time I return a date from the web service, the application is for some reason subtracting 1 day from that date.
For example, if I return information on a Customer, the web service response will give me a date such as:
<pickupdate>2007-02-06T00:00:00-05:00
However, the program is displaying this as 2/5/2007. I'm not doing any sort of manipulation with the date. The web service returns a dataset, and I simply iterate the datatable's row collection and convert that column to a datetime using the following:
<br />
static public DateTime GetDateTime(DataRow DataSource, string ColumnName)<br />
{<br />
if (DataSource[ColumnName] == DBNull.Value)<br />
{<br />
return DateTime.MinValue;<br />
}<br />
else<br />
{<br />
return (DateTime)DataSource[ColumnName];<br />
}<br />
<br />
}
I've confirmed that the date is right when returned from the web service. I'm at a loss as to why it's being changed when running through this GetDateTime() method. I'd be grateful for any help.
|
|
|
|
|
Hi,
kryzchek wrote: 2007-02-06T00:00:00-05:00
However, the program is displaying this as 2/5/2007. I'm not doing any sort of manipulation with the date.
You aren't doing any manipulation, but the framework may do. Have you checked the full DateTime object and not only the date part of it?
return (DateTime)DataSource[ColumnName];
In this line you cast an object to a DateTime . Assuming that your onject is a string, DateTime.Parse will be invoked to do the conversion. If you do not pass any additional parameters, the local CultureInfo and time zone setting will influence the result.
E.g. for me (in Germany) the result of System.DateTime.Parse( "2007-02-06T00:00:00-05:00" ) is 2007-02-06T06:00.
I recommend that you directly call DateTime.Parse and pass the appropriate CultureInfo to the method. Eventually you should use the CultureInfo in your output methods, too.
Regards,
Tim
|
|
|
|
|
Thanks for the suggestions, Tim. I discovered the "problem" not long after posting my first message. I was unaware that the web service was adding a time zone offset. I've since reconfigured the web service to return DataSets without the time zone offset.
Thanks again for your help!
|
|
|
|
|
This sounds like one for the Subtle Bugs forum. It's a classic subtle bug.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Explain what it means to “pre-jit” an assembly and how you would do it?
Ramana
|
|
|
|
|
I think the following reference might help. Clickety[^]
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
How many generations does the Garbage Collector have and what are they?
Vasini
|
|
|
|
|
Does Google not work where you live? http://www.codeproject.com/dotnet/gcbyleslie.asp[^]
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|