ASP.NET

Resize the text area based on the text.

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

eyeseetee

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

eyeseetee

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

Re: Image for all screen sizes

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

eyeseetee

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

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

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

1-Aug-08 0:40

sorry no such thing SqlDataSource.ExecuteReader() ?????

Matt Cavanagh1-Aug-08 0:49

1-Aug-08 0:49

ok, ur misunderstanding. Heres code from something i did a while back. just adapt it to your needs.

sqlConn.Open();
SqlCommand cmdShowCat = sqlConn.CreateCommand();
cmdShowCat.CommandText = "SELECT * From Type WHERE TypeName LIKE '[R]%'";
SqlDataReader readerShowCat = cmdShowCat.ExecuteReader();

while(readerShowCat.Read())
{
string TypeName = (string)readerShowCat["TypeName"];
catagoriesLabel.Text = catagoriesLabel.Text + "
" + TypeName;
}
if (catagoriesLabel.Text == "") { catagoriesLabel.Text = "Sorry, there were no results."; }

sqlConn.Close();

dream_liner_7e71-Aug-08 0:54

how to handle database transactions...in asp.NET

1-Aug-08 0:54

koolprasad200331-Jul-08 23:43

koolprasad2003

31-Jul-08 23:43

hello frndz,
I am very confused, which transaction level should i use ???
What i want to do is , I have to insert 1000 value in a database table n i used transaction handling concept for that purpose.
My Isolation level is "READ COMMITED" but if any other user try to insert record in same table then it will retun me TIME OUT exception.

i think it will lock whole table till i completed my transaction...

what can i do for it ???

can i lock that perticular rows which i inserted???

any other hint ??? that table should not get locked ???

I have Sqlserver 2000 and .NET 2.0

thanks in advance
koolprasad2003 Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how to handle database transactions...in asp.NET

Anand Desai1-Aug-08 1:06