| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Can 2 different projects in the same solution share the same strongly typed dataset Posted by moondaddy at 4/29/2004 10:19:36 PM I have 2 projects in the same solution that have a common strongly typed
dataset which they both use. Can they share it so that one project can pass
the dataset and it's data to the other project where the 2nd project can use
the methods and properties of this strongly typed dataset?
somethin...more >>
Making ADODB More Bulletproof and Connection Timeout Posted by Chuck Cobb at 4/29/2004 5:53:10 PM I'm trying to make my code more "bulletproof"...I have a user who is using a
wireless LAN network connection that is very unreliable and it has caused
some problems. For example, sometimes when they have a very bad network
connection the ADODB connection can hang the application. I want to make...more >>
Working with many to many data Posted by Brian Henry at 4/29/2004 5:50:49 PM Before i explain this because of a strange situation we're haveing with data
we import from a 3rd party this Many to many relationship has to exist, so
it can not be replaced.
With that said, we have two tables, with a junction table in the middle (a
many to a many relationship) these names ar...more >>
Connection to database- how? Posted by Ian at 4/29/2004 5:47:28 PM Hi there,
I have just started learning c# and I have stored my connection string in
the web.config which I can read in my main program.
My question really is, should I open the database on every single page and
also close it too?
I presume I open it on Page Load but where should I close i...more >>
multiuser database with c#? Posted by Ian at 4/29/2004 5:44:47 PM Hi there,
I wonder if anyone can offer some help
I have the task of creating a multiuser database that will be access by 10
different IE sessions (i.e. 10 different machines).
It is basically a stock program, i have come from the background of a VB
application programming but now trying t...more >>
FOR XML AUTO, ELEMENTS Posted by Brett Robichaud at 4/29/2004 5:43:53 PM I am trying to get data as XML from my SQL 2k server.
My select statement is:
SELECT TOP 10 * FROM IMAGE FOR XML AUTO, ELEMENTS
I then use this code to wrtie it to a file:
XmlWriter w = new XmlTextWriter(@"foo.xml", Encoding.UTF8);
w.WriteStartDocument();
w.WriteStartElement("Test");
rd...more >>
ExecuteXmlReader() Posted by Brett Robichaud at 4/29/2004 4:46:57 PM Is there no way to have the returned XmlReader automagically close the
SqlConnection when I call Close() on the XmlReader? I am used to
SqlDataReader where this works nicely.
My data layer currently abstracts out the SqlConnection object so the caller
knows nothing of it. If I add support fo...more >>
Output Parameter always 0 when used with a dataadapter Posted by Tommy at 4/29/2004 4:46:01 PM I have a stored procedure that has an output parameter defined as output and
it is definately being set in the proc. I even went as far as hard coding a
value in the bottom of the proc to be sure it had something other than 0. If
I run it in Sybase central (sybase's version of Query Analyzer) it ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Object Relational Mapping Posted by Noel H at 4/29/2004 3:47:07 PM Hi all,
Just a question. Anyone know a good ORM tool? Would like to hear
recomendations. I've found one that I'm pretty keen on Evaluant
(http://www.evaluant.com/en/default.aspx)
Any news on Object Spaces? Would really be grateful if anyone if this will
still be ship with .NET2.
Thanks,
...more >>
Could not find installable ISAM. Posted by Brent at 4/29/2004 3:30:38 PM Hi, my asp.net c# app is trying to connect to an Access database with a
password and am I getting the error.. Could not find installable ISAM. . If
I connect to one without a password it works fine. I've looked at Q209805
but I don't think that helped. Oledb connection. Here is the one that works...more >>
TABLE NAME AS A VARIABLE IN SQL Posted by Gina L. Hernandez at 4/29/2004 3:29:37 PM
Could somebody tell me what is the syntax for reading the name of a tabla
from a variable??. For example
declare @tabla varchar(10)
set @tabla = 'prompts'
select *
from @tabla
Thanks
...more >>
Connection box in ADO.NET Posted by Learning at 4/29/2004 2:31:04 PM Hi there
ODBC as well as ADO have connection boxes that allow to set up connection strings (pick providers or ODBC drivers etc.). Is there something that is equivalent for ADO.NET. Does ADO.NET still use OLE DB providers or is there something different with the .NET providers and therefore a diffe...more >>
Updating database record Posted by William Gower at 4/29/2004 2:04:01 PM I am new to ADO.NET and have a question about updating
da.Fill(rsUser, "Users")
Dim tbl As DataTable = rsUser.Tables(0)
Dim Row As DataRow = rsUser.Tables(0).NewRow
Row("Name") = FullName.Text
....
....
....
....
rsUser.Tables("Users").Rows.Add(Row)
What's next to update the dataAd...more >>
Cannot serialize transaction Posted by Kettle NO[at]SPAM bigpond.net.au at 4/29/2004 1:25:30 PM I am using manual transaction control with the Ingres ODBC data
provider for .NET. I have simulated a bank transfer example and found
that, despite setting the isolation level of the transaction to
serializable, the result of running the transfer concurrently is >not<
serialized.
I intend to...more >>
HtmlInput "Security" Issue? Posted by Sean Patterson at 4/29/2004 11:25:14 AM Greets all,
I have a simple CSV parsing .NET web app where the user uploads the file
and the web app does the magic. I have been able to get it to run on my
personl workstation and our sanbox, but as soon as I move it to the
pre-production server, I am getting a really weird exception being th...more >>
Dual Combo box binding problem (relation involved) Posted by Brian Henry at 4/29/2004 10:52:37 AM Here's an example of the code.. I have two combo boxes on screen that when
one's selection is change the other's items will be updated to reflect the
change (based on a relation)
Private ds_formData As New DataSet
'
' Fill Line Of Business
'
cmd_selectCommand.CommandText = "BENESP_GetLinesO...more >>
Question: Data Application Blocks - work with MS Access? Posted by VB Programmer at 4/29/2004 10:45:13 AM Do DAB work with MS Access? Any online examples?
If not, any online examples of ADO.NET with Access?
Thanks!
...more >>
Reset to Null a parameter in an SQLCommand Posted by sburns NO[at]SPAM advhomecare.org at 4/29/2004 10:21:11 AM Help
I have a command that executes a stored procedure. The same command is executed thousands of times. Prior to each execution of the command, the parameters need to be reinitialized to null and then repopulated with new values. I've tried the following command
cmSql.parameters(3).value =...more >>
SQL Server and Primary Key Posted by scorpion53061 at 4/29/2004 9:10:03 AM I am attemtping to add a record to SQL Server.
I am trying to find an example of how to increment the primary key value
like we do in Access.
Can anyone point me to an example?
I tried the code from Access and it writes the first record as -1 and then
complains about distinct errors.
T...more >>
VB + MySQL Posted by Stefan Richter at 4/29/2004 8:41:32 AM Hi, I am trying to access a MySQL Database using VB,
with / or without ODBC, whatever is easier...
Any ideas?
Stefan
...more >>
SqlCommandBuilder Posted by h01magha NO[at]SPAM du.se at 4/29/2004 6:11:03 AM Hi
I have a DataGrid that represents an whole databasetable. I fill the
grid with a DataSet, see below.
I wonder if it is possible to turn off the possibility to run Insert
commands for SqlCommandBuilder object when the GetUpdateCommand() is
run?
I dont want the user to be able to add ro...more >>
ADO.Net DataSets and constraints error Posted by n.danson NO[at]SPAM lbs-ltd.com at 4/29/2004 5:21:40 AM I have a database table TBLCOMPANYCONTACTS :
CREATE TABLE RELMAN.TBLCOMPANYCONTACTS (
COMPANY_CODE VARCHAR2(10) NOT NULL,
CONTACT_IDX NUMBER(3) NOT NULL,
TITLE VARCHAR2(4) NULL,
FIRSTNAME VARCHAR2(50) NULL,
LASTNAME VARCHAR2(50) NULL,
POSITION VARCHAR2(50) NULL,
TELNO VARCHAR2(50) N...more >>
populate listbox based on user credentials Posted by victor NO[at]SPAM vanhillo.net at 4/29/2004 1:32:13 AM Hello there,
I have a problem but i don't know how to solve it. I have a Login page
where i use Form based authentication and i use sql server. When the
user is logged in he is redirected to the correct page. I have users
that work in different shops. I want to populate datagrids, listboxex
e...more >>
Updating dataview in VB.net datagrid Posted by gauravdell NO[at]SPAM yahoo.co.in at 4/29/2004 12:31:48 AM Hi,
i have just started working on VB.net and got stuck on the following:
1) i have created a view in Sql Server 2000 using 2 tables and both of
them doesnt have primary keys but i have used inner join on the 1
column in common and those tables , i am confused if i update the data
in datagr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |