Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Paging the results coming from a GridView binded arrayList
Lorenzo - 17 Dec 2005 3:18 PM - 1 message
Hello there, I am trying to enable paging on a GrdView control that I have binded to an ArrayList.  It is not automatically enabled and I couldn't find much on the web. Any hint? Lorenzo ...
Score Paging the results coming from a GridView binded arrayList
Lorenzo - 17 Dec 2005 3:13 PM - 1 message
Hello there, I am trying to enable paging on a GrdView control that I have binded to an ArrayList.  It is not automatically enabled and I couldn't find much on the web. Any hint? Lorenzo ...
Score Paging results from an array binded to a GridView
Lorenzo - 17 Dec 2005 2:58 PM - 1 message
Hello there, I have an array that might return over 100 "records"  on a GridView control. How can I enable paging ?  It is not supported automatically and I was wondering if there is a convenient way to do it. ...
Score Paging results from an array binded to a GridView
Lorenzo - 17 Dec 2005 2:20 PM - 1 message
Hello there, I have an array that might return over 100 "records"  on a GridView control. How can I enable paging ?  It is not supported automatically and I was wondering if there is a convenient way to do it. ...
Score Data Repository Class Vs WebService
Dave Johnson - 17 Dec 2005 11:41 AM - 3 messages
My ASP.net 1.1 online cinema reservation system is Developed in 3 Tiers: 1-DataAccessTier "Data Repository Class" 2-Business Tier "Set of Business Classes" 3-Presentation Tier "set of WebUserControls & aspx pages" if i want to make a WebService that enables its users to interact with ...
Score How to delete thousands of SQL records
ChrisH - 17 Dec 2005 7:50 AM - 7 messages
Hello, I need to delete thousands of records from two SQL tables, but the rows are not contiguous.  There is a unique numeric id for each row (clustered index), and my input is a file containing at least a ...
Score Q: DataAdapters and Global WildCard Searches
JohnT - 17 Dec 2005 6:42 AM - 3 messages
Okay... I'm using VB.net (2003) and I am accessing an MS Access DB file. I have two DataAdapters that I use to search for specific info.  The two of them are similar except one is a Date, the other is a String. ...
Score why code for datagrid doesn't work
jonefer - 17 Dec 2005 6:17 AM - 2 messages
I have confirmed that the following SQL string works in Access: SELECT[MRN],[MemNAME],[DOB],[SEX],[SSN],[GROUP],[SGR],[FROM-DT],[THRU-DT]FROM MEMBERSHIP WHERE [MemName] like 'duld*'; I have also confirmed that it is successfully passed as a Public String ...
Score load datatable as source for reportviewer
James Martin - 17 Dec 2005 1:46 AM - 4 messages
Hello, I have created a class that accepts a text file as input. The file is parsed and a data table is returned. I then take the data table, load it into SQL, and create a local reportviewer instance from a query on the SQL table. I ...
Score DataAdapter Fill method SLOOOOOW
Rene - 16 Dec 2005 11:31 PM - 12 messages
What happened??? I just upgraded one of my 2003 projects to VS 2005 and now, when I call the Fill method of an OleDbDataAdapter passing a DataTable as a parameter it takes a heck of a lot longer that it used to. ...
Score VWD DetailsView' does not allow indexed access.
barret bonden - 16 Dec 2005 10:39 PM - 1 message
Trying to get a value from a Visual Web Developer data control - and place it in a textbox (Hope I'm not in the wrong group here - ttrying to get into the VWD forum for 2 days now - NG) <script runat="server"> ...
Score Nested CLR Stored Procedures
Robert Zurer - 16 Dec 2005 10:15 PM - 4 messages
I don't know id this is ADO but the SQLServer.clr newgroup is not in the managed groups list so sorry if I have misposted I  have an one clr stored procedure that would like to call from another ...
Score asp.net and oracle 8i connection problem
saleryan - 16 Dec 2005 9:47 PM - 5 messages
hi.. i'm trying to connect to oracle 8.1.7 in asp.net using integrated security but i'm always getting a ora 01017 invalid username/password. logon denied message. my web application is running on iis on windows xp professional. ...
Score problem with merge and new row
Paul Delcogliano - 16 Dec 2005 9:25 PM - 3 messages
Hi All, I think I am mis-understanding something about the DataSet's Merge method. I am getting changes from my DataSet and storing them in another DataSet called changes. I then pass those changes to the UpdateDataset method of the ...
Score Updating a DataColumn after ImportRow
joeblast - 16 Dec 2005 8:36 PM - 6 messages
Creating a new dataset from an existing one using ImportRow works just fine but when I want to modify the DataColumn of the imported rows inside the new dataset I always get an error saying that the column is read-only ?!?!?! ...
Score Deadlock error
Jaiganesh - 16 Dec 2005 7:06 PM - 2 messages
"Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source = .Net SqlClient Data ProviderSource" Sometimes I get the above mentioned server error while doing a transaction ...
Score export to word w/Images
rbutch@coair.com - 16 Dec 2005 4:23 PM - 1 message
I want to export a report on a web page to word in asp.net. all the elements are in a Panel. there is a problem with the image. i've had no problem exporting grids,repeaters,lablels etc to word or even excel, but the images just dont go at all. ...
Score DataAdapters and Parameters
jonefer - 16 Dec 2005 4:16 PM - 9 messages
I'm creating a simple search for Members, with possible 4 search parameters: Name, SSN, DOB, SEX, but (just beginning ASP.NET/VB.NET) I'm fearing that I will need to create a dataadapter for every possible combination of fields ...
Score ADODB data adapter problem
Steve Marshall - 16 Dec 2005 3:49 PM - 7 messages
Hi all, I am building a VB application which uses quite a few data adapters.  All was going fine, then suddenly for one of them the wizard refused to generate some of the SQL statements for manipulating the data.  Anyone know why it ...
Score Object reference error when using OleDbCommand object
Sunil Menon - 16 Dec 2005 2:48 PM - 4 messages
Dear All,    We have created a WinForm application that uses OLEDB to connect to Oracle DB. The Oracle client version is 8.1.6 and the Oracle DB version is 10g...sometimes we randomly get errors like <Object reference error> ...
Score Error handling with datasource and gridview
Dorte - 16 Dec 2005 12:52 PM - 2 messages
Hi, I use the new datasource and gridview controls to present data - without writing a single line of code...But what about error handling? If there is access denied to the SQL server, if the stored procedure that is called does ...
Score How to update a view with two detail table
ad - 16 Dec 2005 12:18 PM - 2 messages
I have a view, it is create by one primary table and two detail tables, like SELECT St.GuyID, WH.Weight,WH.Height, Sight.SightL, Sight.SightR FROM St,WH, Sight  where WH.GuyID = St.GuyID and Sight.GuyID = St.GuyID ...
Score DataSet.Merge() does not merge row and/or column errors in any cas
Hans Weber - 16 Dec 2005 8:21 AM - 3 messages
I save changes from a dataset and get them with tempDataSet = myDataSet.GetChanges() I validate the changed rows and if I find an error, I mark the row with tempDataSet.DataTable.Row[..].SetColumnError(...) coming back from validation, tempDataSet.HasErrors is true, that's ok. ...
Score Inverting the DataRelation nesting order for XmlDataDocument?
Roger W. - 16 Dec 2005 7:43 AM - 2 messages
Hi, I'm trying to use the XmlDataDocument to allow Xpath queries of relational data I've loaded from a SQL database (in VC#2005 / SQL2005). I have loaded a DataSet with the proper tables, created their relationships, and set them to ...
Score Select multiple table in 1 stored proc
Brandon Fraser - 16 Dec 2005 5:19 AM - 4 messages
Hi All, Does anyone know how to do this or give an idea how can I achieve this using DataSet and ADO.NET For example I have 2 table relationships. Table1 -> Customer Table2 -> CustomerOrder The name should be pretty much self explanatory. I want to create a stored ...
Score System.Transactions and SQL 2000
Michael - 15 Dec 2005 10:29 PM - 9 messages
Hi, For this to work, does the SQL server 2000 also needs Framework 2.0 runtime installed?  I'm getting the "Network DTC is disabled" exception even the setting is enabled on the SQL Server. Thanks Michael ...
Score Determing which column is identity column
Doug - 15 Dec 2005 9:20 PM - 5 messages
Hi, I am querying the database and sticking the results into a datatable. It would be helpful though if I could determine programmatically which column in that datatable is the identity column (if there is one).  Is there a way to do this? ...
Score visual web d and Access
barret bonden - 15 Dec 2005 8:09 PM - 3 messages
(perhaps the wrong NG -) the DB tools in VWD dont pick up on the autonumber key field in Access (they edit fine) - the key field is not displayed, but neither is it updated and so of course "add" bombs - ...
Score Problems with creating a new table using ADOX
juvi - 15 Dec 2005 5:12 PM - 4 messages
Hi, I have got a problem with creating new tables using ADOX. If I want to append a single table to the db then it works fine. But how can I append more then one table? thx juvi ...
Score Loop thru dataset for running total
coolburn - 15 Dec 2005 2:41 PM - 4 messages
I've run into this problem twice now and haven't quite figured out how to approach it properly.  I'm using ASP.NET 1.1 and C# to develop a reporting package.  Some of these reports are showing a daily total amount.  There has ...
Score Oracle 8.1.7 client and Visual Studio 2005 connection problem ORA-12537
henkka - 15 Dec 2005 2:27 PM - 2 messages
I have a problem connecting to an Oracle database. On my own desktop I run Windows XP SP2, Visual Studio 2005 and Oracle client 8.1.7 with the 8.1.7.1.5 patch. I can connect to the database using SQLPlus (username ...
Score Income for life
sixgun11 - 15 Dec 2005 11:30 AM - 2 messages
Your own web domain plus income for life. Wish you had a dollar for every dot com address? Dont miss out!! http//:[link] ...
Score search with probability
Pieter - 15 Dec 2005 10:33 AM - 4 messages
Hi, I need some search system, that will return me the records with in indicator of probability. This is for a VB.NET 2005 application with a SQL Server 2000 DataBase. I have a table with different columns in which the user needs to search. In ...
Score Custom Column Validation or DataGrid Cell Validation
Stanislav Nedelchev - 15 Dec 2005 10:28 AM - 1 message
Hi to all , How can i implement some custom constraint or to make make some validation of cell in DataGrid. for example i shave 2 tables and i must check in detail table if one column is unique only for some related record no all records to be unique. ...
Score ado.net, connection pooling, and leaked connections
matthew_glen_evans - 15 Dec 2005 9:19 AM - 9 messages
Hi, I have inherited some legacy code with performance issues: I ran perfmon on the problematic use case, with a counter on .NET CLR Data / Current # Pooled connections (amongst others) I noticed that while performing a set of tasks in the use case, pooled ...
Score Maximun length of parameter name in oracle
Popman - 15 Dec 2005 8:47 AM - 2 messages
Hi guys, I met a issue that is about the lenght of the parameter name. I'm using Oracle as back-end database, though I'm not familiar with oracle. I'm using the following code to pass a parameter: ...
Score Do servers automatically return dates in local time zones?
Randall Parker - 15 Dec 2005 4:12 AM - 4 messages
Do most RDBMSs know that they have their data in time zone X (whatever that is) but adjust to the time zone of a client that connects to them and return dates adjusted to that client's time zone? Does ADO.Net communicate client time zone info to the server as part of a database ...
Score The difference of TableAdapter
ad - 15 Dec 2005 2:58 AM - 2 messages
Hi, TableAdapter is a new feature of VS2005. When I design the DataSet (named MyDataSet)  in WinForm Application, it will generate 4 file: MyDataSet.xsd, MyDataSet..xss, MyDataSet.xsc, MyDataSet.Desginer.cs. But if I desgin the DataSet in Web Applicaiton, it only generate two file: ...
Score Each command uses two connections?
Michael - 15 Dec 2005 12:24 AM - 4 messages
Hi, After running the code:    SqlConnection conn = new SqlConnection("server=.;database=Northwind;uid=sa");    SqlCommand cmd = new SqlCommand("select * from Customers", conn);    conn.Open();    SqlDataReader dr = cmd.ExecuteReader();    dr.Read(); ...
Score varchar or nvarchar
tascienu - 14 Dec 2005 10:54 PM - 3 messages
When i get a dataset from db, and I check the dc.DataType.Name value of a column, it gives me "String" for that particular column. How do i know if that String is a Varchar or nVarchar? Thanks. ...
Score SQl Provider Data type map.
Ashish - 14 Dec 2005 10:47 PM - 1 message
does anyone knows the map of data types between sql server and .net ? TIA ...
Score Can we use WinForm DataSet in WebForm
ad - 14 Dec 2005 10:14 PM - 2 messages
I designed a DataSet in a WinForm Applicaiton in VS2005. I use the new feature of TableAdapter of VS2005. The name of that DataSet is WH, and the files create by VS2005 are WH.xsd, WH.desginer.cs, WH.xsc, WH.xss. ...
Score Working, sorta...drop down list
zamdrist - 14 Dec 2005 8:46 PM - 5 messages
I have an ASPX codebehind webform with two drop down lists. The first code below gets data and populates the ddl. The second (ddlGroups) fails and I cannot figure out why. I checked the permissions of the stored procedure, even ran it via query analyzer. ...
Score Databinding problem with sqlhelper.executereader and a dropdownlist in VB.NET
nicolas.neuilly - 14 Dec 2005 7:51 PM - 1 message
Basically, I have a DropDownList control on a page that inputs a string into a database. The user can later go back to the same page in "update" mode to make further changes. So what I need to do is pull the ...
Score dataset to 'flat' xml
gerry - 14 Dec 2005 7:22 PM - 3 messages
Hi , I have a dataset that was populated via ReadXml where the source xml contains nested tables. When I write the dataset back out with WriteXml I get the same hierarchical ( nested ) document structure as was present in the source document ( as ...
Score Executing OleDBConnection.Open erases the password from Connection string
RZavulunov - 14 Dec 2005 6:15 PM - 3 messages
I have just stumbled upon this fact. My scenario is the following: data from a table in Oracle. In the same call, i do another retrieve using the same connection object. The second retrieve crashes becuase there is no password in the  ConnectionString. My debugging showed me ...
Score No Solution still for Saving DataView back to DataSet?
Kimkhoa.Tran - 14 Dec 2005 5:32 PM - 3 messages
HI everyone, i'm so stress out because something so simple but i can't figure out how to do it. I have a dataset name ds (typed dataset), side that ds contains a table name Employee. ds.Tables["Emploee"].Columns["City_Fk"] ...
Score newly added record not showing up
Stephen - 14 Dec 2005 3:54 PM - 4 messages
I posted this on the msdn forums but wasn't having any luck.  I am using Visual C#, .Net 2.0, and SQL Server Express (soon to be ported to SQL Server). I have a dataset, binding source, and table adapter used in a form.  I ...
Score Windows application working against Oracle DB trought web services
otto - 14 Dec 2005 3:48 PM - 2 messages
Hi, all: We have a Windows application that make operations against an Oracle database. The business logic components are in the server and are accesible from the client interface trought a WebService. The business logic components call the data access layer components and obtain the results. tha problem is ...
Score Multiple database access
James Jenkins - 14 Dec 2005 2:53 PM - 3 messages
Hi, I am new, I have a c# app that uses a mdb file for holding statistics, these stats are dumped into the mdb from one process every minute, and obtained from another process periodically ( at the users call) which then ...
Score Cinema System-uptodate info from database -asp.net
Dave Johnson - 14 Dec 2005 1:43 PM - 2 messages
i am doing online cinema reservation project, and i have this problem in the Reservation Process, i want the user to always experiance a Fresh version of the Seats avaiable for him to book, the problem is divided into 2 parts : ...
Score DataSet Editor - migrating DB changes to a Typed DataSet - a Re-Sync button maybe??
Dotnet Gruven - 14 Dec 2005 12:40 PM - 5 messages
Is there a trick to keeping a Typed DataSet in sync with the underlying database other than either manually making the changes or deleting and adding the table back? For example, I've created a Typed DataSet with about 10 tables, each table ...
Score Q: Improvements in VS2005?
Geoff - 14 Dec 2005 11:30 AM - 5 messages
Hi Can anybody tell me if there has been any significant improvement in the speed that rows from a dataset in a client can be transferred i.e. updated, to a database on a Server? The reason I ask is that using VS2003 I have created a dataset via a table ...
Score DbProviderFactory - Problem or Not
Vladica Ognjanovic - 14 Dec 2005 10:56 AM - 3 messages
First - English not so good. I need a list of all database servers in my domain and I use code like DataTable table = DbProviderFactories.GetFactoryClasses();             foreach (DataRow row in ...
Score Memory Build Up
Manjunath s via DotNetMonster.com - 14 Dec 2005 8:57 AM - 10 messages
Hi, I am executing a set of semicoln sperated commands through ExecuteNonQuery, the query length is about 10000 characters comprising of 200 repeated command (identical command operating on different record ids). Each time the ExecuteNonQuery is called the memory is increasing by few mega bytes. Since I ...
Score update blocks
a moreno - 14 Dec 2005 8:32 AM - 1 message
i'm using dataadapter to get data from tables then i use 2 different ways that both are blocking execution without any error. 1 - command execution 2 - update using the data adapter. i might have some locking on tables (i'm also using enterprise services ...
Score DatgridView like in SQL 2005 Management Studio
drinkwater - 14 Dec 2005 4:09 AM - 2 messages
In SQL 2005 management studio, when you open a large table the grid displays the rows in the grid asynchronously, you can manipulate the result grid while all the records are being loaded...Anyone know how to achieve this in VB.NET ...
Score connecting to sqlserver express
Bob - 14 Dec 2005 12:33 AM - 10 messages
I installed SQLserver express as well as VS2005 Standard. I know the database server is functioning correctly since I can manipulate it with the sqlserver express tools. However when I try to connect to the server in VS either programatically or through the server tools I get the same unfortunate error ...
Score CrystalViewer Export - only one page
rbutch@coair.com - 13 Dec 2005 9:47 PM - 1 message
im pushing a dataset to a Crystal report in an asp.net web application and it works just fine. i can also export in word,excel or pdf formats, however, if the report has multiple pages - i only get one page. ...
Score How to connect a remove SQLServer 2005 with instance name
ad - 13 Dec 2005 7:05 PM - 3 messages
I have install e SQLServer 2005 in another machine with a specific instance. The server name is Server1 and the instance name is MyDatabase. When I wnat to add a new ODBC datasource, I enter Server1\MyDatabase as server in the Wizard, but it say that "The server does not exist" ...
Score Increment a Rowcounter in ADO.NET 2.0
Friedhelm Drecktrah - 13 Dec 2005 6:16 PM - 4 messages
Hi, I have an integer rowcounter column in a Table and I want to incremented it after AddRow. AutoInc is not possible, because I want to change it later. RowChanged doesn't seem to be the right place. Is there any OnAfterInsert ...
Score Databinding practice
Jon - 13 Dec 2005 2:37 PM - 4 messages
We're taking our VB 6 application, which uses RDO and moving it to .Net 2.0. We're doing this by recreating each form from the ground up, not using the upgrade wizard.  Our application has about 200 forms and our database has ...
Score ADO.NET 2.0 vs ODBC
PieterM - 13 Dec 2005 12:31 PM - 8 messages
Hi, In my company we are currently using ODBC and i would like them to switch over to ADO.NET 2.0. Unfortunatly i can not find a document with any good reasons. I know that datasets, datareaders, ... are more userfriendly but how ...
Score Excel Like AutoFilter For Datagrid (urgent)
Jon B - 13 Dec 2005 5:24 AM - 6 messages
Hi Everyone! I'm in need of help again! I'm just wondering if WinForm DataGrid can have Excel like AutoFilter? Here's an example: [link] But again, this only in ASP.NET DataGrid. ...
Score SQL Server 2005 and ADO.NET 1.1?
STeW - 13 Dec 2005 1:11 AM - 4 messages
Is possible to connect to SQL 2005 from ADO.NET 1.1? I need to migrate our system from SQL Server 2000 to SQL 2005 duo license politics in our client company. I need to know if is possible to connect to SQL Server 2005 using ...
Score Multilingual and ADO
Jon - 12 Dec 2005 7:44 PM - 1 message
I'm working on a multilingual .Net 2.0 application.  There is an optional parameter for a SQL Server connection string, "Regional". Should I be setting this to Yes?  Or should I only be doing conversion stuff on data in my VB app? ...
Score Data Adapter Update Method
Yossi And Inbar - 12 Dec 2005 7:09 PM - 3 messages
Hi, I am using SqlDataAdapter and i want to do just the delete update to delete child table and after that i want to do the InsertCommand and etc... So how can i choose to do Insert Or Update or Delete not with ...
Score How to use ADO fast?
ARTMIC - 12 Dec 2005 5:56 PM - 19 messages
Hello, does anyone have any opinions on data access functionality ? What is the best way to use the data access components inside of Visual Studio? Do we drag and drop the components on the screen and link them to the ...
Score Convert System.Transactions.Transaction.Current to System.Data.Common.DbTransaction?
Tim Cartwright - 12 Dec 2005 4:46 PM - 2 messages
I have been trying to figure out a way to convert System.Transactions.Transaction.Current to System.Data.Common.DbTransaction with no luck so far. Is this even possible? I am using the Enterprise Library, and several of their calls take in a transaction, but it is of type ...
Score How to create a BLOB column in a typed dataset ?
Igor Dombrovan - 12 Dec 2005 4:06 PM - 1 message
Hi group Any idea how to do %subj% in VS2005 ? Thanks, Igor ...
Score Cannot connect to local SQLServer2000 database
Paul Robinson - 12 Dec 2005 3:06 PM - 8 messages
Hi, I am having problems connecting to a local SQLServer2000 database using ADO.NET.  I am using a 3rd party assembly which I have no control over, and the database connection string is hardcoded into the application (nice). The connection string looks like this: ...
Score DataSet Row = null even after a successful FindByProgramID
Rock - 12 Dec 2005 1:46 PM - 4 messages
Any clue to why this newRow call sets "programSelected" to null no matter what I have tried? Further explanation, this function resides in a form2 which I have been able to give access to form1's (MainWindowReference's) public or internal ...
Score Total Muffled
MC - 12 Dec 2005 1:45 PM - 1 message
Hi all Complete newby trying to understand something I have made my own form with some fields and then dragged a SqlDataSource onto the page and made an Insert to go with the SqlDataSource. I have a button which calls this ...
Score Do I really need to dispose of all DataTables?
David Smith - 12 Dec 2005 1:41 PM - 9 messages
Pretty straight forward question, right? I'm asking because this is one of the recommendations I'm getting from VSTS code analysis. My problem is that I have a pattern of code sprinkled throughout much of my business layer where data access code calls static methods that, in turn, ...
Score Export Gridview to Excel
rmcquade - 12 Dec 2005 1:21 PM - 1 message
I am trying to export a Gridview to Excel. I am using DB2, not SQL. All the examples I have found have me running around in circles. Can anybody tell me how to do this. -- rmcquade ------------------------------------------------------------------------ rmcquade's Profile: [link] View this thread: [link] ...
Score Creating Databases in VB.net
trivender - 12 Dec 2005 10:44 AM - 2 messages
Hi, I am developing a web application in ASP.NEt (VB.net) which runs on SQL server as a backend database. I want to create a standalone database creation utility (not web based). The database creation utility should be a standalone EXE file which can be executed to create a new ...
Score retrieving int32 column with ODP.NET gives InvalidCastException
Andy Fish - 12 Dec 2005 9:54 AM - 1 message
Hi, I'm in the process of converting an ado.net application to work with ODP.NET. I have a column defined on the Oracle database as "int". however, when I call reader.GetInt32Value() it gives me an InvalidCastException and I can ...
Score Build asp.net application under VS2005 environment
sherrylso - 12 Dec 2005 8:40 AM - 2 messages
Hi, all I have developed my asp.net application in Visual Studio 2005 IDE. It is well known that the Visual Studio 2005 IDE is based on framework.20, but I want to know, whether it is feasible to use framework1.1 to build my ...
Score Edit Items in a WinForm DataGrid control
Jon B - 12 Dec 2005 4:47 AM - 2 messages
Hi All! I would like to make my WinForm DataGrid control so that user could easily edit the items in the **related table**. For instance, I have customers table and it has one-to-many relationship with the customerType table. I would like the WinForm DataGrid to display a ...
Score How to design Dataset schema from sproc w/multiple tables?
C. Cordova - 12 Dec 2005 1:42 AM - 1 message
In VS2003, I could drag a stored procedure from the Server Explorer into the dataset designer and generate an XML schema for all tables returned from the procedure.  VS2005 will only generate a single table schema using this process even though the procedures return multiple tables. ...
Score DataView.Rowfilter performance
Joe - 11 Dec 2005 9:12 PM - 6 messages
I have a RowFilter which is doing a not in (). The not in contains 600 items for a single column. For example RowFilter = "ADate not in (600 DateTimes)". This takes several seconds to run. Is there a better way to handle this? ...
Score Add to a database of a 2nd Form
DINESH PATEL - 11 Dec 2005 5:43 PM - 1 message
I have no problems adding, deleting or editing data from a database when these functions are on the 1st form. I need these functions on the 2nd form though, as the 1st form will be a Menu screen. Public Class Form2 ...
Score Using Session object to store dataset
Kim - 11 Dec 2005 10:34 AM - 12 messages
I have a datagrid which enables paging and the data is displayed in it when user selects an item from a drop down list. The code for populating data into the Datagrid is contained in the DropDownList1_SelectedIndexChanged event handler. The Datagrid can only ...
Score Lookup columns in typed datasets
Zoltan Hubai - 11 Dec 2005 10:23 AM - 4 messages
Hi Is there a way to create lookup columns in tables in the typed datasets? Like CityTable ---------- CityID CityName Employee -------- EmployeeID EmployeeName City -> foreign key to CityTable.CityID CityName -> lookup column, will get the value from CityTable according ...
Score Code reuse & SQL CLR
saarcarmi - 11 Dec 2005 8:16 AM - 2 messages
Hi How can I determine whether my code is ran from within the sql server or not? I want to write a block of code which opens a connection to the DB - using a context connection if it resides in the SQL process and regualr ...
Score help with user types in schemas.
rossu - 11 Dec 2005 2:51 AM - 4 messages
I have an xml file where the top level units have the form <a>    <a1>1</a1>    <a2>1</a2>    <a2>2</a2> ...
Score Data Repository Class & OOP Inheritance
Dave Johnson - 11 Dec 2005 1:16 AM - 2 messages
I have made a Data Repository Class that holds all the Methods for the Objects that i use in my System such as Order,Client,etc Example for what i want to do: In the Client Class I want to inherite ...
Next »