ASP.NET Discussion Boards

check this[^]

Best Regards,
Apurva Kaushal

thanks Apurva.
do u thinkis this statements are correct??

a DataSet will have all the data locally. However, this is both a curse and a blessing. It means all the data will have to be fetched before any work can be done, which may increase latency and memory usage substantially.

The Recordset is cached behind the scenes, so there will only be roundtrips to the server when needed to refill the cache.

BTW, in .NET the equivalent of a Recordset is the SqlDataReader (or equivalent for datasources other than SQL Server). It can return multiple results, but you have to process them one by one in order.

Most of the time a DataReader is the fastest method.

if u know more points let me know

thanks again
Suketh

What exactly you want to know? These things are quite correct. Dataset follows a disconnected architecture. Once you get the data from the database you are disconnected. If you again want to update the dataset with the database you again need to get connected and update it.
Here[^] you will get the details of ado.net architecture.

Best Regards,
Apurva Kaushal

I need to write code to force garbage collection and add whatever values i get in DB,How to go about it?

Mini Thomas

You can start with System.GC.Collect(). There is an overload that will allow you to specify the generation to collect also. I highly recommend you let the GC do things by itself because forcing garbage collection messes up its tuning and timing.

█▒▒▒▒▒██▒█▒██
█▒█████▒▒▒▒▒█
█▒██████▒█▒██
█▒█████▒▒▒▒▒█
█▒▒▒▒▒██▒█▒██

i fully agree with you. Why you need explicit call to GC. Can you share the reason. ?

Amit

I am writing a program to collect values u fetch from System.GC.Collect
() into DB

Mini Thomas

miniThomas wrote:
I am writing a program to collect values u fetch from System.GC.Collect

GC.Collect does not return any values.

█▒▒▒▒▒██▒█▒██
█▒█████▒▒▒▒▒█
█▒██████▒█▒██
█▒█████▒▒▒▒▒█
█▒▒▒▒▒██▒█▒██

Amit Kumar G wrote:
i fully agree with you. Why you need explicit call to GC. Can you share the reason. ?

There may be a time when memory is critical and you need to clear it out but you cant wait on the GC to do it for you. These are rare cases along with any other cases where you would explicitly invoke the GC. I believe if you build your code to where you actually need to invoke the GC manually then you need to rethink your design.

█▒▒▒▒▒██▒█▒██
█▒█████▒▒▒▒▒█
█▒██████▒█▒██
█▒█████▒▒▒▒▒█
█▒▒▒▒▒██▒█▒██

I am getting problem while running my pages on Mozilla. I am using master and content pages of VS 2005. My master page is very simple with three section i.e. Menus (left), header (company logo) and footer.

