SharpDevelop : Need some guidance

[1DMF]

Hi,

I'm trying to migrate from MS Access VBA to CSharp.

I have installed SharpDevelop and created a demo project, the first two things I want to do I seem to be stumped on?

1. The Main Form -> Where is the Modal property for forms?
2. How do I attach a project datasource : ie Our SQL Server?

I've hunted the GUI, searched Google and the SharDevelop website, and am coming up blank?

Thanks,
1DMF.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[johnny9864]

You will have a lot of reading to do

1- Form.Show() or Form.ShowDialog()

2- Read everything you can on the notion of datasets, datatables, SQLconnections, Datareaders, SQL adapters and I am probabelly missing some

 

[1DMF]

Thanks Jonny,

I gave up with SharpDevelop, I don't think the GUI has a datasource feature in it, I found many threads all moaning about it from 2009, that's 6 years ago and still nada!

So I've moved over to VSC, which does, but until I build my own datasets and abstract out to SQL SP's keep writing all that connection stuff etc is doing my head in.

So I have adapted

http://www.codeproject.com/Articles/22548/Database-Utilities-for-C

into a package and static class helper as I, like the author are coming from MS Access VBA and simple tasks in C# have become a nightmare.

Form.Show() or Form.ShowDialog()

I don't understand how that works (unless MainForm is already modal) as it seems to be initiated by the program with Application.Run(new MainForm());

I guess I don't replace that with MainForm.ShowDialog() ?

I have a long way to go I know, and I'm sure I will have some bad habits I'll be shoe horning into my C# apps.

I appreciate if I keep SQL code in the app, then if it changes, I have to keep rolling out the app (which I have no idea how I would do). not sure how you distribute updates to a C# windows app, or how I could automate it.

Are your .cs files compiled to .dll bytecode or something and I simply replace the class in question?

I'll worry about how I distribute an app or updates to it when I have something to distribute!






"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music