Browsing records from a specific location

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
    - Gotcha Just so you know scorp I am downloadeding it and am going to try it out. I hope you did better on this one than the last thing you published!! I am sure you learned your lesson this time.... (ROFLMAO) Glad to see you came back...... I knew you would if I went away :) Did the rest of the group miss me? (ROFLMAO!!!!!) >-----Original Message----- >This morning I let the group know that I had finished an application that >categorizes posts in the vb.net and ado.net newsgroups and eliminates the >trash that we hate to wade through on sites like Google and such. > >Well I would like to thank the multitude of you that have emailed me >informing me of the bug in the datagrid (the scrollbars don't show up unless >you resize the form after populating the grid). > >I knew you would be a tough audience but geez :) > >Actually I appreciate you letting me know. It is the inital release of this >so I expected things like this. > >The bug is now fixed. The corrected version is 1.06. It should automatically >remove your previous version but may not because the installer can be buggy. > >You can download the fixed version at >http://www.kjmsolutions.com/newsgrouptool.htm > > > > > >. > Tag: Browsing records from a specific location Tag: 76341
  - 2
    - ASP.NET Automatic vs. Manual ado.net objects Hello, I'm hoping someone here can help me out with this. I'm programming with asp.net within the VS.NET IDE. I've found two different ways to handle data access, I can program my own ado.net components, or drag and drop from the toolbox connections, adapters, datasets, etc. to the design view of the web form. I like the drag and drop features, but would like to know more about it, I kind of just stumbled on it, and never really found a good document explaining it. Does anyone out there have experience with this, and could offer any insight. Any showstoppers someone has run into from using the automatic stuff versus do-it-yourself. In the long term what will be the best option? Thanks for any help! --Michael Tag: Browsing records from a specific location Tag: 76335
  - 3
    - Row Cell Hello, Coming from VB, accessing cells is a little different in C#. If I have a datatable, I see the ItemArray propery, which gives you an array of the items in a row (right?), but it does not allow you to access the individual cell. Do I have to get the ItemArray and access the individual cell from that, or is there another way. In VB there was the "item" property. dt.rows[myRow].item[2] = "Fred" If I have a Datarow is there a property that tells me the index of that row in a DataTable? Likewise, if I have a DataRowView Row, is there a property which tells me the index of that row? Thanks in advance for your assistance!!!! Tag: Browsing records from a specific location Tag: 76329
  - 4
    - Lock HI, I am getting a Connection Time Out Error While executing the follwoing code Transaction isolation Level is "Read Commited" String sConnectStr = "User ID=sa;Password=sa;Database=DAL;Server=."; SqlConnection objConnection = new SqlConnection(sConnectStr); objConnection.Open(); SqlTransaction objTran = objConnection.BeginTransaction(); SqlCommand objCommand = new SqlCommand(); objCommand.Connection = objConnection; objCommand.CommandText = "INSERT INTO Patient (Name, OId) VALUES (@Name, @OId)"; SqlParameter objParam1 = objCommand.CreateParameter(); objParam1.DbType = DbType.String; objParam1.Value = "Test ST"; objParam1.ParameterName = "@Name"; objCommand.Parameters.Add(objParam1); SqlParameter objParam2 = objCommand.CreateParameter(); objParam2.DbType = DbType.String; objParam2.Value = "f6a07441-c3e2-4aaa-8913-cfbab8df395b"; objParam2.ParameterName = "@OId"; objCommand.Parameters.Add(objParam2); objCommand.Transaction = objTran; MessageBox.Show(objCommand.ExecuteNonQuery().ToString()); SqlConnection objConnection1 = new SqlConnection(sConnectStr); objConnection1.Open(); SqlCommand objCommand1 = new SqlCommand(); objCommand1.Connection = objConnection1; objCommand1.CommandText = "select count(*) from Patient"; SqlDataReader objReader = objCommand1.ExecuteReader(); objTran.Commit(); How to over come this?? Thanks in advance Regards, karthikeyan. G Tag: Browsing records from a specific location Tag: 76314
  - 5
    - optimistic concurrency In the .NET Data Access Architecture Guide, under Performing Database Updates with DataSets | Managing Concurrency, it says there are four main approaches to manage optimistic concurrency when updating through a DataSet: 1. Including only the primary key columns 2. Including all columns in the WHERE clause 3. Including unique key columns and the timestamp columns 4. Including unique key columns and the modified columns Then it goes on to say that 1, 2, and 4 are not recommended -- even though 2 is the default behavior of the Data Adapter Configuration Wizard, and 3 is NOT supported by the Data Adapter Configuration Wizard. I think "ironic" is the applicable word here. What is a good way to implement optimistic concurrency, then? Is everyone putting a timestamp column in the tables, and leaving the Data Adapter Configuration Wizard to RAD hackers? ;-) Brad Williams Tag: Browsing records from a specific location Tag: 76306
  - 6
    - SQLDataAdapter SP Generation Hi, I have created an SQLDataAdapter component on my vb.net winform project and stepped through the wizard. In my SQL Database I have a table with fields using user defined data types and not the base data types. The problem is that when the stored procedure gets created by the adapter the parameter's data types did not follow the data type of the table I used in the wizard. Is there any solution on how I could use my user defined data types in my SP, autogenerated by the adapter, w/o actually modifying the SP after running the wizard? Appreciate any help. Thanks. Ramil Domingo Developer Tag: Browsing records from a specific location Tag: 76304
  - 7
    - Unspecified error when performing operations on OLE DB data adapters I have 7 data adapters connected to MS Access tables. When I try to 1) Preview Data or 2) Generate DataSet or 3) look at the Mapping collection in the DA Properties I get "Unspecified Error". Plus one of the data adaptors generates a bad Update statement that throws an error message when I try to update after a dataset Merge. None of the other adapters throw an Update error. I have tried reconfiguring, recreating and virtually every property parameter without luck. I have recreated the MS Access table from which the bad Update command is created. I have deleted the entire form containing the data adapters and started over again with the same result. Any thoughts? Best regards, Drew Yallop Tag: Browsing records from a specific location Tag: 76286
  - 8
    - help with simple ado code Hey all, hoping you can help with this odd problem...hopefully I am just doing something really stupid. I have a small access database with a bunch of text fields, and I want to insert a row, using the following code: OleDbConnection conn = new OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\moneymakin.mdb"); String stmt = "INSERT INTO Person (FirstName, LastName, Email, LoginID, Password) VALUES (" + "'" + this.m_perFirstName + "', '" + this.m_perLastName + "', '" + this.m_emailAddress + "', '" + this.m_loginID + "', '" + this.m_password + "')"; MessageBox.Show(stmt); //conn.Open(); OleDbCommand perCommand = new OleDbCommand(stmt, conn); perCommand.Connection.Open(); perCommand.ExecuteNonQuery(); //OleDbDataReader perReader = perCommand.ExecuteNonQuery(); //perReader.Close(); conn.Close(); I get the following error msg when I run this update: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at WindowsSample.Person.saveNewData() in c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio Projects\WindowsSample\DataItems\Person.cs:line 192 at WindowsSample.PersonalInfo.btnPersonalSave_Click(Object sender, EventArgs e) in c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio Projects\WindowsSample\Forms\PersonalInfo.cs:line 326 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) I have no clue what the problem could be, but I know that when I only use firstname, lastname, and emailaddress, the query works fine. What could the problem be? ----== 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: Browsing records from a specific location Tag: 76285
  - 9
    - Row Number If I have a Row from a dataTable, how do I get the row number of the row? Thanks in advance for your assistance!!!!! Tag: Browsing records from a specific location Tag: 76282
  - 10
    - Access Insert Error I am trying to run the following insert into an Access DB. For some reason I continually get a Syntax error in INSERT INTO statement. I have been looking at it way too long. There has got to be something relatively obvious that I am missing. Any suggestions would be greatly appreciated. conDb = New OleDbConnection( strConString ) 'Set up insert statement for order header strSql = "Insert Orders (UserID, FirstName, LastName, billStreet, billCity, billState, billZip, " & _ "shipStreet, shipCity, shipState, shipZip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" cmdSql = New OleDbCommand( strSql, conDb ) cmdSql.Parameters.Add( "@userID", OleDbType.Guid).Value = guidUserID cmdSql.Parameters.Add( "@firstname", OleDbType.VarWChar).Value = txtfirstname.Text cmdSql.Parameters.Add( "@lastname", OleDbType.VarWChar).Value = txtlastname.Text cmdSql.Parameters.Add( "@billStreet", OleDbType.VarWChar).Value = ctrlBillingAddress.Street cmdSql.Parameters.Add( "@billCity", OleDbType.VarWChar).Value = ctrlBillingAddress.City cmdSql.Parameters.Add( "@billState", OleDbType.VarWChar).Value = ctrlBillingAddress.State cmdSql.Parameters.Add( "@billZip", OleDbType.VarWChar).Value = ctrlBillingAddress.Zip cmdSql.Parameters.Add( "@shipStreet", OleDbType.VarWChar).Value = ctrlShippingAddress.Street cmdSql.Parameters.Add( "@shipCity", OleDbType.VarWChar).Value = ctrlShippingAddress.City cmdSql.Parameters.Add( "@shipState", OleDbType.VarWChar).Value = ctrlShippingAddress.State cmdSql.Parameters.Add( "@shipZip", OleDbType.VarWChar).Value = ctrlShippingAddress.Zip conDb.Open() cmdSql.ExecuteNonQuery() The stack trace is as follows: [OleDbException (0x80040e14): Syntax error in INSERT INTO statement.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112 System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66 Thanks, J. Clay Tag: Browsing records from a specific location Tag: 76278
  - 11
    - Viewing SQL Server system procedures? Does MSDE include SQL Server's system procedures? If so, can I view/execute them from the Server Explorer in VS.Net? If so, how? Thanks -- Dave Veeneman Chicago Tag: Browsing records from a specific location Tag: 76277
  - 12
    - DataReader efficiency I noticed that the datareader has a way to reference returned fields by index or name. Is using the name parameter very inefficient? It seems that if the stored procedure is modified to have the fields in a different order, then using the name as an index would avoid problems. What are other peoples thoughts and experiences on this? Thank you, Ken Tag: Browsing records from a specific location Tag: 76275
  - 13
    - DB data into a custom list... Hi, As I've decided to use my own custom collections to get data from my DB backend, to a web service, and then to my client frontend, I was wondering if there is a way to directly fill the objects of my collection without first having to load into a DataSet. Could I override the SqlDataAdapter.Fill method so instead of dbAdapter.Fill(dataSet, "site"), I have dbAdapter.Fill(myList, "site"), and then the Fill would simply map the fields of each row onto the object fields followed by adding them to the list? What about SqlDataReader, does that give me any more options? Is this a reasonable idea, or should I get my coat? Thanks in advance Colin B Tag: Browsing records from a specific location Tag: 76274
  - 14
    - Inserting dates into SQL Server DB I'm running the following code in a C#.NET page and it doesn't enter the values into the DB. I'm certain the problem is to do with the txtBirth field. It allows users to enter a DOB as dd/mm/yyyy and I think it's the slashes(/) that are causing the problem. If I don't enter a DOB in this field then all the data enters into the database without a problem. Any ideas? SQL Server 2000, VS.NET, C# if (Page.IsValid) { // Save the new user to the database SqlConnection con; string sql; SqlCommand cmd; StringBuilder sb = new StringBuilder(); ArrayList values = new ArrayList(); sb.Append("INSERT INTO [User] "); sb.Append("(UserID, Login, Password, FirstName, LastName, "); sb.Append("PhoneNumber, Email, IsAdministrator, Address, "); sb.Append("CellNumber, DateOfBirth) "); sb.Append("VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', "); // Optional values without quotes as they can be null sb.Append("{8}, {9}, {10})"); // Add required values to replace values.Add(Guid.NewGuid().ToString()); values.Add(txtLogin.Text); values.Add(txtPwd.Text); values.Add(txtFName.Text); values.Add(txtLName.Text); values.Add(txtPhone.Text); values.Add(txtEmail.Text); values.Add(0); // Add the optional values or Null if (txtAddress.Text != string.Empty) values.Add("'" + txtAddress.Text + "'"); else values.Add("Null"); if (txtMobile.Text != string.Empty) values.Add("'" + txtMobile.Text + "'"); else values.Add("Null"); if (txtBirth.Text != string.Empty) values.Add("'" + txtBirth.Text + "'"); else values.Add("Null"); // Format the string with the array of values sql = String.Format(sb.ToString(), values.ToArray()); // Connect and execute the SQL con = new SqlConnection("data source=127.0.0.1;initial catalog=Friends; user id=sa;"); cmd = new SqlCommand(sql, con); con.Open(); bool doredirect=true; try { cmd.ExecuteNonQuery(); } catch { doredirect = false; this.lblMessage.Visible = true; //this.lblMessage.Text = "Insert couldn't be performed. Username may already be taken."; this.lblMessage.Text = sql; } finally { con.Close(); } if (doredirect) Response.Redirect("Login.aspx"); } else lblMessage.Text = "Fix the following errors and retry:"; } Tag: Browsing records from a specific location Tag: 76267
  - 15
    - ADODB.Query Interface failed hello, I'm getting this Error when using a reference to ADODB.DLL Error#: 13 Error desc: QueryInterface for interface ADODB._Command failed can someone help me figure this out? thanks aj Tag: Browsing records from a specific location Tag: 76255
  - 16
    - changing Dataset column order Hi, I am using a SP to fill a dataset and it has 5 columns and data in it. I want to reorder the columns to oldDs --> newDS col1 --> col2 col2 --> col3 col3 --> col1 col4 --> col4 Anybody has idea of how to do this in best possible way? A code snippet would be highly appreciated. Thanks in advance Bravo Tag: Browsing records from a specific location Tag: 76254
  - 17
    - Grouping data at dataset level Hi, I have a SP and I am getting data in a dataset. The datatable in dataset is having 5 columns and out of 5 columns, data in 2 columns has composite unique value. Now I have to group the data based on these two column's value. Can anybody tell me how to do this?? I want to minimize the looping. A code sample would be highly appreciated. Thanks in advance Bravo Tag: Browsing records from a specific location Tag: 76253
  - 18
    - Turning off connection pooling in VS.Net Server Explorer? Is there a way to turn off connection polling in VS.Net's Server Explorer? For debugging purposes, I'd like to create a connection with Pooling=False, but I don't see this option in the Data Link property pagers, and the connection string it creates is read-only in my version (Professional) of VS.Net. Can I turn pooling off in a Server Explorer Data Connections object? Thanks -- Dave Veeneman Chicago Tag: Browsing records from a specific location Tag: 76250
  - 19
    - Primary column constrain programmatically How can I add Primary column constrainst on a DataTable Column in the program (C# or VB). Is the Unique property on DataColumn same as Primary cpnstraint. I need this because I need to Find() values in a DataColumn which is not a primary column in the DataSource. I want to make it a primary coulmn on the fly and search through it. What other option do I have to search through a column which is not a Primary column besides iterating through the DataRowCollection. thanks Aamir Tag: Browsing records from a specific location Tag: 76246
  - 20
    - Auto-Create Parameters? Does anyone have any good tips for coding lots of input parameters? I was wondering if there any tool out there that will auto-generate parameters for me, so I could point it at a database table and it would create for me everything except the values I'd assign them. Thanks, --Michael Tag: Browsing records from a specific location Tag: 76244
  - 21
    - (Search Tool) Alright Already I Fixed It :) This morning I let the group know that I had finished an application that categorizes posts in the vb.net and ado.net newsgroups and eliminates the trash that we hate to wade through on sites like Google and such. Well I would like to thank the multitude of you that have emailed me informing me of the bug in the datagrid (the scrollbars don't show up unless you resize the form after populating the grid). I knew you would be a tough audience but geez :) Actually I appreciate you letting me know. It is the inital release of this so I expected things like this. The bug is now fixed. The corrected version is 1.06. It should automatically remove your previous version but may not because the installer can be buggy. You can download the fixed version at http://www.kjmsolutions.com/newsgrouptool.htm Tag: Browsing records from a specific location Tag: 76242
  - 22
    - Retricting database access. For debugging purposes I have a class that takes in a string and executes this supposed SQL string on a given SQL Server Engine. For obvious reasons I would like to lock down this class as tight as I can but I am finding the access permissions a little daunting and I would like to request some help. First, I would like to restrict the command generated by the SQL script to be read-only. I don't want it to modify the data in the database at all. I don't see a read-only mode for the database security. Second, I would like to restrict the SQL servers that this class can be run against. It seems like the KeyRestrictionBehavior is doing what I want but I need an example of how to use it with SqlClientPermissionAttribute. Any other tips would be much appreciated. Kevin rkevinburton@charter.net Tag: Browsing records from a specific location Tag: 76240
  - 23
    - How do you manipulate records in an ADO.NET recordset? This question seems oversimplified to me, but I come from the land of creating recordsets in old ADO in which I could cycle through each record in the recordset and assign the values of the record to controls, count the number of records in the recordset, etc. In the new ADO.NET, I can only seem to create a dataset which I can set to a datagrid. The information in the datagrid is correct, but I want to be able to cycle through the records, read the the information in the dataset which I created by running a query against a table, and manipulate(read or change) as I see fit. I will tackle saving the information back to the database in the next phase. From my experience, this seems like a really simple question. Can anyone inform me of how simple or how complicated it really is? ----== 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: Browsing records from a specific location Tag: 76239
  - 24
    - @@IDENTIFIER and INSERT Hi, During an insert command, i'm using @@IDENTIFIER to obtain the key (auto increment colonne). 4 users insert record in the same time. result : user1 : Key=1 user2 : Key=2 user3 : Key=2 user4 : Key=3 I've problem because the insert command is good but i've only 3 new records .... Could you help me please ? Tag: Browsing records from a specific location Tag: 76238
  - 25
    - MissingMappingAction I have been trying to figure out why when I set the MissingSchemaAction= Error, I am getting an error. I have run out of ideas why this is occurring. I know that I could choose the "passthrough" setting and all would be well, but I want to understand why it is not happening - what property am I not setting correctly? I have enclosed everything about this situation as I can think of. Here is the DDL for my small table (just a primary key, not foreign keys) CREATE TABLE [SkatingClubs] ( [ClubID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_SkatingClub_ClubID] DEFAULT (newid()), [ClubName] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , CONSTRAINT [PK_SkatingClubs] PRIMARY KEY CLUSTERED ( [ClubID] ) ON [PRIMARY] ) ON [PRIMARY] GO Here is how I set the table up in code... DataTable dtClubs = new DataTable("SkatingClubs"); dtClubs.Columns.Add("ClubID",typeof(Guid)); dtClubs.Columns["ClubID"].AllowDBNull=false; dtClubs.Columns["ClubID"].Unique=true; dtClubs.Columns.Add("ClubName", typeof(string)); dtClubs.Columns["ClubName"].AllowDBNull=false; dtClubs.Columns["ClubName"].MaxLength=50; dtClubs.Columns["ClubName"].Unique=false; // set up primary key for Clubs Table DataColumn[] pkClubs = { dtClubs.Columns["ClubID"] }; dtClubs.PrimaryKey=pkClubs; ds.Tables.Add(dtClubs); // add to the dataset da.MissingMappingAction=MissingMappingAction.Error ; da.MissingSchemaAction=MissingSchemaAction.Error ; daFill(dtClubs); Here is the Proc that I am executing (a little stripped down...) select ClubID, ClubName from dbo.SkatingClubs set @recCount = @@ROWCOUNT I get the following error "Missing Table Mapping when TableMapping.DatasetTable='SkatingClubs'" Any ideas as to what the "MissingMapping" might be? Tag: Browsing records from a specific location Tag: 76237
- Next
  - 1
    - Safe to use regular ado in asp.net application I am working in a large asp.net application. I have found the ado.net learning curve to be quite large. I have two big pieces left in this project. Would I be safe using regular ado (not ado.net) in this? Tag: Browsing records from a specific location Tag: 76236
  - 2
    - SQLCommand Parameters Error Hello I've just read in Visual Studio Magazine Nov 2003 that using parameters in a sqlcommand is 37% faster than 'Exec procedure_name param1,param2,etc'. So i was trying to use it. <code> Me.SqlCommand2.Connection = Me.SqlConnection1 Me.SqlCommand2.CommandType = CommandType.StoredProcedure Me.SqlCommand2.CommandText = "imprime_linha_mapa" With Me.SqlCommand2.Parameters .Add("@worker", SqlDbType.Char).Value = "-1" .Add("@posto", SqlDbType.Decimal).Value = 0 .Add("@obra", SqlDbType.Char).Value = "" .Add("@inicio", SqlDbType.Char).Value = "" .Add("@fim", SqlDbType.Char).Value = "" .Add("@deltah", SqlDbType.Char).Value = "" .Add("@delta", SqlDbType.Decimal).Value = 0 .Add("@mov", SqlDbType.Decimal).Value = mov End With 'Me.SqlCommand2.CommandText = "exec imprime_linha_mapa '- 1',0,'','','','',0," & mov.ToString Try Me.SqlCommand2.ExecuteNonQuery() Catch ex As Exception MessageBox.Show(ex.Message) Me.SqlConnection1.Close() Exit Sub End Try </code> I get the following exception : Procedure or function imprime_linha_mapa has too many arguments specified. But that doesn't make any sense since the stored procedure 'imprime_linha_mapa' has the following declaration: <code> ALTER PROCEDURE imprime_linha_mapa @worker char(255), @posto numeric(3,0), @obra char(8), @inicio char(20), @fim char(20), @deltah char(8), @delta numeric(6,2), @mov numeric(9,0) AS </code> What am i doing wrong? Any suggestion would be most welcome, thanks! Kind Regards Jorge Cavalheiro Tag: Browsing records from a specific location Tag: 76231
  - 3
    - IIf Function and nulls Hello, I'm trying to assign a date value from a DataSet to a textbox. I'd like to use the IIf function so the code to assign it would just be one line, and not multiple lines ( I do have many dates to assign). So here is my problem, using IIf, I get a lovely error with the following code Cast from type 'DBNull' to type 'Date' is not valid. txtDate.Text = IIf(wcDS.WorkersCompensation(0).Isemployee_dobNull, String.Empty, CStr(wcDS.WorkersCompensation(0).employee_dob)) But when I create the actual if/else construct it works fine. If wcDS.WorkersCompensation(0).Isemployee_dobNull Then txtDate.Text = String.Empty Else txtDate.Text = CStr((wcDS.WorkersCompensation(0).employee_dob)) End If It's almost like for the IIf to work, both the truepart and falsepart would need to be able to work, all the time, is that so? Anyone have any ideas on this, or a better way to do it? Thanks, Michael Tag: Browsing records from a specific location Tag: 76226
  - 4
    - Debug offline Dear all, I'm trying to debut an ASP page from .net framework, and the VB.net sas that is not possible to debug it offline and ask about the version of the .et framework. I've installed version 1.1. Is it possible to debug my ASP.net application offline? Thanks for any help. Rodrigo. Tag: Browsing records from a specific location Tag: 76225
  - 5
    - Newbie with VB.NET & Ado Morning Group, Can someone possible answer a simple question for me? Should I use the Database Connection, DataAdapter, and Dataset Wizard or should I right my own code and not bother with the Wizards? Anybody know any good Links for me to read up on? I have a Simpl(ish) DB - Access XP with around 20 Tables and some Relationships Ta Regards Si Tag: Browsing records from a specific location Tag: 76211
  - 6
    - occasionally the wrong foreign key value is being assigned I Have a Master-Detail typed dataset with a DataRelation and a foreign key constraint. It will create new Learners (LEARNER_TK - Identity Field) and associated Learner Programme records (LEARNPROG_TK - Identity Field, LEARNER_TK as the foreign key to LEARNER). 99.9% of the time this works fine, but occasionally the wrong foreign key value is being assigned (this could be the last value or a combination of the generated master records). The pseudo code looks something like: DataAdapter.UpdateCommand = PStoredProcedure.GetStoredProcedure("PSP_PLEARNER_update") DataAdapter.InsertCommand = PStoredProcedure.GetStoredProcedure("PSP_PLEARNER_insert") DataAdapter.DeleteCommand = PStoredProcedure.GetStoredProcedure("PSP_PLEARNER_delete") DataAdapter.Update(DataSet, "PLEARNER") SQL for PSP_PLEARNER_INSERT: CREATE PROCEDURE PSP_PLEARNER_insert ( -- Parameters @TITLE_UK [varchar] (10), @LEARNER_NM [varchar] (20), ... @output_LEARNER_TK [int] OUTPUT ) AS INSERT INTO LEARNER(TITLE_UK,LEARNER_NM,...) VALUES(@TITLE_UK,@LEARNER_NM,...) SELECT @output_LEARNER_TK = SCOPE_IDENTITY() set @output_LEARNER_TK = @output_LEARNER_TK The above would then be repeated for then next table (e.g. LEARNERPROG). In the dataset the DataColumns hold the following values: AutoIncrement = True AutoIncrementSeed = 0 AutoIncrementStep = 1 And SQL Table structure of the primary key fields are: Identity = Yes IdentitySeed = 1 IdentityIncrement = 1 Results after the store: LEARNER TABLE (MASTER) ---------------------- LEARNER_TK LEARNER_NM 1 New Learner 1 2 New Learner 2 3 New Learner 3 4 New Learner 4 LEARNER PROGRAMME TABLE (DETAIL) -------------------------------- LEARNPROG_TK LEARNER_TK 1 4 (Should be set to '1') 2 4 (Should be set to '2') 3 4 (Should be set to '3') 4 4 (Should be set to '4') 4 New Learner & Learner programme records have been created, but the foreign key for LEARNER_TK is set to the last LEARNER_TK created on the Learner Table. I had a file that dumped the contents of the keys (internal values starting at 0) of the Master & Detail table (before storing the data) and these values matched up, so the problem lies in our Data IO Classes or the SQL Returned key. I was wondering if anybody else had a similar problem to this. Thanks in advance, Andy. .Net Development Env 2003 (Version 7.1.3088) .Net Framework 1.1 (Version 1.1.4322) Microsoft SQL Server 8.00.194 Tag: Browsing records from a specific location Tag: 76207
  - 7
    - database as parameter to SP Hi friends, can we pass database as input parameter to stored procedure. Then depanding upon the database passed query will be executed. We donot want it to done by using EXECUTE function in which database name is passed as string. Bye, Alpha --- Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/ Tag: Browsing records from a specific location Tag: 76195
  - 8
    - Batch SQL Commands, Performance? Hello All, In a large production environment, is there be a marked difference in performance when executing a batch of commands and a single command? My VERY simple profiling came up with no difference at all between the following two procedures. public void Update() { StringBuilder sb = new StringBuilder(); sb.Append("UPDATE RECORDINGS SET discID='3001' WHERE id=2001;"); sb.Append("UPDATE RECORDINGS SET title='The Freewheelin''' WHERE id=2001 ;"); sb.Append("UPDATE RECORDINGS SET artist='Bob Dylan' WHERE id=2001;"); //command is a SqlCommand object and the database is SQLServer command.ExecuteNonQuery(sb.ToString()); } public void BatchUpdate() { string commandText = UPDATE RECORDINGS SET discID='3001', title='The Freewheelin''', artist='Bob Dylan' WHERE id=2001"); command.ExecuteNonQuery(sb.ToString()); } I'm creating a persistence mechanism which in which one field of an object might map to TableA in DatabaseA and another might map to TableB in DatabaseB, or, for that matter, to a node in an xml file or some other storage. I would rather use these granular updates in batch rather than write code to combine them before execution. Thanks Robert Zurer Tag: Browsing records from a specific location Tag: 76187
  - 9
    - Populating Dataset from xml file I have an XML file which has elements with nodes. I can load this XML file into a .NET xml document and then populate a dataset with it. Since this xml file has nesting (only 1 level, like master- detail relationship) so can I populate 1 datatable with the parent elements and another datatable with the child nodes. Please provide some information on this. Any pointers or code will be appreciated. Thanks neel Tag: Browsing records from a specific location Tag: 76186
  - 10
    - Getting selected data from Grid x & y co-ordinates: C# Hello i'm developing a helpdesk application on a Windows Form that loads up a datagrid. the grid is populated by a select statement. the idea is that when a person loads up the form, all their open requests will load onto the datagrid. to edit their request, they need to right-click and select Edit Request from a context menu. this will then load up another form with all the details neatly displayed. i have gotten so far as to be able to load up the context menu on a right click and offer the option of "Edit Request". I have also managed to capture the X and Y co- ordinates of wherever the user right-clicked. so what my application does so far is: -it loads a datagrid with open requests, -when a right-click is issued anywhere on the datagrid a context menu appears offering an "Edit Request" option. -When this is selected, the x & y co-ordinates of the right-click are displayed in a message box. Each row in the datagrid has a ChangeID assigned to it, so, from the x & y points, i need to be able to capture the ChangeID from whatever row was right-clicked on. once i have this ID, i will pass it on to a stored proc which will then populate the EditRequests form (another form in my app). Would anyone have any idea on how to translate x & y co- ordinates into data? Any help here would be most appreciated! :) Thanks in advance!!!! Tag: Browsing records from a specific location Tag: 76184
  - 11
    - Which table can a ForeignKeyConstraint be placed on??? Ok, Here is a basic obvious question NO one answers: Why do some articles show the ForeignKeyConstraint being places on the Parent table, and others show it being added to the Child table? Does it matter? Since both the child and parent tables and columns are stored in it, why do I have to put it in a specific table anyway??? As well...if this is the case what is the point of the DataRelation? A ForeignKeyConstraint should be able to perform the exact same goal, if it was stored outside a given table. This really seems illogical...any help??? Tag: Browsing records from a specific location Tag: 76179
  - 12
    - connecting to access db for update from web app Hi- newbie post... so it'll probably be an easy answer :) I'm building a web app in which my students may submit an answer to a trivia question via aspx page. (http://www.sciencesmith.org/submit/trivia_submit.aspx) Access DB stores student name and answer via UPDATE command. When submit button is pressed (go try it!), a box pops up asking for user name and password, title bar says "Connect to www.sciencesmith.org". I'm passing userID and password as part of connection string. No matter what I type for username and password I get "You are not authorized to view this page". HTTP error 401.1 Of course user should not have to enter these things anyway... I'm just trying to establish SOME connection to my database. **I should note that this works fine on my local machine when developing the site with VS.NET... I only have a problem after I've uploaded my db and page to web server. I checked with web server and established a DSN for the database, setting a username and password (which is what I passed in the connection string). ** I'm thinking this should be a very simple task, not sure where I'm tripping up. THANKS IN ADVANCE! -Andy Tag: Browsing records from a specific location Tag: 76167
  - 13
    - how to update dataset w/ multiple table? I have search a lot of thread in google newsgroup and read a lot of articles but still i don't know how to update the dataset that has 3 tables. my 3 tables looks like the 3 tables from northwind database that has an employees, orders, and order details. the following are the 3 tables in my sql database students schyrsem SchYrSemCourse here's some variables i have Private dsStudentCourse As DataSet Private dtStudents As DataTable Private dtSchYrSem As DataTable Private dtSchYrSemCourse As DataTable Private dvSchYrSem As DataView Private dvSchYrSemCourse As DataView Private sda As SqlDataAdapter here's some of the code to fill the dataset Dim scnnNW As New SqlConnection(strConn) Dim strSQL As String = _ "SELECT IDNo, LastName, FirstName " & _ "FROM Students" Dim scmd As New SqlCommand(strSQL, scnnNW) sda = New SqlDataAdapter(scmd) Dim scb As New SqlCommandBuilder(sda) scb.GetUpdateCommand() dsStudentCourse = New DataSet() sda.Fill(dsStudentCourse, "Students") scmd.CommandText = _ "SELECT SchYrSemID, IDNo, SchYr, Sem FROM SchYrSem" sda.Fill(dsStudentCourse, "SchYrSem") scmd.CommandText = _ "SELECT SchYrSemCourseID, SchYrSemID, Course.CourseID, CourseTitle, CourseDesc, Unit, [Hours/Week] FROM Course INNER JOIN SchYrSemCourse ON Course.CourseID = SchYrSemCourse.CourseID" sda.Fill(dsStudentCourse, "SchYrSemCourse") dtStudents = dsStudentCourse.Tables(0) dtSchYrSem = dsStudentCourse.Tables(1) dtSchYrSemCourse = dsStudentCourse.Tables(2) dvSchYrSem = dtSchYrSem.DefaultView dvSchYrSemCourse = dtSchYrSemCourse.DefaultView i have also search the msdn for updating a multiple table but all i can see is on how to save a single table only. i would be very if someone can enlighten me on how to save a dataset that has a multiple table in it. Tag: Browsing records from a specific location Tag: 76166
  - 14
    - SQL Alias in Connection String Hi all I have an ASP.NET application accessing a SQL named instance that runs o the web server. To allow easy deployment from the development environment t production, a SQL alias "My_Alias" has been set up using the Client Networ Utility. The alias is configured to use a Named Pipes connection pointing t the named instance. Both EM and isqlw recognise My_Alias The application attempts to connect as follows <snip Dim myConnection As SqlConnection = Ne SqlConnection(ConfigurationSettings.AppSettings("MyConnectionString") </snip where the connection string is defined in Web.config <snip><add key="MyConnectionString value="Server=My_Alias;Trusted_Connection=true;database=MyDatabase" /></snip This fails with error "System.Data.SqlClient.SqlException: SQL Server doe not exist or access denied If I replace "My_Alias" in the connection string with the instance nam "MyServer\MyInstance" all is well. Why is it failing with the alias? I hav tried an alias name without an underscore, and also tried explicitly settin the network library to named pipes in the connection string. Have also foun that My_Alias will work if I configure it for a TCPIP connection... but want the efficiency of named pipes because client and server are the sam machine Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705. Windows 2000 Server SP SQL 2000 Standard SP Tag: Browsing records from a specific location Tag: 76162
  - 15
    - Stored procedure in Crystal Reports How can you create a crystal report file using a complex stored procedure? Would you have to construct an equally complex typed dataset or is there some other way? Tag: Browsing records from a specific location Tag: 76159
  - 16
    - sqlconnection login question I have created a logon dialog box to collect the userid and password to create my connection string. This connection is a global variable for all my forms to use. The reason I did this was when using the connection wizard (or SQLAdapter wizard) you are forced to use the sa password not a variable. You can not manually change this in the initialization code since the textboxes for username and password do not exist yet. All the ADO.net books I have read just use the sa password to connect, not the best practice for some databases. This is causing problems for future forms since I have to code the Dataset and binding manually. Can anyone tell me a better way to obtain the userid and password yet still use the wizards to simplify coding? Tag: Browsing records from a specific location Tag: 76158
  - 17
    - Dataset error using Access I am learning .net and am using the ASP.net Unleashed shopping cart as a basis. I am attampting to convert it to use an Access DB. Everything is working so far except for the adding of a shopping cart item. I receive the following error: OleDbCommand.Prepare method requires all parameters to have an explicitly set type. The VB Code is as follows: ' Retrieve the shopping cart strSelect = "Select itemID, userID, ProductID, ProductName, UnitPrice, Quantity From ShoppingCarts Where userID = ?" 'changed @userID to ? _dadCart = New OleDbDataAdapter( strSelect, _conCart ) _dadCart.SelectCommand.Parameters.Add( "@userID", _guidUserID ) _dadCart.MissingSchemaAction = MissingSchemaAction.AddWithKey _cbCart = New OleDbCommandBuilder( _dadCart ) _dstCart = New DataSet _dadCart.Fill( _dstCart, "Cart" ) 'Add a record Public Sub Add( ProductID As Integer, ProductName As String, UnitPrice As Decimal ) Dim drowItem As DataRow .... drowItem = _dstCart.Tables( "Cart" ).NewRow drowItem( "UserID" ) = _guidUserID drowItem( "ProductID" ) = ProductID drowItem( "ProductName" ) = ProductName drowItem( "UnitPrice" ) = UnitPrice drowItem( "Quantity" ) = 1 _dstCart.Tables( "Cart" ).Rows.Add( drowItem ) .... UpdateCartDB End Sub Private Sub UpdateCartDB _dadCart.Update( _dstCart, "Cart" ) End Sub I have tried searching for references to this but am coming up short. Any suggestions or guidance would be GREATLY appreciated. TIA, J. Clay Tag: Browsing records from a specific location Tag: 76149
  - 18
    - New ASP.NET 2.0 Terminology: "CROSSPOST" is a very BAD name to use Dear Microsoft: In your new ASP.NET 2.0 page model of being able to crosspost to another page, it would seem that if you were to type that word in Google, "crosspost" or "cross post", you will get endless amount of results from the newsgroup police complaining about posters cross posting to many newsgroups as this very message is doing. So to those at Microsoft, and since posting your form results to another page is very very important in a web site, and probably a big big part of why .NET is so difficult, I recommend you find a better name than "cross post". Otherwise, when you do that Google or Yahoo search for "cross post" when trying to learn how to post to another page, you will get endless results from the newsgroup police. There is no let up in the newsgroup police complaining about cross posting, so don't think when ASP.NET comes out Google or whatever will be able to tell the difference as the "cross posting" complaints are never ending and are always current. If you do that in newsgroups or in the Web, you will also get the same etiquette complaints or web pages as well. You, Microsoft, are essentially choosing the exact same name as the newgroups police do in their complaints and will only confuse people more. Perhaps, you should using something on the lines of the "Post Back" name....how about "Post Forward"? or something of the like...but definately NOT the word, "cross post". Tag: Browsing records from a specific location Tag: 76148
  - 19
    - Populating Combo from Data Table I would like to create a distinct list of last names from a data table, then populate a combo box with these values. What's the best way to accomplish this in ADO.net? Bob Tag: Browsing records from a specific location Tag: 76130
  - 20
    - Computed Column Hello, I think you can create a column in a datatable which is computed based upon other columns in the datatable, but I am not sure how to do this. Say you have a table with "FirstName" and "LastName" and you want to create a column in the data table which equates to "LastName" + ", " + "FirstName". How would you do this? If you add the column to the table, how will this effect the setting of MissingMappingAction and MissingSchemaAction properties on the dataAdapter? Thanks in advance for your assistance!!!!!! Tag: Browsing records from a specific location Tag: 76127
  - 21
    - Find in ADO.net I'm looking for the equivalent of the Find method from ADO in ADO.net. It appears that the Find method in .Net only works on the Key field. How do I search for the first record in a DataTable that meets a given criteria? Tag: Browsing records from a specific location Tag: 76123
  - 22
    - DataBinding Hello - I know that you can bind a control to a table and set the DisplayMember and ValueMember for a particular table. No problem. My question is if there is a way to relate this to another control. Say for instance I have a control which allows a user to select "Color" with is "bound" to a DataTable called "Colors". Then I have another control which list body styles. Not all body styles are available in all colors. When the user selects a new color in one control, I only want to display the body styles which relate to that color. I know that I can do this with a "DataView" and when the SelectedIndex changes on the Colors control, I would then set the dataview on the Body Style Control to the appropriate color. But is there a better way other then this? Tag: Browsing records from a specific location Tag: 76116
  - 23
    - Nortwind.NET? I am looking for something like the nortwind database system but with the tables in SQL and the forms in C#. I already know about TaskVision but what and I am looking is sales point system or something like that. By the way I am not intererested in ASP.NET I want it to be Windows Forms. I allready searched in the mos populars code web site but they do not have any completed system like northwind but instead small systems to be use as samples. I want a Full Open Source C# Windows Forms Database (accounting, sales point or something like that) System. Eliezer Figueroa Tag: Browsing records from a specific location Tag: 76113
  - 24
    - SQL and its primary key Hi I attempted in a database update to autoincrement the primary key this way: Dim i As Integer = 1 Dspostings1.Postings.PostIDColumn.AutoIncrement = True Dspostings1.Postings.PostIDColumn.AutoIncrementSeed = -1 Dspostings1.Postings.PostIDColumn.AutoIncrementStep = -1 but the value returned as -1 Also there is hold over data (highest number 54) in the database that was imported. My hope was it would use the next number (55) when creating the record. What did I do wrong? This did work in access. Tag: Browsing records from a specific location Tag: 76112
  - 25
    - MissingMappingAction I have been trying to figure out why when I set the MissingSchemaAction= Error, I am getting an error. I have run out of ideas why this is occurring. I know that I could choose the "passthrough" setting and all would be well, but I want to understand why it is not happening - what property am I not setting correctly? I have enclosed everything about this situation as I can think of. Here is the DDL for my small table (just a primary key, not foreign keys) CREATE TABLE [SkatingClubs] ( [ClubID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_SkatingClub_ClubID] DEFAULT (newid()), [ClubName] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , CONSTRAINT [PK_SkatingClubs] PRIMARY KEY CLUSTERED ( [ClubID] ) ON [PRIMARY] ) ON [PRIMARY] GO Here is how I set the table up in code... DataTable dtClubs = new DataTable("SkatingClubs"); dtClubs.Columns.Add("ClubID",typeof(Guid)); dtClubs.Columns["ClubID"].AllowDBNull=false; dtClubs.Columns["ClubID"].Unique=true; dtClubs.Columns.Add("ClubName", typeof(string)); dtClubs.Columns["ClubName"].AllowDBNull=false; dtClubs.Columns["ClubName"].MaxLength=50; dtClubs.Columns["ClubName"].Unique=false; // set up primary key for Clubs Table DataColumn[] pkClubs = { dtClubs.Columns["ClubID"] }; dtClubs.PrimaryKey=pkClubs; ds.Tables.Add(dtClubs); // add to the dataset da.MissingMappingAction=MissingMappingAction.Error ; da.MissingSchemaAction=MissingSchemaAction.Error ; daFill(dtClubs); I am using a proc, and here is that proc... ALTER proc Proc_QueryClubName @Name char(50) = null, @msg nvarchar(220) out as declare @recCount int if @Name is null begin select ClubID, ClubName from dbo.SkatingClubs set @recCount = @@ROWCOUNT end else begin select ClubID, ClubName from dbo.SkatingClubs where ClubName = @name set @recCount = @@ROWCOUNT end if @@ERROR != 0 Begin set @msg = 'Unexpected error occurred retrieving records for Skating Clubs, Procedure Name: Proc_QueryClubName Error code: ' + cast(@@ERROR as nvarchar(4)) return -1 end set @msg = ' ' return 0 I get the following error "Missing Table Mapping when TableMapping.DatasetTable='SkatingClubs'" Any ideas as to what the "MissingMapping" might be? Tag: Browsing records from a specific location Tag: 76111

Hi,

I've created a Data Form with the Wizard (Under VB.net
and MS Access)
I can browse the records with the buttons( movefirst,
movelast,move previous,...).
If I want to move to a specific location like where
costumersID=5 for example, and then continuing browsing
the records with the buttons from that position.
How can it be done?

Thanks in advance,

Luis Mendes

Top

Re: Browsing records from a specific location by Miha

Miha
Tue Jan 06 11:42:27 CST 2004

Hi Luis,

First, you have to find the BindingManagerBase (depends on the datasource
the way to obtain it)
Once you have it, simply set its Position property to record number.

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

"Luis Mendes" <anonymous@discussions.microsoft.com> wrote in message
news:09a401c3d467$097d4330$a501280a@phx.gbl...
> Hi,
>
> I've created a Data Form with the Wizard (Under VB.net
> and MS Access)
> I can browse the records with the buttons( movefirst,
> movelast,move previous,...).
> If I want to move to a specific location like where
> costumersID=5 for example, and then continuing browsing
> the records with the buttons from that position.
> How can it be done?
>
> Thanks in advance,
>
> Luis Mendes

Top