ASP.NET

SqlDataSource data reading problem ... help plz.

1-Aug-08 3:31

Hi
If i make a change to my code and refresh my webpage I can only get about 3 refreshes before it times out.
Is there a way to change this?
My webiste is runnign on sessions so I guess this is why they are timing out.
Is there a way to make the sesisons last longer?
thanks

Re: sessions timing out

Abhijit Jana1-Aug-08 3:45

Abhijit Jana

1-Aug-08 3:45

.netman wrote:
Is there a way to make the sesisons last longer?

Then why you are using session ?

cheers,
Abhijit

Re: sessions timing out

Brij1-Aug-08 3:47

Brij

1-Aug-08 3:47

Increase the "Session.Timeout" property as much you need.

Thanks
Brij Smile | :)

Re: sessions timing out

sats_katkar2-Aug-08 0:04

sats_katkar

2-Aug-08 0:04

increase the session time out period in property as much u need so that u can refresh ur site as may times u want..
Laugh | :laugh:

hey i need dot.net help as m developin an application in asp.net 2.0

dream_liner_7e71-Aug-08 1:22

1-Aug-08 1:22

SqlDataSource sds = new SqlDataSource();

sds.ConnectionString = ConfigurationManager.AppSettings[0];

sds.SelectCommand = "select datediff(day, date_, '7/26/2008') from date_tab ";

i want the result in my case the date difference from this query to print or further processing ..

thanks.

Re: REPOST ALERT!!

eyeseetee1-Aug-08 1:24

Resize the text area based on the text.

1-Aug-08 1:24

Be patient, someone will reply to your question below, dont repost

vannapragada1-Aug-08 1:10

vannapragada

1-Aug-08 1:10

Hi, I developing a Discussion forums application.

I want to show the messages for a particular question/thread from the database and display it. I am using a repeater control and using a textarea control and some label controls within the Repeater and binding them to the datafields.

The records are displayed but with a scrollbar. Then i used overflow and
now scrollbar is not shown. But even then the textarea is not resizing to the text size. I don't know how to tackle this problem.

I tried using textbox asp control and still facing the same problem.

All i need is that the textarea/textbox should not have scrollbar and should automatically resize itself based on the text and also retain the formatting such as spaces, line breaks etc.

I would be very thankful if someone can show me a way out.

Thanks in Advance,
Krishna.

Re: Resize the text area based on the text.

Perspx1-Aug-08 2:07

Perspx

1-Aug-08 2:07

Why not use a DIV and then it will resize appropriately to accomodate for the content?

Regards,
--Perspx

"The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia

Image for all screen sizes

eyeseetee1-Aug-08 0:43

Re: Image for all screen sizes

1-Aug-08 0:43

Hi
How can I get an image header to stretch to the correct screen size.
When it is viewed in a small screen the right side of the image is cut off.
How can I prevent this?
thanks

Anand Desai1-Aug-08 1:01

Re: Image for all screen sizes

1-Aug-08 1:01

You Restore Down this window also and see Code Project Header. Its also cut right side.

Anand Desai
Developer
Atharva Infotech

Perspx1-Aug-08 2:12

Perspx

1-Aug-08 2:12

I would suggest doing something like using Javascript to obtain the client width of the browser, then resizing the image accordingly based on this. For example, you could make the image width 50% of the browser client width, then using this, you could change the image height to make it in proportion with the width.

I can give you a code example if you want it.

Hope this helps,
--Perspx

Dynamically loading SQL data(ASP.NET, C#)

Matt Cavanagh1-Aug-08 0:33

1-Aug-08 0:33

Hi, i am making a webpage with asp and C# and now I have a couple of buttons with a table below. Now when the user click a button it loads the appropriate data from sql and puts it in the table. But how can i make this happen without the page refreshing? I have put the code in the OnClick of the button but the page still refreshes(which takes a while because it also reloads the images - which is why i want to do it without refreshing). I have seen this being done on phpBB forums when you quick reply.
Please help me.
Thanks Big Grin | :-D

Anand Desai1-Aug-08 0:58

1-Aug-08 0:58

Use Ajax.

There's no othr option to prevent PostBack

Anand Desai
Developer
Atharva Infotech

Matt Cavanagh1-Aug-08 1:04

1-Aug-08 1:04

So its because its causing a postback? Are there any other controls that dont cause postback's that i can use instead?

Anand Desai1-Aug-08 1:11

1-Aug-08 1:11

Debug your code. You will find its doing "PostBack" each time.

You must use Ajax to resolve it

Anand Desai
Developer
Atharva Infotech

Matt Cavanagh1-Aug-08 1:31

1-Aug-08 1:31

Sorry for being ignorant and wasting your time, but I have never use AJAX. Wouldnt i have to install something on the server for that? I have no access to the server except htdocs folder.
Also how would I do this with ajax? Can i run a C# method(like an onlclick function) that would do it?

Thanks Smile | :)

Anand Desai1-Aug-08 1:46

sqldatasource.selectcommad data retrieval [modified]

1-Aug-08 1:46

Ajax = Asynchronious JavaScript with XML

For your problem, no need to install AjaxToolKit, just search google like this "Load DataGrid using Ajax" or "Run SQL query using Ajax".

N u will find solution

Anand Desai
Developer
Atharva Infotech

IFRAME problem in IE 7.0

VB 8.01-Aug-08 0:05

VB 8.0

1-Aug-08 0:05

Hi all ,

I am creating mail compose editor in web, but iframe is not working in mozilla and the other problem are spacing b/w lines i.e, text format (Heading, Paragraph, etc. and if i refresh the page the content is missing in IFRAME .

but i found a workaround to do that .
But the problem comes with and while selecting the " text format"

like Paragraph ,Header1 ,2,3,4,5,6 Address .

The sample appl for composing

<a href="http://www.mozilla.org/editor/midasdemo/">http://www.mozilla.org/editor/midasdemo/</a>[<a href="http://www.mozilla.org/editor/midasdemo/" target="_blank" title="New Window">^</a>]

if i copy the source and paste in a notepad with .html file name and

opening it with InternetExpolrer 7.0

i am getting the spacing between lines if the format option as NORMAL . it is not consider the format as normal,considering a .

ANY WORKAROUND for spacing i.e., text format and content missing after refresh ?

Thanks

dream_liner_7e731-Jul-08 23:51

Re: sqldatasource.selectcommad date retrieval

31-Jul-08 23:51

sqldatasoruce1.selectcommand = "select * from emp";

if i want the particular result like someone emp name how to get it?

thanks.

modified on Friday, August 1, 2008 6:08 AM

eyeseetee1-Aug-08 0:09

Re: sqldatasource.selectcommad data retrieval

1-Aug-08 0:09

where emp.name = "something"

or if you are comparing to string

where emp.name = '" + stringname + "'"

dream_liner_7e71-Aug-08 0:10

Re: sqldatasource.selectcommad data retrieval

1-Aug-08 0:10

that is ok select * from emp where emp_id = 1

but now i want to print the value

how to get this value???

thanks.

Matt Cavanagh1-Aug-08 0:19

Re: sqldatasource.selectcommad data retrieval

1-Aug-08 0:19

SqlDataReader readerEmp = sqldatasoruce1.ExecuteReader();

while(readerEmp.Read())
{

int EmpID = (int)readerEmp["Emp_ID"];
//the "emp_id" is the column name in the sql database.
string EmpName = (string)readerEmp["Emp_Name"];

}

dream_liner_7e71-Aug-08 0:40