- Create an ODBC data source for the database
- In default.aspx web form drag and drop a Gridview control
- Click on the top right of the Gridview control. Select "new data source". On the page will appear a window with various icons. Select "Database". Click OK.
- Now 'll appear SqlDataSource1 control. Click on "New connection" button.
- It'll appear a window. Click on Edit button and select "Other". In the label It'll appear ".Net Framework Data Provider for ODBC"
- Below click the option button "Use connection string". Click on "Generate.." button, and select the tab "Computer data source". Then select your data source name. Then OK. Next.
- Click on the "Specify a stored procedure or a customized SQL statement" option button. Otherwise you may get a token error message because of the square brackets for a string without white spaces.
- You may use "select" statement. Write the select statement. Next. Click on "Test query" button.
- Now you should see your table.
- For further test start the debug.
Establishing a data connection for Asp.net page
With Visual Web Developer, from Microsoft:
Categorie:
Asp.net
Subscribe to:
Post Comments (Atom)
Hello maybe is better to post some screenshots for the steps too
ReplyDeleteI guess i can link this post to the next one with the DSN and firebird :) ?
Hello mariuz,
ReplyDeletemay be we have encountered one the other earlier in the web.
Just now I added two steps I unfortunately forgot in a first version of the "Howto create a DSN".
As soon as I'll have the time I'll insert the screenshots you asked me.
Goodbye.
Thank you , I have added to firebirdnews
ReplyDeletealso these days people do screencasting and post it to youtube
maybe when you have time (add it in the TODO list :))