Database

FirstPrevNext

manage connection to database dinakatina19-Sep-07 11:31 dinakatina 19-Sep-07 11:31  good evening i have made a online reservation airline tickets website ,my question is if many users reserves online at the same how can the database will respond to those users ,i knew that there is (isolation level )enum that solves this problem but i don't know how to use it in the code thanks in advance Re: manage connection to database DerekFL20-Sep-07 10:25 DerekFL 20-Sep-07 10:25  Sounds like you need to use a transaction BEGIN TRANSACTION UPDATE tblOpenSeats (mark the seat as reserved) INSERT INTO reservations... COMMIT Inserting table adding column problem ASP/SQL hundter19-Sep-07 8:52 hundter 19-Sep-07 8:52  I am a newbie to working with SQL. I am attempting to Insert a record from one table to another table in the same database and add an additional field to the record. The tables are identical with the following exceptions: t2 has a datedeleted(for when it is added to t2 table) and deletedID columns(identity field incrementing by 1). I am writing the code in an ASP page and cannot seem to get anything to work or find the appropriate answer on the web. Here is what I have so far: ' Insert record into Deleted table SQL = "INSERT INTO t2 Select * " & ", DateDeleted " SQL = SQL & "FROM t1 " SQLWHERE = "WHERE PotentialID = " & Session("PotentialID") SQL = SQL & SQLWHERE MyConn.Execute(SQL) I get an error indicating that DateDeleted is an invalid column name. Any help is greatly appreciated. Jeff Hundt Re: Inserting table adding column problem ASP/SQL pmarfleet19-Sep-07 9:37 pmarfleet 19-Sep-07 9:37  Is 'DateDeleted' actually a field in table t1? Paul Re: Inserting table adding column problem ASP/SQL hundter19-Sep-07 10:09 hundter 19-Sep-07 10:09  No it is not. But I was just talking with one of my colleagues and I think that is the simplest choice. Add that field to t1 and then insert into t2. Jeff Hundt Re: Inserting table adding column problem ASP/SQL pmarfleet19-Sep-07 10:14 pmarfleet 19-Sep-07 10:14  Obviously, any field names you include in a query have to be present in one of the tables referenced in your query, otherwise you will get this error. Paul Data Adapter and Updating [modified] dbrenth19-Sep-07 3:39 dbrenth 19-Sep-07 3:39  Has anyone else noticed that if you update through a data adapter and the row it is updating hasn't changed, that the data adapter will not update the database, but will report that it DID update the database? I have a program where we tried to change the value of a column from 1.0 to 1. The row says it was modified, the data adapter says it updated the row, but the update trigger on the table was never fired. And in fact the table says it was never changed. (And by the way there are no bugs if I change the value from 1.0 to 2.) If I run the same update command in generic SQL on the database, it does update the table and the trigger is fired. If I just use a regular ODBCCommand object to run the SQL command everything works just fine. But apparently the dataadapter wants to scrutinize the data and say "no you didn't really change anything so I'm not going to run the command, BUT I'll tell you that I updated the database, just so you won't worry." Is there a way to force the data adapter to run the command anyway? Or conversely to have it report that it didn't do anything? Thanks Brent -- modified at 9:45 Wednesday 19th September, 2007 Brent Re: Data Adapter and Updating Michael Potter19-Sep-07 5:35 Michael Potter 19-Sep-07 5:35  I believe each row looks at the status of each column. The column most likely compares the current and original values to see if it needs to be modified. Since you really didn't change anything, these values remain equivalent. Take a look at DataRow.SetModified(), it may be able to force an update to fire your triggers. See DataRow[DataColumn, DataRowVersion] to visually check the status of each column in a row. Re: Data Adapter and Updating dbrenth19-Sep-07 6:06 dbrenth 19-Sep-07 6:06  With DataRow.SetModified the row is already marked as modified. DataAdapter ignores it anyway. DataAdapter also changes all rows to Unchanged after an update, understandable I suppose. What I did find out is that the RowUpdated event is never called on the rows that are ignored. This is helpful as I can fill a class-level variable with the rows that do get run through this event. And then I have to go back through and figure out which rows are missing if the start and results are different sizes. Anyway it's a big pain. Thanks Brent View or procedure samerh19-Sep-07 3:04 samerh 19-Sep-07 3:04  Hi all, Which is more faster or accurate to use a view then use a select * from that view or directly using a stored procedure and writting inner join and selct statments regards Re: View or procedure Pete O'Hanlon19-Sep-07 3:15 Pete O'Hanlon 19-Sep-07 3:15  Rather than post a question, why not try it out for yourself? It's a very good way to learn. But - as a hint, think about the layers of abstraction between a direct join and a view. Deja View - the feeling that you've seen this post before. getting Row Count of DataTable in c#.net piyusgupta19-Sep-07 1:49 piyusgupta 19-Sep-07 1:49  plz I am trying to fetch 1,50,000 records from the DataTable and dataTable.Rows.Count returns an integer so it gets index out of bound. tell me the way to find the no records in the DataTable which can return a long value. Piyus Gupta Re: getting Row Count of DataTable in c#.net Giorgi Dalakishvili19-Sep-07 2:44 Giorgi Dalakishvili 19-Sep-07 2:44  Why do you need to fetch so much records at once? DataTable.Rows.Count returns integer and its maximum value is 2,147,483,647 so it should be enough for your case #region signature my articles #endregion Re: getting Row Count of DataTable in c#.net PIEBALDconsult21-Sep-07 9:51 PIEBALDconsult 21-Sep-07 9:51  Consider using a DataReader instead. how to calculate age from given DOB in sql 2000 ramyasangeet19-Sep-07 1:16 ramyasangeet 19-Sep-07 1:16  hi all i need to find members whose age is greater 75 yrs.how to calculate age from the give DOB. I used the following code. DOB <= Dateadd(yy,-75,getdate()) Plz help me to find out the correct way thanks in advance cheers sangeet Re: how to calculate age from given DOB in sql 2000 [modified] joemonvarghese19-Sep-07 2:05 joemonvarghese 19-Sep-07 2:05  select * FROM WHERE datediff(year,convert(datetime,DATEOFBIRTH),getdate())>75 -- modified at 8:17 Wednesday 19th September, 2007 SQL reporting Service Prob arnoldpinto8418-Sep-07 22:31 arnoldpinto84 18-Sep-07 22:31  Hi, Can any1 pls tell me if it is possible to place a textbox on the body of a report so that it appears on evry page of the report when a page break occurs, i am not supposed to use the page footer part to accomplish this & also there are no groups. i require the textbox to be in the body section itself. Please also let me know how to detect when a pg. break is going to occur in the rdl file(if it is possible) Thanks Re: SQL reporting Service Prob pmarfleet19-Sep-07 0:22 pmarfleet 19-Sep-07 0:22  You can just place your textbox at the top of the body section of your report. When the report renders, the textbox will be displayed at the top of each page. Why do you need to know when a page break occurs? If you need to explicitly force a page break somewhere in the report, you can do this. Otherwise, page break positions are going to be dependent on local user settings and you won't have any control over where they occur. Regards Paul Re: SQL reporting Service Prob arnoldpinto8419-Sep-07 0:31 arnoldpinto84 19-Sep-07 0:31  Hi, actually the requirement is that i am required to display the page total for every page without using the header or the footer section. Placing a textbox at the top of the body of the report doesnt display it on all the pages, futhermore the repeat item with dataregion on each page option doesnt work. i have read that this problem goes away when we publish the reports onto a report server. but we are not going to publish them onto a server they are going to be local reports. i wanted to know how the page break occurs to figure out if there is a way to insert the required value before it happens Thanks. Re: SQL reporting Service Prob pmarfleet19-Sep-07 0:59 pmarfleet 19-Sep-07 0:59  What does your report do? Does it contain a table object that displays a set of tabular data? In that case, add a footer section to your table object, put your textbox in the table footer and set the footer to repeat on every page via the table properties. Paul Re: SQL reporting Service Prob arnoldpinto8419-Sep-07 1:35 arnoldpinto84 19-Sep-07 1:35  i am looking for a general solution, the report may contain a table object or a list to display the data thats not a prob. Adding textbox on the footer to display the sum and making it repeat on every page will not solve the problem, bcos the final total will be displayed on each page and not the individual page total. i'm not really sure if its possible to achieve this without using the page footer....i hope there is a change in the requirement urgent: can any one plz solve my problem regading SQL Query mavii18-Sep-07 21:58 mavii 18-Sep-07 21:58  i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal"; Re: urgent: can any one plz solve my problem regading SQL Query arnoldpinto8418-Sep-07 22:13 arnoldpinto84 18-Sep-07 22:13  Try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + substring(textBox6.Text,11,30)+"')"; Re: urgent: can any one plz solve my problem regading SQL Query mavii18-Sep-07 22:56 mavii 18-Sep-07 22:56  i had tried the same query but the following error comes Error 14 The name 'substring' does not exist in the current context C:\Documents and Settings\mehwish\My Documents\Visual Studio 2005\Projects\rescue15\new_wanted_criminal_record.cs 654 230 rescue15 Re: urgent: can any one plz solve my problem regading SQL Query arnoldpinto8418-Sep-07 23:11 arnoldpinto84 18-Sep-07 23:11  Check if this works out strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,30) +"')";

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 3:25 Refresh ᐊ Prev1...1410141114121413141414151416141714181419 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.