Batch Insert Problem with SqlBulkCopy. - C# Discussion Boards

Re: Can we use pointers or similar in C# ?

Otex5-Jun-09 0:15

5-Jun-09 0:15

Actually re-reading it I see I explained it wrongly.
What I need is an evaluations something like below is often used in scripting languages.

string varName;
string myVar;

myVar = "varName";
eval(myVar) = "Whatever";

Now Variable varName contains "Whatever"

Basically I have an array with 2 columns, 1st column has the variable name and the second has the value.

I do not want to have something like
for(x = 0; x < arrayRows; x++;)
{
if(array[x,0] = "myVar1") {myVar1 = array[x,1]}
if(array[x,0] = "myVar2") {myVar2 = array[x,1]}
..
..
}
I would like something like
for(x = 0; x < arrayRows; x++;)
{
eval(array[x,0]) = array[x,1]}
}

Of course eval does not exist in C#

Any ideas or directions ?

Thanks

Re: Can we use pointers or similar in C# ?

0x3c05-Jun-09 0:21

0x3c0

5-Jun-09 0:21

As CG said below, you may want to use a class to store these values, using Reflection (namespace System.Reflection) to get their names and get and set their values dynamically

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Re: Can we use pointers or similar in C# ?

Christian Graus5-Jun-09 0:12

Christian Graus

5-Jun-09 0:12

You need to learn some C# basics. You can do this by creating a class to store your variable. And I'm not sure you can do what you want with pointers in C#, C# pointers are pretty limited.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Outlook 2003 VSTO Addin deployment on Windows Vista - Registry and other issues - How to

Chaitanya Joshi4-Jun-09 23:28

Chaitanya Joshi

4-Jun-09 23:28

Hello everybody,

First of all thanks a lot for all of yours' support on forums, blogs and dev networks with the help of which development becomes very easy and motivating.

