| 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 week: 1 2 3 4 5 copying an object by value Posted by Hemang Shah at 4/7/2007 4:06:58 PM I think what i'm trying to do is passing by value.
Here is the scenario:
Main Form - which calls a Search form.
- I pass Mainform as a reference so that I can pass data between the two.
Code:
public frmSearch(Form1 f)
{
InitializeComponent();
frmMain = new Form1();
frmMain = ...more >>
No component code in the form class Posted by Hemang Shah at 4/7/2007 2:00:32 PM I'm creating a new form in visual studio 2005
I'm adding a component to it and when I go inside the form's code, there is
no code for that component
Is that feature changed ?
Where is the code now.
...more >>
Concurrency Problem: Two separate dynamic SQL queries. Posted by Jim Light at 4/7/2007 1:45:03 PM How could I resolve the following concurreny problem, assuming that
this procedure is not written as one stored procedure in T-SQL, but as
two separate, dynamic SQL queries.
QUERY 1: Check if username is already taken, return value to signify
if taken or not.
If username if not...more >>
ADO.NET Abstraction Layer: Basic SQL building blocks? Posted by Jim Light at 4/7/2007 12:26:22 PM Hi,
I'm in the process of creating a light-weight object abstraction layer
(not an ORM) over ADO.NET, to encapsulate the most commonly used SQL
queries (as an exercise). Classes are as follows: Sum.cs, Insert.cs,
Count.cs,... etc.
While these classes don't create a direct object mapping to ...more >>
Editing XSD files Posted by Ant at 4/5/2007 8:14:00 PM Hi,
I am working on an ASP app. that uses Crystal reports. I need to edit the
report but the data is exposed by xsd files. I tried to manually alter the
xsd files but this of course didn't work (I guess the Data adapter &
Datatables in the app would need to be changed accordingly).
I don...more >>
Multiple relation in dataset. Posted by zb at 4/5/2007 5:27:50 PM Requirement:
Number of comma separated *files* (CSV) all related to each other have
to be read in such a way that they could easily be read to find
related data.
My idea:
Write a class with a method to add files which would be read split at
each new line and comma and then add to a seperate ...more >>
Increase Connection\ Command timeout globally Posted by sameer at 4/5/2007 7:02:00 AM environment : .net framework 1.1, ado.net, visual studio 2003, vb, sqlsever
2000, winforms, webforms
I want to increase the connection and command time out for all stored procs
in the application which might be around 200 or more and this woudl take me
forever if i do it indivisually, is th...more >>
Adding a non unique index to a datatable Posted by mudGil at 4/5/2007 2:28:01 AM I have a large datatable in a typed dataset, on which I run the select method
with three different filters. I'm looking for a way to have three NON UNIQUE
indexes so that the select method is much more eficient. The dataset
designer only lets me add unique indexes (or am I missing something?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dataadapter and where clause. Posted by Shum at 4/5/2007 1:49:39 AM Hi!
I want to restrict the selected records with a WHERE clause in
dataadapter... but when i do that no rows are retrieved... Any
alternatives?? Any suggestions? (using sql server 2005 and c#)
..
..
..
..
while (drr.Read())
{
hosp=System.Convert.ToString(drr["HospitalName"]);
...more >>
Connection string / design question Posted by Jens Weiermann at 4/4/2007 3:30:45 PM Hi,
I have a question regarding the handling of connection strings.
I have (finally) written a data access assembly that does all the reading /
writing from/to the database. Basically, this is a Dataset.xsd type thingie
with all the table adapters and stuff.
Now I want to use this data a...more >>
How to Create a Database When User does not have Permission Posted by Scott at 4/4/2007 1:34:03 PM This question is related to SQL Server Express SP2.
When the four gig limit of an SQL Express database is approached it is
desired to have another database created at run time with no user interaction.
The problem is that the user running the application may not have
permissions to create a ...more >>
Yet another designer issue Posted by SAL at 4/4/2007 12:24:21 PM Bill,
Thanks for helping with my last designer issue. Now, I execute the following
query in the Query Builder and it returns one record:
SELECT
ReportedWeeds.RID, Weeds.Name, ReportedWeeds.Density, BioAgents.BName,
ReportedWeeds.Assr_SN, ReportedWeeds.TownRange, ReportedWeeds.LotSize, ...more >>
Can anyone help with Data Designer issue? Posted by SAL at 4/4/2007 11:13:00 AM Hello,
Using the designer in my project, I created a DataTable for one of the
tables in an Access database. I created a TableAdapter for that DataTable by
adding queries. For the most part, the queries are executing correctly but
this one does not return any rows. If I past the sql into the Acce...more >>
adding a column to a table Posted by David Thielen at 4/4/2007 9:46:00 AM Hi;
Is there a way to add a column to a table, preferably not at the end, via
ADO.NET? And hopefully in a vendor independent way as I have to do this for
Sql Server, Oracle, DB2, and MySql.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http...more >>
Performance problems with OracleDataReader Posted by Henning Fiese at 4/4/2007 6:56:30 AM Hello NG,
I'm using the Oracle Data Access Components and I've encountered
serious performance problems with the OracleDataReader. The following
function fills the memberfields of an object with the content of a
reader:
internal void FillFromReader(IDataReader Reader)
{
m_id = (int)Rea...more >>
ADO.NET 2.0 - Binding a Second Form to the Same Data Source Posted by Brice at 4/4/2007 6:14:24 AM >From David Sceppa's "Programming MS ADO.NET 2.0", Chapter 13, Step 9,
He is binding a second form to a Binding Source that is being passed
as a parameter. However, he is performing all Data Bindings for the
second form, manually in code. Is there an easier way?
For example, I have created a...more >>
One sheet workbook, two TABLEs in schema Posted by Grinning Crow at 4/4/2007 3:48:03 AM I'm using
GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing,
Nothing, Nothing, Nothing})
to get the names of the worksheets of my oledbconnection to excel 2003. In
some of the workbooks, there is only one worksheet, say Sheet1, yet it the
schema datatable, there ar...more >>
Question about the ADO.NET Oracle Provider Posted by fabien.molinet NO[at]SPAM gmail.com at 4/4/2007 2:34:31 AM Hi,
I have a question about the Microsoft ADO.Net Oracle Provider
Sometimes (only sometimes) I get exceptions like these :
-------------------------
Invalid operation. The connection is closed. : at
System.Data.OracleClient.OracleCommand.GetStatementHandle()
at
System.Data.OracleClien...more >>
ADO.net 2.0 and XML web service Posted by Peter at 4/3/2007 6:36:03 PM What is the relationship between ADO.net 2.0 and XML web service? Does it
make sense to create a desktop application using ADO.net 2.0 and then enhance
it later with web interface using technology like xml web service? ...more >>
Multiple thread access to a single tableadapter Posted by foolmelon NO[at]SPAM hotmail.com at 4/3/2007 3:38:24 PM Say if I have a single myTableAdapter instance has a myUpdate()
function accessed by 2 threads, is it possible to have folloiwng
seneriao?
1. Thread 1 calls myTableAdapter.myUpdate(), it checks whether the
connection of the table adapter is open. If not, it opens the
connection and call upd...more >>
SQL Stored Proc's Posted by AMDRIT at 4/3/2007 10:55:19 AM couldn't find a group just for SQL Server. Anyone know if it is possible
to retrieve the name of the stored procedure that is currently executing?
What I would like to do is record usage in a table everytime a stored proc
is executed.
create procedure blahblah
as
--Update Usage ...more >>
Connection string question Posted by Tony Girgenti at 4/3/2007 9:58:11 AM Hello.
Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0, SQL Server
Express on XP Pro,
SP2.
In my web.config file, if my connection string looks like this:
"connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and
Settings\Administrator\My Docum...more >>
3rd Repost - Issue in Importing Excel spreadsheet into dataset Posted by dinoo at 4/3/2007 9:52:15 AM I am sorry but I am reporsting this because It was little urgent.
I need some one to help me out here to understand the problem.
I am trying to read an excel sheet and I am using the following connection
string-
"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel
8.0;HDR=YES;IMEX=1...more >>
Rowchanging exception don't propagate (ado.net 2) Posted by francesco.fantoni NO[at]SPAM libero.it at 4/3/2007 6:29:08 AM if i throw an exception in datatable rowchanging (using strongly typed
dataset) this exception don't propagate in debug mode (at runtime it
seems work instead)
in details, im using vs2005 with sqlserver 2005 express and i have a
strongly typed dataset with customer datatable and a form with
b...more >>
Post Revised: A Desperate Plea for Help Posted by billmcintee:VB NOOBIE at 4/2/2007 9:12:03 AM Can anyone give me a thorough explanation on how to use my data adapters to
insert new records into a SQL database that I have connected to my app. I am
very new to SQL and a little familiar with VB. The purpose of the app is to
be a front-end to populate fields in a SQL table with information...more >>
C# Delete Problem Posted by Chris at 4/2/2007 6:42:03 AM Using Datagridview databound:
If I add two rows with data, save (using navigator), refesh that dataset,
then delete the two newly added rows, then Save, everythign is OK.
if I add two rows with data, save (using navigator), then delete those two
rows, then save (using navigator), I get a...more >>
A desperate plea for help.... Posted by billmcintee:VB NOOBIE at 4/2/2007 1:14:04 AM Hello,
Currently, I am a spring chicken in VB and I am writing a program concerning
vb.net 2003 and SQL Server 2005. This program is basically a data collection
app in which collects data from a wedge scanner via barcodes. I have two
questions concerning this program.
1. I have created t...more >>
Is there ever a reason to have a transaction around a select... Posted by David Thielen at 4/1/2007 12:28:02 AM 1) that will always return 0 or 1 rows?
2) that will retun N rows?
In each case where the results will be displayed to the user and so there
can be changes that occur to the DB after the select completes.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cub...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |