Using OleDb with Enterprise Library 1.1 or 2.0
Hi all,
i know that the EL can be used with SQL, Oracle or DB2 database and i know
a MySql connectot for this great pattern.
But i would like to use it even with OleDb provider.
Could someone tell me if is there an Helper for OleDb and Enterprise
Library ???
Thanks in Advance
Stefano Tag: Hiding child rows in a datagrid Tag: 127077
Convert Dataset with Tables with Relations to Flat view
Hi
I have a dataset with 2 tables and Relations
What is the best way to flatten the 2 files to a new table or xml or file
I can loop thru table1 and get the childrows
or
I can do an Xpath on the xml but not sure how to get relation from xsd
or
Is there another alternative???
Currently
Table1
2000 10,000
2001 12,000
Table2
2000 mustang 2,000
2000 corvet 4,000
What I want
2000 10,000 mustang 2,000
2000 12,000 corvet 4,000
Thanks
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="vfffg">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="e1">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="CarYear" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="e2">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="CarYear" type="xs:string" minOccurs="0" />
<xs:element name="CarModel" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1">
<xs:selector xpath=".//vfffg" />
<xs:field xpath="ID" />
</xs:unique>
<xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1">
<xs:selector xpath=".//e1" />
<xs:field xpath="ID" />
<xs:field xpath="CarYear" />
</xs:unique>
<xs:keyref name="e1" refer="e1_Constraint1">
<xs:selector xpath=".//e2" />
<xs:field xpath="ID" />
<xs:field xpath="CarYear" />
</xs:keyref>
<xs:keyref name="e0" refer="Constraint1">
<xs:selector xpath=".//e1" />
<xs:field xpath="ID" />
</xs:keyref>
</xs:element>
</xs:schema> Tag: Hiding child rows in a datagrid Tag: 127072
Sorting a Dataset table
Hi,
I need to export the contents of a DataTable in a Dataset to a text file in
a particual row order. I guess I need to use the DefaultDavaView but I
think I am doing something wrong since traversing the rows in the table
doesn't show them in the correct order.
Thanks
Jeronimo Bertran Tag: Hiding child rows in a datagrid Tag: 127060
Navigation using ODP.net
Dear All,
i have establish a connection to Oracle 10g using ODP.net , i could
populate data in a listbox/combo box, but i need to display these data
in one by one , i mean navigation using
|< < > >| these buttons , plshelp me
blw is the code i'm using to populate data in combo/list box
-----------------------------------------
dbconnection.getConnection() ' connection string written in a module
calling her e
Dim conn As New OracleConnection(oradb)
Dim exp As Exception
Try
conn.Open()
Dim sql As String = "select EMPNO,ENAME,mgr from emp where
1 =1 "
Dim cmd As New OracleCommand(sql, conn)
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
While dr.Read()
ListBox1.Items.Add(dr.Item(1))
End While
conn.Close()
conn.Dispose()
Catch exp
MsgBox(exp.Message.ToString)
End Try Tag: Hiding child rows in a datagrid Tag: 127059
ASC-DESC
Hi,
The Asc or Desc functions work well on the sql server, but when I try to use
the parameters collection through ASP.NEt . The SQL statements doesn't
execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc.
on ASP page I get is as 1 Apr, 8 Aug etc. The sql stmt ends ass ORDER BY
month(date) DESC & works well.
Thanks. Tag: Hiding child rows in a datagrid Tag: 127058
DBNULL
In the UI, there are some optional field but in the DB I want tto store NULL
instead of empty string. Do I check for empty string for these values in the
business layer when I am going thru each row in the datatable for Data
Validation.
Thanks Tag: Hiding child rows in a datagrid Tag: 127057
eMoovie - a new company - we need sponsors
Hello !
We are eMoovie, a young swiss start-up based in Geneva. We developed
SICMovie, a novel technology for VOD security. This technology is not a DRM
but a DRT (Digital Rights Tatoo).
The goal of DRT is not to control the customer's use of the downloaded movie
but to give him responsibilities over the use of the file, and thus to unite
copyright and private copy right (Fair use) in one system.
We need capital from sponsors and private investors in order to continue our
development.
Please visit our website: http://www.emoovie.com
eMoovie Team Tag: Hiding child rows in a datagrid Tag: 127055
Help connecting to Access DB from web service
I am creating a web service that returns data from an Access 2000 database
using VS2005. The Access database is located on a different server than
where the web service is running. The Access database is also opened by a
different desktop application running on various workstations on the
network.
While developing / debugging the web service is hosted on my development
machine using the 'ASP.NET Development Server' that is included with VS2005.
When deployed it is being host with IIS.
I am using the following connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\slo-science1\data\PBI Chem
data\PBIChemDatabase.mdb"
If the database has NOT opened by any of the workstations running the
desktop application then the web service runs correctly on both my
development machine as well as on the IIS server.
If the database has been opened by any of the workstations running the
desktop application the web service runs correctly ONLY on my development
machine and fails on IIS with the following error:
System.Data.OleDb.OleDbException: Could not use ''; file already in use.
What are the differences between the 'ASP.NET Development Server' and IIS
that would effect how a web service opens a remote Access database?
Does anyone know how what settings can be changed so that the web service
runs correctly on IIS?
Thanks in advance,
Jeff Richardson Tag: Hiding child rows in a datagrid Tag: 127054
ODBC DataSet to Update Ole Access Table
I have a dataset that shows data from an ODBC connection and want to
insert that data into an access data base. I'm able to create the
record lock on the access table, but am unable to get any data inserted
from the dataset to the access table. Below is the coding that I have
so far. I've struggled with this for about 2 weeks. This is VB.net. Any
guidence is truly welcomed. RickN
Private Sub btnLoadAccess_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btnLoadAccess.Click
Dim sSQL As String
Dim icount As Integer
Dim i As Integer
Dim ds1 As DataSet1
' create connection and create the command
Dim oOleDbConnection As OleDb.OleDbConnection
Dim objCommand As New OleDb.OleDbCommand
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Rick
Nicholson\My Documents\Visual Studio Projects\MAX Data Interface\Lot
Table.mdb;" & _
"User ID=Admin;" & _
"Password="
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
'start a loop here and loop thru and update access
For i = 0 To DataSet1.Tables(0).Rows.Count - 1
Next
Try
'working sql from pervasive or access...what ever
'INSERT INTO table_name (column_name1,
column_name2,...)VALUES (value1, value2,....)
' try this insert into "LotTrackingHistory"("PRTNUM_72")
values ('333333')
For Each rowX As DataRow In ds1.Lot_Tracking_Hist().Rows
sSQL = "INSERT INTO LotTrackingHistory (PRTNUM_72)
Values (" & rowX.Item("PRTNUM_72").ToString & ")"
Next
With objCommand
.Connection = oOleDbConnection
.CommandText = sSQL
.CommandType = CommandType.Text
.ExecuteNonQuery()
End With
'Count the number of entries and display them
'icount = (objCommand.ExecuteNonQuery())
' MessageBox.Show(icount)
oOleDbConnection.Close()
oOleDbConnection = Nothing
Catch
End Try
End Sub
End Class Tag: Hiding child rows in a datagrid Tag: 127051
Large Upload to SQL - Async?
Is there any possible way to upload a file into an image field in SQL
Server asynchronously?
Our users upload a lot of large files into a SQL Server, and we have no
way of showing them progress. ADO had an "AppendChunk" method, but it
doesn't look like .Net has anything similar. This seems like a big
oversight to me... Tag: Hiding child rows in a datagrid Tag: 127049
How to set in XSD Shema, column not to allows DBNulls?
Column has property AllowDbNull to set is it allowed or not to add DbNull.
How to set this property in XSD Schema in design time?
My object is to make an int field required...
Thanks Tag: Hiding child rows in a datagrid Tag: 127046
deleted rows
I have a strongly typed dataset 'A' with a Customer datatable and data.
I create a new instance of the same dataset ('B') and import rows into
the 'B' Customer datatable from dataset 'A' Customer datatable.
I delete a row in dataset 'B' Customer datatable and now want to mark
the row as deleted in dataset 'A' customer datatable.
How can I do that?
I thought I could loop through the Customer B rows, find rows with row
state = deleted, find them in Customer A and delete them. However,
this process throws an exception that the deleted row is inaccessible.
Any suggestions.
Thanks,
Rick Tag: Hiding child rows in a datagrid Tag: 127044
Is it possible to add DataRelation on Individual tables?
Hello
I have two tables that do not belong to DataSet. They are individual.
Is it posible to create DataRelation Or ForeignKey in this situation?
I tried but on:
childTable.ParentRelation.Add(dataRelation)
got Null Exception.
Thanks
Milan Tag: Hiding child rows in a datagrid Tag: 127041
Delete using GetChanges
I'm using DataSet that fills data from a filestore (filenames, size, a
DelMe bool coln, etc). Now I want to delete rows which have DelMe set
to true. Since I'm using a DataAdapter here, which would be the best
way to delete rows that have DelMe=true;
Currently I do this.
DataRow[] changes = parentTable.Select(null, null,
DataViewRowState.ModifiedCurrent);
Then I loop and set each to row.Delete() and finally call
AcceptChanges() to remove them from the table.
Is there a more efficient way to select and delete. ?
thanks
Sunit Tag: Hiding child rows in a datagrid Tag: 127033
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
You too can learn to be funny in just 7 days flat:
http://www.ExpertHumor.com/HowToBeFunny.htm
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 127028
IndexOutOfRangeException - Index was outside the bounds of the array.
We are encountering an extremely odd issue. We process incoming files for
customers and output text files to produce printed material. Then an XML
file
containing the fields of the original file along with all fields necessary
to
produce the output text files are saved as an XML file. If an individual's
printed material is destroyed in the process of fulfillment, we must
reproduce the output for them. We do this by reading the XML file back into
a
dataset and re-outputting the text files. The XML file (and hence the
datatable in the dataset) have a LOT of fields/columns (some have over
1000).
We discovered that if a column is added to the datatable at the end of the
columns collection, AND is later referred to in a SELECT clause to return a
row collection, AND then large amounts of columns are removed and then added
back into the columns collection, the following error is thrown:
System.IndexOutOfRangeException - Index was outside the bounds of the array.
We also discovered that if we added the column referred to in the SELECT
clause at the BEGINNING of the columns collection (which was not easy) the
error did NOT occur. However, this is simply side-stepping the bigger issue.
I have sample code that will duplicate this behavior, but that and the XML
is too long to post. Is there some way to post this code and XML?
This is running on .NET 1.1 framework. Any light that could be shed on this
issue would be greatly appreciated.
Thank you. Tag: Hiding child rows in a datagrid Tag: 127026
OLEDB: UpdateCommand fails
Hi, can anyone help me with the following.
MS Access 2002 database, Northwind, Customer table.
In VB.NET using a datagrid and a dataset to fill the datagrid.
I'm trying to insert, update and delete records in the datagrid.
Inserts and deletes are working fine, but the updates are failing and I
can't find out why. Looks strange to me because I'm using inserts, updates en
deletes in the same way.
My Code:
Sub GridSaveDatagrid()
Dim cmdUpdate, cmdInsert, cmdDelete As OleDbCommand
Dim MySql_Insert, MySql_Update, MySql_Delete As String
Try
mDbConn.Open()
'Deletes
MySql_Delete = "DELETE FROM Customers WHERE CustomerID =
@CustomerID"
cmdDelete = New OleDbCommand(MySql_Delete, mDbConn)
cmdDelete.CommandType = CommandType.Text
With cmdDelete.Parameters
.Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID")
End With
mDa1.DeleteCommand = cmdDelete
'Updates
MySql_Update = "UPDATE Customers " & _
"SET CompanyName = @CompanyName, ContactName
= @ContactName, " & _
" City = @City, PostalCode =
@PostalCode " & _
"WHERE CustomerID = @CustomerID"
cmdUpdate = New OleDbCommand(MySql_Update, mDbConn)
cmdUpdate.CommandType = CommandType.Text
With cmdUpdate.Parameters
.Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID")
.Add("@CompanyName", OleDb.OleDbType.VarChar, 40,
"CompanyName")
.Add("@ContactName", OleDb.OleDbType.VarChar, 30,
"ContactName")
.Add("@City", OleDb.OleDbType.VarChar, 15, "City")
.Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode")
End With
mDa1.UpdateCommand = cmdUpdate
'Inserts
MySql_Insert = "INSERT INTO Customers (CustomerID, CompanyName,
ContactName, City, PostalCode) " & _
"VALUES (@CustomerID, @CompanyName,
@ContactName, @City, @PostalCode)"
cmdInsert = New OleDbCommand(MySql_Insert, mDbConn)
cmdInsert.CommandType = CommandType.Text
With cmdInsert.Parameters
.Add("@CustomerID", OleDb.OleDbType.VarWChar, 5, "CustomerID")
.Add("@CompanyName", OleDb.OleDbType.VarChar, 40,
"CompanyName")
.Add("@ContactName", OleDb.OleDbType.VarChar, 30,
"ContactName")
.Add("@City", OleDb.OleDbType.VarChar, 15, "City")
.Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode")
End With
mDa1.InsertCommand = cmdInsert
'Update de Customer table.
Dim updTable As DataTable = mDs.Tables("Customer")
mDa1.Update(updTable.Select(Nothing, Nothing,
DataViewRowState.Deleted))
mDa1.Update(updTable.Select(Nothing, Nothing,
DataViewRowState.ModifiedCurrent))
mDa1.Update(updTable.Select(Nothing, Nothing,
DataViewRowState.Added))
Catch ex As Exception
Console.WriteLine(ex.Message)
Stop
Finally
If Not mDbConn Is Nothing Then mDbConn.Close()
End Try
End Sub Tag: Hiding child rows in a datagrid Tag: 127025
Data components design question
Hi all,
I'm new to .NET but have quite a long experience as OO developer. I've
been reading lots of documentation in order to get started with the SDK.
First I started with on-line documentation about ADO.NET and now I am
actually using the Microsoft Patterns and Practices document "Designing Data
Tier Components
and Passing Data Through Tiers" as a guide to develop my Data Access Logic
Components.
This document, as well as others, states that in a distributed anvironment
each DALC should manage the connection towards its own data store.
My questions are:
1) So, is it correct that such an approach invalidates the idea of a global
connection for the whole application (example: a single Connection class
instance that can be passed to each DALC constructor in the application)? Or
this is true just for distributed applications? Would it be better to use a
distributed oriented approach if I want to build a scalable, reusable
solution?
2) Should the DALC know everything about the data store type? I mean,
imagine I want to build a helper class for my DALC which would incapsulate
methods needed to provide the right type of objects (Sql/OracleCommand,
Sql/OracleDataAdapter and so on) to the DALC in order to accomplish a
multiple db platforms implementation? Then I should tell the DALC, at a
certain point in its lifecycle, (let's assume during its
creation/initialization => in its construcytor code) which type of data store
should be used (Sql Server, Oracle etc.).
In a traditional approach, this would usually be implemented as a property
read from the client application registry or something like that, and passed
to the the DALC constructor.
Now, if the DALC does manage the connection on its own who tells it which
data store type should be used? And how? Am I taking it wrong if I think to
read this option from a config file placed into the DALC phisical location?
Or, again, am I thinking it wrong as in a distributed environment a single
DALC "hides" its data store to all the callers and then it can be fixed at
complie time?
Hope I pointed out my doubts, and thanks in advance for any answers.
Cheers,
baba. Tag: Hiding child rows in a datagrid Tag: 127024
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
Chicks dig guitar players.
So get more chicks!
Learn how to play guitar!
http://www.ExpertHumor.com/LearnGuitar.htm
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 127023
<><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><>
That's Comedy - Over 460 Pages of Little Snickers,
Medium-Sized Chuckles, and Great Big Belly Laughs:
http://www.ExpertHumor.com/That'sComedy.htm
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 127022
AllowDBNull in DataTables
I use a data adapter to fill a DataTable (that contains no row or columns)
with data from a table in my SQL Server Express database.
The columns that the DataAdapter creates in my DataTable all have the
correct datatype but each is created so that AllowDBNull = True. However,
the table in the SSE Database has columns where NULLs are not allowed.
Any idea why this information isn't making it from teh database to the
DataTable?
Whats more, if I try and change the change the columns in the DataTable
myself after the Fill() method is called, setting AllowDBNull = True seems
to have no effect. Why would this be?
TIA Tag: Hiding child rows in a datagrid Tag: 127021
SqlDataReader Function From a VB6 refugee
All,
I'm trying to create a DataReader Function to call from within my class
to open a simple datareader.
I have thoroughly read the Data Access Patterns and practices and do not
believe in using canned code right off the bat. I want to rebuild the canned
code so I understand it, then I may use it or use my own understood version.
The error message is in Error Text: Message="Invalid attempt to Read when
reader is closed."
'===================== This is call to function ===================
Dim dr As SqlDataReader = Create_SQL_DataReader("20060213")
While dr.Read() !!! Errs here
End While
'===================== End call to function ===================
Shared Function Create_SQL_DataReader(ByVal sDate As String) As
SqlDataReader
Dim SQLConn As New SqlConnection(sConn)
Using SQLConn
' This Builds SQL String into "s" and uses passed in param
"sDate"
Dim s As String = BuildShiftSQL(sDate)
Dim Cmd = New SqlCommand(s, SQLConn)
SQLConn.Open()
Dim iDr As SqlDataReader = Cmd.ExecuteReader()
Return iDr
s = String.Empty
SQLConn.Close()
SQLConn.Dispose()
End Using
End Function
Error Text:
System.InvalidOperationException was unhandled
Message="Invalid attempt to Read when reader is closed."
Source="System.Data"
StackTrace:
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean
setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at WindowsApplication1.dataReaderDataSetForm.Main() in
C:\Data\VBExpress\Parts\Parts\Form1.vb:line 20
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[]
args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart() Tag: Hiding child rows in a datagrid Tag: 127015
ODP .net
Dear All,
i have establish a connection to Oracle 10g using ODP.net , i could
populate data in a listbox/combo box, but i need to display these data
in one by one , i mean navigation using
|< < > >| these buttons , plshelp me
blw is the code i'm using to populate data in combo/list box
-----------------------------------------
dbconnection.getConnection() ' connection string written in a module
calling her e
Dim conn As New OracleConnection(oradb)
Dim exp As Exception
Try
conn.Open()
Dim sql As String = "select EMPNO,ENAME,mgr from emp where
1 =1 "
Dim cmd As New OracleCommand(sql, conn)
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
TextBox1.Text = dr.Read()
MsgBox("1")
ListBox1.Items.Add(dr.Item(1))
conn.Close()
conn.Dispose()
Catch exp
MsgBox(exp.Message.ToString)
End Try
------------------------------------------------ Tag: Hiding child rows in a datagrid Tag: 127011
Problem in creating sql database in visual web developer 2005 express
Hi,
When I go to Add New item->Sql database-> click ADD i get the following
error.I also get the same error when i open the security page on web
site admininstration tool.
"There is a problem with your selected data store. This can be caused
by an invalid server name or credentials, or by insufficient
permission. It can also be caused by the role manager feature not being
enabled. Click the button below to be redirected to a page where you
can choose a new data store.
The following message may help in diagnosing the problem: An error
occurred during the execution of the SQL file 'InstallCommon.sql'. The
SQL error number is 1802 and the SqlException message is: CREATE
DATABASE failed. Some file names listed could not be created. Check
related errors. An unexpected error occurred while checking the sector
size for file 'U:\VISUAL STUDIO
2005\WEBSITES\APP9\APP_DATA\ASPNETDB_TMP.MDF'. Move the file to a local
NTFS volume, where the sector size can be retrieved. Check the SQL
Server error log for more information. Creating the
ASPNETDB_1e007377194340a4850801591429f1bc database"
Please help me--
Thanks Tag: Hiding child rows in a datagrid Tag: 127009
ObjectDataSource field binding to DataSet does not work
I built a dataset with 11 tables and their relationships using the data set
builder. I removed all the table adapters: the intention is to use the
Enterprise Library to load the data, and to do the updates. That side of
things works fine.
The plan is to use ObjectDataSource to bind web controls to the tables in
the data set. Unfortunately the data source does not show any of the fields
in the table I am returning.
The class I am linking to the data source has a bunch of parameter-less
methods to return each of the tables in the data set. These are strongly
typed, but the signature of my method is GetCompany(), returns DataTable, and
I specify it as the Select method. I have verified that the method is called
at run-time, but the details view does not appear, even with a manual bound
field.
How do I bind do a table in a dataset? Tag: Hiding child rows in a datagrid Tag: 127004
How to synchronise, grid and dataset update ???
Dear all,
I have a strange behaviour when updating a grid. I will try to explain
clearly:
I have a CustDataSet object fill with customer information like Name,
Firstname, Country, adress
That Custdataset contains all my customer information. Then I have a web
page on which my user can select only customers from a particular country.
For that i create a Dataview object from CustDataset. I set the RowFilter to
get only the desired country. Then I bind that DataView to my DataGrid.
If CustDataset contains information from that country, then they get
properly displayed in the grid.
At this stage, my user is able to edit records from that dataGrid bind to
DataView or Add a new entry.
For edition an Edit, Upadate template column has been added and in the
EditCommand event I have following code :
dgLabData.EditItemIndex = e.Item.ItemIndex
dgLabData.DataSource = dataView
dgLabData.DataBind()
Then my user gets text box field to update data directly from grid. When
pressing the Updade link, current records need to be update and store in
custDataset.
In the grid UpdateCommand I retrive cells value as follow:
newData(0) = CType(e.Item.Cells(1).Controls(0), TextBox).Text
newData(1) = CType(e.Item.Cells(2).Controls(0), TextBox).Text
newData(2) = CType(e.Item.Cells(3).Controls(0), TextBox).Text
dgLabData.EditItemIndex() = -1
dgLabData.DataSource = dataview
dgLabData.DataBind()
After this I did not get display any changes made, or new row added but
always the previous initial state.
How to synchrosise changes made in the dataGrid, dataview, dataset object in
order that it reflect changes when DataBind is called ??
I am lost, thnaks for your help
serge Tag: Hiding child rows in a datagrid Tag: 127003
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
You too can learn to be funny in just 7 days flat:
http://www.ExpertHumor.com/HowToBeFunny.htm
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 126999
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
Chicks dig guitar players.
So get more chicks!
Learn how to play guitar!
http://www.ExpertHumor.com/LearnGuitar.htm
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 126998
Amnesty for illegal immigrants will not happen this time.....................
Our politicians lead the league in all talk, no action.
Is blowing us some sunshine good enough?
Read what The Expert thinks:
http://www.ExpertHumor.com/
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 126997
Will illegal immigrants get deported?.........Of course not.....................
Our politicians just wanted to blow us some
sunshine. Get the details from The Expert:
http://www.ExpertHumor.com/
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 126995
Illegal Immigration, the Non-Issue of the Week??????????????
The way our politicians rushed to talk about
illegal immigration this week, maybe they thought it
came with a free lunch. They won't do anything about it,
but it will get them some money. The Expert provides
the details at:
http://www.ExpertHumor.com/
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Hiding child rows in a datagrid Tag: 126994
can't connect to sql server using ip number
My code:
Dim IP As String
IP = "192.168.0.169"
SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated
security=SSPI;Data Source=" & IP & ";persist security info=False;initial
catalog=adp1SQL"
The error occurs when I use the IP address instead "mshome". when
IP="MSHOME" the code runs smoothly.
while in the development stage, this project is only instaled in the PC
where MSDE 2000 is installed. Could this be the problem? Tag: Hiding child rows in a datagrid Tag: 126991
changing key field in Data Form Wizard form
I created a form using the Data From Wizard. It lets me change and
update all the fields except the primary key. When I modify the pk
textbox, it throws this exception:
"Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key constraints."
The row count on the form in incremented by 1 and everything is messed
up until I restart the application. Any ideas? Thanks. Tag: Hiding child rows in a datagrid Tag: 126988
IndexOutOfRangeException - Index was outside the bounds of the arr
We are encountering an extremely odd issue. We process incoming files for
customers and output text files to produce printed material. Then an XML file
containing the fields of the original file along with all fields necessary to
produce the output text files are saved as an XML file. If an individual's
printed material is destroyed in the process of fulfillment, we must
reproduce the output for them. We do this by reading the XML file back into a
dataset and re-outputting the text files. The XML file (and hence the
datatable in the dataset) have a LOT of fields/columns (some have over 1000).
We discovered that if a column is added to the datatable at the end of the
columns collection, AND is later referred to in a SELECT clause to return a
row collection, AND then large amounts of columns are removed and then added
back into the columns collection, the following error is thrown:
System.IndexOutOfRangeException - Index was outside the bounds of the array.
We also discovered that if we added the column referred to in the SELECT
clause at the BEGINNING of the columns collection (which was not easy) the
error did NOT occur. However, this is simply side-stepping the bigger issue.
I have sample code that will duplicate this behavior, but that and the XML
is too long to post. Is there some way to post this code and XML?
This is running on .NET 1.1 framework. Any light that could be shed on this
issue would be greatly appreciated.
Thank you. Tag: Hiding child rows in a datagrid Tag: 126986
Concurrency violation trying to update a table in SQL Server
I have an intermittent error where I get the following exception: "Error:
Concurrency violation: the UpdateCommand affected 0 records."
Here are the steps I follow:
Create SQLConnection
Set connection string of the connection.
Open connection
Create SQL Data Adapter with the connection and a simple select statement
including an indexed column
Create SqlCommandBuilder on this adapter
Fill DataTable with the Adapter
Loop through each datarow and based on contents of a field, possibly update
another field in the same row
Call If Not tbl.GetChanges Is Nothing Then adapter.Update(tbl)
This last step is where the error occurs.
I am the only user of the system so there are no concurrency issues. When I
tried to run profiler while executing, the problem went away and I no longer
seem to be able to reproduce this problem on that machine.
Any help would be appreciated.
Thanks in advance,
Boris Zakharin Tag: Hiding child rows in a datagrid Tag: 126985
How to loop through rows of strongly typed dataset table
In vb.net 1.1 I could do this:
Dim ds As dsEquip = GetDataset()
Dim dr As dsEquip.tbEquipRow
For Each dr In ds.tbEquip.Rows
'Do something
Next
now in c# 2.0 I'm trying to do the same thing like this:
dsEquip ds = oData.PersonGetRecShort();
foreach (dsEquip.tbEquipRow dr in (dsEquip.tbEquipRow)ds.tbEquip.Rows)
{
}
I get a compile error saying:
Error 1 Cannot convert type 'System.Data.DataRowCollection' to
'ClientDataLayer.dsEquip.tbEquipRow' F:\Data\Sample
Projects\WWF\myFormState\BusinessLayer\Persons_BLL.cs 53 63 BusinessLayer
Using c# 2.0, what's the correct way to loop through all the rows in
ds.tbEquip.Rows?
Thanks. Tag: Hiding child rows in a datagrid Tag: 126983
XML string to SqlDataReader for SQL Server 2005 CLR Stored Procedure
I need some help getting an xml string into a SqlDataReader and I am
stuck. (I admit I'm no guru at this stuff.) I can easily get it into
a DataSet object, but the SqlContext.Pipe.Send() method needs a
SqlDataReader object as a parameter. (I don't want to send it as an
XML string.) Here is my method so far...any clues and code samples
would be greatly appreciated...I'm a visual learner. =)
[Microsoft.SqlServer.Server.SqlProcedure]
public static void GetAPList2()
{
// allow https access
System.Net.ServicePointManager.CertificatePolicy = new
AirWave.TrustAllCertificatePolicy();
string webURL =
"https://webservice.somesite.com/ap_list.xml?id=47";
CredentialCache sec = new CredentialCache();
sec.Add(new Uri(webURL), "Basic", new
NetworkCredential("*****", "*****"));
WebClient client = new WebClient();
client.Credentials = sec;
string pageHTML =
Encoding.UTF8.GetString(client.DownloadData(webURL));
Byte[] pageData = client.DownloadData(webURL);
string pageHtml = Encoding.ASCII.GetString(pageData);
DataSet xmlDS = new DataSet();
XmlTextReader rdr = new XmlTextReader(pageHTML,
XmlNodeType.Document, null);
xmlDS.ReadXml(rdr);
SqlDataReader dr = /* STUCK HERE!???? */
SqlContext.Pipe.Send(dr);
} Tag: Hiding child rows in a datagrid Tag: 126982
How can I determinate if the Database exist before detach it?
I use the code below to detach a Database, but if the database does not
exist, it will thow exception.
How can I determinate if the Database exist before detach it?
***********************************************************************
string sConnection = "Data Source=......";
string sCmdDetach="sp_detach_db 'Health'";
SqlConnection cnn = new SqlConnection(sConnection);
cnn.Open();
SqlCommand cmd= new SqlCommand(sCmdDetach, cnn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cnn.Close();
} Tag: Hiding child rows in a datagrid Tag: 126980
How could you explain this?
Hello
I've experienced a very low speed filling DataSet in program running on
PocketPC and connected to SQL Server via Wireles Lan. I used
SqlDataAdapter. Table basically consists of text fields of type
nvarchar and has about 6000 rows. It takes about 5 minutes to fill
DataSet using SqlDataAdapter.Fill.
Then I wrote a stored procedure which created a temporary table
inserting there fields from the initial table and converting them from
nvarchar to varchar.
And now from resultset of this procedure SqlDataAdapter fills DataSet
8-9 times faster!
I've expected 2 times increase in better case.
Why is there such increase of speed? Maybe because SqlDataAdapter or
DataSet makes something like a re-encoding when filling and there is a
way to avoid this not converting nvarchar to varchar? Tag: Hiding child rows in a datagrid Tag: 126974
Trouble entering empty date into Access table from ASP.NET app using ADO.NET
Hi,
I have an ASP.NET app that uses ADO.NET for data access. I have a form
that allows a user to enter a date. This date field is not required
however. If they don't enter it, I shove a variable declared of type
System.DateTime that is initialized to null into the database. It
works but if you open the table in Access, the date field contains
12:00 AM. When this value is rendered in an Access form, it shows as
12/30/1899.
What can I do to basically insert null/nothing into that field?
I'm using the System.Data.OleDb library and a parameterized query to
insert this date data into the Access table.
I tried checking for an empty date and substituted the date parameter
value with DBNull.Value but that doesn't seem to remedy the situation.
Thanks for the help,
Josh Blair
Evergreen, CO Tag: Hiding child rows in a datagrid Tag: 126972
Why won't Dataset reflect changes?
I have a single page application that uses Web Service to fill a dataset
decending. When I add a new record to the database and re-fill dataset it
won't reflect the first record added until after I've added a second one.
Like wise the second record added won't show in dataset until a third is
added.
I've read 44 pages of this forum and tried about every solution to dataset
updating that I found. DataAdapter.Update, dsxxxx.AcceptChanges, totally
killing the dataset and recreating and still I get this same effect. I do
not use any caching or states on this page.
To check if it was the Web Service I added a direct sqlDataAdapter to the
page along with another dataset and these 2 preformed exactly the same as Web
Service supplied dataset.
I know the record is being written as I can time stamp the page post-back
and look at the SQL table and times are same down the 10ths of a second. I'm
using VS2003 with SQL2005 with C# coding.
Any idea's I would be willing to try.
Thanx Tag: Hiding child rows in a datagrid Tag: 126971
Nesting ambient transactions.. doable?
im trying to put a transaction around my NUnit tests fixtures and a seperate
transaction around each test and I'm trying to do that in my base class so
that all my test can benefit from them.
The problem is that I can't find a way to do both transactions. it's either
around the whole fixture or around the test. is there a way to do both?
here is my base test class:
using System;
using System.Transactions;
using NUnit.Framework;
namespace Library.Tests
{
public enum TestTransactionMode
{
None,
AroundFixture,
AroundTests
}
[TestFixture]
public abstract class BaseFixtureWithTxRollback : BaseFixture
{
Transaction fixtureTransaction;
Transaction testTransaction;
private TestTransactionMode testTransactionMode =
TestTransactionMode.AroundFixture;
/// <summary>
/// The transaction mode of the test
/// </summary>
public TestTransactionMode TestTransactionMode
{
get { return testTransactionMode; }
set { testTransactionMode = value; }
}
[TestFixtureSetUp]
public override void TestFixtureSetUp()
{
base.TestFixtureSetUp();
if (testTransactionMode == TestTransactionMode.AroundFixture)
{
fixtureTransaction = new CommittableTransaction();
Transaction.Current = fixtureTransaction;
}
}
[TestFixtureTearDown]
public override void TestFixtureTearDown()
{
if (fixtureTransaction != null)
{
fixtureTransaction.Rollback();
}
}
[SetUp]
public override void TestSetUp()
{
base.TestSetUp();
if (testTransactionMode == TestTransactionMode.AroundTests)
{
testTransaction = new CommittableTransaction();
Transaction.Current = testTransaction;
}
}
[TearDown]
public override void TestTearDown()
{
base.TestTearDown();
if (testTransaction != null)
{
testTransaction.Rollback();
}
}
}
}
So basically i want to have another
TestTransactionMode.AroundTestAndFixture. I found SubordinateTransaction
class which takes ISimpleTransactionSuperior in its constructor but there is
no implementation for this interface. Tag: Hiding child rows in a datagrid Tag: 126960
How can i write an object to db?
I get an e-mail in C# I want to store this e-mail item in SQL Server 2005. I
don't have any hardcopy of this mail item. I only have a programmatic C#
object, and i wish to insert it into a varbinary field. How can i convert
this object to a suitable form to insert to db? Tag: Hiding child rows in a datagrid Tag: 126953
Join two Datatables
I have two datatables in a dataset with a relation defined.
How do I generate a JOINed view of this data?
Thanks,
MS Tag: Hiding child rows in a datagrid Tag: 126949
Empty Parameter
Hello,
I have sql command like: "Select... Where myColumn = @myParameter"
Now, I can simply add parameter to the collection and filter data.
What if I want to return not filtered data, I mean to skip, avoid
executing this "myColumn = @myParameter"?!
Is this possible, or I have to change select command every time I don't
want filtered data? Tag: Hiding child rows in a datagrid Tag: 126945
Update Database records ??
Dear all,
I have a dataset object which as been filled from an SQL server table
I have then a dataview from that dataset,which is bind to a datagrid object.
My user can edit, update, delete entry directly from that datagrid through
an ASP page.
Is there a simple way to automatically handle a database object based on the
rowstate of the datagid ?
What I mean is that :
- if my user add an entry I should run a proper INSERT querry
- if my user Update an entry I should run a proper UPDATE querry
- if my user add an entry I should run a proper DELETE querry
Is there any self intelligent function which is able to read the status of
Rows and execute proper statement.
I could also use the GetChange function to build a new dataset and then
handle th select ..
Any tips
thnaks for your help
regards
serge Tag: Hiding child rows in a datagrid Tag: 126943
Is there a way i can debug through the Sql script in my SqlDataSource ....
Hello,
I'm very excited about the new SqlDataSource in asp.net 2.0.
I have written a wuite long sql script on my SqlDatasource UpdateCommand.
I want to see wheater it actually does what it was meant to do.
Is there any way i can do this?
Many thanks
JJ Tag: Hiding child rows in a datagrid Tag: 126937
Connecting to SQL 2005 Express over a network share
Hello,
To my amazement I cannot connect to a SQL 2005 Express over a network share.
Now reading through the newsgroups I can understand why this can be a
problem BUT...
HOW does one go about having two PCs read/write data to a centralized SQL
2005 Express Database?
Any help would be GREAT!
Phil Tag: Hiding child rows in a datagrid Tag: 126934
Threads and Transaction Problems....
After four long hours of googling on the subject and finding almost
nothing, I'm forced to post this one.
I'm doing a small project that reads several IIS and stores in a
database the domains hosted there.
This application runs quite fine. But I'd like to add some transaction
control on it, because it might ab-end at any given time (so far it
didn't, but I think it's sheer dumb luck :-)
Stripped out of anything meaningful code, my approach to create the
transaction is:
---- BEGIN pseudoCode ----
Imports System.Threading
Private ThreadCount As Integer = 0
Sub Main()
For Each s as Server In Farm
Interlocked.Increment(ThreadCount)
Do While Not ThreadPool.QueueUserWorkItem(AddressOf
WorkerThreadForServer, s)
Thread.Sleep(100)
Loop
Next
Do While (ThreadCount <> 0)
Thread.Sleep(100)
Loop
End Sub
Sub WorkerThreadForServer(s as object)
Dim dbConn as SqlConnection
Dim dbTrans as SqlTransaction
Try
dbConn = new SqlConnection
dbConn.QueryString = QUERYSTRING
dbConn.Open()
dbTrans = dbConn.BeginTransaction()
For Each w as WebServer in s
InsertDataInDB()
Next
dbTrans.Commit()
Catch(ex as Exception)
dbTrans.Rollback()
Finally
dbConn.Close()
End Try
Interlocked.Decrement(ThreadCount)
End Sub
---- END pseudoCode ----
As far as I could gather on the net the above code SHOULD work fine,
but it stumbles on the transactions. If I remove the transactions the
code works fine, smoothly even.
During the process of inserting the data on the server I dump some
information on the screen and in a log file.
When there's no transaction I see information being dumped from all
servers at once, when the transactions are active, however, I see
information of only one server and then it throws an TimeOutException
while including the info.
I've checked, rechecked and triple-checked the code and I can't see
anything wrong.
Can anyone help me?
Regards,
PJ
http://pjondevelopment.50webs.com Tag: Hiding child rows in a datagrid Tag: 126928
Create XLS file from Query? (VB, OLEDB, ADO.NET 2.0)
I need to create new Excel 2003 XLS files containing a single worksheet that
has the results of a database query (a combination of text, integer, and
date columns). Can someone please point me to an example of how to do this
in a VB2005/ADO.NET 2.0 Winforms app, *WITHOUT* using Interop (Office will
*not* be installed on the machine generating the file). Thanks! Tag: Hiding child rows in a datagrid Tag: 126927
Hi,
Is there any way of hiding child tables/rows in a windows form
datagrid. I'm using Vb.net and Visual Studio 2003.
Set the grid datasource to a dataview or directly to a datatable contained
in a dataset.
"al" <alan_o_reilly@yahoo.ie> wrote in message
news:1143983590.038918.201200@i40g2000cwc.googlegroups.com...
> Hi,
>
> Is there any way of hiding child tables/rows in a windows form
> datagrid. I'm using Vb.net and Visual Studio 2003.
>
> thanks in advance
>
> alan
>
Thanks for the quick reply. Unfortunately that hasnt done it either. I
set the datasource of my datagrid to a datatable contained within the
dataset.
On loading data, I still get the plus(expand) symbol and I get can
click on the relationships between the tables and display data from the
related table in the same datagrid.
I think its a pretty useful thing but I dont want to confuse the
technology shy end user!
I havent used Dataviews (pretty new to vb.net) but maybe that will
work.