I need to run a vb.net or aspx.net file every 10 seconds.

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
 - Confirm before delete Hello, How do i confirm before delete from the datagrid? I did like this. But getting error... "Object Reference not set to an instance of object" <asp:datagrid id="dgbrand" Runat="server" Font-Size="12px" Font-Name="arial" BorderColor="SteelBlue" OnEditCommand="editMode" OnUpdateCommand="doUpdate" OnCancelCommand="cancelEdit" DataKeyField="brand_code" AutoGenerateColumns="False" Width="400px" Font-Names="arial" OnDeleteCommand="doDelete"> <AlternatingItemStyle BackColor="#CCCCCC"></AlternatingItemStyle> <HeaderStyle Font-Bold="True" BackColor="Salmon"></HeaderStyle> <Columns> <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="CAN" EditText="Edit"></asp:EditCommandColumn> <asp:BoundColumn DataField="brand_code" ReadOnly="True" HeaderText="Brand Code"> <ItemStyle HorizontalAlign="Center"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="brand_name" HeaderText="Description"></asp:BoundColumn> <asp:TemplateColumn> <ItemTemplate> <asp:LinkButton ID="cmddel" Runat="server" Font-Underline="True" ForeColor="#0000ff" CommandName="Delete">Del</asp:LinkButton> </ItemTemplate> </asp:TemplateColumn></Columns> </asp:datagrid> Private Sub dgbrand_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgbrand.ItemDataBound Dim mybut As LinkButton mybut = e.Item.FindControl("cmddel") mybut.Attributes.Add("onclick", "return confirm('Are you sure to delete?')") End Sub And, i placed the controls manually in the table tag. When i rebuild the project, automatically some unnecessary table is adding in VS.NET that changes my actual alignment. How can i stop this? Thanx in advance Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100569
 - 2
 - ADO.Net equivalent of the ADO rs.GetRows() method Hi, I had a VB application that exported the values of one column - all rows - to an array by doing: rs.movefirst ar = rs.getrows(, , "col2") What is the equivalent to this in ADO.Net? Thanks Ali Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100568
 - 3
 - DataSet.Merge yielding Constraint Error I have dataset1, do a GetChanges to yield dataset2 dataset2 is saved The keys from dataset2 are used as search parameters to retrieve new data into dataset3. dataset1's DataRowState (the test row) is Modified dataset3's DataRowState is Unchanged It's a simple update, so all of the primary key values are there (Original, Current, etc.) dataset3 is returned and then I attempt to merged into dataset1 - and I get Constraint Error. Looking in the watch window I see that dataset3's rows are being added to dataset1 and this thus leads to a Constraint Error. Why aren't the values being "merged" based on primary key? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100565
 - 4
 - Concurrency Issues after a Delete has occurred in Access This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C4DC40.AB537E90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi I get this error below. ------------------- An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll Additional information: Concurrency violation: the DeleteCommand affected 0 records. -------------------- I am using Access and this only happens when I delete data from a Dataset and then try to Update it back to the BD. Adding Works Well and Updating is fine, just deleting. Any Ideas? Thx ------=_NextPart_000_0014_01C4DC40.AB537E90 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD> <BODY> <DIV>Hi I = get this error=20 below.</DIV> <DIV><SPAN=20 class=3D580193623-06122004>-------------------</DIV> <DIV><SPAN=20 class=3D580193623-06122004> </DIV> <DIV> <DIV>An = unhandled=20 exception of type 'System.Data.DBConcurrencyException' occurred in=20 system.data.dll</DIV> <DIV> </DIV> <DIV>Additional=20 information: Concurrency violation: the DeleteCommand affected 0=20 records.</DIV> <DIV><SPAN=20 class=3D580193623-06122004>--------------------</DIV= > <DIV><SPAN=20 class=3D580193623-06122004> </DIV> <DIV><SPAN=20 class=3D580193623-06122004>I am using Access and this only happens when = I delete=20 data from a Dataset and then try to Update it back to the=20 BD.</DIV> <DIV><SPAN=20 class=3D580193623-06122004> </DIV> <DIV><SPAN=20 class=3D580193623-06122004>Adding Works Well and Updating is fine, just=20 deleting.</DIV> <DIV><SPAN=20 class=3D580193623-06122004> </DIV> <DIV><SPAN=20 class=3D580193623-06122004>Any Ideas?</DIV> <DIV><SPAN=20 class=3D580193623-06122004> </DIV> <DIV><SPAN=20 class=3D580193623-06122004>Thx</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV></DIV>= </BODY></HTML> ------=_NextPart_000_0014_01C4DC40.AB537E90-- Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100564
 - 5
 - Concurrency Troubles using Access as Database '?' Appear in SQL This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C4DC3C.8D141AB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am using access as the main DB for an application. Whenever I try to update the DB by my Dataset I get Exception below. -------------- An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll Additional information: Concurrency violation: the DeleteCommand affected 0 records. -------------- What worries me is the "?" in the SQL below of the Update Command? Is this normal? I just cannot get my head around the "?" All the code below was generated by Visual Studio. Do I have to modify this or am I doing something Wrong? Thanks in Advance. 'OleDbUpdateCommand1 ' Me.OleDbUpdateCommand1.CommandText = "UPDATE Reminders SET ReminderDate = ?, ReminderTime = ?, Route = ? WHERE (EventID" & _ " = ?) AND (ReminderDate = ? OR ? IS NULL AND ReminderDate IS NULL) AND (Reminder" & _ "Time = ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route = ? OR ? IS NULL AND " & _ "Route IS NULL)" Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("ReminderDate", System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate")) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("ReminderTime", System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime")) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Route", System.Data.OleDb.OleDbType.VarWChar, 50, "Route")) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_EventID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "EventID", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ReminderDate", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ReminderDate1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ReminderTime", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_ReminderTime1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Route", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Route", System.Data.DataRowVersion.Original, Nothing)) Me.OleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Route1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Route", System.Data.DataRowVersion.Original, Nothing)) ' ------=_NextPart_000_0000_01C4DC3C.8D141AB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN=20 class=3D486520223-06122004>Hi,</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>I am = using access as=20 the main DB for an application.</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>Whenever I try to=20 update the DB by my Dataset I get Exception below.</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV><SPAN=20 class=3D486520223-06122004>--------------</DIV> <DIV>An = unhandled=20 exception of type 'System.Data.DBConcurrencyException' occurred in=20 system.data.dll</DIV> <DIV> </DIV> <DIV>Additional=20 information: Concurrency violation: the DeleteCommand affected 0=20 records.</DIV> <DIV><SPAN=20 class=3D486520223-06122004>--------------</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>What = worries me is=20 the "?" in the SQL below of the Update Command?  Is this=20 normal?</DIV> <DIV>I just = cannot get my=20 head around the "?"</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>All = the code below=20 was generated by Visual Studio.</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>Do I = have to modify=20 this or am I doing something Wrong?</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV>Thanks = in=20 Advance.</DIV> <DIV><SPAN=20 class=3D486520223-06122004> </DIV> <DIV> </DIV> <DIV> 'OleDbUpdateCommand1<FONT=20 size=3D2> ' Me<FONT=20 size=3D2>.OleDbUpdateCommand1.CommandText =3D "UPDATE Reminders SET = ReminderDate =3D=20 ?, ReminderTime =3D ?, Route =3D ? WHERE (EventID" & _ " =3D ?) AND (ReminderDate =3D ? OR ? IS NULL AND ReminderDate IS = NULL) AND=20 (Reminder" & _ "Time =3D ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route =3D ? = OR ? IS NULL=20 AND " & _ "Route IS NULL)" Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Connection =3D Me.OleDbConnection Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New = System.Data.OleDb.OleDbParameter("ReminderDate",=20 System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate")) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New = System.Data.OleDb.OleDbParameter("ReminderTime",=20 System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime")) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New = System.Data.OleDb.OleDbParameter("Route",=20 System.Data.OleDb.OleDbType.VarWChar, 50, "Route")) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_EventID",=20 System.Data.OleDb.OleDbType.Integer, 0, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "EventID",=20 System.Data.DataRowVersion.Original, Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_ReminderDate",=20 System.Data.OleDb.OleDbType.DBDate, 0, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20 System.Data.DataRowVersion.Original, Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_ReminderDate1",=20 System.Data.OleDb.OleDbType.DBDate, 0, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20 System.Data.DataRowVersion.Original, Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_ReminderTime",=20 System.Data.OleDb.OleDbType.DBDate, 0, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20 System.Data.DataRowVersion.Original, Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_ReminderTime1",=20 System.Data.OleDb.OleDbType.DBDate, 0, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20 System.Data.DataRowVersion.Original, Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_Route",=20 System.Data.OleDb.OleDbType.VarWChar, 50, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", = System.Data.DataRowVersion.Original,=20 Nothing)) Me<FONT=20 size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20 System.Data.OleDb.OleDbParameter("Original_Route1",=20 System.Data.OleDb.OleDbType.VarWChar, 50, = System.Data.ParameterDirection.Input,=20 False, = <FONT=20 color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", = System.Data.DataRowVersion.Original,=20 Nothing)) '</DIV></BODY></HTML> ------=_NextPart_000_0000_01C4DC3C.8D141AB0-- Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100562
 - 6
 - ---> System.Transactions and SqlTransaction <---- Okay, I have been trying to peice this together - and I know folks on this board have the answer. What is the common ground between System.Transactions and SqlTransaction? Would it be correct to say that - For most of my work that interacts with one single database, as far as I can see so far, I should stick with the old fashioned SqlTransaction. And well if I need or might have to deal with the possibility that I would have to ever promote my transaction to more than one database, or to other non d/b like resources like MSMQ, then System.Transactions is what I need. In that sense it is incorrect to think that - SqlTransaction is a baby System.Transactions.Transaction.Create() SqlTransaction is going to be deprecated anyday soon. System.Transactions.Transaction is the way to go - and SqlTransaction is not. Either SqlTransaction or System.Transactions is dud - they both kick a33, but serve different purposes. SqlTransaction is an orange, System.Transaction is an apple - both are fruits but can't be compared. Again - my understanding about this could be totally out of whack - and I am hoping someone will fix my understanding of the matter. I've also blogged about this here - http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/06/35314.aspx (and other posts). All in all I am very excited about System.Transactions but I don't want to misuse it :-) - Sahil Malik http://dotnetjunkies.com/weblog/sahilmalik Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100560
 - 7
 - Can't Open Database from WebService I have a project consisting of a Web application and a Web service. The Web application calls the Web service to do some modifications in a database ( Microsoft Access ) When the OleDbConnection.Open function is called I receive the followin message: [SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258 at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 224 at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177 --- End of inner exception stack trace ---] System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80 NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source, DataGridCommandEventArgs e) in C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948 System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e) System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain() The same behavior when I try to open a SQL database. When I call the same function from the Web application everything works!!!! Has anyone any idea what it may be wrong? Thanks in advance for your help -- DimX Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100559
 - 8
 - ADO Connection question I am having trouble opening an Access DB using ADO from VB. I am part of a workgroup, the error message is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. I can open the DB from Access. I have provided my user ID as part of the login, my workgroup password is blank. Thanks in advance... Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100558
 - 9
 - add STOP button, to cancel the query process I have form that executes heavy Stored Procedure on sql 2000. I want to add STOP button, to cancel the process. I try to abort the thread. But this action not stops the process Immediately. It?s take a long time until query cancel. In the Query Analyzer I can kill the process at once by disconnecting the window, it?s cause also to cancel the query. How I can do something like from .NET code? I try close Connection from Main thread, and nothing happened? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100547
 - 10
 - How do I "Fake" a Bookmark? I have a 'for each DataRow in DataTable.Rows loop and I need a way to jump back to a privious row and continue the loop. I haven't been able to come up with any clever ways of faking this since Bookmarks don't exist anymore:-( Thnx, Grayson Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100544
 - 11
 - DataSet I need to convert a VB6 Disconnected Recordset project to C#. The VB6 app uses ADO to create a recordset, add fields, add data. It then Binds to a grid. The VB6 App uses the client side cursor. When ever I move through the Recordset using (MoveNext,MovePrevious,Find) th Grids cursor position mirrors the recordset row. I can't seem to duplicate this in C#. I can create a Dataset, add fields, add data and use the "Find" method and bind the datagrid BUT the grids cursor doesn't track. Also I can't find the Navigate functions in the Dataset(MoveNext,MovePrevious,EOF,BOF) I really need those. is there a "Cursor" in the Dataset? I am somewhat confused, I'm still thinking in the older ADO world... Can someone point me in the right direction? Thanks... -Lou Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100536
 - 12
 - Throw DbConcurrencyException? I am using SQL OleDb provider (not SqlManaged provider). I have an ADO.NET class that uses DataAdapter.Update to pass changes to the database. I have a "concurrency" column in the database and in my DataTable. The MSSQL (2000) stored procedure only does the update of the "concurrency" column matches, if not it returns a result set. What is a good strategy for detecting, at the SP or DataAdapter level, if the update failed so I can throw a DBConcurrencyException? What is a good strategy for force-throwing a DBConcurrencyException from the DB? Thanks. Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100535
 - 13
 - Data Type Error Reading from database Thanks Memnoch, I have got round with that error and now something else has cropped up. My guess is that its something to do with data conversion. I am getting this error, In my database, the field LoginName is set as Vachar type. It looks as though there is a problem reading this field. could you please enlighting me on what I have done wrong and what i could do to correct this error. Thanks for you Help. ''----------------------Error------------------------- The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable. Source Error: Line 56: authorisedusernameList.Items.Add( dataReader.GetString( 0 ) ); Source File: c:\inetpub\wwwroot\websupportproject\login.aspx.cs Line: 56 Stack Trace: [InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.] System.Data.OleDb.DBBindings.get_ValueString() System.Data.OleDb.OleDbDataReader.GetString(Int32 ordinal) WebsupportProject.Login.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\websupportproject\login.aspx.cs:56 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() '---------------end of error------------------------------ Thank you for your help so far. Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100526
 - 14
 - connectionstring Hi, I am new to dotNET. I want to connect to MSAccess DB from ASP.NET I want to seperate connectionstring and open the connection just as an object and properties. I am not able to do that. How can i do? In every page i want to connect to DB and no need to specify connectionstring in every page. And, how can i set the connectionstring in web.config file? <appSettings> <add key="appconnection" value="Provider=....;data source=????> Here we must specify physical path. But with web always must specify virtual path. How can i set server.mappath here? </appSettings> Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100516
 - 15
 - Interrogating mySQL datatypes with ADO.NET Hi, Interrogating the DataType property of a DataColumn object where the underlying column in a mySQL table is CHAR, VARCHAR or TEXT returns System.String for each. Is there a method to differentiate these underlying datatypes and, if so, to interrogate the column length so that it will return me, say, VARCHAR(20) instead of just System.String? Any assistance gratefully received. Best regards, Mark Rae Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100513
 - 16
 - RUSH YOUR RESUMES -------------------------------------------------------------------------------- 1. Software Professionals: B.Tech/MCA from reputed institute/university with 4-6 years of software experience with excellent conceptual understanding and extensive usage of: Ø Microsoft Technology - ASP, .net, HTML, COM, XML, VSS and SQL Server. Ø Java/J2EE Technology - Java, J2EE, EJB, Swing, Servlets, JSP, Struts, XML, XSL style sheets, JDBC, PL/SQL. -------------------------------------------------------------------------------- 2. Project Managers/Software Architects/Database Architect: B. Tech/MCA with Software Project Management experience of 8-12 years. Should have handled projects in Microsoft Technologies like ASP, .Net, etc. Sound knowledge of SDLC & quality processes and ability to manage a team of software engineers, meeting the delivery schedules with quality. For Software Architect / DBA, extensive experience either in Software architecture (Microsoft technology - ASP, .net) or SQL server design and architecture are needed. -------------------------------------------------------------------------------- 3. Testing Professionals: B.Tech/MCA with strong testing skills, preparing test cases and test plans, reporting & tracking the Bugs using PVCS Tracker. Candidates with 3-5 yrs experience in Functional testing, Integration testing, System testing & Acceptance testing along with 2 yrs software development experience are more preferred. Exposure in automated test tools like Mercury WinRunner is desirable. Candidates with 8-10 years experience will be considered for senior position and such candidates should have experience in managing / leading a team. -------------------------------------------------------------------------------- 4. Back Office Associate: B.Com / M.Com / MBA with 1- 2 yrs experience and sound understanding of the Stock Market. Comfortable using MS office tools. Experience in depository, brokerage and/or stock holding industry with exposure to back office operations will be an added advantage. -------------------------------------------------------------------------------- 5. CFA Professionals: Maximum 3 years total work experience, of which minimum 1 year experience with a securities firm. Thorough knowledge of Capital Markets, Advisory Business, and Custodian Operations. Will be a Business Analyst / Domain Expert / Financial Consultant to the technical team, responsible for the accuracy of the functionality and end-to-end testing of an industry leading system for financial advisors. Knowledge about US capital markets will be an added advantage. Should have excellent analytical and communication skills and to be a go-getter. -------------------------------------------------------------------------------- princematthewkoshy@yahoo.com TRIVANDRUM Kerala INDIA Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100512
 - 17
 - logon failed on asp.net and crystal report Hi, I have made a asp.net application which is having a asp.net page showing crystal report.net on it(using crystal report viewer), and MS Access as back end.But when i try to view in a browser it is showing logon failed. I donn't have any password set in my mdb file. Regards Reny --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.806 / Virus Database: 548 - Release Date: 05/12/04 Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100510
 - 18
 - How I can give to my user ability to kill or cancel transaction Sql 2000 with dot.net 1.1 How I can give to my user ability to kill or cancel transaction Immediately, and rollback? I try to kill the thread. But this not cause the transaction to be Cancel immediately. First this takes a lot of time. Secondly I not be sure if this make rollback. Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100508
 - 19
 - Get XML from typed dataset Hi, I was using Typed Dataset in VB.NET to generate XML file. I difined XSD file( named customer_order_info) to include three tables, let's say customers, orders and order_details. I also defined relationship between customers and orders, orders and order_details.( customerid is PK in customers, orderid is PK in orders, orderid and productid are PK in order_details). In my VB.NET code, I declared a variable as the XSD(customer_order_info), declared a adapter to populate it(some common routines to get dataset). the select command is a stored procedure which will retuen 3 recordsets. I also defined table mappings when I populated the dataset. After I got the dataset, I call ds.getXML to get xml file. I was able to get the file with correct content, but the format is wrong. For eample, the format should be as follows: <customer customerid=â??aaaâ?? name=â??billâ?? phone=â??123345456â?? > <order orderid=â??1011â?? customerid=â??aaaâ?? shipname=â??Du monde entireâ??> <order_detail orderid=â??1011â?? productid=â??tool1â?? quantity=â??12â??/> <order_detail orderid=â??1011â?? productid=â??tool2â?? quantity=â??20â??/> <order_detail orderid=â??1011â?? productid=â??tool3â?? quantity=â??30â??/> </order> <order orderid=â??1012â?? customerid=â??aaaâ?? shipname=â??Du monde entireâ??> <order_detail orderid=â??1012â?? productid=â??tool4â?? quantity=â??12â??/> <order_detail orderid=â??1012â?? productid=â??tool2â?? quantity=â??20â??/> <order_detail orderid=â??1012â?? productid=â??tool5â?? quantity=â??30â??/> </order> </customer> But I got : <customer customerid=â??aaaâ?? name=â??billâ?? phone=â??123345456â?? > <order orderid=â??1011â?? customerid=â??aaaâ?? shipname=â??Du monde entireâ??/> <order orderid=â??1012â?? customerid=â??aaaâ?? shipname=â??Du monde entireâ??/> <order_detail orderid=â??1011â?? productid=â??tool1â?? quantity=â??12â??/> <order_detail orderid=â??1011â?? productid=â??tool2â?? quantity=â??20â??/> <order_detail orderid=â??1011â?? productid=â??tool3â?? quantity=â??30â??/> <order_detail orderid=â??1012â?? productid=â??tool4â?? quantity=â??12â??/> <order_detail orderid=â??1012â?? productid=â??tool2â?? quantity=â??20â??/> <order_detail orderid=â??1012â?? productid=â??tool5â?? quantity=â??30â??/> </customer> Could anyone help me out? Thanks. Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100500
 - 20
 - How to excute a MS Access Stored procedure? Hi, there I have create a MS Access Stored procedure using the code below and no error occured. '--------------------------------------------------------------------------- --- Dim cmd As OleDbCommand cmd = Conn.CreateCommand cmd.CommandType = CommandType.Text Try cmd.CommandText = _ "CREATE PROC udpGetSampleIDByName" & vbCrLf & _ "(@zSampleName VarChar(64))" & vbCrLf & _ "AS" & vbCrLf & _ "Select zSampleID FROM TSamples " & _ "Where zSampleName = @zSampleName " cmd.ExecuteNonQuery() Catch e As Exception MessageBox.Show(e.ToString, "Error Creating Stored Procedure") Finally cmd.Dispose() End Try '--------------------------------------------------------------------------- ------ And now I want to call the Stored procedure with OleDBCommand . After I excute the codes below I got an error message: "The syntax of the input string is invalid!" '--------------------------------------------------------------------------- ------ 'connNoTran is an opened oledbconnection Dim oCmd As New OleDbCommand With oCmd .Connection = connNoTran .CommandType = CommandType.StoredProcedure .CommandText = "udpGetSampleIDByName" .Parameters.Add("", OleDbType.SmallInt) .Parameters(0).Value = sName End With Try oCmd.ExecuteNonQuery() Catch e As Exception MessageBox.Show(e.ToString) End Try '--------------------------------------------------------------------------- ------ Anyone can help me? Peter Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100497
 - 21
 - Please Help Me - object reference not set to an instance hello all, I am new to C# and ASP, I am trying to build and applicationwith a login in page. I followed an example from a book to create his page but I am havin problem when i run the program. I know there has been a thread like this in this forum but the suggestion I have tried does not correct this problem. please have a look at the code belo and help me.need help urgently. you help is much appreciated. When i run the run I get this error in the browser, Object reference not set to an instance of an object" The error is on the line coloured red - dataReader = oleDbDataAdapter1.SelectCommand.ExecuteReader(); '------code from program--------- using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Web.Security; using System.Data.OleDb; namespace WebsupportProject { /// <summary> /// Summary description for WebForm1. /// </summary> /// allow authorised users to login public class Login : System.Web.UI.Page { protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1; protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1; protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1; protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1; protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1; protected System.Data.OleDb.OleDbConnection oleDbConnection1; protected System.Data.OleDb.OleDbDataReader dataReader; //web form labels protected System.Web.UI.WebControls.Label lbpassword; protected System.Web.UI.WebControls.Label lbauthorisedusername; protected System.Web.UI.WebControls.Label lbprompt; protected System.Web.UI.WebControls.DropDownList authorisedusernameList; protected System.Web.UI.WebControls.Button submitButton; protected System.Web.UI.WebControls.RequiredFieldValidator requiredPasswordValidator; protected System.Web.UI.WebControls.CustomValidator invalidPasswordValidator; protected System.Web.UI.WebControls.TextBox passwordTxtBox; protected System.Web.UI.WebControls.Label promptlabel; protected System.Web.UI.WebControls.DropDownList authourisedusernameList; protected System.Web.UI.WebControls.Label passwordLabel; protected System.Web.UI.WebControls.TextBox passwordTextBox; //Page Loader //Reading the list of user names from authoriseduser table private void Page_Load(object sender, System.EventArgs e) { if ( !IsPostBack ) { //open Database oleDbConnection1.Open(); //execute query dataReader = oleDbDataAdapter1.SelectCommand.ExecuteReader(); ' line of error // add first authorisedusername to the list while ( dataReader.Read() ) authorisedusernameList.Items.Add( dataReader.GetString( 0 ) ); // close database connection oleDbConnection1.Close(); } // Put user code to initialize the page here } // end of Page_Load private void invalidPasswordValidator_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args ) { //open database connection oleDbConnection1.Open(); oleDbDataAdapter1.SelectCommand.CommandText = "SELECT * FROM AuthorisedUsers WHERE LoginName = '" + Request.Form[ "authorisedusernameList" ].ToString() + "'"; dataReader = oleDbDataAdapter1.SelectCommand.ExecuteReader(); dataReader.Read(); //if password is correct create authentication ticketfor user if ( args.Value == dataReader.GetString( 1 ) ) { FormsAuthentication.SetAuthCookie( Request.Form[ "authorisedusernameList" ], false); Session.Add( "name", Request.Form[ "authorisedusernameList" ].ToString()); Response.Redirect( "LoggedCall.apsx" ); } else args.IsValid=false; //close database connection oleDbConnection1.Close(); }// end method invalidPasswordValidator_ServerValidate #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = @"Integrated Security=SSPI;Packet Size=4096;Data Source=""ERYCKOP-002"";Tag with column collation when possible=False;Initial Catalog=Project;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOLEDB.1"";Workstation ID=""ERYCKOP-002"";Use Encryption for Data=False"; this.Load += new System.EventHandler(this.Page_Load); } #endregion }//end class login } ----end of code------ any help is much needed. Thank you Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100492
 - 22
 - Excel-like appearance in the datagrid I'd like to give my users the same "empty grid" look of an Excel sheet (at least an empty row to start with). I've thought to mimic this appearance by setting up an empty datatable bound to the grid (columns will be predefined) and then using AddNew to add the first empty row to the table. Is that the usual approach or can anyone recommend something better? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100491
 - 23
 - Same question again - tables fro 2DBs Sorry, but I asked the previous question poorly. I have two SQL Server databases (on the same server) and I want to reference tables from both DBs in the SQL. I know that manually written SQL can reference tables in multiple databases by prepending the database name when necessary. However, we use the DataAdapter Configuration Wizard and Querybuilder for productivity reasons but it seems that this wizard will only allow connection to a single database withing a single data adapter. Is there a way to be able to include tables from multiple databases in the Querybuilder wizard? Thanks, T Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100489
 - 24
 - 2 DBs Ref by 1 DataAdapter? I have two SQL Server databases and I want to reference tables from both DBs in the SQL. How can I have a connection object that points to both DBs? Thanks, T Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100485
 - 25
 - Can't save new row to table Can't save new row to table I'm trying to save a new row using the following code: It's a schema adapted almost exactly from one given me by Kevin Yu some time ago. One difference is the inclusion of the ID field. If I don't include it I get an error message. I also have an addhandler onCAIrowupdated. The msgbox in that gives the right answer for the table's ID = 0, since it would be the first entry. However, right after the msgbox I get an error. Message: You cannot add or change a record because a related record is required in table 'PointsOfView'. The line number indicated is intModified = daCAI.Update(tblCAI) Of the six fields in ComceptAssignmentInstances, four have 1 to many relationships with with table: TopicID, PointOfVew, ReportType, and ConceptID. This is an Access database. I carefully examined the relationship table, and PointOfView is identical with all the others. So I put in the following message boxes Both showed values 0, because I hadn't changed them, and the error message showed. The second time I changed the comboxes selected items and the save was successful. Two problems. The first is the known but of having to first move the selected value of of comboboxes to 1 and then back to 0. But where and how can I do it once I click the save button? The second problem is that the ID value in the saved table was -1. Since ID is an autoincrementing long integer, why didn't it have value 0? thanks, dennist685 Private Sub btnSaveC1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSaveC1.Click Try daCAI.Fill(DsCAI1, "ConceptAssignmentInstances") Dim tblCAI As New dsCAI.ConceptAssignmentInstancesDataTable Dim rowCAI As dsCAI.ConceptAssignmentInstancesRow rowCAI = tblCAI.NewConceptAssignmentInstancesRow rowCAI.ID = -1 rowCAI.TopicID = iTopicID rowCAI.BeginText = txtConceptText.SelectionStart rowCAI.ConceptID = lstConcepts1.SelectedValue rowCAI.ReportType = Me.cboRptTypeCncpt.SelectedValue rowCAI.PointOfView = Me.cboPOVCncpt.SelectedValue 'rowCAI.ReportType = Me.cboRptTypeCncpt.SelectedValue MsgBox("report type " & rowCAI.ReportType.ToString) MsgBox("point of view " & rowCAI.PointOfView.ToString) tblCAI.AddConceptAssignmentInstancesRow(rowCAI) daCAI.InsertCommand = New OleDb.OleDbCommand("INSERT INTO ConceptAssignmentInstances(ID, TopicID, BeginText,ConceptID,ReportType,PointOfView) values (?,?,?,?,?,?)", cnCAI) 'daCAI.InsertCommand = New OleDb.OleDbCommand("INSERT INTO ConceptAssignmentInstances( TopicID, BeginText,ConceptID,ReportType,PointOfView) values (?,?,?,?,?)", cnCAI) daCAI.InsertCommand.Parameters.Add("@ID", OleDb.OleDbType.Integer, 4, "ID") daCAI.InsertCommand.Parameters.Add("@TopicID", OleDb.OleDbType.Integer, 4, "TopicID") daCAI.InsertCommand.Parameters.Add("@BeginText", OleDb.OleDbType.Integer, 4, "BeginText") daCAI.InsertCommand.Parameters.Add("@ConceptID", OleDb.OleDbType.Integer, 4, "ConceptID") daCAI.InsertCommand.Parameters.Add("@ReportType", OleDb.OleDbType.Integer, 4, "ReportType") daCAI.InsertCommand.Parameters.Add("@PointOfView", OleDb.OleDbType.Integer, 4, "PointOfView") AddHandler daCAI.RowUpdated, AddressOf OnCAIRowUpDated Dim intModified As Integer intModified = daCAI.Update(tblCAI) Dim sOutput As String sOutput = "Modified " & intModified & " ConceptAssignmentInstances" Dim s As String = ControlChars.CrLf Catch ex As OleDbException If ex.Errors(0).SQLState = "3022" Then Else Dim errorMessages As String errorMessages += "Message: " & ex.Errors(0).Message & ControlChars.CrLf _ & "NativeError: " & ex.Errors(0).NativeError & ControlChars.CrLf _ & "Source: " & ex.Errors(0).Source & ControlChars.CrLf _ & "SQLState: " & ex.Errors(0).SQLState & ControlChars.CrLf _ & "StackTrace: " & ex.stacktrace & "The form will be closed" MsgBox(errorMessages) Me.Close() End If Catch ex As DBConcurrencyException MessageBox.Show(ex.Message & "StackTrace: " & ex.stacktrace, "Update failed!", MessageBoxButtons.OK, MessageBoxIcon.Error) Me.Close() Catch ex As Exception MessageBox.Show(ex.Message & "StackTrace: " & ex.stacktrace, "Update failed!", MessageBoxButtons.OK, MessageBoxIcon.Error) Me.Close() End Try Me.cnCAI.Close() End Sub Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100479
