Re: Search in by using a combobox - ASP.NET Discussion Boards

Guffa3-May-07 3:46

3-May-07 3:46

The ExecuteReader method doesn't fetch the data, it only creates the data reader that is used to fetch the data. The data reader doesn't contain all the data, the data remains on the database server until you read it. When you have read all the data you want using the data reader, you can close the data reader and the connection.

---
single minded; short sighted; long gone;

Re: regarding datareader

Sebastian T Xavier3-May-07 4:36

Sebastian T Xavier

3-May-07 4:36

Actually, in case of other methods like ExecuteNonquery or ExecuteScalar i can use sqlconnectionobject.close() immediately after execution, in business layer itself. but in case of ExecuteReader i think its not possible as it follows the connected data model. My question is this, whether i can close the sqlconnection in the businesslayer itself, when i am using ExecuteReader and i want to return a value to the presentation layer.
I hope you understood the scenario.

thanks

Sebastian

How to update datagrid using xml file to populate the datagrid in asp.net using c#

attalurisubbu3-May-07 2:04

attalurisubbu

3-May-07 2:04

Dear all,

I my application i am using datagrid,by populating with the xml file my problem is how can i update the xml file i can able to delete but updation i am facing problem can any body can give me the idea so that i can accomplish my task.

thanks and regards,
Subbu.

-- modified at 8:51 Thursday 3rd May, 2007

Re: How to update datagrid using xml file to populate the datagrid in asp.net using c#

ToddHileHoffer3-May-07 4:31

ToddHileHoffer

3-May-07 4:31

That shouldn't be too hard. You can save a dataset as an xml file and replace the copy that you opened. DataSet.WriteXml method to do this.

GameFly free trial

Printing in .net

vijay_833-May-07 1:00

vijay_83

3-May-07 1:00

Hi,

I have a Asp.Net application in which i have designed a salary slip with datas fetched from the database for each employee in a single form named SalarySlip.aspx. In that i have to print the form inorder to print the salary slip when we click print. For that is there any option in .net? If so pls provide me with source code examples..

Regards
Vijay. Smile | :)

Re: Printing in .net

Guffa3-May-07 1:15

Guffa

3-May-07 1:15

I suppose that you want to print on a printer connected to the client computer, not to the server? In that case the solution has nothing to do with ASP.NET. Use Javascript:

window.print();

---
single minded; short sighted; long gone;

Search in by using a combobox

Stormint3-May-07 0:44

Stormint

3-May-07 0:44

Let me know how will it appear if you choose from the combobox by selecting a table name and will it work

Romeo

Re: Search in by using a combobox

_mubashir3-May-07 2:54

_mubashir

3-May-07 2:54

What is your question? Try to be more descriptive

Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.

Re: Search in by using a combobox

Mahesh Kulkarni3-May-07 3:09

Mahesh Kulkarni

3-May-07 3:09

Please refere the link given below...It will help you

here[^]

The secret of life is not enjoyment
but education through experience.
- Swami Vivekananda.

Disabling few items in a dropdownlist

gauthee3-May-07 0:16

gauthee

3-May-07 0:16

Hi,

How to disable a specific item present in a dropdownlist!

For example i have a dropdown list with following values:
india
australia
america

now, in the dropdownlist 'india' should be visible but the user should not be provided with a provision to select it!!!!

Gautham

Re: Disabling few items in a dropdownlist

_mubashir3-May-07 2:57

_mubashir

3-May-07 2:57

Well you can always add a Javascript to alert the user of wrong selection and reset it.

Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.

Finding difficulty in using SqlTransaction [modified]

kinnuP3-May-07 0:01

kinnuP

3-May-07 0:01

hi all ,

problem as follows ,
i am using method called
public void ExecuteNonQuery(string sql) inside Database Class .functionality of this method is takes the sql query and execute by using sqlcommand class here each method for example AddSubscriber() method is for inserting values into Subscriber table and AddSubscriberLogin() this is for inserting values into Subscribelogin Table and we have a link table called Subscribrsubscribelogin()
wihich containes both Subscriber and Suscriberlogin Id's so Due to Some problem like internet the values are not stored into SubscriberSubscriberlogintable so clint canot see all logins of Subscribers i got an idea of using sqltransactions i used as follows

Code:

