|
I am trying to figure out how to perform a bulk insert from C#.
Can anyone help me?
Darryl Borden
Principal IT Analyst
darryl.borden@elpaso.com
|
|
|
|
|
Darryl Borden wrote:
I am trying to figure out how to perform a bulk insert from C#.
Not sure of the exact criterion you have, however BCP works extrememly well when dealing with really large datasets. We used it with SQL Server 2000 often.
Nick Parker
The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt
|
|
|
|
|
I am trying to compile a project using the command line compile and I am running into a problem. I have two forms (Form1.cs and Form2.cs) Form2 includes an IE WebBrowser (AxSHDocVw.AxWebBrowser). The program compiles and runs fine when compile within VS.Net; however, when I use csc.exe I compiles, but when I try to run the form with WebBrowser embedded in it, I receive
“Could not find any resources appropriate for the specified culture (or the neutral culture) in the given assembly. Make sure “Form2.resources” was correctly embedded or linked into assembly “xxx”"
I used the following lines to compile:
> <code>resgen Form1.resx</code>
> <code>resgen Form2.resx</code>
> <code>csc /t:winexe /out:xxx.exe
/r:Interop.SHDocVw.dll
/r:AxInterop.SHDocVw.dll
/r:Microsoft.mshtml.dll
/resource:Form1.resources
/resource:Form2.resources
Form1.cs Form2.cs AssemblyInfo.cs</code>
Any suggestions are welcome.
Patrick Hill
Myers Internet, Inc.
|
|
|
|
|
Try the /compile option on resgen, (resgen /compile Form1.resx).
Also, when VS.NET compiles the resx it gets named [DefaultNamespace].[Form].resources. So the /resource option to csc might need to be changed to /resource:Form1.resources,[DefaultNamespace].Form1.resources.
Good luck,
James
"It is self repeating, of unknown pattern"
Data - Star Trek: The Next Generation
|
|
|
|
|
Thanks James!
The key is specifying the fully qualified Namespace for the csc.exe
namespace Foobar
{
public class Form2 : System.Windows.Forms.Form
{
...
csc.exe ... /resource:Form2.resources,Foobar.Form2.resources ...
Patrick Hill
|
|
|
|
|
Help-
I'm developing a calendar application for users to schedule events and i was wondering if anyone here knew how we could develop a program for the users to email the system administrator directly from the website
Thanks a ton.
|
|
|
|
|
After reading several articles i've managed to get a web control in my windows forms app. The problem is that it still has the default Internet Explorer right-click menu.
How do I disable it?? My plans for world domination depend on this!
"Where would you rather be today?"
|
|
|
|
|
You could handle this in the event handler function or disable right-click event
R.Bischoff | C++
.NET, Kommst du mit?
|
|
|
|
|
Jonny Newman wrote:
After reading several articles i've managed to get a web control in my windows forms app. The problem is that it still has the default Internet Explorer right-click menu.
Implement IDocHostUIHandler interface:
http://www.codeproject.com/csharp/advhost.asp [^]
Using the ShowContextMenu method you can show your custom context menu, or leave it clean to get ride of IE's default context menu.
Jonny Newman wrote:
How do I disable it?? My plans for world domination depend on this!
Now you can disable it... and dominate the world 
Cya
|
|
|
|
|
Hello,
Can anyone please tell me how I can display the columns in my own way?
In my program, I linked the C# program with the database (.mdb) and
used a DataGrid to display the data. However, I realized that the column
headings are in alphabetical order from left to right, which is not what I want.
How can I change the setting? Thank you and appreciate any help!
|
|
|
|
|
You could use the OleDbDataAdabpter's DataTableMapping object.
R.Bischoff | C++
.NET, Kommst du mit?
|
|
|
|
|
Hi folks,
whats the easiest way to launch an executable from my prog and activate it's main window (put the focus on it)?
Thanks a lot!
Matthias
You'll never master any language, except maybe VB, because there's nothing to it. (Lounge/Christian Graus)
www.mattbart.org
Sonork ID: 100.32002
|
|
|
|
|
Well, somebody should have a look at the Process class in the System.Diagnostics Namespace.
Sorry for the spam 
Matthias
You'll never master any language, except maybe VB, because there's nothing to it. (Lounge/Christian Graus)
www.mattbart.org
Sonork ID: 100.32002
|
|
|
|
|
System.Diagnostics.Process proc = new Process();<br />
proc.StartInfo.FileName = executablePath;<br />
proc.Start();
Mark Sanders
sanderssolutions.com
|
|
|
|
|
i'm working on C# and asp.net.i have a link button and when i click on it i want to navigate to the give page.but it is not working.can anybody give a solution to this problem .
i have another problem.is it possible to explicitely convert system.io.directory to system.io.directoryinfo.
how to convert void to string type explicitely?
|
|
|
|
|
Greetings ....
I have a DLL I wish to call from an application C# Windows app and it works fine. Calling the DLL from a console application also works fine.
However, when I try calling the console application from a web service it won't work. I'm sure this is a security issue. Can someone help ?
THKS in advance ..
|
|
|
|
|
I would assume the ASPNET user id doesn't have permission to execute your console program.
Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows
|
|
|
|
|
You will need to give execute rights to ASP_NET user for the exe file.
Who is this miscrosoft, and what devilish plans have they for us?
|
|
|
|
|
Hi Leppie,
First of all thks for the reply. What I did try ( I know this is not a good thing to do ) is make the asp.net user account an administrator. That didn't work.
How do you give execute rights to the asp_net user ? Is this the same thing I did. If so it doesn't work.
From my Web Service I can call OTHER console programs just fine. Its just this one that I can't call. Also, I can only seem to run it from an application or in the console. Is there any way I can impersonate or somehow make the console program think that its being run from the desktop ? Is this possible in Web.config or some other way ?
I've been stuck on this problem for 2 days now .. I can't seem to get it running ..
Do you have any ideas ?
|
|
|
|
|
What is the expression to split the following string on the comma with the exception of within quotes?
BT2921893081,071200000006,"Duck, Donald",539485988
Result:
BT2921893081
071200000006
WENTHOLD, HEATHER
539485988
Thanks!
ed
Regulation is the substitution of error for chance.
|
|
|
|
|
Hi,
use the System.Text.RegularExpression-Namespace
string reg = "^(<group1>.*?),(<group2>.*?),\"(<group3>.*?)\",(<group4>.*?)";
Match m = Regex.Match("BT2921893081,071200000006,\"Duck, Donald\",539485988", reg);
U can now find all matches in "m". i.e. m.Groups["group1"]
Hope it works, i have not tested any piece of the code snipped.
Greating, Jan
|
|
|
|
|
Thanks but I think I need to provide a little more detail. I have several files that will have information in different groupings. But they are all comma delimited with quoted strings in one or more positions. So the expression should split on comma's but not those within quotes.
I just bought a regex book last week but left it at home! Great timing!! 
Thanks again!
ed
Regulation is the substitution of error for chance.
|
|
|
|
|
The simple answer to this question is to use a delimiter you know won't be used within quoted strings when you generate your file in the first place. If that won't work then make sure that all of your fields are surrounded by quotes and use "," as your delimiter. Beyond that, what you want is possible, but it doesn't have a simple solution. You could go through and extract each quoted field first removing the field as you go, and then capture what's left. Or, you could create a regular expression and use it as a template. It seems to me that the data for each row should be the same basic pattern with each, but you corrent me if I'm wrong. For instance, if your record looks like this:
BT2921893081,071200000006,"Duck, Donald",539485988
Then your next record probably has the same patter but with different values such as:
BT2677793081,071200444006,"Mouse, Mickey",539488888
In that case a regular expresion like this:
/([^,]+),([^,]+),\"([^\"]+)\",(.+)/
shoudl work. I'm not sure how well you know regex. I am most familiar with a perl regex, but I think that perl regexes is what C#'s were based on. Once you run your string through this expression, you should have the items in your capture variables 1-4. Does that makes sense?
Hope this helps. Good luck.
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
Ok!
So Im into a c# programs that involes multiple forms.
Ya know guys, in VB, we'd just do this
Unload form1
form2.show
And that was it..  p
Well that ain'T working so telle me, how do we switch from
one form to another in C#, like in the example above!!!???
Thanks,
Orlanda
|
|
|
|
|
Well, you have to be a little more specific on what you're trying to do. Do you want to show a 2nd Form from the Form currently displayed? If you have a Windows Forms application then you gotta be carefull, because you will have the Applications MessageLoop attached to (most probably) your main Application Form. You can put the MessageLoop onto a different Form using the ApplicationContext class and its MainWindow (I think) Property.
If you provide us with a little more info we might be able to help better.
Matthias
You'll never master any language, except maybe VB, because there's nothing to it. (Lounge/Christian Graus)
www.mattbart.org
Sonork ID: 100.32002
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
