Re: Use a database like a resource - C# Discussion Boards

Re: Use a database like a resource

Steven Solberg5-Jul-10 1:18

Steven Solberg

5-Jul-10 1:18

I've got a lot of reading ahead of me... OMG | :OMG:

This is what Mycroft Holmes was talking about.
Right now I have got no clue anymore were to begin.
Are there any good 'for dummies' books about this? Laugh | :laugh:

We're going totally off-topic by the way. Not that I really mind though.
Luc pattyn now you are here anyway and to get a little more on-topic. Do you know any way to refer to a database file in the application code? To my understanding including them in the deployment only works in the versions other than express. But to do it in express? Read my previous posts for more info.

Re: Use a database like a resource

Luc Pattyn5-Jul-10 1:26

Luc Pattyn

5-Jul-10 1:26

1. UNIZO[^] has a 5-evening introductory course which is pretty good.

2.
I'm no expert on these topics; what I do is store the connection string in the application settings, which means manual intervention (editing a text file) upon installation. I was hoping to learn other ways from this thread!

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Use a database like a resource

Steven Solberg5-Jul-10 1:27

Steven Solberg

5-Jul-10 1:27

Hehe

2) So am I
Laugh | :laugh:

Re: Use a database like a resource

Steven Solberg6-Jul-10 22:32

Steven Solberg

6-Jul-10 22:32

I found something nice to link to the database
When checking out some files in the manifests and such I found this.

This I a copy of myapp.exe.config

<?xml version="1.0"?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="WindowsFormsApplication1.Properties.Settings.databaseConnectionString" connectionString="Data Source=|DataDirectory|\database.sdf" providerName="Microsoft.SqlServerCe.Client.3.5"/>
    </connectionStrings>
<startup><supportedRuntime version="v2.0.50727"/></startup></configuration>

However, it doesn't show up when I type 'Properties.Settings.' in my code, but I think I'm getting close Wink | ;)

Re: Use a database like a resource

Luc Pattyn6-Jul-10 23:23

Luc Pattyn

6-Jul-10 23:23

This[^] may help.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Use a database like a resource

Kevin Marois6-Jul-10 7:34

Kevin Marois

6-Jul-10 7:34

I got turned down by BizSpark 2 weeks ago. No reason why, just "You don't meet the requirements" sort of thing. Of course, I met the requirements they listed. Some kind of concrete answer would have been nice.

Everything makes sense in someone's mind

Re: Use a database like a resource

Luc Pattyn6-Jul-10 7:36

Luc Pattyn

6-Jul-10 7:36

That's weird. I haven't applied myself yet, I plan on doing so later this year. I would like to hear more about it from people who were accepted though.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Use a database like a resource

Kevin Marois6-Jul-10 7:38

Kevin Marois

6-Jul-10 7:38

I got pointed to BizSpark by a guy I work with who got accepted. He and others all told me, "No one everr gets denied". Of course, I got denied.

I'll apply again in the not too distant future and see what happens.

Everything makes sense in someone's mind

Re: Use a database like a resource

Roger Wright5-Jul-10 19:29

Roger Wright

5-Jul-10 19:29

Just my two cents worth...

VS Professional is a huge waste of money for anyone who does not regularly earn an income from software development. I've been an idiot for about 15 years by buying the Professional version just so I wouldn't be missing anything I might need while playing with the toys. I've squandered thousands doing so, to no benefit. The last version, VS2008, I finally wised up and really looked at the features included in all the versions. I found that, while the professional version contains things useful for teams of developers, there is no value added for the hobbyist or a solo developer, so I saved a bundle and bought the Standard version.

Microsoft appears to be on to me now, since there is no Standard version offered in VS2010 that I can find. I guess it's their goal to eliminate people like me, as I don't qualify for the BizSpark program, and have no intention of shelling out the ridiculous price they are asking for the Professional version. But I'll carry on with VS2008 as long as I can, and expect to one day be the last VS2008 developer on the planet, writing apps to entertain myself on the last remaining WindowsXP SP3 machine on Earth. Big Grin | :-D

