DT, Wow a lot of questions heh. Gonna give this a shot without knowing alot about the particulars.
1.How do I work with a user query (the one where the user gets to enter some values into some fields and then clicks on the 'Query' button to view the query results from the database)? A. I am assuming you have a search for where they put in particular criteria to search the DB with. In that case create a stored procedure with the syntax to plug in those Variables i.e. Select * from tblUsers where username like '%' + @UserNameFromSearchForm + '%' 2.What kinds of SQL commands do I use and how do I code them into the program? A. It's not to use inline sql statements, statements embedded in the application, it increases th execution time as compared to stored procedures which are pre-compiled by the RDMS. 3.How do I save all the values that a user enters from a web form into a database? A. Create another stored procedure which takes the users submitted search form and insert them into the database. 4.How do I delete the database recors that a user deletes from a datagrid? A. This depend if you are using a datagrind that has CausesPostback enabled or not. If you do you capture the event and delete according to the Primary Key captured when the event fires. Check out this article to see more about deleting from a datagrid http://aspnet.4guysfromrolla.com/articles/090402-1.aspx Regards, Shannon --- dt_aiying <[EMAIL PROTECTED]> wrote: > Hi, I'm a beginner in ASP.NET and I'm currently > working with an > Oracle database, using the OleDb Data Provider. > > How do I work with a user query (the one where the > user gets to > enter some values into some fields and then clicks > on the 'Query' > button to view the query results from the database)? > What kinds of SQL commands do I use and how do I > code them into the > program? > > How do I save all the values that a user enters from > a web form into > a database? > > How do I delete the database recors that a user > deletes from a > datagrid? > > Thank you very much on your kind help. > Really appreciate it. > > > > > > > > __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
