Dataset generation and relation rules

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
    - 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: Dataset generation and relation rules Tag: 77642
  - 2
    - 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: Dataset generation and relation rules Tag: 77641
  - 3
    - 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: Dataset generation and relation rules Tag: 77638
  - 4
    - 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: Dataset generation and relation rules Tag: 77629
  - 5
    - 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: Dataset generation and relation rules Tag: 77624
  - 6
    - 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: Dataset generation and relation rules Tag: 77616
  - 7
    - 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: Dataset generation and relation rules Tag: 77606
  - 8
    - 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: Dataset generation and relation rules Tag: 77598
  - 9
    - 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: Dataset generation and relation rules Tag: 77595
  - 10
    - 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: Dataset generation and relation rules Tag: 77594
  - 11
    - 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: Dataset generation and relation rules Tag: 77587
  - 12
    - 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: Dataset generation and relation rules Tag: 77583
  - 13
    - 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: Dataset generation and relation rules Tag: 77577
  - 14
    - 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: Dataset generation and relation rules Tag: 77570
  - 15
    - 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: Dataset generation and relation rules Tag: 77565
  - 16
    - 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: Dataset generation and relation rules Tag: 77561
  - 17
    - 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: Dataset generation and relation rules Tag: 77559
  - 18
    - 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: Dataset generation and relation rules Tag: 77558
  - 19
    - 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: Dataset generation and relation rules Tag: 77557
  - 20
    - mdac 2.9 when is mdac 2.9 coming out? thanks mcgs@guide2grants.biz Tag: Dataset generation and relation rules Tag: 77556
  - 21
    - 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: Dataset generation and relation rules Tag: 77544
  - 22
    - 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: Dataset generation and relation rules Tag: 77541
  - 23
    - 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: Dataset generation and relation rules Tag: 77533
  - 24
    - 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: Dataset generation and relation rules Tag: 77518
  - 25
    - 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: Dataset generation and relation rules Tag: 77510
