|
Hi,
I would like to know that which type of object would give better performance in case I want to work with sql server. Should it be OleDBConnection or SQLConnection?
Somewhere I read that SQLCOnnection can give better performance but I think at the sql server there is a SNAC (sql server native access client service) or a Net library which anyway consists of OLEDB and ODBC component. So instead if we use OLEDBConnection, wouldn't it be faster?
The next query I have is not related to original question but I request to clear my confusion by letting me know which one is better option to free these objects? Should these be freed by Marshal.ReleaseComObject or just closing the connection and then making them NULL?
thanks,
kMeena
|
|
|
|
|
when u r using the sql server use sqlconnection.
and add "System.Data.SqlClient" namespace.
|
|
|
|
|
Hi,
If u use sqlclient in that case it use oledb partially (some code of oledb) and rest it will communcate directly with native code , where as if u use oldedb in that case it use fully(complete code of oledb).
Regards
Anil Pal
|
|
|
|
|
so according to you sqlclient should not be used there??
|
|
|
|
|
Hi,
No its mean sqlclient is better bcz it use min code to communicate with DB where as oledb reuquired more
Regards
Anil Pal
|
|
|
|
|
ya dats true,
as after seeing ur reply i thought u r saying oledb is better.
|
|
|
|
|
but what if I want to make my application generic. In that case there is no alternative to OLEDB. SqlConnection can not work with oracle database.
|
|
|
|
|
hi,
i want to access the value using getElementById, but i am not able to use the .value property for getElementById. can anyone help me???
|
|
|
|
|
Hi,
Please post also detail of the control by whcih u r trying.
I think there must not be a problem with value.
Regards
Anil Pal
|
|
|
|
|
hi,
i am using a table whose rows are created dynamically, and for each row i have a select box. The values are filled in the select box dynamically through the database. I want to access the value selected in the select box in the click of the button. I am handling the button click event using a javascript.
|
|
|
|
|
Hi,
Please use below code to get the dropdownlist value.
var fieldName = document.forms[0].elements["DropDownList1"].value
Regards
Anil Pal
|
|
|
|
|
hi, but here i am not using dropdownlist but simple html select box.....
|
|
|
|
|
|
HI,
I making an application of sending email.but i m getting the error msg
"No connection could be made because the target machine actively refused it "
can u plz help me.
thanks in advance!!
|
|
|
|
|
|
Hi,
If u still u have problem , then pls let me know
Regards
Anil Pal
|
|
|
|
|
I want to display the username once the user logs in successfully.
iam using loginview control in the master page but how to insert the username in the logged in template of the loginview control..
everytime by default it displays the value in the logged in template instead of anonymous template..
plzz suggest some solution
|
|
|
|
|
Hi,
In loggin page u can do below code to assign the user name in either way:
Use label in master page:
1. Session["UserName"]="Anil"; //Set
string str =Session["UserName"].ToString(); /Get
Or
2. Context.User.Identity.Name ="Anil" // Set
string str=Context.User.Identity.Name ;//Get
Regards
Anil Pal
|
|
|
|
|
with the following code iam tryin to access label control of the master page and modify it:
1. Dim mplabel As New Label
2. mplabel = CType(PreviousPage.Master.FindControl("Label1"), _
Label)
3. If Not mplabel Is Nothing Then
4. mplabel.Text = "welcome"
5. End If
but still iam gettin an nullreference exception in line 2:object reference not set to an instance of an object.
modified on Friday, April 3, 2009 4:21 PM
|
|
|
|
|
HI,
Please use below code to access the control of the master page. If it is outside the contentplace holder(Which ofcourse).
Page.Master.FindControl("Label1")
Regards
Anil Pal
|
|
|
|
|
I am using Crystal Report and ASP.net can anybody tell me how to customize this avery label sizes, Gaps for address Labels according to user requirement
|
|
|
|
|
hi all
i want access the textbox control in different usercontrol using javascript,im using TabContainer for access the pages.
Thanks
|
|
|
|
|
can u specify ur problem in detail.
|
|
|
|
|
i have masterpage there i have a ajax TabContainer inside that i have 3 TabPanel, one of that have i call the aspx file and that particular aspx file calling a another usercontrol.so all the textbox controls inside that usercontrol, i want access that textbox id from master page.when i see that client id it shown as follows
ctl00_ContentPlaceHolder1_testusercontrol_txtName
but javascript gives error not define.
i want access that textbox value, how to do that
|
|
|
|
|
the easiest way is to use session variable for ur purpose.
|
|
|
|