I am able to see correct formatting in IE but as soon as i run on mozilla, all formatting changed very badly. Cry | :((

..... ANY ONE KNOW WHY, IF YES how i can resolve the problem.

Point to be noted, my content section of content page is coming fine on mozila. Only header and menu section is (

Thanks for your help!!

Amit

this is a very common problem into various browser.u hav to go very deep into html to resolve tht problem.bcoz browser dosent follow a particular standard.so check ur all html tags are close and chek ur page into various browser.In the point of view of IE tht support too much html tags but mozilla and firefox dosent.so keep maintain a standard through css and html tags for ur page.

Deepak

Smile a Lots,Its Costs Nothing

I think u have used Design View which Generate Pixels. Please Go to ur HTML Code and Do code manualy. Do not touch Design. Remove Pixel's and Use % instead of Pixels.
for example there is a table which width is "width = 45px", Set this to "width = 45%".
Ur problem will be solved.

Hi all,
i am trying to learn .Net Techonolgy. please can anyone tell me how you fill a table with data from a database.?
i know we can use Data adapter to fill the data from the dataset. but i want to know this with sample example.

thanks in advance,
Rahi

If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

MSDN[^]

use System.Data.SqlClient;

SqlConnection conn = new SqlConnection("Data Source=....;Initial Catalog="databasename";User Id=sa;password=;");
SqlCommand cmd= new SqlCommand("Select * from customer", conn);
SqlDataAdapter adp=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
adp.fill(ds,"TableAliasName");

now ds contain data from table in database.
if u want display data in grid then
GridView1.DataSource=ds;
GridView1.DataBind();

anujsharma

I have 2 formview (FVRegDetails,FVPartyDetails)

FVregDetails in Insert Mode takes parameter SroOfficeNo,COnsiderationAmount,TypeOfDocument
After sucessfully Insertion In Database A RegId (Identity Column) created .

Based upon the RegId Value I need to Insert FVpartyDetails 2nd Formview which will take Parameters (RegId(which will come from database table),PartyName,PartyAddress)

How Can I get the Value of RegId in the 2nd Formview ...

Thanks

PKSAHOO

pksahoo wrote:
How Can I get the Value of RegId in the 2nd Formview ...

You can define an insert parameter with the output direction in the first formview and use this one to capture the new generated id, you then can persist the value somewhere so that you can easily get the value to pass in to the insert parameter in the second formview.

Hi.
I need a quick tutorial about object data source.
Can anyone give me a link?
I'd searched, but I didn't find any good article.

Best wishes

http://msdn2.microsoft.com/en-us/library/9a4kyhcx.aspx[^]

Try a little harder next time

only two letters away from being an asset

anyone can help me for PHP/MYSQL questions????if yes mail me on uday.kiet@gmail.com....

Try asking at the DevShed Forums[^]. They have a very active PHP community.

Jon Sagara
When I grow up, I'm changing my name to Joe Kickass!
My Blog | My Site | My Articles

Hi,

Can any body tell me how can I Increase my Cookies size.
I have a file approx 500kb and I want to store it in to the cookies for the time beeing but there is a restriction that by default Cookies size is 4kb, that's why I want to Increase my Cookies size.please provide me with a solution.

Regards
Kavi. Smile | :)

Kavi

I am not sure but i think you can not. You need to think for some workarounds.

Amit

plzz tell how file is uploaded using browser button on page. it means write code to read file,upload and browse button & write code to save and selected file to browser....

please put his code in html site and manage yourself where ever you want to save your file there is method for saveing file.

Cool

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="aaaaaa.aspx.vb" Inherits="civilesengineers.aaaaaa"%><br />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><br />
<HTML><br />
	<HEAD><br />
		<title>aaaaaa</title><br />
		<script runat="server" id="Script1"><br />
	Private Function PickupFileNameWithExtasion(byval sttr as string) as String<br />
				Dim st As String = Trim(sttr)<br />
				Dim sr As String<br />
				dim cs as String<br />
				Dim f, k As Integer<br />
				sr = StrReverse(st)<br />
				f = InStr(sr, "\")<br />
				k = f - 1<br />
				cs = StrReverse(Mid(sr, 1, k))<br />
				PickupFileNameWithExtasion = cs<br />
		        <br />
		End Function<br />
	<br />
		' Upload Files Function<br />
	    <br />
	    Sub UploadBtn_Click(Sender as Object, e as EventArgs)<br />
	     dim strLocalPath as string<br />
	     dim strFileName as string<br />
	     dim i as integer=2<br />
		Dim popUpScript As String<br />
		if MyFile.PostedFile.FileName <> "" then<br />
			'FileName.InnerHtml = MyFile.PostedFile.FileName<br />
			'MyContentType.InnerHtml = MyFile.PostedFile.ContentType <br />
			'ContentLength.InnerHtml = cStr(MyFile.PostedFile.ContentLength)<br />
			'						<br />
			' Making Path and File Name<br />
			'<br />
			strFileName = PickupFileNameWithExtasion(MyFile.PostedFile.FileName)<br />
						<br />
			MyFile.PostedFile.SaveAs(ConfigurationSettings.AppSettings("MyPath")& strFileName)<br />
			<br />
			<br />
		 Else <br />
		 End if<br />
		 End Sub<br />
		</script><br />
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"><br />
		<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1"><br />
		<meta name="vs_defaultClientScript" content="JavaScript"><br />
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"><br />
	</HEAD><br />
	<body bgColor="inactivecaptiontext" MS_POSITIONING="GridLayout"><br />
		<form id="Form1" action="aaaaaa.aspx" method="post" encType="multipart/form-data" runat="server"><br />
			<h1 align="center">Upload Your File</h1><br />
			<P align="center"> </P><br />
			<P align="center">Selec<br />
					<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT: 32px; POSITION: absolute; TOP: 208px"<br />
						runat="server" Width="77px" Height="24px">New User</asp:LinkButton>t File <br />
					To Upload to Server: <input id="MyFile" type="file" size="23" name="MyFile" runat="server"> <br />
				<input id="Submit1" type="submit" value="Upload!" name="Submit1" runat="server" OnServerclick="UploadBtn_Click"><br />
				<asp:LinkButton id="LinkButton2" style="Z-INDEX: 102; LEFT: 40px; POSITION: absolute; TOP: 176px"<br />
					runat="server" Width="43px" Height="16px">Login</asp:LinkButton><br />
				<asp:LinkButton id="LinkButton3" style="Z-INDEX: 103; LEFT: 32px; POSITION: absolute; TOP: 256px"<br />
					runat="server" Width="87px" Height="24px">Emp Longin</asp:LinkButton><br />
				<asp:LinkButton id="LinkButton4" style="Z-INDEX: 104; LEFT: 40px; POSITION: absolute; TOP: 288px"<br />
					runat="server" Width="93px" Height="24px">NewEmployye</asp:LinkButton><br />
			</P><br />
		</form><br />
	</body><br />
</HTML>

Pavan Pareta