in subscriber class
class Subscriber
{
AddSubscriber()
{
string sql="";//insert query
ExecuteNonQuery(sql);
}

but this code is not working. i need like to add All methods like AddSubscribeLogin() And AddSubscriSubscribeLogin() After that only i have to Commit other wise rollback all table values.
}
public void ExecuteNonQuery(string sql)
{
SqlConnection connection = new SqlConnection(databaseConnection);
try
{

connection.Open();
transaction=connection.BeginTransaction();
SqlCommand command = new SqlCommand(sql, connection);
command.Transaction=transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
catch(Exception ex)
{
transaction.Rollback();
}
finally
{
connection.Close();
}
}

but when i am calling in each method it is commit always can u suggest any solution please .

Thanks And Regards,
Kinnu

-- modified at 6:51 Thursday 3rd May, 2007

Insert,Update and Delete to custom Database in VS.NET2005

mhadhia2-May-07 23:58

mhadhia

2-May-07 23:58

I am getting problem in doing data modifications(insert,update,delete) in my CUSTOM DATABASE that i have created instead of using the default(i.e ASPNETDB.MDF that gets created by aspnetsqldataprovider by asp.net which also provides different asp.net services such as membership,role,profiles etc)
what exactly i must do?
also i want to know the way one can change default provider in asp.net 2.0 for different services.

m.h.adhia

Opening a file in its own program??

Nada Adel2-May-07 23:37

Nada Adel

2-May-07 23:37

There's this file that I wanna open from my web application, but I want it to open by Google Earth, the file is not located on the server it's on the user's computer but the application knows its name and path: "C:\\Places.kml"

How can I do that? I'm using ASP.NET web application in C#

Re: Opening a file in its own program??

kubben3-May-07 2:57

kubben

3-May-07 2:57

You can't open files on the users computer. You have have the user upload the file to the web server and then you can open it.

Ben

Testing Tool

jayarajmrj2-May-07 23:25

jayarajmrj

2-May-07 23:25

Can I know if there is any testing tool to test the dotnet applications?

Re: Testing Tool

Sathesh Sakthivel2-May-07 23:30

Sathesh Sakthivel

2-May-07 23:30

Being a developer you should test ur application with unit testing only.

there are lot of tools available to test the application that will be carried out by the testing or QA dept.

Regards,

Satips.

Re: Testing Tool

Brady Kelly2-May-07 23:55

Brady Kelly

2-May-07 23:55

Remind me not to hire a developer that only tests his theapplication with unit tests, or rather one that broadly asserts developers should only use unit tests. I would recommend other people also avoiding such appointments.

Re: Testing Tool

Sandeep Akhare2-May-07 23:40

Sandeep Akhare

2-May-07 23:40

In what way you want to test your application there N number of tool available in the market ...
Do you want to see the performance, Code review, etc of your application

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Testing Tool

jayarajmrj3-May-07 1:06

jayarajmrj

3-May-07 1:06

I want to see performance and Code review also

Re: Testing Tool

N a v a n e e t h3-May-07 3:25

N a v a n e e t h

3-May-07 3:25

Try to use ANTS Load or Microsoft Applcation Center Test which comes along with VS.

printf("Navaneeth!!")

www.w3hearts.com

Re: Testing Tool

firozu3-May-07 0:12

firozu

3-May-07 0:12

If you want to unit test your code than, NUnit is the best free testing tool available. You can get it from www.nunit.org

Session State

Senthil_M2-May-07 23:24

Senthil_M

2-May-07 23:24

I am using Session in a web page before page load. i.e., I have a global variable which instantiates a class where current.session is used.
My current.session is nothing when I create the object for the class.

But after the Page loads, session shows all values.

Please help..

Senthil

Re: Session State

kubben3-May-07 2:56

kubben

3-May-07 2:56

Unless you set up the global variable in the session in the global.asax session.Start event you won't exist until the first page load. Unless I am missing something here?

Ben

loosing data between postbacks [modified]

Ayman Mashal2-May-07 22:25

Ayman Mashal

2-May-07 22:25

Hi
in page_load im calling a function that retrieve data from the database

<small>private void getLocationStdHours()<br />
{<br />
	string cacheKey = "stdHoursDS";  //the key to get/set our cache'd data<br />
	LocationsBL Loc = new LocationsBL();<br />
	DataSet ds=Loc.GetLocationStdHours(vLocCode);<br />
<br />
	Cache.Insert(cacheKey,ds,null,DateTime.Now.AddHours(1), TimeSpan.Zero);<br />
	dgLocStdHours.CurrentPageIndex=0;<br />
	dgLocStdHours.DataSource=((DataSet)Cache["stdHoursDS"]).Tables[0];<br />
	dgLocStdHours.DataKeyField="rownum";<br />
	Response.Write("before : "+((DataSet)Cache["stdHoursDS"]).Tables[0].Rows.Count);<br />
	dgLocStdHours.DataBind();		<br />
			<br />
	btnNew.Disabled = false;<br />
}</small>

the data shows fine without problems
but when i click the "New Record" button which is a server control

private void btnNew_ServerClick(object sender, System.EventArgs e)<br />
		{<br />
			DataSet ds = Cache["stdHoursDS"] as DataSet;<br />
					<br />
			if(ds == null)<br />
			{<br />
				Response.Write("Session timeout - please reload page");<br />
				return;<br />
			}<br />
			.....

the Cache["stdHoursDS"] is null now !!!
but not always in some cases it works sometimes not ?

what is the problem here ?

Note : this problem just appear when i connect from outside the local lan
using VPN or the intranet . its work prfectly from my PC or other PCs in the same lan
thanks

-- modified at 4:43 Thursday 3rd May, 2007

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.