- Next
 - 1
 - Large Datasets Hello All, Does anyone have any suggestions on working with large datasets (10GB - 100GB)? Best initialization? Transfer from dataset to database? Anything would be helpful, articles, code examples, discussions, etc Thanks In Advance Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100474
 - 2
 - Connection String Machine Independent. Hi there, I've been researching on the diferent newsgroups to find out how to do this, but no luck so far. I'm developing a client/server windows application with VB.NET, MSDE is my backend database. This is sample connection string to connect to my server: data source=MACHINE_NAME\MSDE; initial catalog=DatabaseName; user ID=sa;password=sa Now, when I distribute this application, the Server will have to be installed in one machine in the LAN, now the connection string it's hardcoded right now to look for a specific machine name and the instance name. So, how can I build, if it's possible, the connection string machine independent? Thanks very much, Manny Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100467
 - 3
 - ADO .NET and Excel ... Hi Frankly speaking, what ever one says, Microsoft technologies will always remain problem-matic.. specially with versions... they don have seamless integration. Deployment is always always an issue. But I still love .NET!! Anyway folks, my problem goes like this... I am reading and updating excel sheet using ADO .NET. Everything is working fine on machine, but on server it is all messing up... I connect to sheet using the string called... Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES;' But whenver I try to execute insert command, following error occurs... Operation must use an updateable query.Microsoft JET Database Engine 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 MyPledge.ClientPaymentData.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Web1\Data.aspx.vb:line 74 I will highly appreciate if someone help me... !!! eff_kay ------------------- IMPORTANT: No trees were killed during the sending of this message but a large number of electrons were terribly inconvienced. Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100465
 - 4
 - How to resolve "General Network Error"? I'm getting the following message trying to update a SQL Server table: "General network error. Check your network documentation." I'm using stored procedures via a SQL data connection from within a .Net windows application. The application producing the error, reads a table from the server, then proforms a series of updates, deletions and insertions locally to a DataSet. After all processing is completed, the data is written back to the server using the Update(dataset, "table_name") method on the DataAdapter. The Update method is called 3 times, once for all updated rows, once for all inserted rows and once for all deleted rows. Currently, I read and update 3 tables in seperate datasets. 2 tables work and the 3rd does not. How can I get resolved this issue? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100464
 - 5
 - Getting SQL Error - "General network error" I'm getting the following message trying to update a SQL Server table: "General network error. Check your network documentation." I'm using stored procedures via a SQL data connection from within a .Net windows application. The application producing the error, reads a table from the server, then proforms a series of updates, deletions and insertions locally to a DataSet. After all processing is completed, the data is written back to the server using the Update(dataset, "table_name") method on the DataAdapter. The Update method is called 3 times, once for all updated rows, once for all inserted rows and once for all deleted rows. Currently, I read and update 3 tables in seperate datasets. 2 tables work and the 3rd does not. How can I get resolved this issue? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100463
 - 6
 - create table based on existing tables in a dataset, how ? hi all i create a dataset with table a, b and c in it. Is it possible for me to generate extra table (e.g. d) into this dataset based on table a and table b (which already exist in this dataset) ? note that creation of table d, include a LEFT JOIN between table a and b. pls give me some suggestion / example on how to do it. cheers, Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100457
 - 7
 - Cannot open OracleConnection with Oracle 9.2 in ASP.NET Hi I'm using System.Data.OracleClient with VisualStudio.NET 2003 and trying to connect to Oracle 9.2 database. Oracle client software for 9.2 has been installed and I can perfectly make a connection in a Windows Forms application. But on the same machine, I cannot make a connection in an ASP.NET web application. The Exception is raised when I try to open the connection as follows: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. What is happening? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100456
 - 8
 - ado.net exception from raiserror In a couple of stored procedures (SQL Server 2000) im doing: raiserror('aaa',16,1) return 1 My understanding was that this should throw an exception in my C# code. But sometimes it doesn't (I have to manually check the return value parameter). Can anyone explain why? Is there a difference in behaviour between SqlCommand.ExecuteNonQuery and ExecuteReader (or SqlDataAdapter.Fill) in this regard? The situation where I've noticed no exception is being thrown is when I'm calling adapter.Fill(), and the sproc has already returned a resultset (but later on in the sproc code it detects an error). Maybe the presence of a resultset prevents an exception being thrown? Thanks, John Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100448
 - 9
 - Better way to build results? (Relative newbie) Hello, Undoubtedly this answer is in front of my nose, but I can't figure it out or find it anywhere. Using VB.NET, Access database. I have successfully built a series of nested queries that return results from three interrelated tables, reading the results into datareaders. I can iterate through the three datareaders and build the results that I want, but I suspect there are more efficient ways to do what I need. The only way I have been able to get this to work is by establishing one connection for the first query, and then in a nested loop keep making connections to satisfy the second query, and within that loop there is another loop that keeps making connections to satisfy the third query. This works fine on my very small test database, but I know users will have much larger ones. I can't use UNION, because the tables have differing numbers of fields. Let's say I have three tables: Neighborhoods, Houses, and Residents (not my real database!). Neighborhood.nID = Houses.nID and Houses.hID = Residents.hID. The trick is that I might not have houses for every neighborhood, and I might not have residents for every house. But I need to get all the neighborhoods, even the ones without houses, and I need to get all of the houses, even the ones without residents. Conversely, every resident has to have a house, every house has to have a neighborhood. So my simplified code is: Establish first connection Get all the neighborhoods Read the first neighborhood Build a node for a TreeView Establish/reestablish second connection Get all the houses in that neighborhood Read the first house Build a node for a TreeView Establish/reestablish third connection Get all the residents in that house Read the first resident Build a node for a TreeView Loop Close third connection when we've found all the residents for that house Loop Close second connection when we've found all the houses for that neighborhood Loop Close first connection when we've found all the neighborhoods Any and all advice gratefully received. Thanks, Chris Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100447
 - 10
 - Error: ArgumentOutOfRangeException on stringbuilder Hi experts, I wrote a function to use stringbuilder for a fix length text delimited file for banking stuff. I received an error on strResult.Insert(141, "".PadLeft(21, " ")) Error: System.ArgumentOutOfRangeException Message: "Index was out of range. Must be non-negative and less than the size of the collection. StackTrace: "at System.Text.StringBuilder.Insert(Int32 index, String value, Int32 count) at System.Text.StringBuilder.Insert(Int32 index, String value) at EPay_Enroller.JenniferFunct.GenerateA(String& strEmpID, String& strClientAcct, String& strAcctStatus, String& strAddressFlag, String& strNameFlag) Any help? ------------------------------------------------------------------------------------------- Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String, ByRef strAddressFlag As String, ByRef strNameFlag As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection("...................................................") Dim selectCMD As SqlCommand = New SqlCommand("SELECT DDACTNUM, LASTNAME,FRSTNAME,BRTHDATE FROM UPR00102 where EmployID=' " + strEmpID + "'", GPConnection) Dim GPDataAdapter As SqlDataAdapter = New SqlDataAdapter GPDataAdapter.SelectCommand = selectCMD Dim EfundAcct As String Dim LName As String Dim FName As String Dim MName As String Dim DOB As String Dim Loc As String Try GPConnection.Open() Dim DS As DataSet = New DataSet GPDataAdapter.Fill(DS, "AcctInfoTble") EfundAcct = DS.Tables("AcctInfoTble").Rows(0)("DDACTNUM") LName = DS.Tables("AcctInfoTble").Rows(0)("LASTNAME") FName = DS.Tables("AcctInfoTble").Rows(0)("FASTNAME") 'Position 1 2A A strResult.Insert(0, "A ") 'Position 3 10A Employee Number strResult.Insert(2, strEmpyID.ToString.PadRight(10, " ")) .........codes 'Position 142 21A Filler strResult.Insert(141, "".PadLeft(21, " ")) ......more codes -------------------------------------------------------------------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100445
 - 11
 - Adding columns to SQL Server tables dynamically Hi, I'm writing a routine which queries a table in a mySQL database and then adds records from it into a SQL Server 2000 database - pretty easy stuff. Problem is, that the mySQL table may have additional columns every time I query it. I can easily use the Columns collection of both tables to see if there is a new column in the mySQL table which isn't in the SQL Server table, but what's the easiest / most efficient way to add a new column to an existing SQL Server table, given that I know the name and datatype of the column to be added? Would it be to pass some sort of "ALTER TABLE..." SQL into an SQLCommand object, or is there a better way? Any assistance gratefully received. Best regards, Mark Rae Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100440
 - 12
 - Dataset Error:IndexOutofRangeException Hi experts, I have a dataadapter and datasets. I debugged it and gave me an error on LName = DS.Tables("AcctInfoTble").Rows(1)("LASTNAME") error: There is no row at position 1. WHAT DID I DO WRONG at the following code? Thanks. ------------------------------------------------------------------------------------------------ Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String, ByRef strAddressFlag As String, ByRef strNameFlag As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection("workstation id=ADMIN;packet size=4096;user id=MaintenanceHD;data source=AMKSQL2;p" & _ "ersist security info=True;initial catalog=HFC;password=maintainme") Dim selectCMD As SqlCommand = New SqlCommand("SELECT DDACTNUM, LASTNAME,FRSTNAME,BRTHDATE FROM UPR00102 where EmployID=' " + strEmpID + "'", GPConnection) Dim GPDataAdapter As SqlDataAdapter = New SqlDataAdapter GPDataAdapter.SelectCommand = selectCMD Dim EfundAcct As String Dim LName As String Dim FName As String Dim MName As String Dim DOB As String Dim Loc As String Try GPConnection.Open() Dim DS As DataSet = New DataSet GPDataAdapter.Fill(DS, "AcctInfoTble") EfundAcct = DS.Tables("AcctInfoTble").Rows(0)("DDACTNUM") LName = DS.Tables("AcctInfoTble").Rows(1)("LASTNAME") FName = DS.Tables("AcctInfoTble").Rows(2)("LASTNAME") ......more codes -------------------------------------------------------------------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100437
 - 13
 - Incorrect in passing parameters Hi all, I received an error: System.NullReferenceException: Object reference not set to an instance of an object at GenerateA(String& strEmpID, String& strClientAcct, String& strAcctStatus). When I run the debug, and in the command line I entered ?strEmpID, and it does passed the correct employee ID. However, in the first line of the dataset, EfundAcct = DS.Tables("AcctInfoTble").Rows(0)("DDACTNUM") it generates error message "Object reference not set to an instance of an object" and stacktrace is "at GenerateA(String& strEmpID, String& strClientAcct, String& strAcctStatus)" ---------------------------------------------------- Main.vb Main.VB ----------------- some codes........ Dim strCurEmployId As String strCurEmployId = dtrSelectTransactions("EmployID") smCurBatch.WriteLine(GenerateA(strCurEmployId, boxTopCorp.Text, "Open")) some codes............... ------------------------------------------------ Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection(".............................................") Dim GPDataAdapter As New SqlDataAdapter("SELECT LASTNAME,FRSTNAME,MIDLNAME,SOCSCNUM,ADDRESS1,PHONE1,BRTHDATE FROM UPR00102 where EmployID= " + strEmpID, GPConnection) Dim EfundAcct As String Dim LName (30) As Char Dim FName (30) As Char Dim MName (30) As Char GPConnection.Open() GPDataAdapter.Fill(GPDataset, "AcctInfoTble") Dim DS As DataSet = New DataSet EfundAcct = DS.Tables("AcctInfoTble").Rows(0)("DDACTNUM") LName = DS.Tables("AcctInfoTble").Rows(1).Item("LASTNAME") FName = DS.Tables("AcctInfoTble").Rows(2)("LASTNAME") MName = DS.Tables("AcctInfoTble").Rows(3)("MASTNAME") 'Position 1 2A A strResult.Insert(0, "A ") 'Position 3 10A Employee Number strResult.Insert(9, strEmpID.PadRight(10, " ")) 'Position 13 16N Efund acct number strResult.Insert(12, EfundAcct.PadLeft(16, " ")) GPConnection.Dispose() Return strResult.ToString End Function *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100435
 - 14
 - DataSet, Relation, IsNested and WebService Hi all, If I want to provide a typed dataset from a webservice and if that dataset has relations that are nested (isNested=True), then the relations(keyrefs) are not available in the XSD that is offered. If I set IsNested to false or default, then it is included in the XSD. Is this a bug or by design? Corno Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100431
 - 15
 - Can you package a oledb data provider? Hello, Is it possible to package a oledb data provider? I need to be able to access an iSeries machine, but the server that the program is being installed on does not have the ibmda400 provider. The easy way would be to install client express, but unfortunatly that can not happen. Any ideas? Thanks, Brian Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100430
 - 16
 - Converting from DataColumn to OleDbType for Analysis Services 2005?? Its been posted before, but I've not found a satisfactory answer. Environment: Dot-Net 2.0 beta, with Analysis Services 2005 beta. DbDataAdapter produces DataColumns from its FillSchema method which give me all sorts of information about the data type of the column. AMO, the API for Analysis Services 2005, requires me to give an OleDbType when I set up a foriegn key in a fact table and when I make an Attribute. (I'm using metadata as a starting point to scan a data warehouse and build the dimensional model programatically. Think of it as a form of Intellicube, but especially taylored to the structure of our data warehouses feeding off our existing metadata.) The thing is. I've used DbDataAdapter to FillSchema() to get the underlying field types in the tables. It should _know_ what data type is there as its just told me. I suppose the problem is that DataTable class being generic can't know anything about specific databases, but it would be nice if there was a method somewhere to take a DataColumn and get the XXXDbType from it. Analysis Services already knows the data type, as it's got a Data Source View. I've presumably already told it once when I defined the schema by passing in the DataSet that defined it - the DataSet made using FillSchema. Or have I? I'm building up a model that presumably hasn't been committed yet, so presumably the problem is that there's no way (even though I've given it a Connection String) for it to go to the database and find out what it needs, and its not willing to wait until commit time to work it out? Can I assume that the DataColumn doesn't have enough information in itself? Therefore the Data Source View is, at that time, incomplete, and I have to add the information myself from an external source? If thats the case - it's not nice. Also, as an aside, why (I'm following Microsoft's sample code) am I using an OleDbDataType with an SQLServer database? Thanks - Richard Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100428
 - 17
 - Value in output parameter not accessable I am using the Microsoft Data Application Block to access a database and am trying to execute the following stored procedure: CREATE PROCEDURE WhiteboardPostItem @Id int OUTPUT, @Subject varchar(255), @Message varchar(2000), @PostedBy varchar(100) AS INSERT INTO Whiteboard(Subject, Message, PostedBy, DatePosted) VALUES (@Subject, @Message, @PostedBy, getdate()) SELECT @Id = @@IDENTITY GO This procedure is called from the following code: Public Shared Function PostItem(ByVal Subject As String, ByVal Message As String, ByVal PostedBy As String) As Integer Dim arParams() As SqlParameter = New SqlParameter(3) {} arParams(0) = New SqlParameter("@Id", SqlDbType.Int) arParams(0).Direction = ParameterDirection.Output arParams(1) = New SqlParameter("@Subject", SqlDbType.VarChar, 255) arParams(1).Value = Subject arParams(2) = New SqlParameter("@Message", SqlDbType.VarChar, 2000) arParams(2).Value = Message arParams(3) = New SqlParameter("@PostedBy", SqlDbType.VarChar, 100) arParams(3).Value = PostedBy ' Call to Microsoft Data Application Block SqlHelper.ExecuteNonQuery(ConnectionString(), "WhiteboardPostItem", arParams) Return Convert.ToInt32(arParams(0).Value) End Function However, the output parameter (arParams(0)) is never set to the identity value of the inserted row even though the row does get added. I've checked the stored procedure in query analyser and the return value is properly set but it does not work through this code. The code in the above function is now in the format described in a Microsoft example and it still doesn't work. I'm sure I'm missing something obvious, but can anyone tell me how to resolve this as it's driving me mad! Many thanks Alan Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100421
 - 18
 - Viewing large amounts of data We have a data management application writen in Delphi. This app shows all tables in the database, and display all data in a given table in a datagrid. We are using an ODBC connection for this. This functionality is not unlike what is seen in e.g. Enterprise manager. Now even with 400K of rows, this datagrid is "filled" is mere seconds. I am aware that the underlying dataset only retrieves a subset of rows, and dynamically retrieves and unloads rows as needed, thereby giving an illusion of retrieving the entire table. We are now moving to .net and I find myself having a great deal of difficulty getting the same functionality out of ado.net. The ODBC components we are using in our Delphi app is connected whereas ado.net is disconnected. What I basically need is to retrieve say 100 rows at a time, and dynamically unload and retrieve new rows and filling them into a datagrid as the user scrolls back and forth through the datagrid. How do I achieve this? Please dont lecture about filtering and whatnot. This is the functionality we need. -- Thomas Due Posted with XanaNews version 1.16.5.2 "If you can't convince them, confuse them." -- Harry S. Truman Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100419
 - 19
 - include rowstate in dataset.getxml Hi Gurus, how can i include rowstate value in dataset.getxml string <datatable> <row1 state="Added"> <col1>v1</col1> </row1> <row2 state="Modified"> <col1>v2</col1> </row2> </datatable> </dataset> i am passign the above string to stored proc(sql200) to perform DML operations any help on this. regards mak Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100407
 - 20
 - deleting rows in one-to-many relationship Dear Ng, I have a 1(master table) : n(first child table) : m(second child table) relationship in my sql server and strongly typed dataset. Now I locate the corresponding row in the master table. DataAccessControl.DocumentTemplateRow rowTemplate = tblTemplate.FindBydocumentTemplateId(templateId); Then i request all child rows: DataRow[] rowsToDelete = rowTemplate.GetChildRows("DocumentTemplateDocumentField"); Then I want to delete all child rows in the child tables: foreach (DataAccessControl.DocumentFieldRow row in rowsToDelete) { tblFields.RemoveDocumentFieldRow(row); } dac.updateDataAccessLayer(); The delete rules of both relations (from the master to the first child and from the first to the second child) is set to cascade (in the database and in the dataset). But if I execute the code, just the rows in the second child table are deleted. What do I do wrong? If I use additionally the row.delete() command foreach (DataAccessControl.DocumentFieldRow row in rowsToDelete) { row.Delete(); if (row.RowState == DataRowState.Deleted) tblFields.RemoveDocumentFieldRow(row); } dac.updateDataAccessLayer(); I'll get a DBConcurrencyException! What is wrong? What I want to achieve is that the master record is kept and all child records are deleted. Thanks in advance and best regards, Patrick Braunschweig Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100403
 - 21
 - Trouble with OleDbDataAdapter Hi there, I am trying to display information from Active Directory using a DataGrid. Now, I know MS have put out the System.DirectoryServices classes to make this easy. But if you just want to query and display, it seems an easier path is to use the AdsDsoObject provider with OleDb, and get back a DataTable, pour into a DataView, bind to the DataGrid, voila! At least, that's the theory. The main driver is that trying to bind a SearchResultCollection to a DataGrid doesn't yield very satisfactory results, and that's the only useful class in the DirectoryServices namespace that implements ICollection and IEnumerable. The problem is, if I manually construct a DataTable with dummy data, pour into a DataView, bind to DataGrid and display then I see exactly what I would expect. If I setup an OleDbDataAdapter, query the AD, fill a DataSet and serialize to XML I see what I would expect. If I setup an OleDbDataAdapter, query the AD, fill a DataTable, pour into a DataView, bind to the DataGrid and display, I get: System.Web.HttpException: DataGrid with id '' could not automatically generate any columns from the selected data source Here is the source for Page_Load that generates the last result: string ldapString = "<LDAP://DC=acme,DC=com>;(&(objectClass=user)(objectCategory=person));cn,distinguishedName;subtree"; string connstr = "Provider=ADsDSOObject;User ID=acme\\Administrator;Password=notthispassword"; OleDbConnection conn = new OleDbConnection(connstr); OleDbDataAdapter da = new OleDbDataAdapter(ldapString, conn); DataTable dt = new DataTable("Table1"); da.Fill(dt); DataView dv = new DataView(dt); dg1.DataSource = dv; dg1.DataBind(); Now, I'm fairly new to all this, but I've spent a good couple of days butting up against this one. The only checking I haven't really done is using OleDb with a different provider and seeing if it is a general problem. The main reason I haven't done that is that I can see the data there if I use an alternate means of accessing it! So, any ideas? MTIA, Mick Heywood Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100402
 - 22
 - Create Stored procedure Hi, there I want to create a Stored procedure for my Access database using the code below. ' Conn is an opened connection to my Access database Dim cmd As OleDbCommand cmd = Conn.CreateCommand cmd.CommandType = CommandType.Text cmd.CommandText = _ "CREATE PROCEDURE udpGetSampleIDByName" & vbCrLf & _ "@zSampleName VarChar(64)" & vbCrLf & _ "AS " & vbCrLf & _ "Select zSampleID FROM TSamples " & _ "Where zSampleName = @zSampleName " cmd.ExecuteNonQuery() After running, I got a error message: "invalid SQL Syntax£ºneeded symbol AS¡£" It goes well when I create SQL Server stored procedure using SQLCommand . Now I turn to OleDB and the error occurs. Anybody can help me? Peter Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100401
 - 23
 - "Cannot create a child list for field MyTable" I'm having a frustrating problem trying to set up a master-detail relationship between 2 datagrids. I've used DataSets extensively before, but only in code and basically only in a disconnected state. Now as I try to set up this simple master-detail thing, I'm having problems. I have about 6 tables in a SQL Server 2000 database. All tables have single field primary keys, and I've created appropriate relationships betwen the tables in SQL Server. In VS 2003, I've created a SQLDataAdapter for each table, that interacts with the table via stored procedures created by the SQLDataAdapter wizard. I then used the "Generate Dataset..." functionality of one of the data adapters to autogenerate dataset that included all 6 tables (i.e. it was based on all 6 data adapters). So far so good. In the DataSet schema editor, I created relationships between the datatables to mimic the relationships in SQL Server. This seems to go ok, and when I "Preview DataSet" from the schema editor, all seems ok - including the relationships. I also have a WinForm that has 2 DataGrids on it. Both DataGrids have the DataSet I created as their DataSource. When I try to list the DataTables in the DataGrid.DataMember property so I can set up the DataGrids for the master-detail, I the the error, "Cannot create a child list for field MyTable", where 'MyTable' is one of my DataTables in the DataSet. If I remove all of the relations from the DataSet, and save the .xsd schema a few times (moving the datatables on the designer between saves so there's something to save), the error will go away - but then I have no relationships. So, I re-create the relationships in the DataSet schema editor, and I start getting the error again. Sometimes I don't get the error until I have more than one relationship, and sometimes by moving the datatables on the schema designer and re-saving the dataset schema a few times, I don't get the error - even when the dataset has 2 relationships. It seems some code is getting corrupted somewhere. I've tried restarting VS, and I've rebooted my machine. I've also deleted the DataSet and created it again from scratch. The same thing happens. When running my project, I can successfully fill my DataSet from the DataAdapters, but I get the same error when I try to set the DataMember property of one of the DataGrids in code. What's going on? Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100400
 - 24
 - SQLDMO Code Sometimes Works I have this code on two identical machines, named DEVONE and DEVTWO. Both on the network. It works on DEVONE, finding (local) and DEVONE and populates the combo box with them, but does not find any server(s) on DEVTWO, putting <No Servers Found> in the combo box. Can anyone shed any light. Code below: Private Sub GetSQLServers() Dim i As Integer Dim sqlApp As New SQLDMO.ApplicationClass Dim sqlServers As SQLDMO.NameList = sqlApp.ListAvailableSQLServers() For i = 0 To sqlServers.Count - 1 Dim srv As Object = sqlServers.Item(i + 1) If Not IsNothing(srv) Then Me.cboRelevantServer.Items.Add(srv) Me.cboMainServer.Items.Add(srv) End If Next If Me.cboRelevantServer.Items.Count > 0 Then Me.cboRelevantServer.SelectedIndex = 0 Else Me.cboRelevantServer.Text = "<No Servers Found>" End If End Sub Thanks, Michael Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100399
 - 25
 - DataSet and Stringbuilder? Hi expert, I received a sample from bank for the header record in the output file (attached at the bottom). I want to use same method to have a stringbuilder to arrange the fix length positions, and the fields will be retrieved from database and put into the dataset. But I am familiar at how to use dataset and put into .insert stringbuilder. Here is the code that I am working on (the function should return 1 string line at a time. The loop of reading rows will be controled in main form): Can someone show me how to retrieve a column, say LastName and put into strResult.Insert()??? Thanks. Imports System.Data.SqlClient Module Module1 Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String, ByRef strAddressFlag As String, ByRef strNameFlag As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection("............................") Dim GPDataAdapter As New SqlDataAdapter("SELECT LASTNAME,FRSTNAME,MIDLNAME,PHONE1,BRTHDATE FROM UPR00102 where EmployID="+strEmpID,GPConnection) Try GPConnection.Open() GPDataAdapter.Fill(GPDataset, "AcctInfoTble") Dim DS As DataSet = New DataSet 'position 1 20A strResult.Insert ????????????????? Catch ex As Exception MessageBox.Show(ex.ToString) Finally GPConnection.Dispose() End Try Return strResult.ToString End Function End Module ------------------------------------------------------------------------------------- Module GenerateFile Public Function GenerateFH(ByRef strCompanyName As String, ByRef strTopCorp As String, ByRef strBatchNum As String, ByRef dtFileDate As Date) Dim strResult As New System.Text.StringBuilder strResult.Capacity = 731 'Position 1 2A FH strResult.Insert(0, "FH") 'Position 3 10A Header Date strResult.Insert(2, dtFileDate.Date.Year & "/" & dtFileDate.Date.Month.ToString.PadLeft(2, "0") & "/" & dtFileDate.Date.Day.ToString.PadLeft(2, "0")) 'Position 13 8A Header Time strResult.Insert(12, dtFileDate.TimeOfDay.Hours.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Minutes.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Seconds.ToString.PadLeft(2, "0")) 'Position 21 10A Transfer File Version strResult.Insert(20, "4.0".PadRight(10, " ")) 'Position 31 10A Product Type strResult.Insert(30, "EFUNDS".PadRight(10, " ")) ............. Return strResult.ToString End Function End Module --------------------------------------------------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: I need to run a vb.net or aspx.net file every 10 seconds. Tag: 100394

