Chat
Topic : ADO.NET Best Practices Chat Expert : Akila(MVP) and Jignesh Desai(.NET Consultant
and Trainer)
December
01, 2004
Subhashini
(Moderator): Hi all , welcome to the chat. the chat
starts at 5.00 pm IST
Subhashini (Moderator): Thanks Manish Subhashini (Moderator):
how can I help you sudha?
Subhashini (Moderator): absolutely , will put up all
these details at the beginning of the chat
Subhashini (Moderator): you can get all the chat session
details at http://www.microsoft.com/india/communities/chat/default.aspx
Bookmark this url. Subhashini (Moderator):
Hi all. A very good evening J Welcome to today’s Webchat on
ADO.NET Best Practices. I am Subhashini Simha (Community Co-ordinator,
MS India).Today’s chat is hosted by Akila Manian (MVP) and Jignesh
Desai (.NET Consultant and Trainer) Subhashini (Moderator):
Let me introduce them Subhashini (Moderator):
Akila, Founder Director of Akna Infotech Pvt. Ltd, has been instrumental
in pioneering and guiding the vision of Akna Infotech. Under her astute
guidance and unswerving focus, the organization serves multitudes
of platforms encompassing corporate training, architectural consulting
and solution development. We intend to expand and deliver intelligent
solutions globally, to fulfill the expectations of our esteemed clients.
With an experience of 8 years in the IT Developer Training Industry,
she has been uniquely gifted with the ability to effectively communicate
complex technical jargons in user-friendly language. This ability
has made a success out of her and has received repeat calls to impart
trainings in C, C++, MFC, ATL COM, Core JAVA and .NET to various companies
like Infosys, Accenture, Satyam, HCL, Mastek, Tektronix, TCG, and
Microsoft partners. You can reach her at akila@aknainfotech.com Subhashini (Moderator):
Jignesh, an active Member at MUG has an experience of about 9 years
IT Developer and Training Industry. He has been working with .NET
ever since its beta releases. He has a sound knowledge of architecting,
designing and developing applications using NET framework. His website
www.dotnetjini.com provides many articles, tutorials and sourcecode
on MS technologies and others. You can reach him at jignesh_desai@hotmail.com
<mailto:jignesh_desai@hotmail.com>
Subhashini (Moderator):
Chat Procedures:This chat will last for one hour. During this hour,
our Experts will respond to as many questions as they can. Please
understand that there may be some questions we cannot respond to due
to lack of information or because the information is not yet public.
We encourage you to submit questions for our Experts. We ask that
you stay on topic for the duration of the chat. This helps the Guests
and Experts follow the conversation more easily. We invite you to
ask off topic questions after this chat is over. Subhashini (Moderator): Chat Details and Agenda:ADO.NET
Best Practices Discussion on ADO.NET:The
chat will include a briefing on ADO.NET Best Practices with Connection,
DataReader, DataAdaptor and Dataset. Subhashini (Moderator):
The first 30 mins would be a brief by Jignesh and Akila on the topic Subhashini (Moderator):
WE welcome all q's during the next 30 mins Subhashini (Moderator):
And we are very glad to see such a good response and hope you all
enjoy the session Subhashini
(Moderator): Let’s welcome Jignesh and Akila
. Subhashini (Moderator):
Q: typed datasets are those which you drag from toolbox
A: Hemant (Q) typed datasets are those which you drag from toolbox Subhashini (Moderator):
Hemant (Q )How to configure pools? Subhashini
(Moderator): Perumal (Q) connection pooling ? Subhashini (Moderator):
hashims(Q) is it better design our qown Data Access Layer or better
to use Application block for Data Access Subhashini
(Moderator): Jignesh please make a note of the questions
am posting Subhashini (Moderator):
Hashims(Q)is it better design our own Data Access Layer or better
to use Application block for Data Access Subhashini
(Moderator): ysr(Q) can u show.. how to do this using
registry.. Subhashini (Moderator):
Balakrishna(Q)How do we grant access rights through deployment Subhashini (Moderator):
Note : Hi all Please don't use the submit question button to post
questions. Please post them directly . Subhashini
(Moderator): tarun (Q)What are the objects in ADO.
Net Subhashini (Moderator):
please go ahead and shoot your questions . Note : Please don't use
the submit question button to post questions. Please post them directly
Subhashini (Moderator):
varanasi(Q): Hi I want my dataset to remember its data even after
postbacks in an asp.net webform? And finally after clicking save I
want to save the changes and insertions to database. what are the
ways to do this ? Subhashini (Moderator):
The chat will continue till 6.20 pm IST by demand . So please go ahead
and ask your questions. You can also mail jignesh and akila at akila@aknainfotech.com
and jignesh_desai@hotmail.com Subhashini (Moderator):
varanasi: Hi I want my dataset to remember its data even after postbacks
in an asp.net webform? And finally after clicking save I want to save
the changes and insertions to database. what are the ways to do this
? Subhashini (Moderator):
Hi all, We have 5 mins left for the chat to conclude .You can also
mail jignesh and akila at akila@aknainfotech.com
and jignesh_desai@hotmail.com Subhashini (Moderator):
The chat transcript will be available after 24 hours at http://www.microsoft.com/india/communities/chat/default.aspx Subhashini (Moderator):
Thanks Jignesh and Akila Subhashini
(Moderator): hope the chat was informative and useful Subhashini (Moderator):
The next Webchat is scheduled on Dec 8'th on MS Word Object Model Subhashini (Moderator):
Thank you all for taking out time to attend this chat Subhashini
(Moderator): If you have any suggestions Subhashini
(Moderator): on chat topics or would like to host
a Webchat Subhashini (Moderator):
please write to me at commind@microsoft.co Subhashini (Moderator):
If you would like to lead the web chat in future, nominate yourself
as an expert at: http://www.microsoft.com/india/communities/chat/register.aspx> Subhashini (Moderator):
You can find all the future web chats on http://www.microsoft.com/india/communities/chat/default.aspx Subhashini (Moderator):
Sure we can have a variety of sessions Subhashini
(Moderator): You can just email me Subhashini
(Moderator): and am at your assistance Subhashini
(Moderator): If you have any suggestions on chat topics
or would like to host a Webchatn please write to me at commind@microsoft.com Subhashini (Moderator):
thank you guys Guest ChatConnecting to chat service...Akila [Expert]
connected.Welcome to the India Community Chat Room. The chat room
will be used for both peer-to-peer, as well as, event chats. Please
abide by the Chat Code of Conduct, located in the Help file. If you
would like to volunteer to be a chat expert, please register here:
http://www.microsoft.com/india/communities/chat/register.aspx.
To view a list of our upcoming chats, please visit: http://www.microsoft.com/india/communities/chat. Chat Topic: ADO.NET
Best Practices Chat Room Status:
Scheduled Chat in Progress sthanika:
Enforcement of minimums and maximums. This is not done in connection
pooling. The maximum value in object pooling is very important when
trying to scale your application. You might need to multiplex thousands
of requests to just a few objects. sthanika:
(TPC/C benchmarks rely on this.) COM+ object pooling is identical
to what is used in .NET Framework managed SQL Client connection pooling.
For example, creation is on a different thread and minimums and maximums
are enforced. Santhosh:
Connection poolig allows you to create a pool of connection, it helps
to reduce the overhead of establishing new connection. you can configure
the no of connections in the pool Akila
[Expert]: hi all Ritu:
hi sthanika: hai
akila Hemant asked the experts:
How to configure pools? Infinite:
Hi Akila AjayC:
hey all Perumal:
Explain more about CONNECTION POOLING Infinite:
and Object pooling also kashypa:
Hi all kashypa:
This is Lohith from Bangalore vamsy:
Hi this is vamsi from bangalore Manish:
Hi All ..... Ritu:
Hi This is Ritu from Bangalore Mani:
thru MTS only pooling possible is it> sudheesh:
sudheesh frm bangalore JIGNESH[Expert]:
Thanks Subhashini for an Intro. JIGNESH[Expert]:
Good Afternoon friends and thank you all for joining into today's
Chat Session JIGNESH[Expert]:
Its nice to see such a big response. sthanika:
Hai everyone please read the Subhashini information about chat to
follow Manoj: Manoj
alencherry from Bangalore programmer2004:
Good afternoon, this is programmer2004 from Mumbai. vamsy:
is it a good practice to use min size and max size in connection string
for connection poolingPerumal asked the experts: connection pooling
? Vikas: Hello Everybody HEMANT: In real-life
projects where to store connectionString ? In web.config or in global.asax
or anywhere else? sthanika:
hai hemant use web.config... bharathi:
could u please explain what is connection pooling ? sthanika:
you can secure your connectionstring, encrypt... JIGNESH[Expert]:
Guys.. listen to Subhashini (Moderator) Fire
Ozzy: Store Connection string in web.config file encrypted... dotNet Spider: server
registry could also be a possible one.. but not sure whether its advisable Nish [Trivandrum]: The
mod wants everyone to keep quiet for the first 30 mins so Jignesh
and Akila can give an initial briefing :-) Santhosh:
You can configure the connection pooling in the Connection
object Nish [Trivandrum]:
You can ask questions after that DotNetRaghu:
Quite please !!!!!!!!!!!!!!!!!!!!!! BK2004:
Hello Jignesh and Akila sthanika:
Hello everyone please listen subhshini... kashypa:
Hi Jignesh and Akila dotNet Spider:
sure Nish Manish:
Please let experts to start...... Santhosh:
In an SQLConnection object, Add this to the connection
string: Pooling=False; A R Balaji
: Lets start , Akila and Jignesh... Ashish:
Hi Jignesh and Akila, we all welcome you and looking for this session
ahead. sudheesh:
keep quiet balaji sharif:
Hi Akila dotNet Spider:
Please go ahead experts! JIGNESH[Expert]:
Once again Thanks Subhashini for an Intro.y2d dotNET: hi all JIGNESH[Expert]:
Good Afternoon friends and thank you all for joining into today's
Chat Session Chintan:
hi all Swetha: hello
everyone hashims:
Hi all Lorish: hi
everyone JIGNESH[Expert]:
Well come to ADO.NET Best Practice Chat. (Session assumes that you
already know basics of ADO.NET) sharif:
Hi all sthanika:
yes sharif: Good
Evening JIGNESH[Expert]:
We all know that our application development revolves around ADO.NET Arch_kulk: Sorry ...
Hello everybody sudheesh:
my question for this session is Concurrency problem in ado.net Lorish: Hi Jignesh..
senkum: sorry balaji
I was out of my desk JIGNESH[Expert]:
. Hence there is an extensive usage of Connection, Command and other
object of ADO.NET senkum:
ok listen to experts sthanika:
ok Praga: hi all bharathi: hello all JIGNESH[Expert]: and
obviously if we do not use them properly we are going to face challenges
with performance, scalability and other issues. sthanika:
yes JIGNESH[Expert]:
And hence I selected this topic; this chat is intent to offer you
suggestions that can help you optimize the design of your ADO.NET
application. JIGNESH[Expert]:
We'll discuss about the following: Vikas:
ok JIGNESH[Expert]:
Best Practices with Connection (Storing connection string, Connection
Pooling, Authentication Modes and Connection Usage Pattern), JIGNESH[Expert]:
Best Practices with Command, DataReader and DataSet JIGNESH[Expert]:
and then will take on with Q & A. in between if you have any questions
feel free to ask them sharif:
Hi Jignesh I have one problem JIGNESH[Expert]:
For those who are not familiar with ADO.NET , Let me give you reference
url sthanika: yes senkum: Anything reg
discionnected and concurrency issue JIGNESH[Expert]:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconAccessingDataWithADONET.asp JIGNESH[Expert]: Lets
get started with Connection Object sthanika:
yes JIGNESH[Expert]:
Let me raise a question here. How many of you here store connection
string in an XML file (Web.Config)?hashims asked the experts: is it
better design our qown Data AccessLayer or better to use Application
block for Data Access Balakrishna:
me me sthanika:
I am using web.config agrewal asked
the experts: me too !! HEMANT:
me 2 siva: me to tejeshwer: me too sudheesh: me used kashypa: Hi jignesh.
depending on the situation we do this dnn:
ya I do JIGNESH[Expert]:
Let me raise a question here. How many of you here store connection
string in an XML file (Web.Config)? Reji
R: I alsohashims asked the experts: yes thats better nip: me 2 Arch_kulk:
me 2 y2d dotNET:
I store connection string web.config but in encrypted form sunil:
I used Fire Ozzy:
We use web.config in all r projects ysr:
me too Vikas: me
too senkum: I am
using external xml file Sathiya:
we use application.config hashims:
me 2 Lorish: Jignesh..
I don’t use Chintan:
me to JIGNESH[Expert]:
OK OK.... Good. Lets explore some other options we have. Fire
Ozzy: in encrypted form vamsy:
me too JIGNESH[Expert]:
OK OK.... Good. Lets explore some other options we have. dotNet
Spider: I've used config as well as registry sharif:
when I wrote connection sting in web.config file and access in vb.net
its giving error that web.config file is not working.... Manoj:
I stored it in a class file DotNetVIR:
me too JIGNESH[Expert]:
FIRST ONE: We can store connection string in an UDL File JIGNESH[Expert]:
The standard way to create a UDL file is to right-click in the directory
where you want to create it and select the New-Microsoft Data Link
menu command Perumal:
JIGNESH - are you from ATL JIGNESH[Expert]:
Unfortunately, on many computers, this manual procedure won't work,
because the file type "Microsoft Data Link"does not appear
on the "New" menu hashims
asked the experts: is it better design our qown Data
Access Layer or better to use Application block for Data Access JIGNESH[Expert]: The
fix is easy, though: choose the "Text Document" file type,
and then replace the .TXT extension with a .UDL extension. Double
Click on fil sthanika:
ok Praga: ok JIGNESH[Expert]: Dim cnn As New OleDbConnection("File
Name=C:\Documents and
Settings\Administrator\Desktop\MyDB.udl")
cnn.Open()
MsgBox(cnn.ConnectionString)
cnn.Close() JIGNESH[Expert]: Thought
this option is very famous it has some limitations kashypa: Jignesh what
if I am using a Sql Server Fire
Ozzy: What does this UDL file contain..? JIGNESH[Expert]:
1. It can be used only with OLEDBConnection. kashypa:
then y do we need OLEDbconnection Vikas:
ok] JIGNESH[Expert]:
2. It needs to parse connection string every time you read from udl
file and hence it’s slow and should be avoided. sthanika:
ok JIGNESH[Expert]:
UDL file contains connection string. Safder
Husain: Hi Jingensh ,Can u tell me why application
blocks are useful Vikas:
how? DotNetVIR:
k JIGNESH[Expert]:
Mostly classic VB programmers chose this option. sharif: sthanika: yes JIGNESH[Expert]: 3.
Other concern with this technique is I need to store this file in
a secure place, in an isolated area where only administrators and
applications can read
y2d dotNET: PBP:
HEMANT:
first listen expert Praga:
yes JIGNESH[Expert]:
SECOND OPTION: JIGNESH[Expert]:
Registry is another place where we can store connectionstring Praga: safder don’t
ask Questions now senkum:
I am storing in XML file with encrypted format hashims:
ok Roopesh: What
happens if the connection string changes hashims:
cool buddy Safder Husain:
ok chai: Hi Jignesh
, What is the best way to handle Transaction within the component
or in the MTS - You can answer this once you are done with your current
question Roopesh:
after securing the connection string sudheesh:
pls stop asking questions now....listen first senkum:
what is different I UD kashypa asked
the experts: But Jignesh, how will you be able to
do this in an ASp.NEt technology senkum:
ok JIGNESH[Expert]:
Ideally we store it in registry under HKEY_LOCAL_MACHINE since this
section contains configuration information particular to the computer,
irrespective of which user is logged on ysr asked the experts: can
u show.. how to do this using registry.. JIGNESH[Expert]:
Programmatically I can access registry using following code Sudha:
HOW CAN WE CAPTURE THE PORTS OF DIFFERENT EXTERNAL DEVICES JIGNESH[Expert]: Imports Microsoft.Win32
Dim ver As String
Dim regKey As RegistryKey
regKey =
Registry.LocalMachine.OpenSubKey("Software\MyASP.NET\Identity\ASPNET_SETREG",
True)
ver = regKey.GetValue("ConnectionString", "None") JIGNESH[Expert]: this
can be done from ASP.NET too.. Praga
asked the experts: But JIGNESH when we want to change
the location of the UDL file, then we need to modify our code and
build it again Vikas:
good S_09: Sudha,
external devices means u mean PDA's ? kashypa:
Yeah I got that Jignesh Kaustav:
Is ASPNET account allowed to read Registry values
unless you are impersonating ? JIGNESH[Expert]:
This technique secures your connectionstring in safe place but has
issues like Vikas asked the experts:
In Asp.net , how we can do? tejeshwer:
guys u have chance to ask after 30 mins...so lets don't waste time JIGNESH[Expert]: 1.
When deploying application is should have same registry setting on
deployment machine too.. JIGNESH[Expert]:
2. Also I may need to grant access rights to this registry key JIGNESH[Expert]: 3.
So XCopy won’t work anand:
Hi every body Balakrishna asked
the experts: How do we grant access rights through
deployment JIGNESH[Expert]:
Option THREE:: JIGNESH[Expert]:
Third Technique could be creating my own configuration file, somewhat
similar to INI files JIGNESH[Expert]:
Which sounds much similar to .config files of .NET but .config for
applications it works like readonly files sukesh:
I don't think that u can give access rights on deployment JIGNESH[Expert]:
Unless you use File I/O API or System.Xml JIGNESH[Expert]:
REged32 is a tool for granting registry access rights Fire
Ozzy: sukesh are you from Delhi? You are showing it
your words...! JIGNESH[Expert]:
1. So plus point here is I could read and write my own ini files anand: Jignesh can you
tell me how should I optimize my dataset in distributed environment
for better performance Sudha:
YES JIGNESH JIGNESH[Expert]:
2. Can define my own tags and sub-tags senkum:
please cooperate guys sukesh:
u can even add to system registry directly, with out using regsvr32 JIGNESH[Expert]: The
–ve point is that I have to manage all by myself. JIGNESH[Expert]:
OPTION FOUR:::::: JIGNESH[Expert]:
Forth: we can also store connection string in COM+ catalog JIGNESH[Expert]:
Which you would then access it through the COM+ constructor string JIGNESH[Expert]: Only
serviced components have access to the COM+ catalog and there is no
reason to derive all your classes from Serviced Component simply to
get access to COM+ constructor strings san:
hi all Praga: ok JIGNESH[Expert]: So
this is not an option to benefit all Naresh:
Hi All JIGNESH[Expert]:
OPTION FIVE::::: Kamal: Storing
Connection string may be a minor issue,Why not tackle more complex
issues JIGNESH[Expert]:
We all welcome this option because it’s the way we all like
to store connectionstring. WEB.CONFIG JIGNESH[Expert]:
and access in application by calling JIGNESH[Expert]:SQLCOnnection.ConnectingString =
ConfigurationSettings.AppSettings("DBConnStr") Fire Ozzy: Jignesh you
please go ahead.. its interesting to know all the possible options Praga: yeah JIGNESH[Expert]:
Benefits are VEmpower_somu:
how to find the default email client in client system , asp.net? JIGNESH[Expert]: 2.
Easy Programmatic Access Joydeep:
Can we get into more complex issues on ADO.NET JIGNESH[Expert]: 3.
In ASP.NET any changes made in web.config is available immediately
since it will restarts website automatically anand:
AKila can you tell me how should I optimize my dataset in distributed
environment for better performance sudheesh:
joydeep pls listen first y2d dotNET:
Let him finish this topic first guys ... JIGNESH[Expert]:
Althow web.config is secured since IIS will reject any request made
to access web.config via browser Fire
Ozzy: Jignesh you missed point 1 I suppose JIGNESH[Expert]:
But still it may be concern with few developers since everything in
web.config is in a Clear text format JIGNESH[Expert]:
. It would be nice if we had ready-made options to encrypt strings
and then store it in web.config. Unfortunately this version does not
support but certainly we do have options like senkum:
what abt security ravimakam:
hi all JIGNESH[Expert]:
1. DPAPI (DataProtection ADI ) 2. Cryptography Library of .NET (System.Security.Cryptography
) Tarun: Hai all JIGNESH[Expert]: COOL..... JIGNESH[Expert]: Lets
move on to Connection Pooling , Ganesh:
would this be performance hit sudheesh:
ok James: hi all sharif: ok thank u JIGNESH[Expert]: So
how many of you are thinking, “what’s there to know about
it. It’s being handled automatically” Raise your hands. ysr: jignesh... can
u give example.. as to how to use this encryption techniques Rajasekhar:
ok Ganesh: encrypting
and decrypting of connection sting JIGNESH[Expert]:
Oops!!! ysr: YES agrewal: raised hands Rajasekhar: it is handles
automatically HEMANT:
me sharif: sudheesh: raised jcool: hello to everybody Vikas: ok Manoj:
me too y2d dotNET:
i m not raising... JIGNESH[Expert]:
We need to know 3 things. How Pooling Works, When New Pool is created
and what will happen if all connections in a pool are used.?. but
first a little code on how to set pool and its size. dnn:
ya automatically Fire
Ozzy: we can control i t for customization
JIGNESH[Expert]: (YSR) i don't have code at the momnet
, you can mail me after words ) Tarun:
What are the objects in ADO. Net Tarun
asked the experts: What are the objects in ADO. Net
ysr: thanks Jigneesg ysr: Jignesh* Rajasekhar:
tarun keep quiet anand:
hey any body can explain how to compact the dataset when I transmit
my data from client to the server sudheesh:
u will get time to ask questions.....pls keep mum JIGNESH[Expert]:
1. Easy to Deploy using Xcopy Rajasekhar:
jignesh lets continue with connection pooling JIGNESH[Expert]:
When connection pooling is enabled (which it is by default), the data
provider draws each connection from a pool of pre-opened, idle connections
or makes a new connection to the database. JIGNESH[Expert]:
This means that when you close your connection in code, you're really
just releasing the connection back to a pool of used connections;
MayankVy: anand
- you can use surrogate.. for dataset serialization optimizing Rajasekhar: can we set
the max no of connections JIGNESH[Expert]:
the database connection to the data source remains open and continues
to hold resources JIGNESH[Expert]:
on the server until the pooler times out the connection and closes
it anand: but it
work for remoting how it can work on web services JIGNESH[Expert]:
The above code will open 3 connections when your Cnn.Open is executed senkum: i am facing
deadloack issue JIGNESH[Expert]:
. Do you want to verify Santhosh:
common JIGNESH dnn:
ya JIGNESH[Expert]:
Goto SQLQuery Analyzer and call a stroedProcedure “ SP_WHO” Purush: which is the
best way to store the conneciton string.. HEMANT:
where is the code? Rajasekhar:
yeh ysr: above code
;? JIGNESH[Expert]:
let me show you a sample JIGNESH[Expert]:
52 0 sleeping JIGNESHDESAI\Administrator JIGNESHDESAI 0
Northwind AWAITING COMMAND
53 0 sleeping JIGNESHDESAI\Administrator JIGNESHDESAI 0
Northwind AWAITING COMMAND
54 0 sleeping JIGNESHDESAI\Administrator JIGNESHDESAI 0
Northwind AWAITING COMMAND Vikas:
ok JIGNESH[Expert]:
the output of SP_WHO JIGNESH[Expert]:
The First column is your process Ids. So it proves that 3 connections
are opened. JIGNESH[Expert]:
IMP::: dnn: means
if i open a connection through code it will open 3 JIGNESH[Expert]:
The following criteria will decide when new pool is created. diwi:
can v use ODBC connectivity in ADO.net santosh
asked the experts: how to set max pool size explicitly anand: any one how should
i compact dataset while interacting with web services Ajith
asked the experts: Does any one use C# to communicate
with SAP Business one? JIGNESH[Expert]:
1. The connection strings have to match exactly for connections to
be in the same pool JIGNESH[Expert]:
Minor differences like extra spaces do matter anand:
ajith you can do it in VS2005 diwi
asked the experts: can v use ODBC connectivity in
ADO.net JIGNESH[Expert]:
Following lines will create two pools Vikas:
First complete the connection pool. Akila
[Expert]: diwi yes you can Orion_Eagle:
Hi Jignesh/Akila which is the best way to achieve database independence
and how (in simplest possible way) JIGNESH[Expert]: cn2 = New SqlClient.SqlConnection("pooling=true;max
pool
size=3;Integrated Security=SSPI;Initial Catalog=northwind")
cn2.Open()
cn3 = New SqlClient.SqlConnection("max pool size=3;Integrated
Security=SSPI;Initial Catalog=northwind;pooling=true;")
cn3.Open()
Purush asked the experts: Hi Jignesh,which is the best and most
practiced way of storing the conneciton string anand:
yup u can use odbc in ado.net JIGNESH[Expert]:
SEE the difference in connection strings.... maheshgv:
Orion_eagle, you can make use of interfaces JIGNESH[Expert]:
3. If you use a specific UID for each connection, each UID gets its
own pool. JIGNESH[Expert]:
4 Each process, program, component, Web service, or Web application
gets its own pool Akila [Expert]:
yes or modify the Data Application blocks aruninbox:
Hi aLL Tarun asked
the experts: DIfferent Object of ADO .Net Ajith:
anand, I think it is possible with current version of VB.NET Akila
[Expert]: to make it generic using Data access interfaces ranjit: can i use the
sqlserver for system.data.oledb if not whats the reason JIGNESH[Expert]:
When all connections in the pool are used and new more connections
are available santosh:
is it true that pooling doesnt work for user roles JIGNESH[Expert]:
it will wait for a specified time (Connection TimeOUT) before throwing
an exception. diwi asked the experts:
do u guys have sample connectivity code for ODBC ..should ODBC connectvity
be used YES or No .. wat will be performacne issue JIGNESH[Expert]: System.InvalidOperationException:
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections
were in use and max pool size was reached.' at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction)
' at(System.Data.SqlClient.SqlConnection.Open()) Akila [Expert]: ranjit,
you can use it but if you have sql provider it will be better performing
than the OLDB layer bcos of interop issues maheshgv:
sometimes, there ain't no other way to connect to
certain databases other than ODBC Vikas:
ok Rajasekhar: Can
u please tell the diff between ado.net1.1 and ado.net2.0 JIGNESH[Expert]:
So what should I do to handle these errors? anand:
ranjit sql client is customize for sql server and you can not connect
through oledb kashypa asked the
experts: So what to do during this scenario JIGNESH[Expert]:
Huumm...... JIGNESH[Expert]:
its simple create another pool anu:
Hi all. Can any one send me sample question papers for the MCSE Exams
on ASP.NET Orion_Eagle:
u are right maheshgv JIGNESH[Expert]:
Changing connection string will create a new pool.. Remember above
pool creating rules… sharif:
Connection TimeOUT? Mani:
let me other than sqlclient & oledb providers for database connection Nabarun: enough with
connection pooling Rajasekhar:
anu i will send it to u Akila [Expert]:
diwi, depends on why you want to use odbc? if it is some legacy database,
which does not have anoledb provider or .NET provider then us odbc
providfer kashypa asked the experts:
But should the conn string change for that Orion_Eagle:
since each provider is specific for that database JIGNESH[Expert]: Here
is the code to try JIGNESH[Expert]: Example #1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles Button1.Click
Dim cn4 As New SqlClient.SqlConnection
Dim i As Integer = 0
cn4 = New SqlClient.SqlConnection("pooling=true;max pool
size=3;Integrated Security=SSPI;Initial Catalog=northwind")
cn4.Open() cn4 = New
SqlClient.SqlConnection("pooling=true;max pool size=3;Integrated
Security=SSPI;Initial Catalog=northwind") cn4.Open()
cn4 = JIGNESH[Expert]: Try
cn4.Open()
Catch ex As Exception
MsgBox("In Exception")
cn4 = New SqlClient.SqlConnection("pooling=true ; max
pool size=3 ; Integrated Security=SSPI;Initial Catalog=northwind")
cn4.Open()
End Try End Sub
Orion_Eagle: but what about performance hiti? JIGNESH[Expert]:
The only difference is connection strings in the exception section
contains white spaces DotNetHunter:
diwi, to what database do you want to connect to?? ODBC connectivity
introduces an extra layer when compared to native providers and hence
there is performance loss when compared to native providers. ysr
asked the experts: so.. till what extent can we go
on creating the Pools? MayankVy
asked the experts: Experts: performance overhead for
serializing custom entities and dataset for aprox. 100 records are
more or less same.. i mean they will perform same.. is it true? maheshgv: microsoft
standards - OLEDB gives you the best performance senkum:
what is SSPT maheshgv:
ODBC you can expect pretty much acceptable performance JIGNESH[Expert]: HIT: SO define
3 to 4 connections string in your config file and use one of it when
this error occurs anand:
MS standards gives better performance diwi
asked the experts: Visual FoxPro DB and oracle JIGNESH[Expert]: Let
move on to understand with Authentication Mode to use. Praga:
good idea Vikas:
ok mohan: I have
3 tables City State And CityState. City and State are master tables.
CityState is a table which holds the relation ship between city and
states. If am giving the user a screen to enter new cities. What is
the best way to do this(Transaction). Orion_Eagle:
but ODBC is always layed its pretty slow when compared
with native providers DotNetHunter:
oracle has a native provider. Rajasekhar:
yeh its good Nabarun:
excellent...pls carry on JIGNESH sharif: Mrinal: exactly
that's called ODP.Net senkum asked
the experts: SSPI means Fire
Ozzy: Jignesh, You are going great... pls carry on anand: can any body
explain the diff between DAAB 2.0 and 3.1 JIGNESH[Expert]:
Guys ... we have Q&A a while later.... JIGNESH[Expert]:
Hold on for some time let me finish. Mani:
let me know other than sqlclient & oledb data providers in ado.net JIGNESH[Expert]: Using
windows authentication would be advantage in terms of security Mrinal: ODBC.Net , ODP.Net JIGNESH[Expert]: security
as there is not need to specify userid and password in connection
string... dhavalhirdhav:
hi all... I hope, I am not late
Akila [Expert]: Mani, you have providers for oracle
and odbc Rajasekhar:
guys, whats odp.net JIGNESH[Expert]:
Also Mrinal: ODP
- specific for oracle Nabarun:
guys pls...complete JIGNESH first... JIGNESH[Expert]:
Logon security improves through password expiration periods DotNetHunter:
diwi, for visual foxpro, i suppose you have no other alternative other
than odbc. sukesh:
ODP is for Oracle JIGNESH[Expert]:
minimum lengths Mrinal:
Oracle data provider for .Net JIGNESH[Expert]:
and account lockout Sudha: really
gr8 jiginesh, u are answering very fast JIGNESH[Expert]:
after multiple invalid logon requests DotNetHunter:
odp --> oracle data providers JIGNESH[Expert]:
also JIGNESH[Expert]:
Passwords are not sent as clear text over network sukesh:
hi rajashekar, this is new provider from ado1.1 to ado2.0 Rajasekhar:
oh thanx sukesh santosh:
i have application server and database server on different m/c and
i want to use windows authentication how is it possible? JIGNESH[Expert]:
But all this plus points comes with a fact that it takes longer to
open a pooled database connection JIGNESH[Expert]:
So my last few word on connections JIGNESH[Expert]:
Open a database connection as late as possible JIGNESH[Expert]:
Use the connection for as short a period as possible. sharif:
Means JIGNESH[Expert]:
Close the connection as soon as possible anand:
hashims use DAAB , it already tested in MS LAB and contains all the
best practices sharif:
ok JIGNESH[Expert]:
Remember to Close the connection to return it to the pool Nick:
Can any body suggest some examples on creating setup
for asp.net applications Mrinal:
i think that too is only in case of a reader for adapter , dataset
we need not open and close connection explicitly JIGNESH[Expert]:
Do not call Close or Dispose on a Connection, a DataReader, or any
other managed object in the Finalize method of your class Akila
[Expert]: Nick, There are wonderfulk tutorials and
step by step samples available in msdn Mrinal:
that's for ur comment jignesh Rajasekhar:
u mean creating setup projects JIGNESH[Expert]:
Well lets move on with SQLCOmmand Object Nick:
yes Orion_Eagle:
Mr.maheshgv r u there? DotNetVIR:
wht is DAAB and frm where can i get it? sharif:
ok santosh: i have
application server and database server on different m/c and i want
to use windows authentication how is it possible? JIGNESH[Expert]:
so points to remember while working with command object are....... Akila [Expert]: Data
Access Aplication Blocks Akila [Expert]:
from microsoft downloads maheshgv:
Yes, Iam here JIGNESH[Expert]:
1 Retrieve Only the Columns and Rows You Need Mrinal:
get it from MS application block Nick:
I mean an installer using which project can be installed anand:
its data access application block you can get from http://www.microsoft.com/practices JIGNESH[Expert]: 2.
Specify command type as “Stored Procedure” as it will
need to parse commandtext, DotNetVIR:
thanks Akila.. anand:
use web project option from setup project Akila
[Expert]: Nick, yes JIGNESH[Expert]:
3. Use ExecuteNonQuery for commands that do not return data. Else
unnecessary an empty datareader will be opened. JIGNESH[Expert]:
Every time you specify query with parameters sqlserver will create
a execution plan for each JIGNESH[Expert]:
Eg:. Mrinal: that
means for insert , update and delete JIGNESH[Expert]: cmd.CommandText =
"insert into Region (RegionID, RegionDescription) values (@id,
@desc)";
cmd.Parameters.Add ( "@id", SqlDbType.Int, 4, "RegionID")
;
cmd.Parameters.Add ( "@desc", SqlDbType.NChar, 50,
"RegionDescription") ;
Nick: yes but then we have to program to create an installer by
packgng all the dlls right? seshu
asked the experts: Can any one throw some light on
Microsoft Asyncronous Aggregation block implementation in VB.net JIGNESH[Expert]: cmd.Parameters[0].Value = 5;
cmd.Parameters[1].Value = "North West";
cmd.Prepare();
cmd.ExecuteNonQuery(); JIGNESH[Expert]: cmd.Parameters[0].Value = 6;
cmd.Parameters[1].Value = "North East";
cmd.ExecuteNonQuery();
cmd.Parameters[0].Value = 7;
cmd.Parameters[1].Value = "South East";
cmd.ExecuteNonQuery(); cmd.Parameters[0].Value = 8;
cmd.Parameters[1].Value = "South West"; cmd.ExecuteNonQuery();
desh: hello every body Akila
[Expert]: Balakrishna, What access rights do u wish
to grant? Rajasekhar:
JIGNESH, if i fill a dataset with an adapter,will the dataset contains
only the data or any extra info sukesh:
come on sheshu , please don't distrub with u r topic Murali:
How do handle changes to multiple records in dataset? Can anybody
help me? JIGNESH[Expert]:
The Command.Prepare method can improve the performance of parameterized
commands that are repeated at your data source James:
hello guys sudheesh:
jignesh pls tell abt commandbuilder sthanika:
oh JIGNESH[Expert]:
Call to Multiple Select Statements and use NextResultSet where ever
possible Rajasekhar:
sukesh can u please help me James:
how to transfer the datas from xml file to database while using ado.net seshu asked the experts:
what? James: ? kaushik asked the experts: can
ADO be Used instead of ADO.net in any .NET application Akila
[Expert]: James. use the ReadXml method of the datset nalluri: Hi guys sukesh: what information
u r required with dataset..? John
asked the experts: when i do a dataadaptor.update,
how can i know whether the update has successfuly hapned or not? kampat: yes ado can
be used but not preffered seshu:
wht sukesh what u want? James:
yes akila
HEMANT: Expert session finished? bharathi:
after this session gets over please send copy of questions and answers
to the group members HEMANT:
can we ask questions now? James:
then what is the process anand:
kaushik u can make a com component using ado and call in ado.net Akila [Expert]: John,
if update failed an exception will be raised JIGNESH[Expert]:
Fine.... I think i will stop here... there are lots of questions poping
up... let me answer them.... kashypa
asked the experts: Guys PLEASE LET JIGNESH FINISH
HIS TOPIC Sudha: sir
if a view is created in mysql clubing 2 tables, if we take the datasource
to a datagrid. can we insert in to the database ???? sharif: kashypa: Guys PLEASE
LET JIGNESH FINISH HIS TOPIC HEMANT:
please go on Jignesh kashypa:
Guys PLEASE LET JIGNESH FINISH HIS TOPIC John:
what exception ? how can i catch that exception ? sudheesh: jignesh ,pls
write abt commandbuilder Mrinal:
catch it in SqlException sharif:
Jignesh u finish u r topic first Nabarun:
this is becoming a mess sukesh:
sudha, yes, we can insert into database from the datagrid. Arch_kulk:
Jignesh please complete the session Nabarun:
we are here to hear from JIGNESH fiirst comfire:
Common Jignesh!!!!!! m_sunils:
yeah jignesh plz carry on Akila
[Expert]: Jignesh carry on
Nabarun: JIGNESH ...why don't u carry on.... kaushik:
can ADO be Used instead of ADO.net in any .NET application bharathi:
hi all let jignesh continue with the topic sarvan:
hi, i want to read an excel file and update some of
the content i.e with some criteria, to the database , how i can achieve
this using ado.net James:
pls jignesh anand:
JOHN an exception is the breaching of predefined assumption of the
application“ santosh:
plz explore something on diff betn dataset and datareader Akila
[Expert]: he will guys JIGNESH[Expert]:
Cool! Guys.... On Demand... No Prob... I talk on DataRead.... sudheesh: he gone for
tea...i think? anand:
YOU CAN CATCH IT THROUGH TRY/CATCH/FINALLY Akila
[Expert]: Kaushik, Yes ado can be used maheshgv:
Kaushik, you can use ADO instead of ADO.Net in any
.Net application. bUt unnecessarily you are decreasing the performance
by using COMP Interop JIGNESH[Expert]:
points to remember while working with DataRead object are.. Nabarun:
thanks AKILA Akila [Expert]:
this is technically it can be . it will go thru the COM interop layer JIGNESH[Expert]: Use
the typed accessors like GetString, GetInt32
Instead of DataReaderObject(0) | DataReaderObject(“FieldName”) Lorish: i wanna know
about Dataset Sudha: Mr.
Sukesh, i know how to insert from datagrid. but if the datasource
is a view i.e merged tables in the mysql Akila
[Expert]: yes lorish tell me JIGNESH[Expert]:
By default, the DataReader loads an entire row into memory with each
Read John: is there
any property or method by which i can come to know whether the update
has successfully hapned? Akila [Expert]:
i mean post ur query Sudha:
akila madam, kindly solve my problem JIGNESH[Expert]:
Use CommandBehavior.SequentialAccess if you are reading a row which
has many “Text “ columns ( Blobs senkum:
Jinesh type more lines at a time pl JIGNESH[Expert]:
use CommandBehavior.CloseConnection Technique JIGNESH[Expert]:
when you are returning a DataReader from a method Rajasekhar:
i think u cannot insert Lorish:
can i have all the child tables name to a particular master table JIGNESH[Expert]: and
do not have control over the closing of the DataReader or associated
connection. Akila [Expert]:
tell me sudha JIGNESH[Expert]:
DataReader is designed for connected access so don’t think of
remoting it between tires Lorish:
in dataset DotNetRaghu asked the
experts: Will there be any performance hit if we use
a Custom Dataprovider rather than a SQL dataprovider ? JIGNESH[Expert]:
QUICK TIPS::: JIGNESH[Expert]:
Avoid using DA.FillSchema Method instead DataAdapter.MissingSchemaAction
is MissingSchemaAction.AddWithKey before Fill Lorish:
Akila solve my query James:
what is differece between Client side control and Server side control? JIGNESH[Expert]: this
will avoid Extra trip to sever Lorish:
i asked first anand:
dotnetraghu I have done one small test here the result SQLDataReader
is 115% faster then OleDbDataReader JIGNESH[Expert]:
QUICK TIPS:::: JIGNESH[Expert]:
Use DataTable.Rows.Find instead of DataTable.Select If the query is
against the columns that make up the PrimaryKey of the DataTable Akila [Expert]: lorish
can u frame it again what u r looking for? DotNetRaghu:
how about Custom Dataprovider ? Ashish:
Please give some more detail on "Avoid using DA.FillSchema Method
instead DataAdapter.MissingSchemaAction is MissingSchemaAction.AddWithKey
before Fill" JIGNESH[Expert]:
I finish with my Expert session... lets move on with Q & A nanaiah: hi sukesh sudheesh: jignesh write
abt commandbuilder pls Nabarun:
I am not satified with your session
Lorish: i want to have all the child tables name to
a master table in dataset James:
jignesh is busy, akila can u pls explain "what is differece between
Client side control and Server side control" Sudha:
madam if a view is created in mysql clubing 2 tables, if we take the
datasource to a datagrid. can we insert in to the database ???? i
know how to insert from datagrid. but if the datasource is a view
i.e merged tables in the mysql DotNetRaghu
asked the experts: Will there be any performance hit
if
we use a Custom Dataprovider rather than a SQL dataprovider ? JIGNESH[Expert]: (ASHISH)
to fill schema we normally use DA.FillShema and then say DA.Fill...
this will make extra trip to ther server to fetch schema anand:
use sysobject Akila [Expert]:
James, that is an asp.net Q. can we take it after the session? Rajasekhar: James pls
refer MSDN sharif:
I am not satified with your session m_sunils:
Is it possible for a batch update when using Data adapter's update
method when more than 2 tables have to be updated HEMANT:
If i m stroing sha1 encrypted password in web.condig file in connectionString
then how to validate it with sql server?? JIGNESH[Expert]:
(ASHISH) DataAdapter.MissingSchemaAction will do that in single TRIP James: ok thank u sudheesh: jignesh write
abt commandbuilder pls Rajasekhar:
Sudha i think it is not possible Ashish:
(JIGNESH) Got it..thanks JIGNESH[Expert]:
(HEMAT) use DPAPI for storing connection string in web.config. dnn asked the experts:
In an ecommerce site should i use datareader or dataset? sukesh:
sudha , then, u can't do it directly. because tables r merged in to
one view. for updating u need to separate view to according columns
of tables and update it using dataset to database. Rajesh:
Hi all maheshgv: Thanks
Jignesh Biswajit:
I am using a web service to read the data from the oracle databse.
My web method returns the data in xml format. But when I am using
the order by in my query then oracle and the xml data returns in different
sorting order.Its working properly when I a Lorish:
akila... wat happend to my query anand:
dnn asked the experts use dataset JIGNESH[Expert]:
(SUDESH) The CommandBuilder automatically generates the InsertCommand,
UpdateCommand, and DeleteCommand properties of a DataAdapter based
on the SelectCommand property of the DataAdapter, provided that the
SelectCommand performs a single table SELECT Akila
[Expert]: Lorish can u reframe the question? we quite
did not get what you are looking for! JIGNESH[Expert]:
(SUDHESH) USAGE OF COMMAND BUILDER Should be limited to ad-hoc scenarios sudheesh: where we will
use command builder Ashish:
Jignesh..question related to dataview object...Can we create a dataview
from more than one tables of a dataset? Akila
[Expert]: Ashish m_sunils:
jignesh but how bout the situation when multiple tables are involved
and u want to do a batch update Akila
[Expert]: no yopu cannot santosh:
diff betwn dataset and datareader? JIGNESH[Expert]:
(ASHISH) Its not possible in this version atleast... Akila
[Expert]: A dataview can be created only from one
datatable HEMANT:
using odbc.net is good practice??? Dayal:
Hello all Ashish:
Akila..even if we have specified a datarelationship between the datattables Ramesh: dataset is disconnected
architecture
maheshgv: Hemant, it depends on your requirements
& the databas Lorish:
I want to get all related table of one master table in dataset Akila [Expert]: yes Sudha: akila madam view
has been created in the backend sql JIGNESH[Expert]:
(HEMANT) ODBC will perform quite slow... sudheesh:
if we are using a command obj we need to open and close connections
,right whereas dataadapeter is not so...so how commandbuilder work
on this senerios Akila [Expert]:Ashish: understand how
will u query and get data from 2 datatables? Vikas
asked the experts: can u tell about MTS Akila
[Expert]: Sudha, if u r using the view created in
the database there is no issue HEMANT:
can we access data from sqlserver using oledb classes ?? Akila
[Expert]:Vikas:
shall we discuss that after we complete the agenda fo today? anand:
(Hemant) no we can not Ashish:
Got it... JIGNESH[Expert]:
(SUDHEESH)... if you are assigning ad-hos queries in Dataadaptor then
to update via same dataadaptor u take help of commandbulder sudheesh:
we are using a command obj we need to open and close connections ,right
whereas dataadapeter is not so...so how commandbuilder work on this
senerios dnn: i
had used microsoft data access block bout i am facing connection pool
used exception Sudha: how
can we insert into a view having relationship dnn
asked the experts: i had used microsoft data access
block bout i am facing connection pool used exception JIGNESH[Expert]:
(SUDHESH) to generate update statement.... alternatively you yourself
can specify upate stateent. Akila
[Expert]: Hey Hemant yes u can use oledb to read data
from sql server but it is preferred to use sql provider for performance
reasons maheshgv: Hemant,
you can use OleDB classes to access sqlserver, but it'll be slower Biswajit: please answer
my question nanaiah: using
instead of triggers sudheesh:
ok m_sunils: akila
, Is it possible for a batch update when using Data adapter's update
method when more than 2 tables have to be updated Akila
[Expert]: Sudha In my experience i prefer to use a
stored procedure Ado.net does not have a support for that Biswajit:
I am using a web service to read the data from the oracle databse.
My web method returns the data in xml format. But when I am using
the order by in my query then oracle and the xml data returns in different
sorting order.Its working properly when I am HEMANT:
What is MDAC ? kampat:
Microsoft Data Access Component Rajasekhar:
MIcrosoft data access component JIGNESH[Expert]:
(HEMANT) Microosft data acess components.. sudheesh:
would u pls explain abt concurrency problem in .net Biswajit:
.Its working properly when I am using sql server but not with oracle.
Tell me the solution. sudheesh:
jignesh:would u pls explain abt concurrency problem in .net kashypa:
Jignesh. kashypa:
I have a peculiar problem sharif:
(Akila) but the old programmers said that querie's r executing faster
than stored procedures santosh:
jignesh sir i want power point presentaion file that u used for presentation
last week , where i will get that? Akila
[Expert]: (Sunil ) Nope HEMANT:
How to call oracle Cursor from .net? sudheesh:
would u pls explain abt concurrency problem in .net Biswajit:
Jignesh, please answer my query Praga:
i also want that ppt file m_sunils:
so how do we solve such issues sudheesh:
would u pls explain abt concurrency problem in .net Akila
[Expert]:sharif:
yes i agree but i do not have a support in my ado.net adapter to specify
2 inserts in case of a relation. So either i use atored procedures
or use queries to do the same Ashish:
Akila/Jignesh...you pointed out 5 ways to store connection string...Which
will u prefer and why? JIGNESH[Expert]:
(varanasi)... you can cache data in session object. Tapan:
concurrency handling should be addressed on high priority as its a
common problem ..pls m_sunils:
i have a typical problem where in i have to update records in two
tables which i m showing in a datagrid sudheesh:
jignesh:would u pls explain abt concurrency problem in .net kampat:
sudeesh ref to this link for data concurrecy in ado.net http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vboridataupdatesconcurrency.asp sudheesh: thnks kampat nilesh: I have a problem
while connection to oracle server through client machine using OracleConnection
class of OracleClient namespace. JIGNESH[Expert]:
(ASHISH)/... all are having some or other limitations. JIGNESH[Expert]:
(ASHISH) so one should choose a technique in a CONTEXT. senkum
asked the experts: how to prevent deadloack Mrinal:
what's the problem nilesh JIGNESH[Expert]:
(ASHISH) concern with security ... use REGISTERY Mrinal:
can u give a bit detail san:
hi jignesh, could u please tell me the main differences between ado
and ado.net HEMANT:
Can we use datareader for datagrid paging? JIGNESH[Expert]:
(ASHISH) conern with simple useage and need XCOPY deployment use WEB.CONFIG. Praga: yes Akila
[Expert]:Biswajit:
what happens? some error is generated? Ashish:
JIGNESH...but don't u think in future there is nothing like registry
(means in longhorn OS) sharif:
Akila:using sql server is bestpeactice r oracle JIGNESH[Expert]:
(SAN) ... ADO is not designed for disconnection access Vikas:
but why web.config. JIGNESH[Expert]:
(SAN) there was not straingt way to pass ADO ibjects between tires
and firewall.. santosh:
give some tips on transaction object Akila
[Expert]:sharif:
thats a very very debatable question. In my experience with varied
technologies, there are benefits and limitations. A lot depends on
what we r looking for JIGNESH[Expert]:
(ASHISH)... I don;t thnk registery will die... only application will
no longer use them as we have found better alternative ways... sharif: Akila:what about
data concurrency topic? nilesh:
My connection string is "Data Source
= Oracle8i;User
Id=Scott;Password=tiger;" if I run this code through client machine
it give an error 'Unable to load OCI.dll'. JIGNESH[Expert]:
(ASHISH) infact win3004 and even .NET installation use REGistery. kampat: yes i agree
to jignesh abt ado.net vs ado the ado.net has broken down into modules
the different steps of data access san:
we can do it in ado also using adUseClient Praga:
tell me something about the transaction handling in ADO.NET HEMANT:
(santosh) transaction objects are used with dataset Biswajit:
akila, no error. Vikas:
Jignesh, but we have to see the longhorn. JIGNESH[Expert]:
(NILESH)... you need to install ORacle Client. Ashish:
so do u advise to use COM+ instead of udl/ini/web.config and others.. Akila [Expert]:san:
u can read data in a disconnected way but u cannot have the benefit
of relations, views in ado santosh:
i am talking abt sql transaction object ranjit:
diff. indexer and delegate give some stuff on that kampat:
for accessing oracle data from .net app u need to have oracle client
installed so that suitable drivers are availeble and the tnsnames.ora
file needs to have a entry for db u r accessing senkum:
hi Akila what abt concuurrency issue in disconnected ado.net san:
it is possible to access dataset at client side in asp.net Akila
[Expert]: yes dotnetramesh:
hi all JIGNESH[Expert]:
(ABOUT TRANSACTION IN ADO>NET) JIGNESH[Expert]:
JERE IS the SAMPLE COD m_sunils:
Is there any way to scan a document using asp.net JIGNESH[Expert]: Dim cn As New SqlClient.SqlConnection("workstation
id=JIGNESHDESAI;packet size=4096;user id=sa;initial
catalog=pc;persist security info=True;password=jigs")
cn.Open()
Dim tx As SqlTransaction = cn.BeginTransaction()
Dim cmd As New SqlCommand("Insert into dept
values(50,'abc','abc')", cn)
cn.Close()
cn.Open() cmd.Transaction = tx
cmd.ExecuteNonQuery() cn.Close() sharif:
Akila could u plz explain data concerrency kampat:
senkum refer here for concureency managemant in ado.net ranjit:
where can i use the indexer in .net kampat:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vboridataupdatesconcurrency.asp nilesh: (Jignesh) Orcle
client is installed in my m/c and I have also created alise through
Net Easy Config. Akila [Expert]:
yes yes shraif and others: in case of concurreny it supports only
optimistic concurrency Akila [Expert]:
look at the san:
IS IT POSSIBLE TO ACCESS DATASET AT CLIENTSIDE? senkum:
ye kampat JIGNESH[Expert]:
(NIKESH) tell me the error message again JIGNESH[Expert]:
(SAN) your IIS Server in case of ASP.NET is a client for SQLSERVER. Akila [Expert]: check
on the 'continueupdateonerror' property and also Rowupdated event ranjit: diff. indexer
and delegate give some stuff on that Akila
[Expert]: sa n: yes Ashish:
Jignesh...so do u advise to use COM+ instead of udl/ini/web.config
and others..? nilesh: (Jignesh)'Unable
to load OCI.dll' HEMANT:
Is it good practice to store data objects in session objects? JIGNESH[Expert]: (ASHISH)
Only serviced components have access to the COM+ catalog and there
is no reason to derive all your classes from ServicedComponent simply
to get access to COM+ constructor strings. So this is not an option
to benefit all sharif:
akila i want u r id i have lot of queries to discuss Biswajit:
Akila, what happened to my problem kampat:
nilesh most likely ur oracle client installation is not proper JIGNESH[Expert]: Make
sire you have rights on oci.dll JIGNESH[Expert]:
and its folders. Akila [Expert]:akila@aknainfotech.com san: NOT IIS SERVER
AND SQL SERVER. AT END USER I WANT TO ACCESS DATASET. IS IT POSSIBLE?
Praga: wat is oci.dll ranjit: diff. indexer
and delegate give some stuff on that Orion_Eagle
asked the experts: (san) what do u mean by end user
here? santosh: i
have application server and database server on different m/c and i
want to use windows authentication how is it possible? sharif:
ok thank maheshgv: oracel
call interface DLL kampat:
san to access data on client u can carry the xml content to the client san: BROWSER Praga:
ok MJ: how performant
are the odbc classes that we have now nilesh:
(jignesh) i didn't get you how to give the rights JIGNESH[Expert]: (SANTOSH)
\\DOMAINNAME\USerNAME san:
NOT THAT ALSO HEMANT:
Please tell me how to connect remote database? If there are 2 sql
servers with same name? san:
NOT USING XML CONTENT nilesh: i
am properly connected by using oledb connection VEmpower_somu:
Can i change web.config file runtime? JIGNESH[Expert]:
(NILESH) was windows Permission optiona and grant rights to everyone... santosh: for that may
i have to create a user in that domain? kashypa:
some u can JIGNESH[Expert]:
(VEmpower_somu) YES using File I/O or XML Classes... dotnetramesh:
how can we handle multiple databases(sqlserver and access) nilesh:
but by using oracle client class it gives error James: how to overcome
firewall in ado.net/sql server? Akila
[Expert]: Varanasi: you will have to use Caching in
this case if u want the data to be persisted between postbacks san: ? HEMANT:
Please tell me how to connect remote database? If there are 2 sql
servers with same name? Vikas:
How can we handle DTS concurrecy? nilesh:
if i run the same code in oracle server without using datasource name
it works properly sharif:
how i can featch the data in database through xml file nilesh:
but it gaves error on client machine santosh:
plz give link of ppt Nabarun:
Akila...can't we use hidden variables...?? James:
hi akila VEmpower_somu:
if i want to protect particular folder for existing user how to do
that?( JIGNESH)? dotnetramesh:
hi akila kashypa:
sharif -> use DataSet.GetXml() method Lorish:
wat happend ? James:
plz answer my question James:
how to overcome firewall in ado.net/sql server? kashypa:
James -> have you tried WebService way HEMANT:
Who are from PUG here? Vikas asked
the experts: How can we handle DTS concurrecy? san: JAMES. SEND A MAIL
TO akila@aknainfotech.com nilesh: how to join
the PUG ? JIGNESH[Expert]:
Thanks everyone for listening patiently, but I hope everyone must
have enjoyed the session.See you all soon on kampat:
hemant u can use ip of the remote servers to connect kampat:
thanks jignesh santosh:
what abt ppp???? kampat:
appreciate ur effort kashypa:
it was helpfull Purush:
thanks Akila kashypa:
Hey jignesh thanks Tapan:
Many thanks Jigs Vikas:
nest session?? Purush:
thanks jignesh kashypa:
will mail you if needed anything ranjit:
asked the experts: diff. between indexer and delegate James:
thanks jignesh and akila JIGNESH[Expert]:
(Y) Arch_kulk: what
about ppt Tapan:
and many thanks to Akila Akila [Expert]:
hey thanks for ur time and the encouragement u have given to Jignesh brij: thanx Jigs san: THANKS JIGNESH
AND AKILA, IT IS VERY USEFUL Vikas:
Jignesh - ur emial? santosh:
thank you Jignesh and Akila for u r kind assistance bharathi:
thank u jignesh Nabarun:
Many thanks JIGNES Nabarun:
wish u all the best HEMANT:
(kampat) Please give me expample connstring san:
BUT STILL I HAVE ONE QUESTION Nabarun:
thanks to akila tooo.. JIGNESH[Expert]:
if you have any more question you can use www.dotnetjini.com forum's
section sharif:
mani thanks akila/jigu Akila [Expert]:
Yes Thanks to Jignesh for all his efforts! wonderdot:
THANKS JIGNESH AKILA AND ALL kashypa:akila@aknainfotech.com
and jignesh_desai@hotmail.com
JIGNESH[Expert]:
THANK You ALL FOR A GREAT SUPPORT! Ashish:
Thanks experts san:
HOW TO ACCESS DATASET AT CLIENTSIDE? Vikas:
Please Next Topic for XML. objectvimal:
Thanks to Biswajit. kampat:
hemant send me a email kampat@gmail.com san: THANKS TO ALL kampat: i will give
u the samples HEMANT:
sure.. Vikas: Thanks
To all Guests and experts san:
HI KAMPAT JIGNESH[Expert]:
THANKS TO AKILA for her valuable TIME and SUPPORT kampat:
hi san kampat: lets
have a next session very soon Akila
[Expert]: yes Akila
[Expert]: can u suggest a topic? kampat:
on xml, xslt Akila [Expert]:
what will u like san:
COULD U SEND ME THE SAMPLES AT SD.ANWAR@GMAIL.COM HEMANT: WEB Services JIGNESH[Expert]: Have
a Nice Evening with ADO.NET BEst Practices... Bye EveryOne... SEE
you soon in next chat session... senkum:
still no answer on deadlock kampat:
and have a very focussed discussion san:
ANYTHING RELATED TO .NET santosh:
i think we should have a session on remoting Praga:
OOPS way of building .NET apps san:
SENKUM SEND A MAIL TO akila@aknainfotech.com Nabarun: better on WEB
SERVICE....AKILA Praga:
OOPS way of building .NET apps Vikas:
web services is ok kampat:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vboridataupdatesconcurrency.asp
refer this link senkum senkum:
thanks san Lorish:
sombody can hel me on sql.....Pls... san:
OK kampat: hi lorish
wht do u need kampat:kampat@gmail.com santosh:
arranged session on both web services as well as Remoting so that
we can easily differentiate and it will be easy to understand Akila [Expert]: yes
we have got ur interest areas santosh:
Akila mam hope u will consider me opinion HEMANT:
when are the sessions? senkum:
thanks Nabarun:
yeah ...i endorse santosh..... Akila
[Expert]: i am sure subhashin, and other experts can
be involved and we can have a variety of sessions santosh:
thanks a lot.... Akila [Expert]:
yes yes san: WHEN
IS THE NEXT SESSION AND ON WHICH TOPIC? Akila
[Expert]: hey subhashini can u suggest ? Akila
[Expert]: JIGNESH[Expert]: kashypa: C kashypa: Manoj:
Ok thank you JIGNESH , AKila and other friends.... VEmpower_somu:
thanks jigensh ,akila and subhasini. Perumal:
Thank you Subhashini, This is realy very nice session. Bye, Expect
more events like this Chat Room
Status: Open Peer-to-Peer Technical Chat in Progress Perumal: Thankyou JIGNESH
and AKILA Lorish:
anyone can help me on sql.... harish:
hi soh: hello Lorish: hi.. san:
hi Lorish: do knoq
sql? DotnetGH: hi
howz the cummunity goinog harish:
hi Jingesh, will u pls tell me how to update multiple records using
Dataset. Lorish:
bad... DotnetGH:
can manage some of the topics in sql Lorish:
so late buddy Lorish:
DotnetGh... right u r.. DotnetGH:
yeah DotnetGH: ok
how about some topics DotnetGH:
can a dataset populated with multiple talbles based on query (like
a view) be upldated? DotnetGH:
i mean tables G Mallesham Goud:
Hi friends I'm Mallesh any one can help me Isolated Storage in Dot
Net G Mallesham Goud:
Hi friends I'm Mallesh any one can help me Isolated Storage in Dot
Net DotnetGH: what
are the types of transactions, can anyone help me harish:
What is MigPol.exe? DotnetGH:
MigPol.exe is used to migrat policy configuration files from one version
to other .net version.
