Many Thanks Jamie Fraser. u put me on the right track. :) On Thu, May 20, 2010 at 12:12 PM, Theraot <[email protected]> wrote:
> Hi, > > Still insist in calling you new in ASP.NET when suddently happens that > the trouble is with ADO.NET. the sequence you need is open a > connection (DbConnection, it may be: OdbcConnection, SqlConnection, > OleDbConnection, OracleConnection...), create a command (DbCommand, it > may be: OdbcCommand, SqlCommand, OleDbCommand, OracleCommand...) to > query the db, the command needs to know the connection and the query > string, then you need to ensure the connection is open (you may have > done that before creating the command, it's ok), and then execute the > command (ExecuteNonQuery for the insert/update/delete, ExecuteReader > for the select), in the case of ExecuteReader, it will return a reader > (DbDataReader, it may be: OdbcDataReader, SqlDataReader, > OleDbDataReader, OracleDataReader...), then you use the reader to > iterate trhu the result and do your stuff after which you can close > the connection. An extra step you can do is create an Adapter > (DbDataAdapter, it may be... you know) and use the adapter to fill a > DataTable or a DataSet with the info returned by the select, then you > can close the connection and iterate thru the DataTable/DataSet and do > your stuff. > > Search on MSDN those classes, there are examples. > > Guys around here usually go with the sql* classes, those are for SQL > Server. I prefer OleDb as I can use it for more database engines > without the need to ask to manually set the sources as in Odbc ones. > Also It is possible to find a specific provider for all the mayor > database engines (such as Oracle), for example you can download MySql > provider for .NET from their web page. If you know what database > engine you are using go with the provider specific for that one. > > Hope this helps > > Theraot > > On 19 mayo, 14:02, Awais <[email protected]> wrote: > > Oh Many Thanks to *Naveen Kumar* and *Jamie Fraser*. u both understood > my > > question about 99% > > one question from Jamie Fraser and my question will this work if i want > to > > make changes from the same table. e.g > > > > OPEN DB > > INSERT DATA // insertation in same table > > OPEN DB > > SELECT DATA //selection from same table > > CLOSE DB > > CLOSE DB > > > > and it will be great pleasure if u give me the working code of the above, > > and if u cant then no problem. well many thanks to answer my stupid > question > > (i'm very new to asp.net) :( > > > > On Wed, May 19, 2010 at 5:07 PM, Jamie Fraser <[email protected] > >wrote: > > > > > > > > > Essentially, you are doing > > > > > OPEN DB > > > INSERT DATA > > > OPEN DB > > > SELECT DATA > > > CLOSE DB > > > CLOSE DB > > > > > The problem here is that you don't indicate whether you are using 1 or > > > more connections. If you are using a single DB connection, it will > > > fail. If you have 2 connections, it will work. > > > > > On Tue, May 18, 2010 at 4:57 PM, Awais <[email protected]> wrote: > > > > lol, i'm getting funny replys . yes im newbie to asp.net. :( > > > > i made a one change, now please tell me is this possible? will my > > > function > > > > my_function_call work correctly. > > > > protected void btsignup_Click(object sender, EventArgs e) > > > > { > > > > > > if (Page.IsValid) > > > > { > > > > database open > > > > //some DataBase stuff (here i want to use > Insert > > > > Query) > > > > > > my_function_call( some_var); //my change > > > > databe close //my change > > > > > > public void my_function_call(string some_var) > > > > { > > > > database open > > > > //some DataBase stuff (here i want to use > Select > > > > Query) > > > > databe close > > > > } > > > > } > > > > } > > > > On Tue, May 18, 2010 at 11:49 AM, Theraot <[email protected]> wrote: > > > > > >> May be you want to see something about anon methods: > > > >>http://msdn.microsoft.com/en-us/library/0yw3tz5k(VS.80).aspx > > > >> Lambda Expressions: > > >http://msdn.microsoft.com/en-us/library/bb397687.aspx > > > >> And LINQ: > http://msdn.microsoft.com/es-es/library/bb397965(VS.90).aspx > > > > > >> Just because If I understand your pseudocode you have a function > > > >> inside of another, and that's the part that requires more chemical > > > >> synapse in newbies brains. > > > > > >> Now is it possible, yes, you just did it! You posted that here. > > > >> Now if "achive" is "archive" then don't worry, google groups have > this > > > >> thread already archived in their server >.<. > > > >> And last, alternative solutions... there are a couple from ask > better > > > >> to pay me passing through finding something else to do, and of > course > > > >> you can always suicide. > > > > > >> Is just my idead or awais is feeling too shame :P > > > > > >> Theraot. > > > > > >> On 16 mayo, 03:32, Awais <[email protected]> wrote: > > > >> > Is it possible or how can i achive this? or tell me plz > alternative > > > >> > solution. Thanks in advance. > > > > > >> > protected void btsignup_Click(object sender, EventArgs e) > > > >> > { > > > > > >> > if (Page.IsValid) > > > >> > { > > > >> > database open > > > > > >> > //some DataBase stuff (here i want to use > > > >> > *Insert > > > >> > Query*) > > > > > >> > databe close > > > > > >> > *my_function_call*( some_var); > > > > > >> > public void *my_function_call*(string some_var) > > > >> > { > > > >> > database open > > > > > >> > //some DataBase stuff (here i want to use > > > >> > *Select > > > >> > Query*) > > > > > >> > databe close > > > > > >> > } > > > >> > } > > > > > >> > } >
