Query work in Access Query, but don't work in C# - C# Discussion Boards

Gerry Schmitz17-Nov-14 1:14

17-Nov-14 1:14

What's your connection string look like?

I assume it looks something like this:

... connectionString="Data Source=|DataDirectory|\MyDB.sdf" ...

Somewhere in your code (i.e. before you access the database), you should be setting the "DataDirectory" property; e.g.

AppDomain currentDomain = AppDomain.CurrentDomain;
currentDomain.SetData( "DataDirectory", myDbLocation );

Your program should "infer" the location of your installed db using, for xample:

Environment.SpecialFolder.CommonApplicationData

because (assuming your setup did a "typical" install), and based on the operating system, "user/app data" folders (where your db should be) wind up in different locations.

(If you did not install your db in the "standard" location, then you should find out where it did get installed and use that location).

Your installed app is not working because your installed db is not in the same relative location as it was during development.

how to make self signed code in xamarin IOS8 v2010 [moved]

AhmedOsamaMoh16-Nov-14 19:57

AhmedOsamaMoh

16-Nov-14 19:57

dears
now i am in phase of self learning ios8 developing using C# throught using xamarin and vs2010
i am using and vmware in my win7 64bit hosting mac & xamarin developing host

now i tried a lot to built the solution and get the IPA file , but i stuck in phase of code signing , i need to make a self signed code , i will just test the IPA in my ipad

when i make a progress i will purchase the apple develop lic to be able to post it in the AppStore

any tips ??

waitting for your help

thanks all

Re: how to make self signed code in xamarin IOS8 v2010

CBadger16-Nov-14 20:05

CBadger

16-Nov-14 20:05

For a better response you might want to look at asking your question here[α] $Shucks | :-\$

»»» <small>Loading Signature</small> «««

· · · <small>Please Wait</small> · · ·

Badger | [badger,badger,badger,badger...]

Re: how to make self signed code in xamarin IOS8 v2010

Jacquers16-Nov-14 20:11

Jacquers

16-Nov-14 20:11

Step 1: Read the instructions - no coding questions in the lounge.

Try asking in the coding forums, you have a much better chance of getting an answer there.

Re: how to make self signed code in xamarin IOS8 v2010

Mycroft Holmes16-Nov-14 20:31

Mycroft Holmes

16-Nov-14 20:31

I'd actually dispute that it is a coding question. If the OP had not started the question with Dears and had focused slightly more on a strategy for achieving his goal he would probably have got away with it. I have seen similar from regulars!

Having said that he has obviously strayed into the wrong forum and has rightly been redirected.

I wonder what the word Lounge means in his local language!

Never underestimate the power of human stupidity
RAH

Re: how to make self signed code in xamarin IOS8 v2010

OriginalGriff16-Nov-14 20:22

OriginalGriff

16-Nov-14 20:22

You just need to Hornswoggle your whojemaflip (obviously remembering to protect your tardis code from tachyon emissions) using the Round Tuit API. Once you've done that, it's all pretty obvious!

(other vendors are available)

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: how to make self signed code in xamarin IOS8 v2010

Richard Deeming17-Nov-14 3:07

Richard Deeming

17-Nov-14 3:07

Don't forget to reverse the polarity of the neutron flow before you start.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Query work in Access Query, but don't work in C#

nta_388616-Nov-14 19:45

nta_3886

16-Nov-14 19:45

My database Access have 3-columns : ID (int), Doc_no(string), Rcv_date(Date). I try to filter the newest row in the rows that have same Doc_no.
i have a query for database Access :

SQL

SELECT  ID, Doc_No, Rcv_Date, 
FROM            [SDC Documents Record] A
WHERE           (ID =
                   (SELECT        TOP 1 ID
                   FROM            [SDC Documents Record]
                   WHERE        (A.Doc_No = Doc_No)
                   ORDER BY    Rcv_Date DESC))

That query still work well with Query Tool in Access, but in Query Builder in Visual Stuido 12 - C#, there are message : "Error in WHERE clause near 'ORDER'" .
I don't know why. Plesea help me to fix it

leo

Re: Query work in Access Query, but don't work in C#

Mycroft Holmes16-Nov-14 20:43

Mycroft Holmes

16-Nov-14 20:43

