Database backup/restore

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
    - DataAdaper.Fill question Hi all, with the sample below, if the query returns huge amount of data, will database returns the portion required by program or returns all data, then Fill methods filter unnecessary ones? int currentIndex = 0; int pageSize = 5; string orderSQL = "SELECT * FROM Orders ORDER BY OrderID"; SqlDataAdapter myDA = new SqlDataAdapter(orderSQL, nwindConn); DataSet myDS = new DataSet(); myDA.Fill(myDS, currentIndex, pageSize, "Orders"); -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy Tag: Database backup/restore Tag: 111222
  - 2
    - Adding a row to a dataset I have a need in my application to add a dummy row to a dataset object after I have filled it with a call to the database. Trying to find a solution I thought that doing a dataset merge might work, however its doesn't seem to be. Following examples I found in some MSDN articles I came up with the following code: DataSet ds = new DataSet(); DataSet dsTemp = new DataSet(); DataRow dr; DataTable dt = new DataTable("tempTable"); DataColumn dc = new DataColumn("VALUE",Type.GetType("System.String")); dt.Columns.Add(dc); DataColumn dc1 = new DataColumn("TEXT",Type.GetType("System.String")); dt.Columns.Add(dc1); dr = dt.NewRow(); dr["VALUE"] = "test"; dr["TEXT"] = "test"; dt.Rows.Add(dr); dsTemp.Tables.Add(dt); dsTemp.AcceptChanges(); ds = functionThatReturnsData(); ds.Merge(dsTemp); return ds; In the above example, my expectations where that ds would contain both its data and the data from dsTemp. However it only contains the data returned from the db call. If I switch it around to: dsTemp.Merge(ds), dsTemp only contains its original data and nothing from ds. Am I just missing something here or am I way off base? thanks Tag: Database backup/restore Tag: 111212
  - 3
    - Redistributing - MSDE I want to develop an app that requires database management. I was initially planning on using an mdb and the Jet driver. However, MSDE offers more robust features. For some reason I always thought you could develop apps with MSDE and freely redistribute. However, I recently read that MSDE "is licensed for development purposes only". That would seem to indicate I can't redistribute. Anybody know? Thanks in advance. Tag: Database backup/restore Tag: 111209
  - 4
    - Need advice-VB.NET to C# transition it looks like i'm in a C# world here in houston,Texas and i'm gonna have to make the plunge after doing and really enjoying VB.NET with winforms and web forms for the last couple of years. yes, even picked up some javascript along the way. my question is (since there's no classes being held in this area @ the community colleges during the summer on this subj), does anyone have any suggestions for some really great books that'll make the VB.NET to C# transition any easier??? i'm really gonna miss my global variables. thanks for any advice rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Database backup/restore Tag: 111205
  - 5
    - CSV read problem using Jet OLEDB I am trying to read a CSV file using Jet OLEDB provider. The file (badimport.csv) looks like this: Name,Description,DefaultPrice_$_per_m3 S6,Structural sawlog MSG6,65 S8,Structural sawlog MSG8,75 S10,Structural sawlog MSG10,90 S12,Structural sawlog MSG12,120 Using an OLE DB connection the first column seems to be getting interpreted as a Decimal and not a string. All the records in the name field come in with the first character (i.e. S) truncated. My pared back code looks like this: using System; using System.Collections; using System.IO; using System.Data; using System.Data.OleDb; public class MyClass { public static void Main() { string csvFileName = "C:\\badimport.csv"; // break to debugger // System.Diagnostics.Debugger.Break(); DataTable csvTable = ReadFromCSVFile( csvFileName ); DataColumn nameColumn = csvTable.Columns[ "Name" ]; DataColumn descriptionColumn = csvTable.Columns[ "Description" ]; DataColumn priceColumn = csvTable.Columns[ "Price" ]; for ( int row = 0; row < csvTable.Rows.Count; row++ ) { try { DataRow csvRow = csvTable.Rows[row]; string name = GetAsString( csvRow, "Name"); string description = (string)csvRow[ descriptionColumn ]; int price = (int)csvRow[ priceColumn]; Console.WriteLine(" Row {0}: Name = {1}, Description = {2}, Price = {3}", row, name, description, price); } catch ( Exception e ) { throw new ApplicationException( "Error importing LogProductDefinition on line " + (row+2) + " of file '" + csvFileName + "': " + e.Message + e.StackTrace ); } } } private static System.Data.DataTable ReadFromCSVFile( string csvFileName ) { // can use a file-specific SCHEMA.INI file to control the importing process // specifically the MaxScanRows=0 entry forces the entire file to be scanned to determine the column types. // Format of this file is defined here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp // if ( !File.Exists( csvFileName ) ) { throw new ApplicationException( " Cannot find CSV file : \"" + csvFileName + "\"." ); } string csvPath = Path.GetDirectoryName( Path.GetFullPath( csvFileName ) ); OleDbConnection connection = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + csvPath + ";" + "Extended Properties=\"Text;HDR=Yes;FMT=Delimited\"" ); return ReadDataTable( connection, Path.GetFileName(csvFileName) ); } private static System.Data.DataTable ReadDataTable( OleDbConnection connection, string tableName ) { connection.Open(); try { // Read all data into a data table. OleDbDataAdapter adapter = new OleDbDataAdapter( "SELECT * FROM [" + tableName + "]", connection ); System.Data.DataTable dataTable = new System.Data.DataTable( tableName ); adapter.Fill( dataTable ); return dataTable; } finally { connection.Close(); } } private static string GetAsString( DataRow row, string columnName ) { DataColumn column = row.Table.Columns[ columnName ]; if ( column == null ) { throw new ApplicationException( "Column '" + columnName + "' not found" ); } object content = row[column]; if ( content == System.DBNull.Value ) { return ""; // empty cell is OK } try { content = row[column]; if ( content.GetType() == typeof( System.String ) ) { return (string)content; } else { return content.ToString(); } } catch ( Exception e ) { throw new ApplicationException( "Unable to convert value \"" + content.ToString() + "\" in column \"" + column.ColumnName + "\" to a string. " + e.Message ); } } } If is set up a SCHEMA.INI file with the follwoing contents in the same directory the name column is read correctly: [badimport.csv] ColNameHeader=True MaxScanRows=0 Anyone have any odea why the first column is interpreted as a decimal? Thanks, John. Tag: Database backup/restore Tag: 111190
  - 6
    - Timeout on dataAdapter Update method I have run out of ways to determine the reason for a timeout error. The timeout is occuring on the line indicated with ==>. After completing the statement before, the status of the connection object(cn) is Open. After the timeout occurs and execution is transferred to the Catch block, the connection is closed. Also, during the time the Update method is executing, the CPU usage in Windows Task Manager is pegged. What can I do to determine the cause of this timeout? Thanks for the help, Lars Dim cn As New SqlConnection(ConnectionSettings.cnString) Dim daMaster As New SqlDataAdapter("usp_UnivUseCode_Sell_All", cn) Dim daDetail As New SqlDataAdapter("usp_UnivUseCodeMap_Sell_All", cn) Dim tblMaster As DataTable = ds.Tables(0) Dim tblDetail As DataTable = ds.Tables(1) daMaster.InsertCommand = Me.CreateInsertCommandUse(cn) daMaster.UpdateCommand = Me.CreateUpdateCommandUse(cn) daMaster.DeleteCommand = Me.CreateDeleteCommandUse(cn) daDetail.InsertCommand = Me.CreateInsertUpdateCommandMap(cn) daDetail.UpdateCommand = Me.CreateInsertUpdateCommandMap(cn) daDetail.DeleteCommand = Me.CreateDeleteCommandMap(cn) cn.Open() Try ' Submit the only new Master/Detail rows daMaster.Update(tblMaster.Select(Nothing, Nothing, DataViewRowState.Added)) ==> daDetail.Update(tblDetail.Select(Nothing, Nothing, DataViewRowState.Added)) ' Submit the only modified Master/Detail rows ... Catch ex As SqlException MessageBox.Show(ex) End Try cn.Close() Private Function CreateInsertUpdateCommandMap(ByVal cn As SqlConnection) As SqlCommand Dim cmd As New SqlCommand("usp_UnivUseCodeMap_Save", cn) cmd.CommandType = CommandType.StoredProcedure Dim pc As SqlParameterCollection = cmd.Parameters pc.Add("@CompID", SqlDbType.Int, 0, "CompID") pc.Add("@UseCodeFK", SqlDbType.Int, 0, "UseCodeFK") pc.Add("@UnivUseCode", SqlDbType.Char, 2, "UnivUseCode") Return cmd Tag: Database backup/restore Tag: 111187
  - 7
    - Using a cursor SQL server side Problem Hello All Thank you for any help you can provide! I have a long list of links with decscriptions titles etc in a SQL Server 2000 database. The basic problem is that I am attempting to use a data base cursor to to the proper starting point in a sorted view, get the next 10-or 20 records and return them. Problem is ony one record is being returned. Here is the code SQL ALTER PROCEDURE dbo.PS_GetLinks @start as int, @rcount as int AS declare @ACounter as tinyint declare @RecordCount as tinyint set @ACounter=1 set @RecordCount = (Select Count (id) FROM Selectlinks) Declare My_Cursor CURSOR SCROLL for SELECT URL, Title, description, @RecordCount as Rcnt FROM Selectlinks Open My_Cursor Fetch absolute @start FROm My_Cursor WHILE (@ACounter < @rcount) BEGIN fetch next FROM My_Cursor set @ACounter = @ACounter + 1 END Close My_Cusor Deallocate my_Cursor RETURN --ASP NET code below Dim Start As Int64 = 1 '(mPage * (10 - 9)) Dim rd As SqlClient.SqlDataReader Dim cmd As SqlClient.SqlCommand = con.CreateCommand Dim lnk As HyperLink Try cmd.Parameters.Add("@start", 1) cmd.Parameters.Add("@rcount", 10) cmd.CommandText = "PS_GetLinks" cmd.CommandType = CommandType.StoredProcedure con.Open() rd = cmd.ExecuteReader While rd.Read lnk = New HyperLink lnk.NavigateUrl = rd("URL").ToString lnk.Text = rd("title") centercontent.Controls.Add(lnk) centercontent.Controls.Add(New LiteralControl("<br>")) 'RecordCount = rd("rcnt") End While Dim nav As New MultiPage(mPage, 10, 340) centercontent.Controls.AddAt(0, nav.buildnav) 'Catch ex As Exception Finally If Not rd Is Nothing Then rd.Close() End If If Not con Is Nothing Then con.Close() End If End Try Tag: Database backup/restore Tag: 111185
  - 8
    - Why does setting the InsertCommand proprty of a Data Adapter fail? Hi; I am trying to do a simple operation of inserting a row into a database. I have set a data adapter to get data from the database to check for duplication. That works fine. When I try to use this data adapter to INSERT the data into the database, if there are no duplicate records, I get an exception when I try to set MyAdapter.InsertCommand.CommandText property. Can Anyone tell me why? Here is the code: Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click Dim sConnectionString As String = "Provider=Microsoft.Jet.OleDB.4.0;" & "Data Source=" _ & System.AppDomain.CurrentDomain.BaseDirectory & "BDCIN.mdb;" _ & "User Id=admin;" & "Password=" Dim conLigacao As New OleDb.OleDbConnection Dim daAdaptador As New OleDb.OleDbDataAdapter("Produtos", conLigacao) Dim dsProdutos As New DataSet Dim dsAlteracoes As New DataSet Dim sSQLProdutos As String Dim sSQLInsertProdutos As String = "INSERT INTO Productos (Ref, Nome) VALUES (1,'TESTE')" Dim elementos As Integer Try If Not IsNumeric(txtRefProd.Text) Then MessageBox.Show("O conteÃºdo da referÃªncia do Produto de ve ser nÃºmerico.", "Valor errado") txtRefProd.Focus() Else sSQLProdutos = "SELECT * FROM Produtos WHERE Ref =" & txtRefProd.Text conLigacao.ConnectionString = sConnectionString conLigacao.Open() daAdaptador.SelectCommand.CommandText = sSQLProdutos daAdaptador.Fill(dsProdutos) conLigacao.Close() If dsProdutos.Tables("Table").Rows.Count > 0 Then MessageBox.Show("A referÃªncia " & txtRefProd.Text & " jÃ¡ existe.", "ReferÃªncia jÃ¡ existente.") txtRefProd.Focus() Else Dim rowNovoRegisto As DataRow rowNovoRegisto = dsProdutos.Tables("Table").NewRow rowNovoRegisto("Ref") = txtRefProd.Text rowNovoRegisto("Nome") = txtNomProd.Text dsProdutos.Tables("Table").Rows.Add(rowNovoRegisto) dsAlteracoes = dsProdutos.GetChanges() conLigacao.Open() daAdaptador.InsertCommand.CommandText = sSQLInsertProdutos daAdaptador.Update(dsAlteracoes, "Produtos") conLigacao.Close() Me.Close() End If End If Catch ex As Exception MessageBox.Show(ex.ToString) End Try End Sub I tried this approach from a WROX book, but It does not work. The exception I get from the line "daAdaptador.InsertCommand.CommandText = sSQLInsertProdutos" is: System.NullReferenceException: Object reference not set to an instance of an object. at ManutenÃ§Ã£o_Intermix.IntroProduto.btnOK_Click(Object sender, EventArgs e) in C:\Documents and Settings\Pedro\My Documents\Visual Studio Projects\Estudo VB\ManutenÃ§Ã£o Intermix\IntroProduto.vb:line 162 Thanks for any help. Tag: Database backup/restore Tag: 111184
  - 9
    - convert true to 1 in asp.net application I bulk insert records using OPENXML, into table "myTable". which has the following field: column name : myCol dataType : bit .... ... .. myCommand.CommandText = "select myCol from myTable " adapter.SelectCommand = myCommand adapter.TableMappings.Add("Table", "myTable") adapter.Fill(dS) Dim tbl As DataTable = ds.Tables("myTable") for i=0 to 1 Dim NewRow As DataRow = tbl.NewRow() NewRow("myCol") = 1 'get converted automatically by the compiler to: true/false tbl.Rows.Add(NewRow) ' which generate the error. next Dim sb As StringBuilder = New StringBuilder(1000) Dim sw As System.IO.StringWriter = New System.IO.StringWriter(sb) Dim col As DataColumn For Each col In tbl.Columns col.ColumnMapping = System.Data.MappingType.Attribute Next ds.WriteXml(sw, System.Data.XmlWriteMode.WriteSchema) myCommand.Connection = cn myCommand.CommandType = CommandType.StoredProcedure myCommand.CommandText = "myStoredProcedure" myCommand.Parameters.Add(New SqlParameter("@xmldata", System.Data.SqlDbType.NText)) myCommand.Parameters(0).Value = sb.ToString() Dim a As String cn.Open() com.ExecuteNonQuery() cn.Close() 'error : Syntax error converting the nvarchar value 'true' to a column of data type bit explicit conversion of true/false to int return always "True"/"False" wording thanks for help Tag: Database backup/restore Tag: 111171
  - 10
    - Child Relationships If I create a child relationship between 2 tables, but the parent table has a value which is not found in the child table, then this will cause an exception....right? So how to I indicate that the parent/child relationship may or may not exists so that no exception is generated when that occurs? Tag: Database backup/restore Tag: 111170
  - 11
    - Updating typed dataset schema from code Repost using registered alias: I have an existing .xsd file with typed dataset information in it. I need the ability to update this existing schema information when a column is removed from one of the underlying data adapters. Currently I read the existing schema info into a temp dataset object, update the schema for the table in question by just calling MyAdapter.FillShema and passing it my temp dataset. I then write the schema file back to disk. This works great for column additions, the new columns are placed in the schema, but it does not change the schema if a column is deleted. I've been searching through the merge documentation, the MissingSchemaAction documentation, anything I can think of, but I'm at a loss. Any ideas or pointers in a new direction? TIA Tag: Database backup/restore Tag: 111166
  - 12
    - Error MSDAAB ExecuteDataset I'm confused on calling ExecuteDataset with on a stored procedure with a single parameter. The following code gets an error stating there is no Stored Procedure with the name of '4' (probably the value of the CommandType.StoredProcedure enumeration). Dim parm() = New SqlParameter(0) {} parm(0) = New SqlParameter("@CompID", SomeParm) Dim ds As DataSet = SqlHelper.ExecuteDataset( _ ConnectionSettings.cnString, _ CommandType.StoredProcedure, _ "usp_StoredProc", _ parm) However, if I change the call to: Dim ds As DataSet = SqlHelper.ExecuteDataset( _ ConnectionSettings.cnString, _ "usp_StoredProc", _ SomeParm) there is no error and the code works correctly. Can someone explain what I am missing here? TIA Lars Tag: Database backup/restore Tag: 111164
  - 13
    - DataGrid.DataSource undefined when trying to Sort I had something like the following working: !!!!!!!!!! !!!!!!!!!! Start of Code snipet!!!!!!!!!! !!!!!!!!!! <asp:DataGrid id="FormListDataGrid" runat="server" AutoGenerateColumns="False" ShowHeader="true" HeaderStyle-CssClass="header" AllowSorting="true" OnSortCommand="SortCurrentMonth_OnClick" HeaderStyle-Height="25px"> <Columns> <asp:HyperLinkColumn Runat="server" DataNavigateUrlField="FormName" DataNavigateUrlFormatString="ShowForm.aspx?form={0}" DataTextField="FormName" HeaderText="Form Name" SortExpression="FormName"></asp:HyperLinkColumn> <asp:BoundColumn DataField="Due Date" HeaderText="Due Date" DataFormatString="{0:d}" SortExpression="Due Date"/> <asp:BoundColumn DataField="Entity" HeaderText="Entity" SortExpression="Entity" /> </Columns> </asp:DataGrid> protected void SortCurrentMonth_OnClick(Object source, DataGridSortCommandEventArgs e) { ((DataView) FormListDataGrid.DataSource).Sort= e.SortExpression; FormListDataGrid.DataBind(); } !!!!!!!!!! !!!!!!!!!! End of Code snipet!!!!!!!!!! !!!!!!!!!! This aspx load up the DataGrid on page start up. However, I now created another ASPX for reporting, whose DataGrid is set to Visible=false initially, with the DataSource, etc. only set at the click of a button. Code-snippet as follows: ~~~~~~~~~~~~~~~Start of new Code snippet~~~~~~~~~~~~~~~ <asp:DataGrid id="ReportDataGrid" runat="server" AutoGenerateColumns="False" ShowHeader="true" HeaderStyle-CssClass="header" AllowSorting="true" OnSortCommand="SortReport_OnClick" HeaderStyle-Height="25px" CellSpacing="5"> <Columns> <asp:HyperLinkColumn Runat="server" DataNavigateUrlField="FormName" DataNavigateUrlFormatString="ShowForm.aspx?form={0}" DataTextField="FormName" HeaderText="Form Name" SortExpression="FormName"></asp:HyperLinkColumn> <asp:BoundColumn runat="server" DataField="Due Date" HeaderText="Due Date" DataFormatString="{0:d}" SortExpression="Due Date" /> <asp:BoundColumn runat="server" DataField="Manager" HeaderText="Last Manager" SortExpression="Manager" /> <asp:BoundColumn runat="server" DataField="DummyComments" HeaderText="Dummy Comments" /> <asp:BoundColumn runat="server" DataField="Status" HeaderText="Status" SortExpression="Status"/> </Columns> </asp:DataGrid> private void ReportButton_Click(object sender, System.EventArgs e) { string reportSQL = "SELECT * FROM forms"; //Render reportSQL now based upon selected criteria on the web form DataSet dataList = new DataSet(); OdbcConnection Conn = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\dev\\outstandingForms.mdb"); Conn.Open(); OdbcDataAdapter accessDataAdapter = new OdbcDataAdapter(reportSQL,Conn); accessDataAdapter.Fill(dataList); DataView oView= new DataView(dataList.Tables[0]); ReportDataGrid.DataSource= oView; ReportDataGrid.DataBind(); Conn.Close(); ReportDataGrid.Visible= true; } protected void SortReport_OnClick(Object source, DataGridSortCommandEventArgs e) { ((DataView) ReportDataGrid.DataSource).Sort= e.SortExpression; ReportDataGrid.DataBind(); } ~~~~~~~~~~~~~~~End of new Code snippet~~~~~~~~~~~~~~~ The issue now is whenever I try to sort something by clicking on the column heading, I get an error, which is caused by an un-initialised ReportDataGrid.DataSource! How could I rectify this? I don't really want to re-run the query and re-set the DataSource, re-create the SQL everytime, do I? "Kevin Yu [MSFT]" wrote: > Hi Patrick, > > I agree with Elton that you have to assign e.SortExpression to the sort > expression of the DataView. > > oView.Sort = e.SortExpression; > > Here is an example: > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/ > frlrfsystemwebuiwebcontrolsdatagridsortcommandeventargsclasssortexpressionto > pic.asp > > Kevin Yu > ======= > "This posting is provided "AS IS" with no warranties, and confers no > rights." > > Tag: Database backup/restore Tag: 111162
  - 14
    - Cannot Open Any more databases I am converting from ADO to ADO.NET, and have written a routine to get records from an Access database. It's a customer-order type program. It works fine until I run a 'batch job' which runs through many orders - I then get the message "Cannot Open Any more databases" (I presume this is refering to tables?). I've tried closing all connections, but it still doesn't work properly. I don't want to set the connections to nothing if I can avoid it, as they will then need to be reinitialised each time I call the function (shown below). Any help on this would be appreciated! Function PopDataTable(ByVal ods As DataSet, ByVal sTable As String, ByVal sSQL As String, Optional ByVal sdsSQL As String = "", Optional ByVal rowParent As DataRow() = Nothing, Optional ByVal sRelation As String = "", Optional ByVal bForceClearTable As Boolean = False, Optional ByVal oda As OleDbDataAdapter = Nothing, Optional ByRef ocn As OleDbConnection = Nothing, Optional ByVal ocomSel As OleDbCommand = Nothing) As DataRow() Dim rowR As DataRow Dim rowSelected() As DataRow Dim iRecCount As Integer Dim iSelCount As Integer Dim shChildCount As Short Dim shTabCount As Short PopDataTable = Nothing If IsNothing(ocn) Then 'use the generic connection ocn = cnGen End If If IsNothing(ocomSel) Then 'use the generic command object ocomSel = comSelGen End If iSelCount = 0 'See if the rows are there If Not IsNothing(ods.Tables(sTable)) And Not bForceClearTable Then If sdsSQL = "" Then rowSelected = GetChildren(rowParent, sRelation, shChildCount) Else rowSelected = ods.Tables(sTable).Select(sdsSQL) End If iSelCount = rowSelected.Length PopDataTable = rowSelected ElseIf Not IsNothing(ods.Tables(sTable)) And bForceClearTable Then 'Clear the dataset if necessary or required ods.Tables(sTable).Clear() End If 'if there are no records execute query If iSelCount = 0 Then Try ocn.Open() 'Set the SelectCommand string and connection... ocomSel.CommandText = sSQL ocomSel.Connection = ocn 'set the data adapter to use this information oda.SelectCommand = ocomSel 'Fill the dataset table iRecCount = oda.Fill(ods, sTable) shTabCount = ods.Tables.Count() If iRecCount > 0 Then If sdsSQL <> "" Then PopDataTable = ods.Tables(sTable).Select(sdsSQL) Else 'If there's no relationship, select the whole datatable 'as it's just been populated If RelationShipExists(ods, sRelation) Then 'PopDataTable = GetChildren(rowParent, sRelation, shChildCount) PopDataTable = ods.Tables(sTable).Select(sdsSQL) Else PopDataTable = ods.Tables(sTable).Select(sdsSQL) End If End If End If Catch eFillException As System.Exception MsgBox(eFillException.ToString) 'TODO: handle errors here Finally ocomSel.Connection.Close() ocomSel.Connection.ReleaseObjectPool() oda.SelectCommand.Connection.Close() oda.SelectCommand.Connection.ReleaseObjectPool() ocn.Close() End Try End If Return PopDataTable End Function Tag: Database backup/restore Tag: 111161
  - 15
    - Data Table Joins I have data from two different databases which I want to join together. If I create one Datatable with the results of one query and another Datatable with the results of the second query, can I somehow join the 2 Datatables to produce a result which will look like I had executed a single query to return a single datatable? Tag: Database backup/restore Tag: 111154
  - 16
    - DataGrid header apperance I have a DataGrid that support sorting in ASP.NET 1.1 as defined at the end of this post. The issue is that regardless of what "style" attributes I put in the <asp:DataGrid/> tag or the <asp:HyperLinkColumn /> tags, I don't seem to be able to change the actual CSS class for the generated <a/> hyperlink tags for the sort column links. How could I do this? (Note settin style in the header won't do, as default CSS styles for <a/> has already been defined.  <asp:DataGrid id="FormDataGrid" runat="server" AutoGenerateColumns="False" HeaderStyle-CssClass="header" AllowSorting="True" OnSortCommand="SortArchived_OnClick" HeaderStyle-Height="25px"> <Columns> <asp:HyperLinkColumn Runat="server" DataNavigateUrlField="FormName" DataNavigateUrlFormatString="ShowForm.aspx?form={0}&xoq=31" DataTextField="FormName" HeaderText="Form Name" SortExpression="FormName"></asp:HyperLinkColumn> <asp:BoundColumn DataField="Due Date" HeaderText="Due Date" DataFormatString="{0:d}" SortExpression="Due Date"/> </Columns> </asp:DataGrid>  Tag: Database backup/restore Tag: 111145
  - 17
    - Join on two data tables in same dataset I have one dataset. Filled one DataTable from dbase. Filled another DataTable using ReadXml() and Merge(). So now I have to DataTables that I want to Join on that exist in memory but are from disparate data sources. Can I Join on them with ADO.NET? Thanks. Tag: Database backup/restore Tag: 111132
  - 18
    - Dataset to XL Hi Is there any way to export to XL thru Dataset , or DataTable or Grid or any other controls , than manually writing to each cell in XL Renjith Tag: Database backup/restore Tag: 111131
  - 19
    - Dataview filtering problem (Type your message here) -------------------------------- From: vallabh naidu Hi everyone, I have a typical problem, I dont weather what i am writing is= correct or not but I just want to filter the dataview and here= goes the code but that code below is not filtering according to= the condition=2E=2E=2E eagarly waiting for a positive result from any= of you people=2E Dim myfilter As String =3D "Parent_Org =3D'" & e=2ENode=2ETag &= "'" Dim DVOrg As New DataView(dt, myfilter, "ORG_Cd",= DataViewRowState=2EModifiedCurrent) Dim dr As DataRow Dim SelNode As TreeNode =3D e=2ENode If DVOrg=2ETable=2ERows=2ECount > 1 Then For Each dr In DVOrg=2ETable=2ERows Dim Nd As New TreeNode Nd=2EText =3D dr("ORG_Cd") + " " + dr("UDOrg_cd") + "= " + dr("ORG_DESC") Nd=2ETag =3D dr("ORG_Cd") SelNode=2ENodes=2EAdd(Nd) Next End If ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>VZHkFM4KsE+m93C804jX4g=3D=3D</Id> Tag: Database backup/restore Tag: 111130
  - 20
    - ADO.Net 1.1 : SQL Insert ? How do I convert this ASP 3.0 to VB.Net coding? ASP 3.0 Coding ----------------- Set rs = Server.CreateObject("ADODB.Recordset") rsstatm = "SELECT * FROM F4111" rs.Open rsstatm, ConnSQL rs.movefirst do while not rs.eof rsAdd = "INSERT INTO F4111A (ILITM,ILLITM,ILAITM) VALUES" rsAdd = rsAdd & "( " & rs("ILITM")&"," rsAdd = rsAdd & "'" & rs("ILLITM") &"'," rsAdd = rsAdd & "'" & rs("ILAITM") &"' )" ConnSQL.Execute(rsAdd) Set rsAdd = Nothing rs.movenext loop rs.close Set rs = Nothing Set rsstatm = Nothing Please help. Many thanks. Tag: Database backup/restore Tag: 111129
  - 21
    - RowFilter Expressions with multiple relationships I am difficulty in filtering a dataTable with muiltiple FK relationships. I have a table tblContacts(name, cityID, companyID) which has FK relationships to 2 lookup tables tblCity and tblCompany created in the DataSet. When I build the DataView.rowFilter String, I use "Parent.cityName like 'San*' AND Parent.companyName like 'Uni*'", but I get an error "Additional information: Invalid variable: Parent.cityName" at run time. Is there a way to work around this error? Thanks. Tag: Database backup/restore Tag: 111115
  - 22
    - Statement separator for Oracle client provider Hi, I have a large portion of an application (actually some sort of middleware) that has been developed first for SqlServer and now I am in the process of making it accessible to Oracle as well. The problem is that I use DataSets where, for instance, the UpdateCommand contains an UPDATE sql statement followed by a semicolon and a SELECT sql statement, all of this in the same CommandText. In this way, and in one single round-trip to the server, I can modify and obtain a fresh copy of the record. With Oracle provider, this is not working at all since Oracle dislikes the ';' and throws an exception (invalid character...). I have tried this in ORACLE SQL Plus Worksheet and works fine if one places a newline after the ';', but my hopes were seriously affected when I tried it in ORACLE SQL Plus, where it does not accept the semicolon regardless of a following newline. Can somebody shed some light on this, please!! -- Thanks in advance, Juan Dent, M.Sc. Tag: Database backup/restore Tag: 111113
  - 23
    - ado and ado.net dissimilarities Salam, this is faisal and i want to know about vb.net Actually, i am a programmer of Visual Basic and used to work with ado in order to have connectivity with database, now i want to move on .Net api but the problem is that, i can understand the tools provided by the .net but unable to work with ado.net. Can any Please tell me all about this. ------------------------------- From: faisal khanzada ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>mTbt6M6UTEadruoUV2jBXw==</Id> Tag: Database backup/restore Tag: 111102
  - 24
    - Adding a Row With an AutoIncrement Field I am trying to add a row to a table in a dataset. The table contains an ID field, which is set up as an AutoIncrement field, with AutoIncrementSeed = 1 and AutoIncrementStep = 1. I like the convenience of the following syntax: MyDataset.Tables("MyTable").Rows.Add(New Object(){"data for field1", "data for field2", "data for field3"...}) but because the first field is an AutoIncrement field, I'm not sure what to put in place of the first field. I tried vbNull, but that doesn't help. It complains on the second add that the ID already exists. How do I deal with the AutoIncrement field in an add such as the one above? Thanks. Tag: Database backup/restore Tag: 111101
  - 25
    - Help! Typed Dataset across multiple databases (e.g. IDBDataAdapte Is there a way the strongly typed dataset wizard will create classes that are usable across multiple databases? We are writing an application that can use Oracle, PostgreSQL, or Sql Server as the database. We have setup a DAL (using IDBConnection, IDBDataAdapter, etc.) to facilitate database portability. We can now use the DAL for all our database functions, which is great. However, we can't figure out how we to utilize the auto-generated strongly typed dataset classes across multiple databases. Is it possible? Our app has 1000's of columns, so this would be a MASSIVE time saver vs. creating all the classes by hand or hand-writing all the SQL. Thanks, Josh Tag: Database backup/restore Tag: 111100
- Next
  - 1
    - How does Dataset.Relations work internally? Does ADO.NET internally sets up hashtables for the columns that are used to tie tables, so that later on hashtables can be used to quickly retrieve data? Or does it just loop through data to locate the ChildRows. For instance, in a line like this. ds.Relations.Add( new DataRelation(RELATION_BREAK_PRODUCT, tblBreak.Columns[FIELD_BREAK_ID], ds.Tables["Product"].Columns[FIELD_BREAK_ID])); Thanks. Tag: Database backup/restore Tag: 111097
  - 2
    - Load a string of CSV from memory into a dataset Hi Group, Here is what I'm trying to do in my application: 1. the customer uploads an encrypted file to the server (it's a ASP.NET application) 2. the uploaded file is decrypted to a comma separated list of values 3. the list is being written to a CSV file 4. the csv file is being loaded into a datatable, using OleDbDataAdapter 5. the recordset, after some checking and validation, is being written to a SQL database. Question: Is it possible to skip somehow the steps where I'm writing the comma separated list to a csv file and then reloading the list into a datatable? Something like loading the datatable directly from the comma separated string **in memory** ? Many thanks ! Andrei. Tag: Database backup/restore Tag: 111093
  - 3
    - Invalid Key node inside constraint error I have an XML document that I'm reading into a dataset. I programmatically created dataadapters and constraints for all the tables and relationships and I'm able to insert all the data into the database no problem. Instead of running the code to create the constraints all the time, I used WriteXMLSchema to write out an .xsd for me that has everything already defined. Now when I read this schema back using ReadXMLSchema, I get the error: Invalid 'Key' node inside constraint named: Arrests-Inv_Holding_Facilities .NET created this .xsd for me, why can't it read it in? I've made no changes to it manually. I've seen several messages with this same question out on the web, but no answers. Can anyone tell me what the problem is? Tag: Database backup/restore Tag: 111090
  - 4
    - Oracle Driver Behavior I am running the Oracle 9.02 driver in development, which is working fine with the following statement. #region Add Inbound Transaction // for valid requests, insert transaction into table: INBOUNDTRANSACTIONS // returns boolean indicating success public bool addInboundTransaction(string structureID, string msgIn, string status, string lastUpdatedBy, string originatingID, string hostSystem) { OleDbConnection cn = new OleDbConnection(DataSource); string sql = "INSERT INTO TABLENAME (TABLEROWID, STRUCTUREID, STATUS, LASTUPDATEDBY, MSGIN, ORIGINATINGID, HOSTSYSTEM) VALUES (IBTXN_SEQ.NEXTVAL, :1,:2,:3,:4,:5,:6)"; OleDbCommand cmd = new OleDbCommand(); cmd.CommandTimeout = CommandTimeOut; cmd.CommandText = sql; cmd.Connection = cn; cmd.CommandType = CommandType.Text; OleDbParameter p1 = cmd.Parameters.Add("strucID", OleDbType.VarChar,50); p1.Direction = ParameterDirection.Input; p1.Value = structureID.Trim(); OleDbParameter p2 = cmd.Parameters.Add("status", OleDbType.VarChar,50); p2.Direction = ParameterDirection.Input; p2.Value = status.ToUpper().Trim(); OleDbParameter p3 = cmd.Parameters.Add("lastUpdatedBy", OleDbType.VarChar,50); p3.Direction = ParameterDirection.Input; p3.Value = lastUpdatedBy.ToUpper().Trim(); byte[] ba = stringToByteArray(msgIn); OleDbParameter p4 = cmd.Parameters.Add("blobData", OleDbType.Binary, ba.Length); p4.Direction = ParameterDirection.Input; p4.Value = ba; // the ip/dns address of the system making the request (like http_referrer) OleDbParameter p5 = cmd.Parameters.Add("originatingID", OleDbType.VarChar,50); p5.Direction = ParameterDirection.Input; p5.Value = originatingID.ToUpper().Trim(); // the name of the host system (http, websvcs) OleDbParameter p6 = cmd.Parameters.Add("hostSystem", OleDbType.VarChar,50); p6.Direction = ParameterDirection.Input; p6.Value = hostSystem.ToUpper().Trim(); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } #endregion But, when trying to run this same code from test system, which is running Oracle driver 8.01.07, I am receiving this error: "ORA-01036: illegal variable name/number" Is there something I can do to fix my SQL so it runs properly using the 8.01 driver? Or is it possible to install the 9.02 driver on test without disrupting the current apps that are using 8.01? - not a highly supported solution by other developers on my team. Or can I run these drivers side by side on the same machine? Ideally, I can identify what is causing this code to fail using the 8.01 driver and just redo the SQL. Thanks for the assistance! Tag: Database backup/restore Tag: 111086
  - 5
    - ADO.NET System.Data.SqlClient I'm developing web applications using Visual Studio.NET 2003 Version 7.1.3088 on two laptop configurations. One is Windows 2000 Professional, other is Windows XP SP2. Microsoft.NET Framework 1.1 Version 1.1.4322 SP1 (on XP Laptop), Microsoft.NET Framework 1.1 Version 1.1.4322 (on 2K Laptop). I have SQL Server 2000 - Version 8.00.0384 - SP4 installed on standalong machine. I've used VB.NET 2003 for over 1.5 yrs - no problems on 2K platform. I have web application connecting flawlessly to SQL server using SqlClient namespace. I have "headaches" while migrating same web application on XP platform. Continually getting message "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Basically SQL Server 2000 - is fully operation for all apps, includes web app on 2000 Professional development machine. Just can't get SQL connects to database on XP Sp2 platform. I feel differences in OS are causes - different DLL's, possible issue with MDAC - TDS stream issue. I've submitted 3 postings to other newsgroups. Other disagree with MDAC issue & OS issue. I guess my questions are then - What is causing this to NOT work on SP2 of XP platform - same code - etc... Just 98% of time WON'T connect - once in blue-moon connection passes with XP Sp2. Again, no problems with 2000 OS platform. Please advise! Tag: Database backup/restore Tag: 111083
  - 6
    - Accessing deleted and changed rows in a DataSet I'm writing a client to connect to a legacy system (pre-.NET) which only accepts input and provides output using ADO Recordsets. I've been able to convert Recordset to DataSet, and if the DataSet has no changes I can convert back to Recordset. The problem comes when converting DataSet to Recordset when rows have been deleted or updated. The only way I could find to do the conversion involves "hand-crafting" the XML for the ADO Recordset combined with running an XSLT transform on the DataSet data. What I can't do is access the original rows in the DataSet in order to write <rs:update>, <rs:original>, and <rs:delete> elements and their child rows in the <rs:data> section. This data must be in there somewhere, otherwise how could a DataSet update a database directly? Does anyone know how I can get to it? Alternatively, if I'm missing an obvious way of making this easier, please can someone enlighten me ;-) Thanks Ian Tag: Database backup/restore Tag: 111082
  - 7
    - Can't insert in my table Hello, I have a stange error and I don't know where to look at. I do multiple insert in muliple table in my MDB databse. Everything work except from one table. when the code execute I get this error: Message "Syntax Error in the instruction INSERT INTO." StackTrace " 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 NTiersConstructeur.Data.DataProviderOleDb.Execute(String SQL) in C:\_DEV\NTiersConstructeur\Classe\DataProvider.vb:line 187" String When I execute the sql string in my mdb, It's work!!! Here is the sql string INSERT INTO [Valeur] (IDEntity, [Name], [Description], [Version], [TypeValue], [ReadWriteValue], [FieldNameValue]) VALUES (20, 'Valeur1', '', '', 'String', 'ReadWrite', '' ) Here is the code that execute all the insert, update and delete SQL string Private Function Execute(ByVal SQL As String) As Boolean Try Dim strConnectionString = System.Configuration.ConfigurationSettings.AppSettings("OLEConnectionString") Dim oConnection As New OleDbConnection oConnection.ConnectionString = strConnectionString oConnection.Open() Dim oCommand As OleDbCommand oCommand = New OleDbCommand(SQL, oConnection) oCommand.CommandType = CommandType.Text Dim oTransaction As OleDbTransaction oTransaction = oConnection.BeginTransaction oCommand.Transaction = oTransaction Dim intResult As Integer = 0 intResult = oCommand.ExecuteNonQuery Dim blnResult As Boolean = False If intResult >= 0 Then blnResult = True End If If blnResult Then oTransaction.Commit() Else oTransaction.Rollback() End If oConnection.Close() oConnection.Dispose() oCommand.Dispose() Return blnResult Catch ex As ArgumentException Catch ex As OleDbException MsgBox(ex.ToString) Catch ex As Exception MsgBox(ex.ToString) End Try End Function Can someone tell me what I am doing wrong? Is there an error in my sql string? Why do I have this error only with one table and not from the others? Tag: Database backup/restore Tag: 111081
  - 8
    - Divide by Zero exception Hi there My .asp application draws data from a number of sources, converts the results to type.double and does various calculations with these figures. Because of data entry errors on the system from which some of the data is drawn (this system is unfortunately not under my control so I can not sort this problem out at source....) I occasionally get Divide by Zero Exceptions which crash my application. Does anyone have a clever (or otherwise) way of catching this particular error and inserting a value of 0 in to the result instead of crashing ? Any help would be appreciated Tag: Database backup/restore Tag: 111076
  - 9
    - Problem with Data Refresh Hi there I have an .asp application that uses an accounting package for some of it's data. This links to a warehouse stock system. I am not running an ODBC link straight to the accounting system, but instead run a data refresh every 5 minutes that synchronises all the stock in the warehouse in to an SQL table - my .asp application links to this. I believe I am having issues with queries that are executed during this scheduled refresh of data - the application does not fail, but I am getting reports of inaccurate data resulting from queries at apparently random times of the day. Does anyone know if I am able to either lock the table during a refresh (and how my ado programming will recognise this status) so that I can catch the query and display a message along the lines of "Data refreshing, please wait" and then requery once the refresh has completed - any more practical suggestions would be musch appreciated. Thanks very much for your time Stuart Tag: Database backup/restore Tag: 111075
  - 10
    - Issues with DataGrid sort I have been trying to follow some examples on http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconsortingdatainsqldatabase.asp http://www.dotnetjunkies.com/Tutorial/E169C6D4-D335-4D2B-AE3F-918EE3161815.dcik http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsDataGridClassTopic.asp I found two issues 1) Sorting does not seem to work at all when AutoGenerateColumns is set to False 2) Data binding is not working When AutoGenerateColumn disabled, the header appears in plain text, with no links to sort on columns! Even when AutoGenerate is enabled (and I can't have that!) Any suggestions on how to resolve these? Code snippet as follows: /********* Start of ListForms.aspx***********************/ <asp:DataGrid id="FormListDataGrid" runat="server" AutoGenerateColumns="False" ShowHeader="true" HeaderStyle-CssClass="header" AllowSorting="true" OnSortCommand="SortCommand_OnClick"> <Columns> <asp:HyperLinkColumn Runat="server" DataNavigateUrlField="FormName" DataNavigateUrlFormatString="ShowForm.aspx?form={0}" DataTextField="FormName" HeaderText="Form Name"></asp:HyperLinkColumn> <asp:BoundColumn DataField="Due Date" HeaderText="Due Date" DataFormatString="{0:d}"/> <asp:BoundColumn DataField="Entity" HeaderText="Entity" /> </Columns> </asp:DataGrid> /********* End of ListForms.aspx***********************/ /*************Start of ListForms.aspx.cs*****************/ 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.Data.Odbc; namespace BeanCounter { /// <summary> /// Summary description for ListForms. /// </summary> public class ListForms : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid ArchivedDataGrid; protected System.Web.UI.WebControls.DataGrid FormListDataGrid; protected string currentFormSQL = "SELECT * from Forms where Active=1"; protected string actualCurrentFormSql; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here DataSet dataList = new DataSet(); actualCurrentFormSql=currentFormSQL; OdbcConnection Conn = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\db\\outstandingForms.mdb"); Conn.Open(); OdbcDataAdapter accessDataAdapter = new OdbcDataAdapter(currentFormSQL,Conn); accessDataAdapter.Fill(dataList); DataView oView= new DataView(dataList.Tables[0]); FormListDataGrid.DataSource= oView; FormListDataGrid.DataBind(); Conn.Close(); } #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.Load += new System.EventHandler(this.Page_Load); } protected void SortCommand_OnClick(Object source, DataGridSortCommandEventArgs e) { actualCurrentFormSql = currentFormSQL + " ORDER BY " + e.SortExpression; FormListDataGrid.DataBind(); } #endregion } } /*************End of ListForms.aspx.cs*****************/ Tag: Database backup/restore Tag: 111070
  - 11
    - Merging XML Documents (with ADO.NET?) I have got 2 XML documents, both of which conform to the same XSD Schema, which define possible optional elements. The 2 XML documents contain 2 disjoint set of XML elements. What is the best, easiest, most efficient way of merging the 2 XML Documents? Can I use DataSet.Merge() facility in ADO.NET?? Any pre-requisites? Any other suggestions? Tag: Database backup/restore Tag: 111067
  - 12
    - Error when committing the row to the original data store I am new to VB.NET so please bear with me. I have a small test application where the user can choose a table from a combo box, whereupon a DataGrid is populated with data from the chosen table. Here is the code in the combo box's SelectedIndexChanged event procedure. Private Sub cboTable_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboTable.SelectedIndexChanged If cboTable.Text <> "" Then Dim cmdLookupTableSelect As New SqlClient.SqlCommand With cmdLookupTableSelect .Connection = cnnConnection .CommandType = CommandType.StoredProcedure .CommandText = "admLookupTableSelect" .Parameters.Add("@tableName", SqlDbType.NVarChar, 50).Value = cboTable.Text End With mdaDataAdapter = New SqlClient.SqlDataAdapter mdaDataAdapter.SelectCommand = cmdLookupTableSelect mdsDataSet = New Data.DataSet mdaDataAdapter.FillSchema(mdsDataSet, SchemaType.Mapped, cboTable.Text) mdaDataAdapter.Fill(mdsDataSet, cboTable.Text) dbgDataGrid.DataSource = mdsDataSet dbgDataGrid.DataMember = cboTable.Text End If End Sub The idea is that the user will be able to add/update/delete data in the DataGrid and save the changes to the database. I am using a CommandBuilder to build the commands on the DataAdapter. Validation of the data added to the DataGrid is handled automatically; for instance, if I add too many characters to a column and move to the next row in the DataGrid, I get an error message with the title, 'Error when committing the row to the original data store', and the message gives details of the constraint. This is mostly what I want and I didn't have to write much code to achieve it, which is great. The trouble is that I want to make the MessageBox fit in with the rest of the application, which will have a rigorously consistent style for all GUI elements. So my question is, how can I trap this error message and package it in a way that is more in keeping with my application? The message appears on moving from an edited DataGrid row to another row. The exception thrown is of type System.ArgumentException. No matter what events I try to trap on the DataTable, I cannot get access to this exception. Any help would be greatly appreciated. Tag: Database backup/restore Tag: 111063
  - 13
    - Type Casting to long When we retrieve data from a int field from a datatable and if I write lValue = (long)dtTable.Rows[0]["Fld1"] it generates an error at runtime. whereas it should be done because we are converting int to long which should be possible. but if I use Convert.ToInt64 it does give any error. What is reason for that? Regards, Lalit Bhatia Tag: Database backup/restore Tag: 111062
  - 14
    - Oracle Client Components Is there a way to connect to oracle 9i database from c# WITHOUT installing the Oracle Client Components on my machine? Thanks Arlef Tag: Database backup/restore Tag: 111059
  - 15
    - Updating joined tables Hi, I am trying to display data from two sqls tables in a datagrid, and then alow the user to make changes that update one of the tables. Currently I am bringing in two tables into a dataset, merging them and binding them to a datagrid. I then use a comand builder on one of the original sql tables in order to update it. It sort of works - I cant get tables to merge that have different numbers of records. Is there a better way to do this? Thanks, Tag: Database backup/restore Tag: 111056
  - 16
    - How do I convert a base64 encoded bytearray? Hi! I have a webservice which queries a table in SQLServer. The table has a column, "Text", which is of datatype "image". When invoking the webmethod it returns dataset with the table included. The column is returned as a base64binary as can be seen in the declaration excerpt below: <xs:element name="text" type="xs:base64Binary" minOccurs="0" /> When I call the webservice and loops through the rows I see that the column "text" is represented as a bytearray as well. What I'd like to do is to convert this bytearray into an "ordinary" string. Please note that it must work in a .Net Compact Framework environment. I've tried a number of approaches but none has worked so I feel a little bit "lost in binary space". Hope you can help me! /Peter Tag: Database backup/restore Tag: 111054
  - 17
    - how to update datagrid (Type your message here) i am trying to create tables in sql server programmatically in= vb=2Enet=2Ei can add fields and update them programmatically=2E i need= to know how i can update the table records when displayed in= datagrid=2Ei want to update the datagrid/records as it is done in= access=2Eneed to know how to get count of number of rows filled in= datagrid=2Eplzzz help!! -------------------------------- From: amritac20 chaudhuri ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>kSuuS0+4DU+lP+VwPUuFeA=3D=3D</Id> Tag: Database backup/restore Tag: 111052
  - 18
    - Updating a column in a DataTable... Ok, I'm sure this one has been asked before, so I'll apologize upfront. What I'd like to do is take a DataTable and run an update statement against one of its columns. Say for instance, my DataTable has a ProductID column, which is an integer, and I'd like to update all values in that column to something like 33786. What's the best way to do it? Would a SQL-like statement work combined with a DataAdapter, or is it not that simple? Tag: Database backup/restore Tag: 111039
  - 19
    - null or DbNull or what? Hello, I am trying to find the most efficient way to send record UPDATES from a client to my webservice. I am already using GetChanged to only send the records that have actually been modified, but I would like to further reduce network traffic by not sending individual columns that were not modified. My first attempt in doing this was to use SQL stored procs that have default values that would be values that would never actually be used for these fields. The update statement then evaluates each parameter to determine whether it should really update each column. This works great on the SQL Server side, and I've discovered that by leaving the Command Parameter value as null (not DbNull), the default values would be invoked. The problem here lies in determining if a value in my DataTable is DbNull because it was set to null or if it is DbNull because it was not changed. It seems that I cannot actually set fields in a datarow to be actual null (not DbNull). Is there something I am missing here? Moreover, is there something bigger that I am missing? Is there a better solution for minimizing the amount of XML being sent from my client to my webservice? I do realize that a possible solution would be to stop sending a DataSet and just use my own XML specification that allowed for more flexibility in minimizing packets being sent. But that solution seems to negate a great deal of Microsoft technology that we hoped to be leveraging. Thank you for any suggestions, Glenn Thimmes Tag: Database backup/restore Tag: 111038
  - 20
    - Reading Data From Excel Via ADO.NET I have an application reading data from an Excel file and filling a SQL Server table. When I read the Excel file, I want to be able to trim trailing spaces off the data as it's read into the dataset. I'm connecting to the Excel file via an OleDbDataAdapter & OleDbCommand object. All the code compiles and runs fine - I just want to trim any trailing spaces off of the data. Here is a portion of the code I'm using: Dim oCmdSelect As New OleDbCommand(moImportFormat.SelectFromStatement, moConnExcel) 'Get the values in the Excel file and verify mDSExcel = New DataSet() Dim oDA As New OleDbDataAdapter() oDA.AcceptChangesDuringFill = False oDA.SelectCommand = oCmdSelect oDA.Fill(mDSExcel, sTableName) The SQL statement stored in moImportFormat.SelectFromStatement is: SELECT STORENAME FROM [Sheet1$] The trick, I believe, is to add a "trim" statement as in TRIM(STORENAME) or RTRIM(STORENAME). However when I tried TRIM & RTRIM, I receive an error message. When I take out the TRIM or RTRIM it works fine. So the $1 million dollar question is, is there a function that can "trim" data when being read in with an OleDbDataAdapter / OleDbCommand? Thanks, Kyle Tag: Database backup/restore Tag: 111035
  - 21
    - good data-driven place to store default values? so i have a database schema, a .NET object library .dll, and an ASP classic web application. i'm wondering where in this setup i should place default values for fields/columns of forms/objects/rows. SQL Sever doesn't seem like a good candidate, because i'm using stored procedures for all inserts. these procs use input parameters for each of the values in case there IS a value other than default, but since the parameters are optional, they are defined with the = null. so these mechanisms basically completely circumvent the default values, because either a value is specified by the caller of the proc, and that value is stored, or the value is not specified by the caller, and a null is stored. either way, no default values from the table definition. The object library seems like a decent place, except that i would love for it to be data driven. i suppose each object could keep track of all of its own default variables. part of the constructor could be to go find its default-value definition file, and load them up that way. does anyone foresee any major architectural problems with this? And the last option is to put the default value definitions in the ASP code somehow, probably through a constants file, and value comparisons. Much less elegant than putting them in the object library, but pretty simple, too. Thoughts? comments? Suggestions? Thanks, Jason Tag: Database backup/restore Tag: 111026
  - 22
    - how can I create a properties collection for a user control How can I create a properties collection for a user control? (or reference what's there if it already exist) I have a user control that displays an HTML table with several values. For each field's value I have a public property that is set from a repeater's itemdatabound event. In the ItemDataBound Sub, I use something like the following where the datasource column name is always the same as the form's property name: DisplayTable.FIELD1 = DataBinder.Eval(e.Item.DataItem, "FIELD1") I have to go through and set approx. 30 fields just like this but I'd like to do something that is completely independent of the number of columns returned plus I'd rather not have to name each property or field should one be deleted or added.... Something like: dim x as property for each x in MyUserControlInstance.PropertiesCollection MyUserControlInstance..x= DataBinder.Eval(e.Item.DataItem, x) next I've tried several different approaches but can't get it working . The compiler identifies the .x part after the control name as the source of the error. I can't recall right this second if the message was 'identifier expected' or 'expression expected' but I think it was one of these. Mike Tag: Database backup/restore Tag: 111024
  - 23
    - Using DataReader to count rows Hello All: First let me thank everyone on the forum(s) for all the great (and timely) help!!! I am writing a help desk app in asp.net that allows people to input work orders for IT. I used to use data adapters and datasets until someone here helped me to realize the performance advantage of using data reader. It works great for displaying the info, but i would like to add the ability to pull the *number* of open and closed work orders for a particular user as such: SELECT * FROM workorders WHERE extension = ('extension') and STATUS = ('Open') SELECT * FROM workorders WHERE extension = ('extension') and STATUS = ('Closed') then i want the data reader to tell me how many rows were selected. I tried things similar to; ****************************************** While rdr.read() a = a + 1 End While labelOpenWorkOrders.text = a ****************************************** and I also tried ******************************************** while rdr.read() do a = a + 1 loop end while labelOpenWorkOrders.text = a ******************************************* It never returns the actual row count. i also tried labelOpenWorkOrders.text = rdr.recordsaffected -- but this is only for insert, update, delete. HELP!!!! Thanks Steve Tag: Database backup/restore Tag: 111018
  - 24
    - Defaults in Column Mappings Dear All, I have designed a DataAdapter which reads data from a table. The table has an auto-incrementing Primary Key. None of the columns in the table accept Nulls although some of the columns do have defaults. My question is - Is there an automatic method of filling these properties on the table when I call the fill method, or do I have to manually key the properties for each column when the table has been filled? Thanks in advance for your assistance Mike Tag: Database backup/restore Tag: 111008
  - 25
    - ConnectionState problem Hi, My application connects to an Access database when it is loaded, and keeps the same connection open all the time. There is logic in the code to ensure that the connection is automatically opened the first time it is used: if ((cmd.Connection.State == ConnectionState.Closed) || (cmd.Connection.State == ConnectionState.Broken)) cmd.Connection.Open(); However occasionally my application says this: System.InvalidOperationException: The connection is already Open (state=Connecting). or it might say the same but with state=Executing. But if the state is Executing, you can neither call .Open nor can you execute a query. So how can I maintain an open connection without these errors occuring? To be honest, I don't understand why it is ever in the "Exectuting" state, because it's a single threaded application and theres no way that it can be doing more than one thing at once. Thanks, Nick... Tag: Database backup/restore Tag: 111006

Is there any way to backup/restore an SQL Server database from .NET, using
the System::Data::SQLClient namespace?

Thanks

Top

Re: Database backup/restore by William

William
Fri May 27 21:10:09 CDT 2005

Sure. Create a sqlCommand object that has a BACKUP DATABASE command. For
details on this command, consult SQL Server books online.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Kimon Ifantidis" <Kimon Ifantidis@discussions.microsoft.com> wrote in
message news:B99F9285-411E-45A2-804F-E4D4B279192D@microsoft.com...
> Is there any way to backup/restore an SQL Server database from .NET, using
> the System::Data::SQLClient namespace?
>
> Thanks

Top