|
Dear All
Anybody explain, i have two defrend databse (Foxpro,Sql). i have two table in defrend databse thats are same manner.One table all datas pick one DataSet , now i want simply to insert this Datset to Other Databse Table.
i want Only without Useing Loops. is it Possible...?
Kindly reply Me...
Thanx For advance
|
|
|
|
|
SSIS would have been a good choice here. Although you can also do this using the SqlBulkCopy class in case you are inserting data into the SQL database.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
thanx for Your Valuable Information.
Dear frnd is it Posiible to Accssdatabase table also..?
supose i have one dataset thats insert into AccssDatabase..is it possible...
Kindly reply me
|
|
|
|
|
I guess you would connect to the access table through OleDb which does not provides a BulkCopy class. So, your best bet, IMO, would be to have a stored procedure or a bulk insert SQl statement which will take in the array of values or the datatable itself as a parameter and perform the insert.
Since I have not used Access, I am not sure writing such stored procedure in it is possible or not. But I am sure google will help with that.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
thanx for your valuable information...
if u get any solution pls foraward me...
shamsubava@gmail.com
|
|
|
|
|
Thanks in Advance
I want to change System Short Date Format to "dd-MM-yyyy" , Already Goggled and tried even on CP but all in vain , i tried this code but its not working even
Dim reg As RegistryKey
reg = Registry.Users.OpenSubKey("S-1-5-21-1757981266-861567501-682003330-500\Control Panel\International", True)
If Convert.ToString(reg).Trim = String.Empty Then
MsgBox("Invalid")
Else
reg.SetValue("sShortDate", "dd/MM/yyyy")
reg.SetValue("sLongDate", "dd/MM/yyyy")
End If
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Check this[^] article. Might help.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
its in VB6
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Yes. But all it does is to call some methods in kernel32. You can do the same through .Net as well.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
S0FTDEV wrote: dd-MM-yyyy
Just to make sure that this is just a typo, you are trying to set your date format to dd-MM-yyyy, but your code sets it to dd/MM/yyyy.
| There are only 10 types of people in this world — those who understand binary, and those who don't. |
|
|
|
|
|
"dd-MM-yyyy" is not the problem actually it changes the Registry value to "dd/MM/yyyy" or "dd-MM-yyyy" but in regional settings the date format still remains the same
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
I am learning visual basic, i have asked questions before and got great answers and oping for a little bit of help again if no one is busy 
I am a trainee web designer/developer and have my own website, which i am currently designing. Now i have planned it all out and wish to create a Visual Basic.NET program.
I wish for both the website and the program to have the same logins, both using a MySql database. The website is using a simple script by me for the login at the moment. I didn't want to over complicate it, till i have the Vb program connecting to the database too.
Heres a simple breakdown:
1. Both website and program use same login credentials and same MySql database.
2. Visual Basic program connect remotely to the Mysql database. ( with a shared host )
The program would go about it by basicly starting with a mysql connection then, accessing both username and password tables and checking is Username.TEXT & Password.TEXT match with the database. Once matches, then load up Mainfrm
Sorry for the big message. I have did research on how i would go around doing this. Nothing i can find suggests how i could connect to a remote database on a shared host with (cPanel)
Some of the code im using just now to open the connection, but not sure how to connect to my databse :
Dim connect As New MySqlConnection
Dim sqlcommands As New MySqlCommand
Dim myConnString As String
Dim UserID As Integer
myConnString = "server=" & My.Settings.HostIP & ";" _
My.Settings.HostIP - code i have put in settings file all it contains is my website which doesn't work, of course hehe XD
I have the import mysql client.
Any help would be great thanks. Ofc im not asking someone to do all the work, just asking for some help or ways to improve what i have.
|
|
|
|
|
This tutorial can help you [^]
If you still have errors (after properly initializing the connection string), you should also create mysql user in cPanel and grant connect to the database right.
|
|
|
|
|
Thanks for the reply, the tutorial looks very helpful. Just about to go read it 
|
|
|
|
|
Hi,
what is the easiest way to transfer all the records in the dataset to a database? Is there a bulk method what could handle the whole process.
I have populated dataset that identical to database. How can I transfer all the record into database?
Thanks.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
There's a walk-through from Microsoft Support here[^], with code-examples 
I are Troll 
|
|
|
|
|
Sorry, I have to ask once more as this is killing me.
My version of VS2008 stops executing on exceptions that are encountered in the try part of the try-catch block. Any ideas about what might be causing that? Is there an opion I'm missing?
ty
|
|
|
|
|
Post some code and maybe someone can help you.
| There's nothing left in my right brain and nothing right in my left brain. |
|
|
|
|
|
OK, well for instance, this code throws a NullReferenceException and stops my processing
Dim x
Try
Console.WriteLine(x(0))
Catch ex As Exception
End Try
|
|
|
|
|
Do NOT create empty catch blocks; if you catch an exception, you should act on it, and either report it, or fix the situation, or both.
Which line in the catch block do you want Visual Studio to highlight????????????????????????????????
|
|
|
|
|
I think I am not explaining myself well. What is happening is that VS2008 is stopping execution on the error that is created within the try part of the try-catch block. My understanding (and my prior experience with VS2005) is that the debugger should ignore errors in this part of the block.
ty
|
|
|
|
|
stop being stubborn, add a Console.WriteLine() or some other statement to the catch block, and try again.
|
|
|
|
|
Doesn't matter... same thing.
Dim x
Try
Console.WriteLine(x(0))
Catch ex As Exception
Console.WriteLine("Error")
End Try
|
|
|
|
|
asked and answered here[^].
|
|
|
|
|
cstrader232 wrote: My understanding (and my prior experience with VS2005) is that the debugger should ignore errors in this part of the block.
Your understanding is wrong. When an exception occurs, it is "thrown" upward through the call stack until a catch is encountered or the top of the stack is reached. If you want to have code that runs no matter what you can put it in a Finally block. Or, since this is the VB section, you can use the horrific "On Error Resume Next" construct.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
