Re: how to solve this Error...in insert query - C# Discussion Boards

Mohammad Soleimani2-Jul-14 6:22

2-Jul-14 6:22

I tried very hard, but I did not succeed,can you fix my code for Join two Data Table with database tables. Thanks

-- modified 2-Jul-14 13:12pm.

System.AccessViolationException When Using Win32 DLL

Django_Untaken1-Jul-14 0:36

Django_Untaken

1-Jul-14 0:36

Hello. I have developed a simple win32 dll. When I try to use this dll in C#, I get the said exception. Then function that is causing the problem is shown below in both managed and unmanaged form

//       Win32 DLL Definition

BOOL CMyFileHandler::SetFileName(LPCWSTR sFilePath)
{
  // code here
}

//        CSharp Code

[DllImport("Path of MyDll.dll", EntryPoint = "decorated name of GetFileName()")]
public static bool SetFileName(string sFilePath);

So what could I be doing wrong here? Thansks for an input.

Re: System.AccessViolationException When Using Win32 DLL

OriginalGriff1-Jul-14 2:40

OriginalGriff

1-Jul-14 2:40

Could be "decorated name of GetFileName()" - shouldn't that be SetFileName?

Otherwise, you will be trying to write to a C# string, which is not allowed.

Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

Re: System.AccessViolationException When Using Win32 DLL

Django_Untaken1-Jul-14 8:49

Django_Untaken

1-Jul-14 8:49

OriginalGriff wrote:
shouldn't that be SetFileName?

oops. A typo there. It is actually decorated name of SetFileName(). Well I was reading somewhere that dll has decorated function names when we compile them. We can find these names using Dumpbin.

Re: System.AccessViolationException When Using Win32 DLL

Bernhard Hiller1-Jul-14 20:38

Bernhard Hiller

1-Jul-14 20:38

From Windows Vista onwards, a non-administrative user must not write into C:\Program Files or C:\Windows folders; and even an admin needs to run the program in elevated mode when he wants to do so.
Write your files into a folder which is appropriate, e.g. %temp%.

Re: System.AccessViolationException When Using Win32 DLL

Django_Untaken1-Jul-14 21:36

Django_Untaken

1-Jul-14 21:36

Bernhard Hiller wrote:
a non-administrative user must not write into C:\Program Files or .....

Yes. I am writing my out dll files in a subdirectory of my project, which is placed on desktop. I hope that is fine.

how to solve this Error...in insert query

Nishant.Chauhan8030-Jun-14 21:50

Nishant.Chauhan80

30-Jun-14 21:50

ERROR:-No mapping exists from object type System.Data.DataRowView to a known managed provider native type.

code following :-

con.Open();
SqlCommand cmd = new SqlCommand("addprd1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", label10.Text);
cmd.Parameters.AddWithValue("@srno", textBox1.Text);
cmd.Parameters.AddWithValue("@itm", comboBox1.SelectedItem);
cmd.Parameters.AddWithValue("@make", comboBox2.SelectedItem);
cmd.Parameters.AddWithValue("@dop", dateTimePicker1.Text);
cmd.Parameters.AddWithValue("@year", comboBox3.SelectedItem);
cmd.Parameters.AddWithValue("@mno", textBox6.Text);
cmd.Parameters.AddWithValue("@srm", textBox7.Text);
cmd.Parameters.AddWithValue("@off", textBox9.Text);
cmd.Parameters.AddWithValue("@usr", textBox8.Text);
cmd.ExecuteNonQuery();
con.Close();
label10.Visible = true;
MessageBox.Show("Insert Successfully");
Bind();
label10.Visible = false;
Clear();

Re: how to solve this Error...in insert query

Rob Philpott30-Jun-14 22:40

Rob Philpott

30-Jun-14 22:40

ComboBox.SelectedItem returns you an object. Without guidance, ADO has no idea what to do with one of these. You could stick .ToString() on the end of the SelectItem maybe.

The code makes me feel uneasy, there's no validation anywhere and no domain object to represent a table row - I hope this is a quick and dirty application!

Regards,
Rob Philpott.

Re: how to solve this Error...in insert query

AjayJamwal2-Jul-14 3:20

AjayJamwal

2-Jul-14 3:20

Dear Member,

As per your code analysis , it is clear that you are using three comboboxes & one datetime picker control.

Since combobox control also returns object type instance, you have to mentioned here:

