| DataTable Index (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngstart] to [aspngdata] by Marcie Jones marciejones@yahoo.com Hi All, how can i Add an index to created datatable inorder to increase the performance when selecting from the table dtblSpringNet New DataTable() dtblSpringNet.Columns.Add(New DataColumn("Date", GetType(DateTime))) dstSpringNet.Tables.Add(dtblSpringNet) If dstSpringNet.Tables(1).Select("Date #" & drowAppointment("date")... |
|
| Want to know performance of CommandType missing on SP. (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Can anybody tell me what the difference between these two methods are (missing the command type)? I was helping somebody and realized that in the "old" days of asp3, SQL Server recognizes you are running a stored procedure anyway. a) MyCommand New SqlDataAdapter("spMySecretSP", MyConnection) MyCommand.SelectCommand.CommandType CommandType.StoredProcedure DS new DataSet() MyCommand.Fill(DS, "Produc... |
|
| Parent / Child Dataset Update. Is there an easier Way? (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, This question boils down to, "Is ado.net smart enough to use scope identity and automatically write code to handle parent/child updates?" that said, I have a screen where Parent rows can be dynamically added to a dataset, then after the parent row is added child's can be attached to that row. (before saving to the db) Parent Row Child Child Child I set the ParentID column AutoIncrement True, A... |
|
| Is the ListBox, ComboBox bindable in ASP? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I tried the simple examples of binding a SqlDataReader to a ListBox control on an ASP page as illustrated in the doc. However, I get a list full of "System.Data.Common.DbDataRecord". Most of the examples use DataAdapters and Fill to construct DataSets, but I was lead to believe that the DataReader was bindable in an ASP Web Application. The code works fine with the DataGrid control. Bug? Mydatarea... |
|
| I am trying to convert my VB script to C# here are the line that are the culprit (6 replies) |
| ASPFriends.com 'aspngdata' list |
| I am trying to convert my VB script to C# here are the line that are the culprit // in VB the failing line was like this // Dim parameterSearch As SqlParameter New SqlParameter("@Search", SqlDbType.NVarChar, 255) parameterSearch SqlParameter New SqlParameter("@Search", SqlDbType.NVarChar, 255) parameterSearch.Value Request.Params("txtSearch"); myCommand.Parameters.Add(parameterPortalID); Descripti... |
|
| SV: I am trying to convert my VB script to C# here are the line that are the culprit (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I am by no means a C# expert, but : 1: Aren't you always supposed to use square brackets in C# parameterSearch SqlParameter New SqlParameter["@Search", SqlDbType.NVarChar, 255)]; and also, I though that using the semicolon after each statement was also standard procedure. Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malmö Sweden Tel.: 46 (0)40 97 78 8... |
|
| are timestamp columns automatically updated ? (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Are timestamp columns automatically updated or do I need to create my own trigger events. Does anyone have links to articles on how to manipulate timestamp columns to implement optimistic concurrency ? NextPart 000 0009 01C226AC.EF197A90 |
|
| Are records locked during update, insert and delete (4 replies) |
| ASPFriends.com 'aspngdata' list |
| ARe records locked during inserts, updates and deletes ? I know that they are if I put them inside transactions, but are they if I don't ?? Also, what happens if the two users try to lock the same record at the same time. Is it first come first serve, with the later one waiting, or is an exception thrown. If so, what exception is thrown ?? Does anyone have any information on this ??? Is it always ... |
|
| SQL Query multiple table join (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Michiel van Otegem mvo@mail.aspnl.com Can someone tell me what is wrong with this in ASP.net? I keep getting an error "Incorrect syntax near 'dc'." Note: all of the first Select statement line is on one line, which is why I don't have any & in there. "An unhandled exception occurred during the execution of the current web request. Please review the st... |
|
| Can't connect to remote SQLServer FROM .NET? (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Yannick Smits dotnet@stepcompany.com Hi all: I have a really pressing issue we've been struggling with here. We have a .NET application. It connects to a database on OurPC1. When the application itself is running on OurPC1, it connects to the SQLServer just fine. However if we run a build of the same application on OurPC2, it cannot connect find SQLSe... |
|
| XmlNodeList to DataSet, DataGrid, DataBind, etc. (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Michiel van Otegem mvo@mail.aspnl.com I had such as hard time looking for a good XmlNodeList to DataBind sample that I decided to publish my findings in case anyone runs into the same problem I did, here ya go ;) Dim xNodeList As XmlNodeList "Your XmlNodeList Here!" Dim ds As DataSet New DataSet() Dim xReader As XmlTextReader For x 0 To xNodeList.Coun... |
|
| data set merge (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [ngfx sqlclient] to [aspngdata] by Yannick Smits dotnet@stepcompany.com WHen I do a merge of two datasets with the same table in each of them I get the result of the orginal dataset. Ok let me expline dataset1.table1 has three fields id,name,state dataset2.table1 has three fields id,name,state now I want to merge dataset2 into data set1 dataset2.merge(dataset1) now the values for datase... |
|
| records (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Tim Musschoot Tim.Musschoot@rug.ac.be hi how do i get the number of records returned by a query in asp and ouput the result: eg. query returned 50 records ? thanks eoghan |
|
| IsDefined (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Anyone out there that knows Coldfusion as well, I need the .net equivalent. I'm trying to read from a objDataReader4.Item("myName") and it says there's no data there. I think I need to do an equivalent of IsDefined("") around it. Anyone know? Mike Collins *********************************************************************** NOTICE: This e mail message and all attachments transmitted with it may ... |
|
| Fill dropdown with dataset items (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Tim Musschoot Tim.musschoot@rug.ac.be Hi I am binding a html drop down list to one typed dataset that I fill somewhere else. I call the fillddnParts() in the onload event of my page. I have the html control named ddnParts in the aspx page with the directive runat server. Is there something else that I must Do. protected System.Web.UI.HtmlControls.Html... |
|