Look into the BizSpark program if you're really interested in becoming a freelance developer - you won't find better pricing, and they may be able to help you get started in other ways. Good luck! Smile | :)

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Re: Use a database like a resource

Steven Solberg5-Jul-10 20:13

Steven Solberg

5-Jul-10 20:13

Since we both have Windows XP SP3 and like VS2008 we should write apps for eachother Laugh | :laugh:

Seriously now... I didn't even now about a standard version. I will check that out.
I looked at ebay and found a 2008 Pro version for 160 euros. A friend of mine uses ebay quite regularly (not sure about this word Sniff | :^)

) and he thought it to be legit. But I'm going to lookup that Standard version first.

Re: Use a database like a resource

Steven Solberg5-Jul-10 20:24

Steven Solberg

5-Jul-10 20:24

Okay... I just did the biggest WTF?? in my life.

Check this out:
http://www.microsoft.com/express/support/support-faq.aspx[^]

Then search for the word 'commercial'. I wonder what the hell I have been wasting so much time on because THAT is definitely not what I read in the EULA of express.

Re: Use a database like a resource

Roger Wright6-Jul-10 3:04

Roger Wright

6-Jul-10 3:04

As far as I know there are no restrictions on products developed with the Express editions. But there are features missing that make it easier to deploy finished products, and probably other bits I haven't discovered. On the Visual Studio website there used to be a table that compares the features of all editions, including Express. If you can locate it, spend a little time looking it over and thinking about what you are likely to need over the next 3 years, then decide which one fits your requirements. If your plans for your career turn out well you probably will one day want to go whole hog and take the MSDN subscription route with the top of the line development tools. But there's little sense in spending all that money before you're even got your toes wet. Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

AxisItemLabelStyle

It_tech3-Jul-10 22:28

It_tech

3-Jul-10 22:28

Hi all ,

I am trying to lable my datapoints in Y axis to a currency.

This will format my Y axis to currency ---- Chart1.ChartAreas(0).AxisY.LabelStyle.Format="C"

How can i format my datapoints for Y Axis to have the same format as Currency?

I thought this will work but there is no property like 'ItemlableStyle' --- : Chart1.ChartAreas(0).AxisY.ItemlableStyle="C"?????

Can any one Suggeet any ideas?

Thanks

Re: AxisItemLabelStyle

kevinnicol5-Jul-10 7:32

kevinnicol

5-Jul-10 7:32

Is this a .NET Chart or some 3rd party, such as DeveloperExpress? I am looking through the default toolbox in .net and can't find any sort of chart like you are talking about.

conversion

Parthi278873-Jul-10 6:02

Parthi27887

3-Jul-10 6:02

Hi

I want to convert a unicode character(multi byte) into its hexadecimal value using C#.

Re: conversion

Keith Barrow3-Jul-10 6:13

Keith Barrow

3-Jul-10 6:13

Yeh me too.

Do you have a question?
[edit]

This looks like it might be useful

http://stackoverflow.com/questions/3170523/converting-unicode-character-to-a-single-hexadecimal-value-in-c[^]

Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.

Re: conversion

Luc Pattyn3-Jul-10 6:49

Luc Pattyn

3-Jul-10 6:49

char unicodeChar = 'a';
int integerValueOfUnicodeChar = (int)unicodeChar;
string stringShowingUnicodeValueInHex = integerValueOfUnicodeChar.ToString("X");

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

Sqlparameter

humayunlalzad3-Jul-10 1:59

humayunlalzad

3-Jul-10 1:59

The following does not work

