Database

FirstPrevNext

Re: What is "N" in OBJECTPROPERTY(id, N'IsUserTable') = 1) Pete O'Hanlon9-Jan-07 3:36 Pete O'Hanlon 9-Jan-07 3:36  It converts the string into a Unicode string. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before. Re: What is "N" in OBJECTPROPERTY(id, N'IsUserTable') = 1) Rob Graham9-Jan-07 3:46 Rob Graham 9-Jan-07 3:46  Strictly speaking, th N' doesn't itself "convert" the string, but rather specifies that it should be converted (if needed) and stored/retrieved as a Unicode string by the server... Re: What is "N" in OBJECTPROPERTY(id, N'IsUserTable') = 1) Pete O'Hanlon9-Jan-07 4:11 Pete O'Hanlon 9-Jan-07 4:11  True. I should be more careful with my grammar. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before. Re: What is "N" in OBJECTPROPERTY(id, N'IsUserTable') = 1) Rob Graham9-Jan-07 6:45 Rob Graham 9-Jan-07 6:45  Re: What is "N" in OBJECTPROPERTY(id, N'IsUserTable') = 1) Nick1977_209-Jan-07 17:39 Nick1977_20 9-Jan-07 17:39  Thanks a lot .Net 2.0 Table Adapter best practice Adam Crawford9-Jan-07 0:58 Adam Crawford 9-Jan-07 0:58  Hello, I was hoping someone could give me a bit of information on the way I should be creating / handling my table adapters. I have a persistant business object that is managing a number of database calls using a lot of different table adapters. The question I have is what the best practice is for creation of these table adapters. Is it better to persist a reference to each of my different table adapters over the life of my business object (i.e. create them all once, store them in class variables, then dispose of them all at the end) or is it better to create them as they are required (i.e a new table adapter created for each function call). If someone could give a bit of an insight into what a table adapter is doing in terms of the connections created for it during instantiation that would be most helpful in helping me decide the most efficient approach. Thanks for your help, Adam Re: .Net 2.0 Table Adapter best practice Rob Graham9-Jan-07 3:52 Rob Graham 9-Jan-07 3:52  Since each creation of a new table adapter will require one or more network round trips to populate the date, it is better to persist a reference as long as the data contained is not likely to become stale rapidly. The trade off is that keeping populated table adapters around can consume a lot of memory if the tables are large. Re: .Net 2.0 Table Adapter best practice Adam Crawford9-Jan-07 4:22 Adam Crawford 9-Jan-07 4:22  You seem to be inferring that each instance of a table adapter stores the data from the table in the application. Are you certain this is correct as I assumed that data was only retrieved once the Select function of a table adapter was called in order to fill a data table object? (It is possible that my orginal message was not clear enough and you thought I was referring to data table objects rather than table adapters) I always assumed that table adapters stored connection details for the appropriate database object - these are the resources I was hoping to find out about so that I can ensure my application is not leaving connections open inappropriately or unnecessarily hammering the database. Re: .Net 2.0 Table Adapter best practice Pete O'Hanlon9-Jan-07 4:36 Pete O'Hanlon 9-Jan-07 4:36  I'm not going to comment on Table Adapters as I don't use (like) them very much. However, you may want to look at using Query Analyzer to see what is happening with your connections (and queries). This tool is invaluable. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before. Re: .Net 2.0 Table Adapter best practice Rob Graham9-Jan-07 6:58 Rob Graham 9-Jan-07 6:58  NamelessParanoia wrote: ou thought I was referring to data table objects Yes, I was confused... Each call to Myadapter.Fill or Myadapter.Update will cause a network round trip. If you open the connection before calling Fill, then the connection will remain open, otherwise it is opened and closed for you. The data (and schema information) gets stored in the datatable/dataset. Fine Tuning of Query Sasmi9-Jan-07 0:56 Sasmi 9-Jan-07 0:56  Hi Guy's i am searching for the details about 'Fine Tuning of SQL-Query' can any one give me any good site or other details about this. I mean what steps are carried out to increase the performance of SQL Query? so the data will flow fluently please help me... Thanks in advance Sasmi Re: Fine Tuning of Query Pete O'Hanlon9-Jan-07 1:30 Pete O'Hanlon 9-Jan-07 1:30  In SQL Server, you can use the Query Profiler. Also, you will want to look at the execution plan for your query. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before. retrieving data from sql database rahulpasupuleti8-Jan-07 23:53 rahulpasupuleti 8-Jan-07 23:53  Hi.can someone help me in writing code for retrieving records from database table.i should get the list of records when the page of my web aplication is loaded. thanks in advance Re: retrieving data from sql database Colin Angus Mackay9-Jan-07 0:30 Colin Angus Mackay 9-Jan-07 0:30  Too vague. Have you attempted to search for a tutorial on ADO.NET? Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos Integrating SQL server 2005 Reporting Services into asp.net Application Sarath Vellampalli Babu8-Jan-07 20:28 Sarath Vellampalli Babu 8-Jan-07 20:28  How to Integrate SQL server 2005 Reporting Services into asp.net Application connected and unconnected layer groundzero1118-Jan-07 20:27 groundzero111 8-Jan-07 20:27  hi, what is the differance between connected and unconnected layer? I read a book that tried to explain that but I saw in the examples that in both layers the commands are the same and you can retrieve data insert data and so on. so what is the differance? Re: connected and unconnected layer Pete O'Hanlon8-Jan-07 22:39 Pete O'Hanlon 8-Jan-07 22:39  A connected system will keep the connection to the database open. Disconnected means that the data is read in to memory, and the connection is closed - if the data changes, a connection to the database is obtained to persist the change and the connection is closed again. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before. Despair :( - ODBC Behaves differently in COM+ Application [modified] BillyGoatGruff8-Jan-07 4:12 BillyGoatGruff 8-Jan-07 4:12  I have written a data access layer running under com+ Using the IBM Informix ODBC driver, I am able to select from a table with no problems, when I attempt to updtate the table, the error I receive is "Invalid string or buffer length" (all my googling seems to indicate that this message may have something to do with parameters) I have set up a test application that performs identical operations to the com+ app. These are: . Open Connection . Create a select command . Fill dataset adapter using select command and adapter . Alter 1 single field in a single row . Create an update command . Call adapter.update Now here's the weird thing. The test app works fine, the com+ app fails. When I compare the SQLTrace between the 2 applications. The test application which works, generates many, many more ODBC instructions than the failing com+ app. Each application is performing the identical workload through the same driver using the same the system.data.odbc objects. Does anybody have any ideas? I've been banging my head against this for a while now and have no idea what to try next. Much thanks. -- modified at 3:35 Wednesday 10th January, 2007 Re: JOY (: - ODBC Behaves differently in COM+ Application BillyGoatGruff10-Jan-07 0:27 BillyGoatGruff 10-Jan-07 0:27  The bug was caused by me having only one pair of eyes. Adding another 2 eyes to the code revealed... That If you use the ODBCParameter object, and the sourceColumn property contains a leading space... Things don't work. Same Username Dayekh8-Jan-07 4:12 Dayekh 8-Jan-07 4:12  Hi, I want to prevent the admin from being able to store 2 user records which both have the same username. So far, I have pupulated a Dataset variable with the details, but I am unable to work it into an IF statement. Any suggestions?? Thank you Re: Same Username Mark J. Miller8-Jan-07 6:10 Mark J. Miller 8-Jan-07 6:10  Have you tried ?: string sql = @' IF NOT EXISTS(SELECT * FROM foo WHERE user = @username) BEGIN INSERT INTO foo (user) VALUES (@username) SET @Success = 1 END ELSE BEGIN SET @Success = 0 END'; bool bSuccess = false; using(SqlConnection conn = new SqlConnection("connection string")){ SqlCommand cmd = new SqlCommand(conn, sql); cmd.Parameters.Add("@username", SqlDbType.Varchar, 50); cmd.Parameters.Add("@Success", SqlDbType.Bit); cmd.Parameters["@username"].Value = DataSet.Tables[0].Rows[0]["Username"]; cmd.Parameters["@Success"].Direction = ParameterDirection.InputOutput; conn.Open(); cmd.ExecuteNonQuery(); bSuccess = (bool) cmd.Parameters["@Success"].Value; } if(!bSucess) { //tell the user } saving dynamically mohd imran abdul aziz8-Jan-07 3:10 mohd imran abdul aziz 8-Jan-07 3:10  Dear All, I am bit new to this programmming world. Currently i am making web application using C# ,asp.net and sql. in a web page there i have listbox with multiple selection option. now with single option i am able to save the form data. but problem occur when there is multiple option. as i am confuge with how can i based on selection (no of selected data). i can save the record. please guide me. thanks regards imran khan Re: saving dynamically Colin Angus Mackay8-Jan-07 3:23 Colin Angus Mackay 8-Jan-07 3:23  I don't understand what you are trying to insert into the datbase. You have not said which database you are using (SQL is a languge that is used by pretty much all relational databases - Did you mean SQL Server?) If you can give the code you currently have it might also help because there are many ways to put data in the database. Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos Re: saving dynamically mohd imran abdul aziz8-Jan-07 3:45 mohd imran abdul aziz 8-Jan-07 3:45  thanks for quick responce, Actually there is agent master where i need to capture or display agent name, Services he provides(listbox with multiple select option) and which branch he belongs to corresponding to agentid. Fine . Now One agent can provides any no. of services. so i have provides listbox with multiple select option. i need to save all this information. my problem is how based on no. of selected listbox data. how can i save the all record. rightnow i saparated this infomation to two table. in one table i am saving agentid, agentname, branchid, in other table i am saving service no of service. but i am confuged... in 1> how can i retrieve listbox data on save button.especially when there is nultiple records. 2> how can i display it back on edit command and save the changes. i am using sql2000 along with asp.net and C# please guide me thanks regards imran khan Re: saving dynamically nagendra rao s.v.9-Jan-07 5:50 nagendra rao s.v. 9-Jan-07 5:50  Hai, Here are the Steps. 1)declare a string strListOptions=""; 2)Now Iterate through the ListBoxItems foreach(ListItem li in lbServices.Items) { if(li.Selected) { if(strListOptions.length>0) { strListOptions+=","+li.Index.ToString(); } else { strListOptions+=li.Index.ToString(); } } } 3)Save the Agent Data and Return the AgentID. 4)Save the Services Altogether or individually in the Services Table with the AgentID. While Retriving: 1)Loop through the records and loop through the list items and select the corresponding indexed listItem. If you have any problem let me know. You need to modify the same according to your conditions.

Last Visit: 31-Dec-99 18:00     Last Update: 4-Jun-24 10:32 Refresh ᐊ Prev1...1708170917101711171217131714171517161717 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.