Re: Database :( - C# Discussion Boards

amx_tiger1-May-12 4:07

1-May-12 4:07

Hi. How I can move an application with database? ... If I move the application to another pc , it can't open the database Hmmm | :|

The database is Sql Server Compact (.mdf). I tried with Sqlite, but it gave me some error Frown | :(

at ConnectionString: Picture with Add Connection Error... or when I debug the application: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.
When I add at the form.config this:

<startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0"/>
  </startup>

It give me this error: Error...

Sql:
At SqlConnection I tried to declare:

SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename="+ System.IO.Directory.GetCurrentDirectory()+"\\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;");

and

SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\\Users\\ccs\\documents\\visual studio 2010\\Projects\\Database Software Pack\\Database Software Pack\\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;");

Any ideas? I know I am stressful, but I need help.

I am sorry for my bad english Frown | :(

Thank you in advance.

modified 1-May-12 10:38am.

Re: Database :(

Dave Kreskowiak1-May-12 4:22

Dave Kreskowiak

1-May-12 4:22

and the exception message would be ..... ?

That picture doesn't tell us anything at all.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Database :(

Not Active1-May-12 4:51

Not Active

1-May-12 4:51

Dave Kreskowiak wrote:
That picture doesn't tell us anything at all.

But its worth a thousand words.

Failure is not an option; it's the default selection.

Re: Database :(

amx_tiger1-May-12 4:53

amx_tiger

1-May-12 4:53

Thank you for your response David Smile | :)

Anyway,I rezolve the problem with SQLite removing this

<configSections>
</configSections>

from form.config (app.config) Big Grin | :-D

But now, if I started this topic with this question, I want to know how I can make that my application (with database) become movable into another pc and the database can be opened by my application ? Smile | :)

Re: Database :(

Dave Kreskowiak1-May-12 7:37

Dave Kreskowiak

1-May-12 7:37

You'd have to install the appropriate database engine on the target machine and copy over your application, and then register any libraries, blah, blah, blah...

The easier method is to make an installer for it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Database :(

Eddy Vluggen1-May-12 5:00

Eddy Vluggen

1-May-12 5:00

amx_tiger wrote:
The database is Sql Server Compact (.mdf).

Sql Server Compact/CE uses the .sdf file extension. Your database is not a Sql Compact database. Sqlite is also a very different database-format from Sql Server.

Show us the original ConnectionString; I bet it points to an Sql Express version. You'd only need to change the servers' location, perhaps the login-information.

Bastard Programmer from Hell Suspicious | :suss:

Re: Database :(

amx_tiger1-May-12 5:04

amx_tiger

1-May-12 5:04

The original ConnectionString is :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

Thank you

Re: Database :(

Eddy Vluggen1-May-12 8:41

Eddy Vluggen

1-May-12 8:41

That means you're using Sql Express, not Compact or Sqlite. Is there a Sql Express server installed on that other computer? It won't work without it.

This connectionstring should work "as is", since it's pointing to the Sql Express version on the "same" machine. If you want to point to your original Sql Express database, then you'll have to replace the ".\SQLEXPRESS" with "MACHINENAME\SQLEXPRESS".

Bastard Programmer from Hell Suspicious | :suss:

Re: Database :(

amx_tiger2-May-12 10:53

amx_tiger

2-May-12 10:53

Yes, I have installed SQL Express on my computer.

Thank you again Smile | :)

Koushal Dosi1-May-12 0:46

Koushal Dosi

1-May-12 0:46

Actually I want to create c# application setup with Ms Access Database. How i create this type of setup.

Re: C#

PIEBALDconsult1-May-12 3:36

PIEBALDconsult

1-May-12 3:36

Koushal Dosi wrote:
I want to create c# application setup with Ms Access Database

No, I'm pretty sure you don't; you really want to use SQL Server Express.

Re: C#

Eddy Vluggen1-May-12 5:01

Eddy Vluggen

1-May-12 5:01

Using an application that creates setups. You can choose from ClickOnce, InnoSetup, InstallShield and others.

Bastard Programmer from Hell Suspicious | :suss:

Re: C#

Abhinav S1-May-12 16:35

Abhinav S

1-May-12 16:35

Deploy your Application and Database[^] might be useful to you.
MSDN has some reasonable articles on Setup and Deployment.

Client found response content type of 'multipart/related; but expected 'text/xml'.

NarVish30-Apr-12 2:37

NarVish

30-Apr-12 2:37

Hi,
When I tried to access a method of webservice, I got the below exception in my windows application(.net 3.5).
"Client found response content type of 'multipart/related; but expected 'text/xml'."

When I searched, I found the solutions for web applications using MTOM encoding in wsHttpBinding. How can I resolve this issue in windows application(without installing WSE)

Thanks in advance.

Re: Client found response content type of 'multipart/related; but expected 'text/xml'.

Member 890733330-Apr-12 6:43

Member 8907333

30-Apr-12 6:43

zeyad

Re: Client found response content type of 'multipart/related; but expected 'text/xml'.

NarVish30-Apr-12 20:24

NarVish

30-Apr-12 20:24

Was the reply typed by mistake?

Re: Client found response content type of 'multipart/related; but expected 'text/xml'.

Abhinav S30-Apr-12 21:28

Abhinav S

30-Apr-12 21:28

Try to use a tool like TCP monitor to check what is being sent over the wire.
It could be that you are getting a response like 'authentication failed' which your client is not able to read.

You cannot use MTOM without using WSE (unless you are use WCF).

Re: Client found response content type of 'multipart/related; but expected 'text/xml'.

NarVish1-May-12 19:43

NarVish

1-May-12 19:43

TCP monitor showing the below response
"<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:body><ns1:getclientidresponse xmlns:ns1="http://abc.com/data/xx/xxService">
--MIMEBoundary_4a93bd5d7dcbb70d03b467000df991e9537137eb808fad18--
"
There is no repsonse with 'authentication failed'

I used WCF Service Library project and added the wsdl file as webreference. Still I'm getting the same exception "Client found response content type of 'multipart/related; but expected 'text/xml'"

DataGridView - Cell Border Line VS2010

Paramu197330-Apr-12 1:18

Paramu1973

30-Apr-12 1:18

Hi,
I have a DataGridView called MyDataGrid1. Based on a field value I need to hide the bottom line for certain rows.

DataTable MyStudentsDtb = new DataTable(); 
MyStudentsDtb.Columns.Add("sl_no", Type.GetType("System.String")); 
MyStudentsDtb.Columns.Add("standard", Type.GetType("System.String")); 
MyStudentsDtb.Columns.Add("student_section", Type.GetType("System.String")); 
MyStudentsDtb.Columns.Add("no_of_student", Type.GetType("System.Int32")); 
 
MyDataGrid1.DataSource = MyStudentsDtb;

My Requirement...
Once the user enters '20' in no_of_student, then I want to remove the CellBorder Lines on that row and further 19 rows below to that CurrentRow, Is this possible?
Thanks For The Help.. Thumbs Up | :thumbsup:

Re: DataGridView - Cell Border Line VS2010

BobJanova30-Apr-12 2:23

BobJanova

30-Apr-12 2:23

I imagine it's technically possible, but there's something wrong with your data structure. The number of students shouldn't be in the students table.

Also, you can just use typeof(string) and typeof(int) instead of calling Type.GetType.

Re: DataGridView - Cell Border Line VS2010

Paramu197330-Apr-12 4:18

Paramu1973

30-Apr-12 4:18

Thaks Bob, Thanks For the comments...I gave as a sample..But Its required in diffrent place for different purpose..

Thanks Thumbs Up | :thumbsup:

Re: DataGridView - Cell Border Line VS2010

Reegan Durai.m4-May-12 21:38

Reegan Durai.m

4-May-12 21:38

should be removed for gridview properties cellborderstyle is None, remove cell border

honeypot files

Member 876297729-Apr-12 22:24

Member 8762977

29-Apr-12 22:24

Ive planted honeypot files over few directories.

My code is fire event whenever user click with his mouse anywhere.

When the event is fire i want to check weather the user made right click or left click on honeypot file, if he does then i can assum hes unlegitimate user.

There is a way to check it?

Re: honeypot files

Eddy Vluggen30-Apr-12 0:54

Eddy Vluggen

30-Apr-12 0:54

Member 8762977 wrote:

When the event is fire i want to check weather the user made right click or left click on honeypot file, if he does then i can assum hes unlegitimate user

So you told all your workers "not to click" the file, and are hoping to catch a hacker who "does" click it?

Why would I click on a file that I'm interested in? I'd zip it, download it, and then I'd look at it. Best way to find the "unauthorized" user is by going trough the connection-logs.

Bastard Programmer from Hell Suspicious | :suss:

Re: honeypot files

Member 876297730-Apr-12 4:46

Member 8762977

30-Apr-12 4:46

exactly. the legitimate user know the honeypot files and he'll never select them, the files will named with attractive names like "credit card details"...
i don't need that the unlegitimate user will open this file, only one click, if he select the file i want to lock the system, how can i check if honeypot file like: C:\credit_card.txt was selected?
BTW this project not suppose to defend against hackers, only against unauthorized user that use my PC or laptop without my acception to extract worth data.

modified 30-Apr-12 11:00am.

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