Displaying Enumerated DB Integers as Strings In DataGrid

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Getting changes from the database I'm using a DataAdapter to Update and Synchronize with the database. When I do a Fill on my dataAdapter I get the changed and new records from the database (changed by other users) into my dataset but not those which have been deleted at the database. Is this the way the DataAdapter should work (don't synchronize the deleted records from the database to the dataset) or is it my fault? If this is the way the DataAdapter act's what can be done, do get completely in synch? If I do a clear on my dataset before invoking the Fill method, my databinding get's lost for a Moment, because the dataset is completely rebuild. Thanks. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77703
  - 2
    - insert decimal in Access Hallo Im learning VB.net 2003 and now I like to insert a decimal in Access, but the number 10,25 is in Access 1025. The Access field is also decimal with 2 digets behind. I think it will be on the regional settings, because whenn I try with 10,25 then it works. But my variable is always format as 10,25. What must I do? Can anyone help me? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77691
  - 3
    - Datareader passed ByVal - OOP Basics question Hi All, I've a big doubt about reference to object destruction. In the test below I call 2 times a sub passing a datareader in 2 different ways. Who can tell me if datareader is destroyed in both cases and so connection closed (using dr behavior)? *-*-*-* Case 1 *-*-*-* Dim cm As SqlCommand Dim dr As SqlDataReader = cm.ExecuteReader(CommandBehavior.CloseConnection) ' Datareader is passed ByVal to MySub ' I have to close "dr" here and "otherdr" in MySub MySub(dr) dr.Close() dr = Nothing *-*-*-* Case 2 *-*-*-* Dim cm As SqlCommand ' No reference to datareader exist (?) at this level, ' I have only to close "otherdr" in MySub ? MySub(cm.ExecuteReader(CommandBehavior.CloseConnection)) *-*-*-* MySub *-*-*-* Sub MySub(ByVal otherdr As SqlDataReader) While otherdr.Read ' Do something End While otherdr.Close() otherdr = Nothing End Sub -- Giulio Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77687
  - 4
    - Newbie: Adding new rows to dataset Hi, I have a data-entry type form I created with textboxes bound to a dataset. I can successfully pull all the correct information up and change any existing data, and navigate through each record using the BindingManagerBase.Position. What I'm trying to do now is add a row to the dataset and then move to that row with the form to add new information. I've tried declaring a new row and adding it to the dataset, as well as doing BindingManagerBase.AddNew. Each of these adds a row to the dataset, but I can't get it to show on the form. When I close the form, the database is updated, and the new row appears in the database table correctly. How do I get the form to show the added row? Thanks, Nathan Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77682
  - 5
    - Databinding question hi all, Can we call our procedures when databinding is in process. I want to check all the checkboxes in a checkboxlist control while data is coming from dataset. I can do this after the binding is done.. and manully loooping through the checkboxlist control and checking all the checkbox.. but i want to ask if there's better way to do it.. thanks Noor Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77678
  - 6
    - Working with a dataset I have a dataset with tables in it that i have filled from my database. If i want to find the Max value from a column in my dataset how do i do this? ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77675
  - 7
    - UTF8 Character Set issues with Oracle Provider We are building an application with VB.NET on the .NET Framework 1.1 and the .NET Managed Provider for Oracle. We are connecting to an Oracle 9.2.0 server on HP-UX using the 8.1.7 client. The character set on the server instance is "AL32-UTF8". When we call OracleCommandBuilder.DeriveParameters(), we get the following exception: System.Data.OracleClient.OracleException: ORA-06550: line 1, column 72: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated KB 322158 seems to indicate that there are some issues when UTF character sets and NCHAR, NVARCHAR2, or NCLOB data types with the Oracle 8.1.7 client. In our case, we are using standard CHAR, VARCHAR2, and CLOB data types. If the Oracle client is upgraded to 9.2, the exception is not thrown. However, we would like to avoid upgrading the Oracle client, as there is a large number of machines with the 8.1.7 client already installed. Can anyone else shed some additional light on the issue? Thanks, Brian Baker -- Microsoft MVP -- ASP / ASP.NET Please post responses to the group Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77662
  - 8
    - GROUP BY date I think I need to format the date in the table when I use GROUP by to group the dates. The table has date and time stamp but I need it to group by the date alone without the time stamp. How do I format the date field in the SQL statement using SQL Server? I was able to do it in MS ACCESS but it is different in SQL Server then MS ACCESS or .net then VB6. The old way was "Select sum(tot) as total, dte from tblName group by format(dte, 'mm/dd/yyyy') " Thanks Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77649
  - 9
    - passing input parameter to sql server sproc I have a very simple Stored Procedure that isn't working for me: CREATE PROCEDURE FindTutors ( @LastName NVarChar ) As ( SELECT fn, ln FROM main WHERE ln = @LastName ) GO Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas? Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnString")) Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString() 'Cmd.Parameters.Add("@LastName", txtLastName.Text) cn.Open() Dim rdrContent As SqlDataReader gridTutors.DataSource = Cmd.ExecuteReader() gridTutors.DataBind() cn.Close() End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77648
  - 10
    - Filling dataset from text file. I am getting data from a text file using the folowing code. It uses the schema.ini file to define a structure of the datatable in the Dataset. The default file called schema.ini. I have about 10 or 15 tables i have to populate. Is there a way to specify an ini file i want to use? Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""") Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " & FileName, Conn) Dim DS As New DataSet Try Comm.AcceptChangesDuringFill = False Comm.Fill(DS) End try Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77647
  - 11
    - Dataset generation and relation rules In VS.NET 2003 if you use sqldataadapters at design time to create your dataset there is problem : after you regenrate a dataset the relation rules are set all to default. Any quick hint to avoid this? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77643
  - 12
    - Adding Data To a Table That Isn't Part Of the Original SQL Query I am fairly new to ASP.NET so I think I am missing something fundamental. Anyway, quite often I am pulling data from a database, but then I need to use that data to produce more data. A simple example would be: Let's say Column1=StartDate and Column2=EndDate. In addition to displaying Column1 and Column2, I need to do some calculations and display in as Column3. The calculations are easy and can be done in the code-behind. How to display it is another question. However, they might not be math calculations. Take for example, a SQL query that returns a list of servers and then for each server I use WMI to get some additional information and then I need to display the servername (from SQL) and the OS and Service Pack Version (from WMI) on a web page. The way I have been handling it is creating a new table in memory and adding the columns from the original SQL query and then doing the calculations and adding that as a column. Then I'll use this new table to DataBind my DataGrid or DataList. Is this the best way to do it? I feel like this isn't the smartest way to acomplish this. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77642
  - 13
    - getOleDbSchema Hi, I want to get the tables,columns and constraints in a database. I understand that the getOleDbSchema method of the Connection object helps. Could anyone help me with code samples or direct me to appropriate links where I could find out more ? Thank You Julian Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77641
  - 14
    - passing input parameter to sql server sproc I have a very simple Stored Procedure that isn't working for me: CREATE PROCEDURE FindTutors ( @LastName NVarChar ) As ( SELECT fn, ln FROM main WHERE ln = @LastName ) GO Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas? Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnString")) Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString() 'Cmd.Parameters.Add("@LastName", txtLastName.Text) cn.Open() Dim rdrContent As SqlDataReader gridTutors.DataSource = Cmd.ExecuteReader() gridTutors.DataBind() cn.Close() End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77638
  - 15
    - ini files I am getting data from a text file using the folowing code. It uses the schema.ini file to define a structure of the datatable in the Dataset. The default file called schema.ini. I have about 10 or 15 tables i have to populate. Is there a way to specify an ini file i want to use? Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""") Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " & FileName, Conn) Dim DS As New DataSet Try Comm.AcceptChangesDuringFill = False Comm.Fill(DS) End try Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77629
  - 16
    - Connect to remote SQL server ... Can anyone give me the ADO.Net connection string to connect to a remote SQL server using it's IP address ? Any parameters and settings to be checked ? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77624
  - 17
    - Dataset ExtendedProperties woes I'm working with a dataset to which I've added an extended property like so: Const KEY_SELECT = "selectquery" Dim strSQL as String = "Blah blah blah" dsetTemp.ExtendedProperties.Add(KEY_SELECT, strSQL) If I try to retrieve the value using the constant to specify the key, I get a "The parameter is incorrect" error, but if I hardcode the key name it works: Console.WriteLine(dsetTemp.ExtendedProperties.Item(KEY_SELECT).ToString) spits out: "The parameter is incorrect" Console.WriteLine(dsetTemp.ExtendedProperties.Item("selectquery").ToString) spits out: "Blah blah blah" Why doesn't it work when I specify the key with a constant? - Don Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77616
  - 18
    - Security through stored procedures I've just started reading "Microsoft ADO.NET" by David Sheppa. One of the lines in the overview caught my eye: "Because many database administrators allow users to modify the contents of a database only through stored procedures, many developers cannot submit updates through the ADO Recordset object". This is new to me - does it mean that you could revoke UPDATE access to a database table but allow EXEC access and that the code inside the sproc carries out the update? I rather like the idea of this. I've always had a problem with the conflict between security and open access to a database. For example, our users have UPDATE access to a table as they obviously have to write updates back. However, this means that anyone with a little knowledge could use ODBC to connect to the database and write whatever they want to the database table. Which from a security/audit point of view isn't good. I was thinking about adding an encryption code to each record so that whilst we couldn't stop users changing data directly, we could at least detect when it had happened. Another option was to carry out all updates via a service which had different security rights but that's getting very messy, an probably very inefficient. Regards, Rob. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77606
  - 19
    - autonumber problem in my datatable Hello, I wanted some help on a dataset question. I have created a dataset and datatables and used the dataadapters 'fill' method on them. In my database the primary key is an autonumber. When i use the fill method and set a datagrid source to my datatable i can see 10 rows. The rows each have a primary key value from 0 to 10 (Autonumbers). When i try to insert a new row into my datatable, the primary key autonumber seems to start at the value 0 rather than continuing from the highest number. i.e 11 onwards. For this reason my inserts into the datatable keep failing. Why does it do this? Is there anyway i can make the autonumber start from the..... 'highest already generated number' (in this case 10) + 1 ??? Another question If i have an autonumber coloumn in my database, will this automaticcaly be created for my datatable if i simply use the dataadapters fill method? thx Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77598
  - 20
    - synchronizing 2 grids in two different forms Hi all! i have this problem: i need to synchronize 2 datagrids in 2 different forms upon the Master Details model. i want to do this using BindingContext, BindingManagerBase. can you give me any directions? (i've read the msdn topics concerning this stuff) Thank you, Bamse ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77595
  - 21
    - Automatically Generated Commands & Optimistic Concurrency Hello, I have created a dataadapter by specifying the select command and then used the SqlCommandBuilder to automatically generate the Update, Delete and Insert commands. I fill the dataset, close the DB connection, open the connection again, manually change the database, and then update the dataset and call the dataadapter update method, I was expecting it to raise a dbconcurrrency error but none was raised. why is this as the help on the Microsoft pages states "The logic for generating commands automatically for UPDATE and DELETE statements is based on optimistic concurrency. That is, records are not locked for editing and can be modified by other users or processes at any time. Because a record could have been modified after it was returned from the SELECT statement, but before the UPDATE or DELETE statement is issued, the automatically generated UPDATE or DELETE statement contains a WHERE clause such that a row is only updated if it contains all original values and has not been deleted from the data source. This is done to avoid new data being overwritten. In cases where an automatically generated update attempts to update a row that has been deleted or that does not contain the original values found in the DataSet, the command will not affect any records and a DBConcurrencyException will be thrown." any help would be appreciated, Kay. My code is as follows: Dim dataset As New DataSet Dim connectString As String = "db connection string is in here" Dim myConn As New SqlConnection(connectString) Dim SqlSelectCommand As New SqlCommand("SELECT ID, Description FROM optFrame WHERE (RoleAccessRevised = 1)", myConn) Dim dataadapter As New SqlDataAdapter(SqlSelectCommand) dataadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey Dim cmdBuilder As New SqlCommandBuilder(dataadapter) myConn.Open() dataadapter.Fill(dataset, "optFrame") myConn.Close() 'NOTE: At this point I go to sql server DB and manually change the data in the specified row, hoping it will cause concurrency myConn.Open() Dim rowToUpdate As DataRow = dataset.Tables("optFrame").Rows.Find(TextBox13.Text) 'NOTE : the row specified in textbox13 exists and is updated rowToUpdate.Item("Description") = TextBox14.Text Try dataadapter.Update(dataset, "optFrame") 'Note: concurrency is not caught here Catch ex As DBConcurrencyException Label28.Text = "concurrency error" End Try myConn.Close() Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77594
  - 22
    - Update datasource without using DataAdapter Hi All, I'm trying to find a way to update Dataset's datasource withtout using DataAdapter, does there exist any methods? Thanks! ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77587
  - 23
    - Connection Pool - Does not check for Server Status. hi All, Connection Pool - Does not check for Server Status. Here is the scenario : 1) SQL Server is up 2) Create a connection pool for a particular connection string by repeatedly executing the same query in .NET ( using SqlConnection and SqlCommand classes ) This involves following steps - Open a connection - Execute a Query - Close the connection 3) STOP the SQL Server. 4) Run the same query again. We notice that - Opening a Connection goes through fine. If the pool was not formed ( if we are opening the connection for the first time ), this would have FAILED by throwing SQL Server not found execption. - Execute Query , Throws an Exception - General Network Error, Error Number 11. 5) Now RE-START the SQL Server. 6) Run the same query again. We notice that - Opening a Connection goes through fine. BUT, - Execute Query , Throws an Exception - General Network Error, Error Number 11. An Exception is thrown even if SQL Server is UP! Once the Server is up, we want the connection to succeed. Now, How do we handle this scenario? How do we invalidate the Connection Pool? thanks, HiChetu Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77583
  - 24
    - Problem with sql server text data type Hi , I have a method in an asp.net application that calls a sql server stored procedure. The stored procedure inserts data to Text field. Here is the .net procedure... public int Insert(int articleId,string textData) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@articleId",SqlDbType.Int,4), new SqlParameter("@text",SqlDbType.Text), new SqlParameter("@pageId",SqlDbType.Int,4) }; parameters[0].Value = articleId; parameters[1].Value = textData; parameters[2].Direction = ParameterDirection.Output; try { RunProcedure("weeklyreport_inserttext",parameters,out rowsAffected); } catch(SqlException exc) { return 0; } return (int)parameters[2].Value; } My problem is that only so much of the text parameter gets stored and the rest is just cut off. Has anyone had a similar problem? Any help would be gratefully appreciated. Thanks, Kevin. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77577
  - 25
    - XML support in ADO.NET I've got a dataset with <xs:restriction> tags, custom elements and other stuff in it. I want to populate it using a dataadapter and data from SQL but it ignores the schema/tags. Apparently this is due to the way ado.net works with XML. To do it I have to revalidate the xml data using the XMLValidatingReader class, which then gives me a performance overhead and is a right programming pain. Does anyone know if Microsoft has plans to provide more complete support for xml documents in ADO.NET in a future release? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77570
