SharpDevelop Community

Hi! Thanks for the quick reply. Yes, it is sure because if I remove the parameter from the SQL string - and comment the parameter part - it works properly. I know that the Stored Procedure would be the best-practice. On one side I'd like to practice this solution, on the other side there will be no SQL...

Hi! I know this is not really a SD problem but I hope someone help me. I have this code: sCheckQuery = "SELECT code FROM MyDataBase WHERE code = @code" ; this . odbcCommand1 . CommandText = sCheckQuery ; this . odbcCommand1 . Parameters . Add ( "@code" , OdbcType . NVarChar , 2 ). Value = this . textBox1...

Hi! My problem is the following where I need some assistant. I've created a form to show data from an MDB table. I would like to bind the coloumns of the table to the texboxes of the form. I'm trying to use the bindingsource component for this. In the design view I was able to set the datasource property...

How can I create a DataSet with a table reflecting a table on my MSSQL db without the need to create manually each column? I mean: there's a way to retrieve schema from DB and create a table in a DataSet in an automatic way? Any link? Any addin? I really can't find any informtions

Awesome! Now I can build and run SharpDevelop! Cool! Only 3 warnings! :) I quickly tested the SQLite connection tool. Seems great! I could view the db schema and even the contents of the db. There are a few things left though, I understand. Like seeing the column types. Also, right-clicking in the Server...

Hi, as a workaround you can generate DataSets by using SharpReport. Start the Wizard, Select PullModel-Report on the first Wizard Page. On the second Wizard Page create a connection and a SqlStatement The thierd Wizard Page shows the QueryResults. The ContextMenu of the DataGrid lets you save the Results...

ygmail: Is there some kind of feature like "Generate dataset" like in VS.net 2003? I like that function very much. Or is there some alternative? I use MS Access (.mdb) databases. No, I don't think there is. Check this thread . But there is the hard way. I'm a user of Visual Studio ...

Hi Evelyn, i think i solved your problem. Under this thread http://community.sharpdevelop.net/forums/thread/10479.aspx i told you to get the newest version of #Develop I solved the problem with ref 1694 and you are working with ref 1591! So if you get the newest download from the repository and give...

Hi, I want to know which programs could I use to create reports for my application in sharpdevelop. I tried the SharpReport but there is a problem with stored procedures, another program? I be trying with NeoDataType Report but I didn't find any tutorial, so I am having many troubles and using a...

Hi Durand, 1) you can use a) Server Explorer, you will find this Addin under View/Server Explorer b) or SharpQuery, View/Tools/Database Explorer but this tool will be gone sometime's Peter