I've developed an addin for Outlook 2003 using VSTO SE and VS 2005 (C#). By referring to the articles regarding deployment I was able to manage to create its MSI installer from setup and deployment project in the solution. The addin gets properly installed on other machines having Outlook 2003 and works there fine. All the security policies are granted properly as well. I am using SetSecurity project for granting trust to assemblies. For that I had referred to articles
Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer Part 1 & 2 (http://msdn.microsoft.com/en-us/library/aa537173(office.11).aspx) (http://msdn.microsoft.com/en-us/library/aa537179.aspx)

Now I want to deploy the same addin for Windows Vista. I am aware of the issues faced due to UAC. The major issue is regarding admin access to installer and need of presence of registry keys in HKLM when UAC is turned off. In my installer project I can add those additional registry keys in Registry view. Now my questions are (finally ...)

1. I want to know whether it is possible to use a single installer for Windows XP and Windows Vista. If yes, how can I determine OS version in my Custom Actions or Launch Conditions?
2. If answer to previous question is positive then are there any changes required in method of granting trust to assemblies For Windows Vista? I've already stated that I'm using modified version of SetSecurity project for that.
3. How can determine in Windows Vista whether the UAC has been turned on or off? How can I set a registry launch condition for that so that I can register additional keys in HKLM hive. I'm anyways going to add keys in HKCU for both XP as well as Vista.
4. How can I add those registry keys if I find that it's Windows Vista and UAC is turned off?

I've read articles. They say all about where to change in the registry of Windows Vista, but not how to change it.

* Deploying Application Level Addins (http://msdn.microsoft.com/en-us/library/ms269007(VS.80).aspx)

* Deploying Visual Studio 2005 Tools for the Office System SE Solutions Using Windows Installer (Part 1 of 2) (http://msdn.microsoft.com/en-us/library/bb332051.aspx)
* Deploying Visual Studio 2005 Tools for the Office System SE Solutions Using Windows Installer: Walkthroughs (Part 2 of 2) (http://msdn.microsoft.com/en-us/library/bb332052.aspx)

Thanks a lot once again for your appreciation. Awaiting the reply.

regards,

Chaitanya

Re: Outlook 2003 VSTO Addin deployment on Windows Vista - Registry and other issues - How to

led mike5-Jun-09 4:37

led mike

5-Jun-09 4:37

Chaitanya Joshi wrote:
how can I determine OS version in my Custom Actions or Launch Conditions?

See here[^]

Chaitanya Joshi wrote:
How can I add those registry keys if I find that it's Windows Vista and UAC is turned off?

See here[^] ( Also notice where this page is in MSDN (see the location links at the top ), it's in the Windows Installer Documentation. You may find many answers here, like this one, if you just look )

Re: Outlook 2003 VSTO Addin deployment on Windows Vista - Registry and other issues - How to

Chaitanya Joshi7-Jun-09 23:26

Chaitanya Joshi

7-Jun-09 23:26

Thanks Led...

Very precious links.

But word about MSDN links... I was not investigating what registry keys were to be added but where to add them as in which section of VS Setup & Deployment Project by checking the necessary conditions.

Thanks for help though...

Re: Outlook 2003 VSTO Addin deployment on Windows Vista - Registry and other issues - How to

led mike8-Jun-09 5:37

led mike

8-Jun-09 5:37

Chaitanya Joshi wrote:
which section of VS Setup & Deployment Project

I don't know what that means. Windows Installer has tables, I don't know what "section" means.

Batch Insert Problem with SqlBulkCopy.

hdv2124-Jun-09 22:33

hdv212

4-Jun-09 22:33

Hi i have access db as client db and sql server db as web db. all structures of two database is same except PKs, in sql server PK is uniqueidentifier and in access, PK is Text (with 255 max Length).

in client app i want to send some data from client to web(access to sql) via SqlBulkCopy class, to do this, i use this code to transfer data :

this.personsTableAdapter1.Fill(this.testDataSet1.Persons);

            DataTable dtImported = this.testDataSet1.Persons.Clone();

            // because PK dataType in sql server is uniqueidentifier, hence i convert PK column to guid
            dtImported.Columns["PersonID"].DataType = typeof(Guid);
            foreach (TestDataSet.PersonsRow row in this.testDataSet1.Persons.Rows)
            {                
                Guid g = new Guid(row.PersonID);                
                dtImported.Rows.Add(new object[] { g, row.PersonName }); // Error occur
            }

            System.Data.SqlClient.SqlBulkCopy bc = new System.Data.SqlClient.SqlBulkCopy(Properties.Settings.Default.TestSqlConnectionString);
            bc.DestinationTableName = "Persons";
            bc.WriteToServer(dtImported);

but at runTime the following error show me in above line of code:

Cannot set column 'PersonID'. The value violates the MaxLength limit of this column.

where does my problem and how to solve it ?
Thanks

Re: Batch Insert Problem with SqlBulkCopy.

Manas Bhardwaj4-Jun-09 22:41

Manas Bhardwaj

4-Jun-09 22:41

hdv212 wrote:
The value violates the MaxLength limit of this column

Doesn't the error message explain the reason.
The length of the PersonID you specified in the Access and SQL Server are different. Infact, SQL Server has lesser size thn that of in the Access.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Batch Insert Problem with SqlBulkCopy.

hdv2124-Jun-09 23:45

hdv212

4-Jun-09 23:45

Hi Manas
yes, hence i change max length from 255 to 16 in DataSet Designer(in visual stduio), but the problem was not solved.

Re: Batch Insert Problem with SqlBulkCopy.

Manas Bhardwaj4-Jun-09 23:49

Manas Bhardwaj

4-Jun-09 23:49

hdv212 wrote:
i change max length from 255 to 16 in DataSet Designer(in visual stduio),

you need to change the size in your SQL Server table

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Batch Insert Problem with SqlBulkCopy.

hdv2125-Jun-09 0:41

hdv212

5-Jun-09 0:41

i can not change size in sql server table, because it is uniqueidentifier and it's fix size is 16.

Re: Batch Insert Problem with SqlBulkCopy.

I Believe In GOD5-Jun-09 2:04

I Believe In GOD

5-Jun-09 2:04

Deleted ( sorry I post a stupid answer ) Unsure | :~

I know nothing , I know nothing ...

How to install Microsoft.mshtml.dll in GAC

svt gdwl4-Jun-09 22:28

svt gdwl

4-Jun-09 22:28

This is the error I was getting while installing a in-process dll (BHO) setup which is made in Vs2005 using c#
"could not load file or assembly 'Microsoft.mshtml, version=7.0.3300.0,Culture=neutral,PublicKey=b03f5f7f11d50a3a' or one of its dependencies. The System cannot find the file specified."

For this, I googled and found that Microsoft.mshtml should be installed in GAC or should be available in IE installation folder.
I tried the second one, but still the dll doesnot gets injected?
Anyone can suggest something to solve this?

Re: How to install Microsoft.mshtml.dll in GAC

Christian Graus4-Jun-09 23:05

Christian Graus

4-Jun-09 23:05

Is it even a .NET DLL ?

WMI

arkiboys4-Jun-09 22:21

arkiboys

4-Jun-09 22:21

Hi,
I have create a simple vbscript called vbscriptSample.vbs
When you double click it, you see the message Hello.
This script is saved in the local machine i.e. c:\work\vbscriptSample.vbs
I can call this script using:

System.Diagnostics.Process.Start(@"c:\work\vbscriptsample.vbs");

Question:
I am developing a .net application to trigger this local script but to run it against a network machine i.e. MachineB
So when you run it from my local machine, then the message Hello appears on the MachineB
I believe this is to do with WMI
So, this is what I have. It does not give an error but the message hello does not appear.

try
{
ManagementPath p = new ManagementPath(@"\\MachineB\root\cimv2:Win32_process");
ManagementClass m = new ManagementClass(p);

m.InvokeMethod("Create", new object[] {@"\\MachineB\c$\work\vbscriptsample.vbs"});
}
catch (ManagementException err)
{
MessageBox.Show("An error occurred while trying to execute the WMI method: " + err.Message);
}
catch (UnauthorizedAccessException unauthorizedErr)
{
MessageBox.Show("Connection error (user name or password might be incorrect): " + unauthorizedErr.Message);
}

Any thoughts please?

Thanks

Re: WMI

Pete O'Hanlon4-Jun-09 23:05

Pete O'Hanlon

4-Jun-09 23:05

Have a look at this[^].

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: WMI

arkiboys4-Jun-09 23:49

arkiboys

4-Jun-09 23:49

Yes, I have been looking at this site but not sure how to sort out the settings Frown | :-(

Thanks

Re: WMI

arkiboys5-Jun-09 0:31

arkiboys

5-Jun-09 0:31

I have now been through the suggested settings.
Still get Access Denied.
I can however ping the remote machine but can not use the code.
Here is the code.
Not sure why I get the Access Denied error on th einvoke line.
Any thought please?
Thanks

string stringCommandLine = "notepad.exe";

System.Management.ManagementOperationObserver observer = new System.Management.ManagementOperationObserver();
System.Management.ConnectionOptions conn = new System.Management.ConnectionOptions();

conn.Impersonation = ImpersonationLevel.Impersonate;
conn.EnablePrivileges=true;
conn.Authentication=AuthenticationLevel.Default;

System.Management.ManagementScope ms = new System.Management.ManagementScope("\\\\" + "11.3.432.76" + "\\root\\cimv2", conn);

ms.Connect();

System.Management.ManagementPath path = new System.Management.ManagementPath("Win32_Process");

System.Management.ManagementClass processClass = new System.Management.ManagementClass(ms, path, null);

object[] methodArgs = { stringCommandLine, null, null, 0 };

processClass.InvokeMethod(observer, "Create", methodArgs);

User Control

User 62554644-Jun-09 21:14

User 6255464

4-Jun-09 21:14

Can a form be minimized and maximized by a user control like Button or something else?

modified 6-Jun-21 21:01pm.

Re: User Control

Christian Graus4-Jun-09 21:37

Christian Graus

4-Jun-09 21:37

Of course it can. It can ask for it's parent form, or it can fire a delegate and the main form can consume it and do the work.

Re: User Control

User 62554645-Jun-09 19:35

User 6255464

5-Jun-09 19:35

I am still not able to understand if you can send me some code-bytes to add help.

modified 6-Jun-21 21:01pm.

non selectable cells/columns in datagridview

Otex4-Jun-09 21:01

Otex

4-Jun-09 21:01

I have a datagridview with 3 columns and I would like to have the cells in 2 first columns to not be selectable in the form but the cells in the 3rd column should be selectable.

Any help welcome.

Thanks

Re: non selectable cells/columns in datagridview

dan!sh 4-Jun-09 23:12

dan!sh

4-Jun-09 23:12

In the CellStateChanged event, check for the column index of the cell and if it 0 or 1 set Selected property to false.

जय हिंद

dataGrid SelectedIndexChanged Method not available in Compact Framework

Paulo Mitchell4-Jun-09 20:27

Paulo Mitchell

4-Jun-09 20:27

I have an application running on a PDA that currently uses the OnClick Event of a DataGrid to perfortm some functionality. I would like to have the same functionality run when the current row of my DataGrid is highlighted (by the user scrolling ro it instead of clicking on it). The method to use would seem to be OnSelectedIndexChanged but this does not seem to be available in the Compact Framework (3.5). I The OnGotFocus doesn't seem to be suitable either (I guesss that this is because it applies to the DataGrid itself and not the row). Can anyone suggest how I can get this to work. Note that I only want the event to fire when the user moves to the row and not when the grid is populated.

Thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.