- Next
  - 1
    - Extract Excel Cell Properties in c# Hi, Can u help me to Extract Excel Cell Properties like Formula Functions and Data Type like Numeric,Accounting etc.. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77565
  - 2
    - Sorting a DataTable... Hi, I have a DataSet whose default table, namely DataSet.Tables[0] which has a row for each day selected from a database, however not all the days are always there so I am iterating thro each day and if it is missing I add it to the table by way of a new row with default values. The DataSet is then passed thro a web service to a Web front end and then shown on a grid. The problem I have is that I want the days to appear Mon thro' Sunday, but as I am adding them at the end of the Rows, they will not appear in the right order. I thought about using InsertAt, but depending on the number of days already there or inserted it would be tedious to have to work out which position to InsertAt, to get them in the right order at that stage. So to save my little brain getting a buzzing noise is there an existing way to do this, I was thinking of using DataTable.Select, but wasn't sure how to get it back into the original dataset to pass thro'. Any ideas? TIA Colin B Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77561
  - 3
    - Whi can't I read config file I use the following app.dll.config file to store connection string. The string always returns null when I try to retrive it. Here is what I have for the app.config and base class code: I used a similar code in ASP.NET and it works fine. What is the problem ? <?xml version="1.0" encoding="utf-8" ?><configuration><appSettings><add key="connectString" value="data source=mimora; user id=scott; password=tiger" /></appSettings></configuration> using System; using System.Data; using System.Data.OracleClient; using System.Configuration; using System.Collections.Specialized; using System.IO; namespace Com.AAD.Business { /// <summary> /// Summary description for Class1. /// </summary> abstract public class DataLayerBase : IDisposable { private OracleConnection _connection; public DataLayerBase() { try { string connStr= System.Configuration.ConfigurationSettings.AppSettings["connectString"]; _connection = new OracleConnection(connStr); } catch (OracleException exep) { throw (exep); } catch (Exception exep) { throw (exep); } // _connection = new OracleConnection("data source=mimora; user id=scott; password=tiger"); } protected OracleConnection Connection { get { return _connection; } } public void Dispose() { _connection.Dispose(); } } } Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77559
  - 4
    - SQL Insert Syntax Error Hi, I can't see what is wrong with this statement. I have verfied the table and field names are correct and still have no idea. I am using the following code. Dim sSQLInsert As String = ("INSERT INTO Members (Member_ID,Password) Values(") & "'" & txtUserName.Value.ToString & "'" & "," & "'" & txtPassword.Value.ToString & "'" & ");" m_oOleDbCmd.CommandText = "" m_oOleDbCmd.CommandText = sSQLInsert m_oOleDbCmd.ExecuteNonQuery SQL Insert Statement: "INSERT INTO Members (Member_ID,Password) Values('chrisg','rckrll');" I compared this to other Insert statements I have that work and don't see anything wrong with it but yet I am getting a syntax error on the Insert statement. The data types of the fields are Text in an Access .mdb. Thanks, Chris Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77558
  - 5
    - Windows AUTH w/ASP.net My db admin has decided that he does not like sql logins. I would like to know if it is possible to have asp.net connect to a MSSQL datasource. But I was curious if it was possible for me to have it connect as the visitor to the site with out setting up asp.net to impersonate the connected user? Sorry if this does not make since or if I posted the question in the wrong location. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77557
  - 6
    - mdac 2.9 when is mdac 2.9 coming out? thanks mcgs@guide2grants.biz Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77556
  - 7
    - Limit Connections Is it possible via code or within a access database to limit the number of connections involved with the database. I have a client who has asked me to write a program but is being dishonest (told by other sources) on the number of users involved. I do vb.net and windows applications. Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77544
  - 8
    - DataRowView To DataRow If I have a DataRowView record, how do I find the DataRow version of the row? Is there some property which will aloow me to get that? Thanks in advance for your assistance!!!!!!!!!!!! Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77541
  - 9
    - ADO error Cannot convert type 'DataLayer.WSTimeEntryLog.User_STDS' to 'StronglyTypeDSCreation.User_STDS' dataset Problem: The following line, StronglyTypeDSCreation.User_STDS myDS = myWS.EmployeListSTDS(); Give me the error, Cannot convert type 'DataLayer.WSTimeEntryLog.User_STDS' to 'StronglyTypeDSCreation.User_STDS' dataset Project description: One solution, with projects, one DataLayer class, one StronglyTypeDSCreation class, one BusinessLayer class, one Web service WS_TimeEntryLog The Web service is working properly and return a TypedDataset. Inside the DataLayer class I do have one reference to the web service WS_TimeEntryLog who return a StonglyTypeDataSet base on class StronglyTypeDSCreation for table User_STDS and also one reference to the class StronglyTypeDSCreation. I notice when I add that WebService reference, Visual Studio also add the schema file or the xsd file use to generate the class. Now I am unable to find the way to actually called the web service function returning one TypeDataset of type StronglyTypeDSCreation from the DataLayer class. I try to cast it, with the same result, any Idea on how to fix this ? ----------------------------------------------------------------------------------------------- namespace DataLayer public class DL { WSTimeEntryLog.WSTimeEntryLog myWS = new WSTimeEntryLog.WSTimeEntryLog(); // my Web Services ... public StronglyTypeDSCreation.User_STDS ListEmploye() { myWS.PreAuthenticate=true; myWS.Credentials= System.Net.CredentialCache.DefaultCredentials; StronglyTypeDSCreation.User_STDS myDS = myWS.EmployeListSTDS(); // Line with error return myDS; } } Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77533
  - 10
    - Better to pass dataSet1 or just GetChanges() to Update()? Hi again, and please pardon the silly question - new to ADO.NET... :-) When I call the DataAdapter's Update() method, am I better off passing the entire dataset, or call GetChanges() first? Is there a performance difference either way, either when A) all parts of the application are on the same machine B) a middle tier is set up on a remote machine. It seems to me that in this case it's better to just pass the changes (less data to serialize), but I want to make sure I'm correct in my thinking. Thanks! -Eric Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77518
  - 11
    - Need some help to figure out why record isnt updating I am working on content management system that allows the text in articles to be updated. On the main page of the cms (default.aspx) the article titles are shown with an edit hyperlink that sends the user to the edit page which has a textbox and an update linkbutton. All of my data access logic is a separate class file and i then call the appropriate routine. However the text in the textbox doesnt update. It only updates when a text value is hardcoded into the the sql statement. Maybe one of you can figure out what the heck is going on. Thanks in advance...Here is the code: 'this sub populates the textbox Public Sub ShowArticleText(ByVal ArticleID As String, ByRef ArticleText As String) Dim cmd As New OleDbCommand("Select * From Articles Where ArticleID = @ArticleID", RDConn) cmd.Parameters.Add(New OleDbParameter("@ArticleID", cmd)) cmd.Parameters("@ArticleID").Value = ArticleID da.SelectCommand = cmd da.Fill(ds, "Articles") ArticleText = ds.Tables(0).Rows(0).Item("ArticleText").ToString End Sub ' this is the sub to update the text in the texbox Public Function UpdateComment(ByVal ArticleText As String, ByVal articleid As String) As OleDbCommand Dim cmd As New OleDbCommand("UPDATE Articles SET ArticleText = @ArticleText WHERE ArticleID =@ArticleID", RDConn) cmd.Parameters.Add("@ArticleText", cmd).Value = ArticleText cmd.Parameters.Add("@ArticleID", cmd).Value = articleid da.UpdateCommand = cmd da.Fill(ds, "Articles") End Function And in the page w/ the textbox Dim Dal As New DataLayer.AccessDataLayer Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dal.ShowArticleText(Request.QueryString("ArticleID"), TextBox1.Text) End Sub Sub BindData() Dal.ShowArticleText(Request.QueryString("ArticleID"), TextBox1.Text) End Sub Private Sub LinkButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton1.Click If IsValid Then Dal.UpdateComment(TextBox1.Text, Request.QueryString("articleid")) End If BindData() End Sub Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77510
  - 12
    - Finding a row by ID - data view is not sorted by ID Hi, I have a bit of an issue that I don't know how to deal with. I have a dataview connected to a datagrid. I don't know exactly how the dataview might be sorted at any point in time, as the user can click on the grid headers to change the sort order. Regardless of how the grid/dataview is sorted, I have a routine that I call, which adds a row to the underlying table, using MyTable.NewRow(), MyTable.AddRow(), etc. The row shows up in the grid in the correct order, but I want to set focus to the newly added row. I know the ID (primary key) of the row just added, but the grid might be sorted by name, city, state, etc. What's the best way to find the index of the newly added item in the dataview/grid regardless of sort order, so I can set it as the current row? Thanks in advance for any help you can provide... -Eric Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77506
  - 13
    - Component class based DAL Hi I am into implementing my DALs using component based classes due to the drag drop capability. However, can I do the following with component based DALs; 1. Share a common dataconnection between datadapters in different component DALs? I have separate DALs for suppliers & clients but I want to share the same db connection? Or, should I make a single DAL for both clients & suppliers? 2. Filter a dataadpter result on any given value? For example can I filter client's by current or prospects? Users would like to switch between the two from time to time. 3. Sort a dataadapter result in any given order say by company id or company name? Thanks Regards Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77504
  - 14
    - ANN: MSDE 2000 Deployment Toolkit (RC) available It's a FAQ how to deploy MSDE 2002 with a .NET setup package. The Microsoft SQL Server 2000 Desktop Engine Deployment Toolkit will make deploying the MSDE 2000 DE using VS.NET 2003 easier. Currently, there is a release candidate version available for download: <http://www.microsoft.com/downloads/details.aspx?familyid=6e9a7403-c4ba-4d98 -bb0b-2c9d6414071f&displaylang=en> <quote> The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Deployment Toolkit (release candidate) is a plug-in to Microsoft Visual Studio that automates the process of creating an integrated package with both the application and the MSDE database. </quote> -- Herfried K. Wagner [MVP] <http://www.mvps.org/dotnet> Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77499
  - 15
    - DataRowCollection RemoveAt doesn't work in certain circumstances Hi all, I am using the following code to remove rows from a table. Only rows which match a certain value are removed. The code works in one form very reliable and fails in another. The only difference between the two usages seems to be, that in the one Form a typed dataset is used and an untyped one in the other. DataTable tab = ds.Tables[ tabName ]; DataColumn col = tab.Columns[ colName ]; DataRowCollection rc = tab.Rows; for( int idx = 0; idx < rc.Count; idx++ ) { DataRow row = rc[ idx ]; if( row.RowState == DataRowState.Deleted ) { if( row[ col, DataRowVersion.Original ].ToString() == id ) { rc.RemoveAt( idx ); idx--; } } else { if( row[ col ].ToString() == id ) { rc.RemoveAt( idx ); idx--; } } } The failure appears in the first RemoveAt statement: The row is just not removed. No exception is thrown, nothing happens, but the row just stays there. The code, as shown above, then produces an endless loop. As said above, in another Form this code works. Karl Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77498
  - 16
    - SELECT DISTINCT Hi, I'm using an oledb adapter to connect to Access. I need to select three columns from a database and load them to a dataset: Name, Number, and Category. Name and Number are unique for each record, but many records can have the same Category. But I want to do a SELECT DISTINCT for only the Name, but get the Number and Category as well. I first had only the first two columns, and this worked fine: SELECT DISTINCT Name, Number FROM DatabaseTable ORDER BY Name This works because the Name and Number are unique for each record. But now I have added Category to the table; how do I add it to the selection query? SELECT DISTINCT Name, Number, Category FROM DatabaseTable ORDER BY Name brings an error. Thanks for your help. Nathan Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77497
  - 17
    - how to save from textbox anyone know how to save record that is encoded from a textbox back to sql server 2000? i know how to display a record from sql server to textbox but don't know how to save the changes i made. thanks in advance Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77491
  - 18
    - about to shoot myself Conn.open() works RANDOMLY!! ok this page is located @ http://www25.brinkster.com/mixertrucks/db/inventory.aspx the database is @ http://www25.brinkster.com/mixertrucks/db/myaccess.mdb sometimes oConn.Open() works, it was working at the beginning of the day when I viewed the page and reloaded it a million times and even called other people to go to the web page and reload it a million times. I didn't do ANYTHING to my web space or even access my account. I open the page at the end of the day and get this (i saved the error HTM file): http://www25.brinkster.com/mixertrucks/db/ERROR.htm why does it decide to work a few times and then quits?? here is my code and the VERY first oConn.Open() -(located @ line 31)- is the one that decides to work randomly If you can figure out why it does this I owe you a million dollars in IOU's. Also, this db is just for testing that's why it's not password protected. Another Also, I tried including <%@ Import Namespace="System.Data.OLEDB" %> and changing my code respectively to work w/ this and it didn't change anything. I just added the oConn.Close above the oConn.Open() thinking the DB was left open or something and wondering if I could somehow make sure it was closed. As you can tell I don't know what to do.  <%@ Page Language="VB" Debug="True" %> <%@ import Namespace="System.Net" %> <%@ import Namespace="System.IO" %> <script runat="server"> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) dim PrintFooter as boolean dim IDtext,pagetype,getPrint as string IDtext = Request.QueryString("id") pagetype = Request.QueryString("type") getPrint = Request.QueryString("print") PrintFooter = true dim NOID as boolean Dim sConnString As String Dim sSQL As String Dim oConn As System.Data.OleDb.OleDbConnection Dim oComm As System.Data.OleDb.OleDbCommand Dim oDR As System.Data.OleDb.OleDbDataReader Dim i As Integer Dim sColor As String Dim sTemp As String Dim sMapPath As String sConnString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & server.mappath("myaccess.mdb") oConn = New System.Data.OleDb.OleDbConnection(sConnString) oConn.Close oConn.Open() 'select * from entry order by id desc if (IDtext <> "") then sSQL = "SELECT name, email, message_text, test, test2, test3, test4, test5, test6, test7, test8, test9, test10, test11, test12, test13, test14, test15 from entry where id = " & IDtext NOID = true else sSQL = "SELECT id, name, email, message_text, test, test2, test3, test4, test5, test6, test7, test8, test9, test10, test11, test12, test13, test14, test15 FROM entry order by name asc, test desc" 'Dim strSQL as string ="select * from entry order by id desc" NOID = false end if oComm = New System.Data.OleDb.OleDbCommand(sSQL, oConn) oDR = oComm.ExecuteReader() if (getPrint <> "") then 'print Response.Write("<title>Chaparral Concrete Inventory Page</title><body background=http://www.mixertrucks.net/images/backp.jpg marginheight=0 marginwidth=0 leftmargin=0 topmargin=0 link=#002760 alink=#002760 vlink=#002760 font=arial>") Response.Write("<table width=775 border=0 cellspacing=0 cellpadding=0><tr><td valign=top><table width=208 height=411 border=0 cellspacing=0 cellpadding=0><tr></tr></table></td><td valign=top>") Response.Write("<font face=Verdana size=2>") Response.Write("<table width=100% cellpadding=2 cellspacing=2>") Response.Write("<tr><td colspan = 8> <center><font size=6>Chaparral Concrete Equipment, LP</font></center></td></tr>") Response.Write("<tr><td colspan= 8><center><font size=5>WORLD-WIDE CONCRETE EQUIPMENT PROVIDER</font></center></td></tr>") Response.Write("<tr><td> </td><td> </td></tr><tr><td colspan=8><a href=javascript:window.print()> CLICK HERE TO PRINT </a></td></tr>") else Response.Write("<title>Chaparral Concrete Inventory Page</title><body vlink=#002760 alink=#002760 link=#002760 bgcolor=#eead33 leftmargin=0 background=http://www.mixertrucks.net/images/back.jpg topmargin=0 marginheight=0 marginwidth=0>") Response.Write("<table width=100% border=0 cellspacing=0 cellpadding=0><tr><td valign=top width=215><table width=208 height=411 border=0 cellspacing=0 cellpadding=0><tr><td width=208><img src=http://www.mixertrucks.net/Toolbar.gif border=0 USEMAP=#Map></td></tr></table></td><td align = center valign=top>") Response.Write("<font face=Verdana size=2>") Response.Write("<table width=100% cellpadding=2 cellspacing=2>") Response.Write("<tr><center><td align=center valign=center colspan=8><a name = toppage><img border=0 src=http://www.mixertrucks.net/images/MainTitle.jpg width=293 height=64></a></center></td></tr>") Response.Write("<tr><center><td align=left valign=left colspan=8><a href=inventory.aspx?" & Request.ServerVariables("QUERY_STRING")) Response.Write("&print=yeas><font size=2>Printable Version of This Page</font></a></td></tr>") end if sColor = "white" dim prevcategory as string Do While oDR.Read if (NOID = true) then 'need to set ID to IDtext else IDtext = oDR.Item("id") end if dim thiscategory as string thiscategory = oDR.Item("name") if (thiscategory = prevcategory) then 'don't print table header else 'print table header prevcategory = oDR.Item("name") Response.Write("<tr>") Response.Write("<td colspan=7><br>" & oDR.Item("name") & "</td>") Response.Write("</tr>") end if If sColor = "silver" Then sColor = "white" Else sColor = "silver" End If Response.Write("<tr bgcolor='" & sColor & "'>") Response.Write("<td align=center valign=center>") if (oDR.Item("test6") <> "") then Response.Write("<font size=1><a href=inventory.aspx?id="& IDtext & "&type=picture> <img src=" & oDR.Item("test6") & " border=1 width=100></a></font>") end if if (oDR.Item("test7") <> "") then Response.Write("<br><font size=1><a href=" & oDR.Item("test7") & ">Word Doc</a></font>") end if if (oDR.Item("test8") <> "") then Response.Write("<br><font size=1><a href=inventory.aspx?id=" & IDtext & "&type=spec" & ">Spec Sheet</a></font>") end if if (oDR.Item("test10") <> "") then Response.Write("<br><font size=1><a href=inventory.aspx?id=" & IDtext & "&type=gallery" & ">Picture Gallery</a></font>") end if if (oDR.Item("test14") <> "") then Response.Write("<br><font size=1><a href=" & oDR.Item("test14") & ">Extra Word Doc</a></font>") end if if (oDR.Item("test15") <> "") then Response.Write("<br><font size=1><a href=inventory.aspx?id=" & IDtext & "&type=extraspec" & ">Extra Spec Sheet</a></font>") end if Response.Write("</td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("email") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("message_text") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("test") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("test2") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("test3") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("test4") & "</font></td>") Response.Write("<td valign=center align=center><font size=2>" & oDR.Item("test5") & "</font></td></tr>") if(pagetype="gallery") then Response.Write("<tr><td colspan=10 align=center valign=center><br> <font size=5>" & oDR.Item("test") & " - " & oDR.Item("test2") & " Gallery</font></td></tr><br><br>") if (oDR.Item("test10") <> "") then Response.Write("<tr><p><td colspan=10 align=center valign=center><img src=" & oDR.Item("test10") & " border=1></td></tr>") end if if (oDR.Item("test11") <> "") then Response.Write("<tr><p><td colspan=10 align=center valign=center><img src=" & oDR.Item("test11") & " border=1></td></tr>") end if if (oDR.Item("test12") <> "") then Response.Write("<tr><p><td colspan=10 align=center valign=center><img src=" & oDR.Item("test12") & " border=1></td></tr>") end if if (oDR.Item("test13") <> "") then Response.Write("<tr><p><td colspan=10 align=center valign=center><img src=" & oDR.Item("test13") & " border=1></td></tr>") end if if (oDR.Item("test6") <> "") then Response.Write("<tr><td colspan=10 align=center valign=center><img src=" & oDR.Item("test6") & " border=1></td></tr>") end if else if (pagetype="spec") then Response.Write("</table><br><br>") Response.Write("<br> <font size=5><center>" & oDR.Item("test") & " - " & oDR.Item("test2") & " Spec Sheet</font></center><br><br>") if (oDR.Item("test6") <> "") then Response.Write("<center><img src=" & oDR.Item("test6") & " border=1></center><br>") end if dim tempstring as string if(oDR.Item("test8")<> "") then dim test8location as string test8location = "http://www25.brinkster.com/mixertrucks/db/" & oDR.Item("test8") tempstring=readHtmlPage(test8location) Response.Write("<center><div align=center>") Response.Write(tempstring) Response.Write("</div></center>") end if else if (pagetype="extraspec") then Response.Write("</table><br><br>") Response.Write("<br> <font size=5><center>" & oDR.Item("test") & " - " & oDR.Item("test2") & " Spec Sheet</font></center><br><br>") if (oDR.Item("test6") <> "") then Response.Write("<center><img src=" & oDR.Item("test6") & " border=1></center><br>") end if dim tempstring as string if(oDR.Item("test15")<> "") then dim test15location as string test15location = "http://www25.brinkster.com/mixertrucks/db/" & oDR.Item("test15") tempstring=readHtmlPage(test15location) Response.Write(tempstring) end if else if (pagetype="spec2") then Response.Write("</table><br><br>") Response.Write("<br> <font size=5><center>" & oDR.Item("test") & " - " & oDR.Item("test2") & " Spec Sheet</font></center><br><br>") if (oDR.Item("test6") <> "") then Response.Write("<center><img src=" & oDR.Item("test6") & " border=1></center><br>") end if Response.Write("<table width = 100%><tr>") if (oDR.Item("test8") <> "") then Response.Write("<td width=50% align=center valign=top><br>" & oDR.Item("test8") & "</td>") end if if (oDR.Item("test9") <> "") then Response.Write("<td width=50% align=center valign=top><br>" & oDR.Item("test9") & "</td>") end if PrintFooter=false Response.Write("</tr></table>") Response.Write("<center>" & Now() & "</center></font><br><br>") Response.Write("</td></tr></table>") else if (pagetype="spec3") then Response.Write("</table><br><br>") Response.Write("<tr><td colspan=10 align=center valign=center><br> <font size=5>" & oDR.Item("test") & " - " & oDR.Item("test2") & " Extra Spec Sheet</font></td></tr><br><br>") if (oDR.Item("test6") <> "") then Response.Write("<tr><td colspan=10 align=center valign=center><img src=" & oDR.Item("test6") & " border=1><br></td></tr>") end if if (oDR.Item("test15") <> "") then Response.Write("<br><br><Br><tr><td colspan=10 valign=top><br>" & oDR.Item("test15") & "</td>") end if PrintFooter=false Response.Write("</tr></table>") Response.Write(Now() & "</font><br><br>") Response.Write("</td></tr></table>") else if (pagetype="picture") then if (oDR.Item("test6") <> "") then Response.Write("<tr><td colspan=10 align=center valign=center><img src=" & oDR.Item("test6") & " border=1><br></td></tr>") end if end if Loop if (PrintFooter = true) then Response.Write("</td></tr></table><br><br>") Response.Write("<center>" & Now() & "</font></center><br><br>") Response.Write("</td></tr></table>") end if oDR.Close() oConn.Close() if (getPrint <> "") then Response.Write("<center><table width=775 border=0 cellspacing=0 cellpadding=0><tbody><tr><td align=left><tr><td colspan = 2><center>MORE AVAILABLE, PLEASE CALL FOR CURRENT UPDATED INFORMATION</center></p></td></tr><tr><td colspan=2> <br></td></tr><tr><td> MAIN OFFICE</td><td align = right> INTERNATIONAL OFFICE</td></tr><tr><td> FRED VINCENT JR </td><td align = right> RICARDO MOLINA</td></tr><tr><td>222 Winchester Lane</td><td align = right> ESPINOZA #1453 OTE</td></tr><tr><td> Weatherford, Texas</td><td align = right> MONTERREY N.L. MEX 64000</td></tr><tr><td> TEL: +1 (817) 677-1276</td><td align = right> TEL/FAX: +52 (818) 340-0440</td></tr><tr><td> FAX:+1 (817) 677-1278</td><td align = right> MOBILE: +52 (818) 064-0783</td></tr><tr><td> <a href=http://www.mixertrucks.net/>WWW.MIXERTRUCKS.NET</a></td><td align = right> <a href=mailto:ricardo@molina.net>ricardo@molina.net</a></td></tr><tr><td colspan=2><br></td></tr><tr><td colspan=2> <center><font size=4>WE FINANCE NEW AND USED EQUIPMENT!!!</font></center></td></tr></td></tr></tbody></table></center>") Response.Write("<br><Br><Br><br><br><br><br>") else Response.Write("<table width=100% border=0 cellspacing=0 cellpadding=0><tr><td valign=top><table width=215 border=0 cellspacing=0 cellpadding=0><tr><td width=215> </td></tr></table></td><td valign=top><table width=100% border=0 cellspacing=0 cellpadding=0><tbody><tr><td align=left><tr><td colspan = 2><center>MORE AVAILABLE, PLEASE CALL FOR CURRENT UPDATED INFORMATION</center></p></td></tr><tr><td colspan=2> <br></td></tr><tr><td> MAIN OFFICE</td><td align = right> INTERNATIONAL OFFICE</td></tr><tr><td> FRED VINCENT JR </td><td align = right> RICARDO MOLINA</td></tr><tr><td>222 Winchester Lane</td><td align = right> ESPINOZA #1453 OTE</td></tr><tr><td> Weatherford, Texas</td><td align = right> MONTERREY N.L. MEX 64000</td></tr><tr><td> TEL: +1 (817) 677-1276</td><td align = right> TEL/FAX: +52 (818) 340-0440</td></tr><tr><td> FAX:+1 (817) 677-1278</td><td align = right> MOBILE: +52 (818) 064-0783</td></tr><tr><td> <a href=http://www.mixertrucks.net/>WWW.MIXERTRUCKS.NET</a></td><td align = right> <a href=mailto:ricardo@molina.net>ricardo@molina.net</a></td></tr><tr><td colspan=2><br></td></tr><tr><td colspan=2> <center><font size=4>WE FINANCE NEW AND USED EQUIPMENT!!!</font></center></td></tr></td></tr></tbody></table></td></tr></tbody></table>") Response.Write("<br><Br><Br><br><br><br><br>") end if oDR.close oConn.close End Sub Function readHtmlPage(url As String) As String Dim objResponse As WebResponse Dim objRequest As WebRequest Dim result As String objRequest = System.Net.HttpWebRequest.Create(url) objResponse = objRequest.GetResponse() Dim sr As New StreamReader(objResponse.GetResponseStream()) result = sr.ReadToEnd() 'clean up StreamReader sr.Close() return result End Function </script> <html> <head> </head> <body> <map name="Map"> <area shape="RECT" coords="16,156,132,194" href="http://www.mixertrucks.net/Languages/English/english.html" /> <area shape="RECT" coords="26,315,148,343" href="http://www.mixertrucks.net/Languages/English/contactus/contactus.html" /> <area shape="RECT" coords="29,275,131,295" href="http://www.mixertrucks.net/Languages/English/aboutus/aboutus.html" /> <area shape="RECT" coords="15,8,134,61" href="http://www.mixertrucks.net/" /> <area shape="RECT" coords="22,210,149,252" href="http://www25.brinkster.com/mixertrucks/db/inventory.aspx" /></map> </body> </html> Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77490
  - 19
    - DataBinding If I set the I change the DropDownStyle propety of a ComboBox to DropDownList, can the the SelectedIndex propety ever be a -1? It seems no matter what I do, when I bind the comboBox to a datasource and set the DropDownStyle to DropDownList, it always shows the first row value. When this control is bound to a datasource (DataTable) and the ValueMember and Display Member properties are set appropriately, when I attempt to retrieve the SelectedValue from the ComboBox, rather then retrieving the value, as I expected and as I believe the documentation states it will, I get "System.Data.DataRowView" being returned. What am I doing wrong? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77488
  - 20
    - databound inherited textbox can't keep changes to me.text I created a custom textbox I named "NumericTextBox" by inheriting from System.Windows.Forms.Textbox so I could filter keystroke input.. After changing the custom property "Precision", I desire to delete a certain amount of digits from the "me.text". However, after changing the text programatically, moving the focus to another control changes the text back to the previous text. Although calling EndCurrentEdit() on the BindingManagerBase prevents the text from reverting, using EndCurrentEdit() in this fashion is not helpful. This is because I am using the NumericTextBox on a form with "OK" and "Cancel" buttons which use a currencymanager to apply or abandon changes via CM.EndCurrentEdit or CM.CancelCurrentEdit. The NumericTextBox needs to handle the digit deletion and application in a generic way because it is used on multiple forms accross the project. Here is a snippet of the NumericTextBox class: Thanks, k '//////////////////////////////////////////// '// In the inherited textbox '//////////////////////////////////////////// <Description("If IntegerOnly is FALSE, this property sets _ the allowed number of digits to the right of the decimal."), _ Browsable(True), _ Category("Validation"), _ DefaultValue(2)> _ Property Precision() As Integer Get Return m_Precision End Get Set(ByVal Value As Integer) If Value >= 0 Then m_Precision = Value '// Look for a decimal Dim i As Integer = Me.Text.IndexOf(".") '// If we've a decimal AND Precision is larger than allowed If i > -1 AndAlso (Me.Text.Length - (i + 1)) > Me.m_Precision Then '// Trim off extra, disallowed digits Me.Text = Me.Text.Remove(i + Me.m_Precision + 1, _ (Me.Text.Length - i - 1) - Me.m_Precision) End If End If End Set End Property '//////////////////////////////////////////// '// And on the containing form '//////////////////////////////////////////// Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click cm.CancelCurrentEdit() Me.m_parent.Focus() Me.Close() End Sub Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click If ValidateForm() Then cm.EndCurrentEdit() Me.m_parent.Focus() Me.Close() End If End Sub Private Sub SetForm() '// set a currency manager for this form to manage the appropriate dataset tables cm = CType(Me.BindingContext(Me.m_parent.DsMngMenu1.Taxes), CurrencyManager) '// If appropriate, Synchronize our Form to the record currently selected in parent form If m_actionToTake = formAction.editTax Then '// set a currency manager for the owner form to find Form1's current record position cmOwner = CType(CType(Me.Owner, myns.mngMenu).BindingContext _ (Me.m_parent.DsMngMenu1.Taxes), CurrencyManager) '// synchronize the table record positions between form1 and form2 Me.cm.Position = Me.cmOwner.Position Else '// create a new Tax cm.AddNew() End If '// Set our databindings Me.tbTaxName.DataBindings.Add("Text", Me.m_parent.DsMngMenu1.Taxes, "TaxName") Me.tbTaxSource.DataBindings.Add("Text", Me.m_parent.DsMngMenu1.Taxes, "TaxSource") Me.tbTaxValue.DataBindings.Add("Text", Me.m_parent.DsMngMenu1.Taxes, "TaxValue") Me.cbxTaxType.DataBindings.Add("SelectedItem", Me.m_parent.DsMngMenu1.Taxes, "TaxType") If Me.m_actionToTake = formAction.newTax Then Me.cbxTaxType.SelectedIndex = 0 End Sub Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77487
  - 21
    - DataAdapter Update I have an update screen which is designed such that the user makes a few selection and then the data that matches that selection criteria is retrieved using the DataAdapter. The user is then free to make adds/changes/deletes as necessary. They then can make additional selections which will require the retrieval of data which matches that criteria. If I want to delay making any updates to the table until the user logs out, how can this be done if I am "constantly" refreshing the contents of the data table with new rows. Should I copy the update rows into another Table which accumulates all changes to date? If this is the approparch to take, if the user makes selection again to bring back rows which are already in the "holding" table, how can I merge the two tables giving the appearance that the updates have already been made to the table? Thanks for your assistance!!! Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77486
  - 22
    - execute more then one command in one Command execution ? sounds vague I know sorry. I'll try to explain what I need. I need to run a sql script that will initialize my tables and it needs to do it on more then one table so the script will contain several SQL commands to be run. I wonder if I can load the SQL script into the commandText property and run the ExecuteNonQuery method ? Yoramo Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77484
  - 23
    - Problem with DBase in ADO.NET Can you help? I am trying to read a table in a dbase database strMyDB = HttpContext.Current.Server.MapPath(".") & pstrPathName strDB = "Driver={Microsoft dBase Driver (*.dbf)};Data Source=" & strMyDB ' the connection object mdbDatabase = New OdbcConnection(strDB) ' open the connection mdbDatabase.Open() mdaIC031016 = New OdbcDataAdapter mdaIC031016.SelectCommand = New OdbcCommand("Select * from IC031016", mdbDatabase) Dim dsAny = New DataSet mdaIC031016.Fill(dsAny, "IC031016") The Fill fails: The message is 5: Procedure call or argument is not valid. Thanks, Bob Avallone MetaPro Systems Inc. www.metaprosystems.com Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77481
  - 24
    - BindingContext & CurrencyManager I'm trying get at the underlying data in the form's currencymanager. I found an example in the Microsoft Press book "ADO.NET Step by Step" but I'm having problems with it. I've already filled my dataset (DsInfo) with a datatable ("RootInfo") Dim cm As System.Windows.Forms.CurrencyManager cm = Me.BindingContext(Me.DsInfo, "RootInfo") The second line here is giving me a compile error: C:\Projects\Code\Uniway\ServiceCenter\frmMain.vb(1082): Option Strict On disallows implicit conversions from 'System.Windows.Forms.BindingManagerBase' to 'System.Windows.Forms.CurrencyManager'. I've also tried to explicitly convert it using the CType function. It compiles then, but has an unhandled exception. Any ideas? Thanks, Blake Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77475
  - 25
    - Data Retrieval Best Practices type of Question I'm trying to load all the 'Ticket' Data that may be associated with a particular AccountID. I'm fairly satisfied with the way I get the AccountID and I'm storing it in the CurrentAccountID variable. So, I build my select statement to retrieve all the Tickets into the "Tickets" table of the dsTicketMain DataSet. . dascTicketsMain.SelectCommand.CommandText = "SELECT TicketID, AccountID, CreationDate, CSRID FROM scTickets WHERE AccountID = " & CurrentAccountID.ToString dascTicketsMain.Fill(dsTicketMain, "Tickets") . Now, each AccountID will most likely have more than one Ticket associated with it. And each Ticket will have many line Items associated with it. I want to load all the line items for all the tickets so I can let the DataRelation handle my navigation. That way I don't have to load the Item info each time I switch tickets. So, should I build my 'Items' Select statement to do something like this.? . dascItemsMain.SelectCommand.CommandText = "SELECT ItemID, TicketID, BookID, Description, QtyOrdered, UnitPrice, QtyReceived, FROM scItems WHERE TicketID IN (SELECT TicketID FROM scTickets WHERE AccountID = " & CurrentAccountID.ToString dascItemsMain.Fill(dsTicketMain, "Items") . Or should I iterate through the Tickets DataTable and retrieve each TicketID like the following, then merge each time? . CurrentTicketID = CInt(dsTicketMain.Tables("Tickets").Rows(0).Item(0)) "SELECT ItemID, TicketID, BookID, Description, QtyOrdered, UnitPrice, QtyReceived, FROM scItems WHERE TicketID = " & CurrentTicketID.ToString . Or is there another, better, way that I'm not thinking of? Hope I included all the necessary info for the question. let me know if I need to provide more. Thanks guys, Blake PS, the last couple posts I made to this group and showing up for me. I got a reply to one of them but it showed up its own thread. Maybe its just one of those things and this one will show up, but anyone got any idea what would cause that? Tag: Displaying Enumerated DB Integers as Strings In DataGrid Tag: 77471

Hi

Quite a banal problem... But for some reason I have found no elegant solution..

I have enumerated integer values in my DB, and I would like to use DataGrid for displaying the contents of the DataSet (filled from the DB, of course) including displaying meaningful text strings for the enumerated integer values

There are several levels in which this issue may be handled, So..

1) Is there any way to force use of a specific user-defined type, which can be converted to/from a DB type (Int for instance) when generating typed DataSet? I mean possibility to use a user-defined type (Enum or other class, minding the conversion possibilities) in the XSD schema

2) Is there a simple way to force the DataGrid to perform conversions from integer values to strings, through using enums or something? (Without implementing some custom monstrosity DataGridColumnStyle or something)

3) I hate to think of putting conversions and giving the DataGrid other DataTable with converted string values..

Thank you.

Top