Hi,

I need to run a vb.net or aspx.net file every 10 seconds. The Task Scheduler
in Windows 2003 Server can only do it every 1 minute at the minimum, but I
need it every 10 seconds. Is it possible to write a small program in VB.NET
that would run in the background without using much resources, and request a
vb.net or aspx file every 10 seconds? Could you show me how to write such
code? or give me good directions?

Thank you.
Steve.

Top

Re: I need to run a vb.net or aspx.net file every 10 seconds. by W

W
Mon Dec 06 21:37:35 CST 2004

Create a Windows Service and use the System.Timers.Timer class.... it's
built precisely for this task

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Steve Jacobs" <steve00932@yahoo.com> wrote in message
news:6tmdndW88LKkhSjcRVn-rg@comcast.com...
> Hi,
>
> I need to run a vb.net or aspx.net file every 10 seconds. The Task
Scheduler
> in Windows 2003 Server can only do it every 1 minute at the minimum, but I
> need it every 10 seconds. Is it possible to write a small program in
VB.NET
> that would run in the background without using much resources, and request
a
> vb.net or aspx file every 10 seconds? Could you show me how to write such
> code? or give me good directions?
>
> Thank you.
> Steve.
>
>

Top

Re: I need to run a vb.net or aspx.net file every 10 seconds. by Sahil

Sahil
Mon Dec 06 22:35:40 CST 2004

Here's a nifty trick you might find handy in developing your windows
service --

http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/06/35295.aspx

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

"W.G. Ryan eMVP" <WilliamRyan@NoSpam.gmail.com> wrote in message
news:%23Nq6m2A3EHA.1296@TK2MSFTNGP10.phx.gbl...
> Create a Windows Service and use the System.Timers.Timer class.... it's
> built precisely for this task
>
> --
> W.G. Ryan MVP (Windows Embedded)
>
> TiBA Solutions
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "Steve Jacobs" <steve00932@yahoo.com> wrote in message
> news:6tmdndW88LKkhSjcRVn-rg@comcast.com...
>> Hi,
>>
>> I need to run a vb.net or aspx.net file every 10 seconds. The Task
> Scheduler
>> in Windows 2003 Server can only do it every 1 minute at the minimum, but
>> I
>> need it every 10 seconds. Is it possible to write a small program in
> VB.NET
>> that would run in the background without using much resources, and
>> request
> a
>> vb.net or aspx file every 10 seconds? Could you show me how to write such
>> code? or give me good directions?
>>
>> Thank you.
>> Steve.
>>
>>
>
>

Top