- Next
  - 1
    - 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: Dataset generation and relation rules Tag: 77506
  - 2
    - 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: Dataset generation and relation rules Tag: 77504
  - 3
    - 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: Dataset generation and relation rules Tag: 77499
  - 4
    - 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: Dataset generation and relation rules Tag: 77498
  - 5
    - 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: Dataset generation and relation rules Tag: 77497
  - 6
    - 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: Dataset generation and relation rules Tag: 77491
  - 7
    - 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: Dataset generation and relation rules Tag: 77490
  - 8
    - 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: Dataset generation and relation rules Tag: 77488
  - 9
    - 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: Dataset generation and relation rules Tag: 77487
  - 10
    - 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: Dataset generation and relation rules Tag: 77486
  - 11
    - 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: Dataset generation and relation rules Tag: 77484
  - 12
    - 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: Dataset generation and relation rules Tag: 77481
  - 13
    - 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: Dataset generation and relation rules Tag: 77475
  - 14
    - 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: Dataset generation and relation rules Tag: 77471
  - 15
    - Getting ID H Im working with OleDB and Access db. I was wondering it it was possible to retrieve a ID, with some OleDB object, from an insert sql statement regards Palli Tag: Dataset generation and relation rules Tag: 77463
  - 16
    - CSV to SQL Best Practice?? I have an web app where users need to be able to upload data from a .csv file into a SQL database. What is the best practice for doing this? My application is a .net web app written in C#, with a SQL Server 2000 database. The web server and database servers are located on different boxes. For security reasons the SQL box does not have FTP or any way for a web user to upload files to it. From the SQL perspective, it seem like using the bcp Utility or BULK INSERT would be the method of choice, but don't you need to have the data file on the SQL box to do that? Tag: Dataset generation and relation rules Tag: 77459
  - 17
    - PropertyGrid - Collection Editor Add/Remove Buttons Disabled ???? Hi all, I want to make a runtime DataSet schema designer. So i drag a dataset to form and a property grid. While opens the tables collection editor from the property grid in runtime, add/remove buttons looking disabled. How can i enable them ? Tag: Dataset generation and relation rules Tag: 77458
  - 18
    - datatable storage where is datatable stored-RAM or hard disk? Tag: Dataset generation and relation rules Tag: 77446
  - 19
    - Expose a datatable column as a property? Hi All, I would like to know if there is a way I could expose my column from a datatable of strongly-typed dataset as a property without literally adding the code of creating a property? I mean, instead of using Dataset.DataTable.Rows("ColumnName") I could directly use Dataset.DataTable.Rows.ColumnName. Is this possible? TIA. Ramil Domingo Developer Tag: Dataset generation and relation rules Tag: 77445
  - 20
    - dataset and Ienumerable I have read that the binding for a webdatagris is possible only onf the binding object supports IENUMERABLE interface But dataset and datatable are deriving from IListSource. Then how are they gettong binded to a datagrid What is the difference b/w ILISTSOURCE and IEnumerable interfaces plzz help me ou thnks in advanc Tag: Dataset generation and relation rules Tag: 77444
  - 21
    - Is this a good way to close DB Connection in ASP.NET? Is this a good way to close DB Connection in ASP.NET? I've been trying to come up a way to close DB connection automatically (or sort of) in my ASP.NET application without having to write the close() method everywhere. Every web page in my application needs to call the database, and all DB access and SQL Command code are wrapped in a separate class (called DBAccess below). I don't want to open and close the connection within every public method of the DBAccess class as some of the pages need to call several methods. My goal is to make one page instance create one instance of the DBAccess and use only one connection, and no need for page developer to explicitly open and close the underlying connection (as it should be wrapped inside DBAccess). Here's what I came up with and would like to get some comments on whether this is a good approach. --------------------------------------------------------------- /******************************************************* The DBAccess class implements IDisposable so the public Dispose method can be called to close the connection. ********************************************************/ public class DBAccess : IDisposable { private System.Data.SqlClient.SqlConnection _conn; public DBAccess() { //Initialize _conn and call _conn.Open() } public System.Data.DataTable SomeDBCall() { //Call a Stored Proc to return a DataTable } public void AnotherCall() { //Call a Stored Proc to update a table } //more methods......... public void Dispose() { _conn.Close(); } } /********************************************************* A sample web page class. The using statement guarantees the DBAccess.Dispose() would be called. Alternatively, the Page class' Dispose method can be overridden to call DBAccess.Dispose(). Probably more flexible to override Page.Dispose *********************************************************/ public class MyWebPage : System.Web.UI.Page { private DBAccess _db = new DBAccess(); private void Page_Load(object sender, System.EventArgs e) { //Do something.... using (_db) { //execute calls to the DB; } //Do some other thing..... } } Tag: Dataset generation and relation rules Tag: 77435
  - 22
    - Column Expression Hello, I am trying to figure out how to specify the property of the "expression" so that I can create a Data Column which is a computed column. I thought I could use the SQL Server functions such as RTRIM and Convert Functions ("RTRIM(CompetitionName) + ' ' + convert(char(10), EventStartDate, 101)") It does not seem to like either expression. I tried similar expressions in Query Analizer and they worked just fine. Am I not able to use the SQL Functions? Your assistance is greatly appreciated!!!!!!!!!! Tag: Dataset generation and relation rules Tag: 77430
  - 23
    - run stored procedure? I have been able to send input into a stored procedure I think, as shown below. Just wondering how to get the output and actually call the procedure? Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003" Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() = "1/1/2003" Also I could not find the value property of the parameters the wizard was suposed to create. Thanks Paul. Tag: Dataset generation and relation rules Tag: 77426
  - 24
    - ADO.NET DataRelation I am trying to learn the proper use of the DataRelation class in ADO.net. When I try to create a DataRelation and add it to my dataset, I get an error stating that says "This constraint cannot be enabled as not all values have corresponding parent values." After initially receiving this error, I successfully create a constraint between the two tables in question without error. Upon creating the constraint, I left "check existing data on creation" checked. I also ran numerous queries against the table in an attempt to troubleshoot the problem. Here is the query I used to check the integrity of my data: /*********************************/ select * from ann_announcement where not exists (select * from dpt_department where ann_dpt_id = dpt_id) /*********************************/ where dpt_id is the primary key, and ann_dpt_id is the foreign key. Below is the code I am using: '********************************* SqlDataAdapter1.Fill(DataSet11, "ann_announcement") SqlDataAdapter2.Fill(DataSet11, "dpt_department") Try ' Get the DataColumn objects from two DataTable objects in a DataSet. Dim parentCol As DataColumn Dim childCol As DataColumn ' Code to get the DataSet not shown here. parentCol = DataSet11.Tables("dpt_department").Columns("dpt_id") childCol = DataSet11.Tables("ann_announcement").Columns("ann_dpt_id") ' Create DataRelation. Dim relDeptAnnouncements As DataRelation relDeptAnnouncements = New DataRelation("ann_dpt", parentCol, childCol) ' Add the relation to the DataSet. DataSet11.Relations.Add(relDeptAnnouncements) Catch e2 As SqlClient.SqlException System.Diagnostics.Debug.Write(e2.Message) Catch e3 As Exception System.Diagnostics.Debug.Write(e3.Message) End Try '********************************* Any clues that you can offer me would be appreciated! Thanks - TJR Tag: Dataset generation and relation rules Tag: 77425
  - 25
    - database diagrams, how to save to sourcesafe ? tired of recreating... In VS.NET, I often create DB diagrams in the server explorer. How do I save these diagrams ? I need to persist all this stuff to sourcesafe, I can do that with my code, my sql scripts, etc...but not the db diagrams ? -- THanks, Andrew Tag: Dataset generation and relation rules Tag: 77421

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?

Top

Re: Dataset generation and relation rules by Miha

Miha
Mon Jan 19 15:06:03 CST 2004

Hi Alex,

Can you be a more specific?
How do you regenerate the dataset?
What exactly is set to default?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Alex Pop" <anonymous@discussions.microsoft.com> wrote in message
news:03C19175-07C1-4606-9DA2-CE97F6FFAE1B@microsoft.com...
> 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?

Top

Re: Dataset generation and relation rules by Miha

Miha
Mon Jan 19 15:46:55 CST 2004

Hi Alex,

Ah, I see.
I guess that is a feature of the wizard.
You might try my template for generating strong typed datasets instead - it
generates xsd schema for given tables.
See:
http://www.rthand.com/default.aspx?Page=2&SubPage=1#5

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Alex Pop" <anonymous@discussions.microsoft.com> wrote in message
news:AC9A911D-BA5F-4DB2-9741-09337A1B014F@microsoft.com...
>
>
> ----- Miha Markic wrote: -----
>
> Hi Alex,
>
> Can you be a more specific?
> How do you regenerate the dataset?
> What exactly is set to default?
>
> It's about a typical dataset generation at design time, based on the
dataadapters that are mapped each on a database table. Let's say that I
generated my dataset in this way ,then I create the relations, i set to each
relation its rules( e.g. UpdateRule for a relation "TABLE1_TO_TABLE2" is set
to Cascade ). Then if I modify something in my database then I update my
dataadapters and regenerate the dataset to refelct changes I got all my
rules of relations set to "Default"
>
>
>

Top

Re: Dataset generation and relation rules by anonymous

anonymous
Tue Jan 20 04:26:05 CST 2004

Yes , I guess also that is a bug or an issue in dataset design time generation tool. I bookmarked your page anyway for future use if I don't find a quick solution for this.
10x

Top