cmd = con.CreateCommand();
cmd.CommandText = @"select * from tblcustomer where @column = @value";
cmd.Parameters.Add("@column", SqlDbType.NVarChar , 50);
cmd.Parameters.Add("@value", SqlDbType.NVarChar , 100);
cmd.Parameters["@column"].Value = comboBox1.SelectedItem.ToString();
cmd.Parameters["@value"].Value = txtSearch.Text;

But this workds

cmd = con.CreateCommand();
            cmd.CommandText = @"select * from tblcustomer where " + comboBox1.SelectedItem.ToString() + " = @value";
            //cmd.Parameters.Add("@column", SqlDbType.NVarChar , 50);
            cmd.Parameters.Add("@value", SqlDbType.NVarChar , 100);
            //cmd.Parameters["@column"].Value = comboBox1.SelectedItem.ToString();
            cmd.Parameters["@value"].Value = txtSearch.Text;

Can someone tell me whats the problem with the first code snippet

Re: Sqlparameter

Estys3-Jul-10 2:06

Estys

3-Jul-10 2:06

Yep, it's as if you had written :

@"select * from tblcustomer where <big>'</big>" + comboBox1.SelectedItem.ToString() + "<big>'</big>= @value"

Note the single quotes. You can't insert a column name as a parameter.

Cheers

^I _don't like ^my _signature at ^all

Re: Sqlparameter

humayunlalzad3-Jul-10 2:18

humayunlalzad

3-Jul-10 2:18

Ok I get it now.

But is there any other way of doing it?

Re: Sqlparameter

Estys3-Jul-10 2:26

Estys

3-Jul-10 2:26

Maybe, haven't tested this :

Select blabla FROM YourTable WHERE
CASE
WHEN @a = 'YourColumn1' THEN YourColumn1
WHEN @a = 'YourColumn2' THEN YourColumn2
ELSE YourColumn1
END
= @value

If this works it has the drawback is that when columns are added or changed, you need to edit your query.

Cheers

[edit] forgot the END Sleepy | :zzz:

[/edit]

^I _don't like ^my _signature at ^all

modified on Saturday, July 3, 2010 8:51 AM

Re: Sqlparameter

Not Active4-Jul-10 3:01

Not Active

4-Jul-10 3:01

Very poor example that opens up sql injection attacks

I know the language. I've read a book. - _Madmatt

Re: Sqlparameter

Not Active3-Jul-10 2:38

Not Active

3-Jul-10 2:38

Column names are not simple strings, they are literals that represent values from the sys.columns table.

In oder to do this you need to construct the sql dynamically and I highly and strongly recommend you do it in a stored procedure

As an example:

declare @value nvarchar(255)
declare @column nvarchar(255)
 
set @value = 'Some value'
set @column = 'ColumnName'
 
declare @sql nvarchar(1024)
 
set @sql = 'select * from tblcustomer where ' + @column + ' = ''' + @value + ''''
exec(@sql)

Notice that @value needs to be in quotes since it is a string. Also, don't use * to return results. It is more efficient to return named columns and better documented.

I know the language. I've read a book. - _Madmatt

Incrementing the pointer returned by GCHandle.Alloc

Keith Vitali2-Jul-10 22:57

Keith Vitali

2-Jul-10 22:57

Hello,

I am using GCHandle to allow unmanaged code to access some managed data.

My code is as follows:

<br />
byte[] data = new byte[numBytes];<br />
GCHandle dataPtr = GCHandle.Alloc(data, GCHandleType.Pinned);<br />

Now what I would like to do is to be able to address with an offset into my dataPtr array. So, I need to get the address of an element (say element number 100) and pass that to my unmanaged C++ code. I see some method to convert it ToIntPtr(). However, does anyone know what might be the best way to address the offset?

Many thanks,

keith

Re: Incrementing the pointer returned by GCHandle.Alloc

DaveyM692-Jul-10 23:16

DaveyM69

2-Jul-10 23:16

You can use dataPtr.AddrOfPinnedObject() to get the IntPtr. You can convert an IntPtr from/to an int for any pointer arithmetic.

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

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