The ( puts the ORDER BY inside your WHERE clause, you have 2x ( and 3x )

Never underestimate the power of human stupidity
RAH

Re: Query work in Access Query, but don't work in C#

Bernhard Hiller16-Nov-14 21:36

Bernhard Hiller

16-Nov-14 21:36

SELECT  ID, Doc_No, Rcv_Date, FROM

the last comma is wrong - but with it, the query should not run in MS Access either.

Calling a MySQL Stored Procedure over SSH using .PEM file

bpoker16-Nov-14 4:33

bpoker

16-Nov-14 4:33

Does anyone have C# sample code for calling a MySQL stored procedure through SSH connection using .PEM file for the SSH password?

Re: Calling a MySQL Stored Procedure over SSH using .PEM file

Richard MacCutchan16-Nov-14 5:10

Richard MacCutchan

16-Nov-14 5:10

See http://www.codeproject.com/Messages/1278604/How-to-get-an-answer-to-your-question.aspx[^].

issue with date format when exporting to excel

parkway15-Nov-14 6:23

parkway

15-Nov-14 6:23

Hi,
I have a grid where i have to filter the columns like multiple search filter and what ever records i get in the grid i am doing export to excel in c#

Everything was went well except the date column in the grid the date column data is in this format 2014/11//15

here is my c# code which i am using to remove special characters

private void getfilterdata(string filter, out string key, out string val)
{
key = string.Empty;
val = string.Empty;
if (!string.IsNullOrEmpty(filter))
{
string[] retval2 = filter.Split(new string[] { "data" }, StringSplitOptions.RemoveEmptyEntries);
if (retval2 != null && retval2.Count() > 1 && !string.IsNullOrEmpty(retval2[1]))
{
string[] strkeys = retval2[0].Split(new char[] { '"' }, StringSplitOptions.RemoveEmptyEntries);
if (strkeys.Length >= 3 && !string.IsNullOrEmpty(strkeys[3]))
{
key = strkeys[3];
val = RemoveSpecialCharacters(retval2[1]);
}
}
}
}

In the key its shows column name and in the val it shows data..
in the val i am getting data as 20141115.

So its not matching and while exporting its empty i am not getting any records becaus e of this

this is my code for RemoveSpecialCharacters

public static string RemoveSpecialCharacters(string str)
{
return Regex.Replace(str, "[^a-zA-Z0-9_.]+", "", RegexOptions.Compiled);
}

Any help plz.....

Re: issue with date format when exporting to excel

Mycroft Holmes15-Nov-14 12:54

Mycroft Holmes

15-Nov-14 12:54

Are you using the Grid functions to export the content of the grid or are you exporting the underlying collection. If it is the grid then you should get the grid to reformat the date then export the data.

If you are exporting the underlying collection then it is just a matter of formatting the underlying DateTime data object. The most unambiguous format I have found to bd dd/MMMM/yyyy.

Never underestimate the power of human stupidity
RAH

Re: issue with date format when exporting to excel

Richard MacCutchan15-Nov-14 21:36

Richard MacCutchan

15-Nov-14 21:36

You may like to read http://www.cpearson.com/excel/datetime.htm[^], which explains how Excel stores Date values.

Generic EventHandlers

conradsmith14-Nov-14 22:27

conradsmith

14-Nov-14 22:27

I'm currently revisiting C# and oop after a few years programming PLCs. I'm looking at delegates and events. I was wondering what is the difference between a non-generic event handler and a generic one. Why would you use the generic one over the non-generic one. I've searched on the internet and can't find a satisfactory explanation.

Thanks in advance

Re: Generic EventHandlers

Richard MacCutchan14-Nov-14 23:43

Richard MacCutchan

14-Nov-14 23:43

I think you can find a reasonably good explanation in http://msdn.microsoft.com/en-US/library/ms182178(v=vs.80).aspx[^].

can i use viewstate in if else conditon?

Member 1122118514-Nov-14 20:45

Member 11221185

14-Nov-14 20:45

My application is for Leave Module. now in that i used, employee can apply leave normally Seek Leave, Casual Leave and Paid leave. but Now i have to put condition like if total leave days(Count) is less than or equal to 2 then it will automatically goes in CL n PL will be invisible in drop down list. so what can i do for that?

Re: can i use viewstate in if else conditon?

Mycroft Holmes14-Nov-14 21:28

Mycroft Holmes

14-Nov-14 21:28

Filter the underlying collection based on the number of days asked/available. To do this you trap the change event on the requesting control and then filter the collection accordingly.

More specific help will require more detail on the UI you are using.

Never underestimate the power of human stupidity
RAH

Re: can i use viewstate in if else conditon?

Member 1122118514-Nov-14 22:15

Member 11221185

14-Nov-14 22:15

Ok. I can understood. now i have change event on no of days calculation button. but what can i put a condition for that. can u help me in coding.

Re: can i use viewstate in if else conditon?

Mycroft Holmes14-Nov-14 23:44

Mycroft Holmes

14-Nov-14 23:44

Member 11221185 wrote:
can u help me in coding

Coding what! I have no idea of your data structure, the technology you are using. For all I know you may be coding for an iPhone.

We don't do the coding for you, you will get help if you show the code YOU have written and have a problem with.

Never underestimate the power of human stupidity
RAH

Looking for simple graph library for C# windows console app

jsundownr14-Nov-14 4:29

jsundownr

14-Nov-14 4:29

Need a simple 2D graph library for C# console app. Thanks for any ideas.

sundownr

Re: Looking for simple graph library for C# windows console app

OriginalGriff14-Nov-14 4:47

OriginalGriff

14-Nov-14 4:47

And?
Google not working today?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: Looking for simple graph library for C# windows console app

jsundownr14-Nov-14 5:19

jsundownr

14-Nov-14 5:19

Google works fine and after trying a few libraries I did not find what I wanted... thus I asked for any ideas. I am trying SharpDX now but prefer something simpler. All I need to do is graph a series of voltages.

sundownr

Re: Looking for simple graph library for C# windows console app

BillWoodruff14-Nov-14 5:55

BillWoodruff

14-Nov-14 5:55

Are you looking to manipulate a Charting library from a Console App: I mean what else could you do in the Console but read a file into some data structure(s), manipulate the data, call the library's facilities for creating a chart passing in the data, save the resulting output chart/graphic to a file ?

Why not create a WinForms app where you can preview the chart/image you create ?

«At the still point of the turning world. Neither flesh nor fleshless;
Neither from nor towards; at the still point, there the dance is
...
Neither ascent nor decline. Except for the point, the still point,
There would be no dance, and there is only the dance»

T.S. Elliot, The Four Quartets: "Burnt Norton"/xml>

modified 14-Nov-14 13:12pm.

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