cmd.Parameters.AddWithValue("@itm", comboBox1.SelectedItem.Text); // if <a href="/Members/item">@item</a> is varchar.
cmd.Parameters.AddWithValue("@make", comboBox2.SelectedItem.Text); // if <a href="/Members/make">@make</a> is varchar
cmd.Parameters.AddWithValue("@dop", dateTimePicker1.SelectedDate); // if you are using RadDateTimePicker
cmd.Parameters.AddWithValue("@year", comboBox3.SelectedItem.Text); // if <a href="/Members/Year">@year</a> is varchar

Hope it help.

Thanks

Executing few lines of code on Windows Store app installation

Sharath C V30-Jun-14 21:14

Sharath C V

30-Jun-14 21:14

Is it possible to execute few lines of code on installing a windows Store App? The lines of code that needs to be executed will be part of the store app itself.

So far, I am unable to find any information on this, but if any one has any info on this, please let me know. As of now I am trying to evaluate the feasibility.

Re: Executing few lines of code on Windows Store app installation

Pete O'Hanlon30-Jun-14 23:19

Pete O'Hanlon

30-Jun-14 23:19

The installation process is locked down to prevent tampering. Apps installed from the App Store are heavily federated so you aren't allowed to mess about with the installation. If you need to do something as a one off, do it when your application first starts up and mark that the task has been done.

Re: Executing few lines of code on Windows Store app installation

Sharath C V1-Jul-14 0:34

Sharath C V

1-Jul-14 0:34

Thanks Pete for your valuable input on this...

Re: Executing few lines of code on Windows Store app installation

Pete O'Hanlon1-Jul-14 1:31

Pete O'Hanlon

1-Jul-14 1:31

You're welcome.

MSI installer, deployment

ankum1630-Jun-14 18:17

ankum16

30-Jun-14 18:17

Hi all,

I have created a MSI installer file which installs a desktop application. This setup contains many dlls which will be deployed to user's machine. Whenever I made changes to any one of the dll, I am again creating MSI installer and running the installation/setup. Or copying of dll also works. But my requirement is to publish these modified dlls and then this installed version of software takes the updated dll by itself. I do not want to do this activity again and again on user's machine to deploy the dll. Please suggest possible ways. All users are in LAN only.

Regards.

Re: MSI installer, deployment

Bernhard Hiller30-Jun-14 20:24

Bernhard Hiller

30-Jun-14 20:24

Create an updater application (as a Windows Service). It will be started automatically, looks into a folder somewhere on the network (make it configurable, e.g. a key-value-pair in its .exe.config file), compares the files there with local files, and replaces/adds them if necessary. Because Windows services use to run "elevated" with an administrative account, they can write into C:\Program Files and replace the files there.

Alternatively, your new setup packages can be installed automatically by Group Policies.

How to add ScrollViewer to usercontrol in MVVM by josh smith.

vijendra malik30-Jun-14 16:45

vijendra malik

30-Jun-14 16:45

I am building an application based on MVVM approach shown in an article by josh smith. One of my user control has many controls (3 data grids and other controls) due to which its size has gone past the size of normal window. I tried adding a scrollviewer to the user control so that the user can scroll to see the hidden controls but the scrollviewer is not working. it is shown as disabled and during runtime the usercontrol only shows the controls visible in normal window size. The other controls are truncated. Can anyone please let me know how to add scrollviewer to workaspaces so that it can work effectively.
I am loading the workspaces suggested by Josh Smith in his article.

Re: How to add ScrollViewer to usercontrol in MVVM by josh smith.

Kornfeld Eliyahu Peter30-Jun-14 19:18

Kornfeld Eliyahu Peter

30-Jun-14 19:18

Whenever you have problem with sample from an article, the best approach is to ask the author...
Scroll down to the end of the article and there is a place to comment/ask...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

between two Datetimepicker using

Nishant.Chauhan8029-Jun-14 19:30

Nishant.Chauhan80

29-Jun-14 19:30

how to search data from database between two dates using datetimepicker control in window form application asp.net C#

Re: between two Datetimepicker using

Eddy Vluggen29-Jun-14 22:28

Eddy Vluggen

29-Jun-14 22:28

By executing a query, like SELECT [...] FROM [..] WHERE [..] BETWEEN @DatePicker1.Value AND @DatePicker1.Value).

That is assuming you know how to execute a query using C# and what SQL is. Documentation on the BETWEEN keyword can be found here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: between two Datetimepicker using

OriginalGriff29-Jun-14 22:59

OriginalGriff

29-Jun-14 22:59

Try:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM myTable WHERE MyDateColumn BETWEEN @ST AND @END", con))
        {
        cmd.Parameters.AddWithValue("@ST", dtpStart.Value);
        cmd.Parameters.AddWithValue("@EN", dtpEnd.Value);
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["iD"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", iD, desc);
                }
            }
        }
    }