ASP.NET

Feddo0419-May-09 2:52

Feddo04

19-May-09 2:52

Hi!!

I'm using SQL Server 2005.
and I've a table of comments.

so I want to view thease comments in the page. (Like forums)

EliottA19-May-09 2:55

EliottA

19-May-09 2:55

Ok, so use a datatable.

Check out the CodeProject forum Guidelines[^]

Feddo0419-May-09 3:00

Feddo04

19-May-09 3:00

Thanks for your help

www.Developerof.NET19-May-09 2:57

www.Developerof.NET

19-May-09 2:57

Feddo04 wrote:
Hi all.
How are you?

I`m fine!!! Thank You!!!

Feddo04 wrote:
Can anyone tell me what is the best way to view the user comment as in forum?

Use a good browser. You can find one here[^]

Feddo04 wrote:
Thanks a lot...

You are welcomed !!!

When you fail to plan, you are planning to fail.

connection string

jainiraj19-May-09 2:14

jainiraj

19-May-09 2:14

I have connection sting like-

connectionString="Data Source=IpAddress,Port#;Initial Catalog=DatabaseName;uid=user;pwd=password;" providerName="System.Data.SqlClient";

here what is meaning of "Data Source=IpAddress,Port#"...
plz explain........

Re: connection string

El_Programmer19-May-09 2:19

El_Programmer

19-May-09 2:19

in Data Source you write the server where the database is.
If the database is in your local machine then you write: DataSource="Local" (or the name of you pc).

Re: connection string

meeram39519-May-09 4:58

meeram395

19-May-09 4:58

Check this,ConnectionStrings[^]

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

getting data

AndyInUK19-May-09 0:43

AndyInUK

19-May-09 0:43

Hi

There are 3 tables
table A with ID , Name, VID
table B with SID, Address , VID
table C with ZID , abc, SID

So basically, i can get the ID from the query string. Now how to get the VID, SID AND ZID from the database using known ID.
Code snippet would be really helpful if possible.

Thank you

Manas Bhardwaj19-May-09 0:58

Manas Bhardwaj

19-May-09 0:58

AndyInUK wrote:
Code snippet would be really helpful if possible.

Google for SQL Joins Rose | [Rose]

SELECT
	TABLEA.VID,
	TABLEB.SID,
	TABLED.ZID
FROM
	TABLEA INNER JOIN TABLEB ON
		TABLEA.VID = TABLEB.VID
	INNER JOIN TABLEC ON
		TABLEB.SID = TABLEC.SID
WHERE
	TABLEA.ID = @ID

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

AndyInUK19-May-09 1:06

AndyInUK

19-May-09 1:06

I am asking in ASP.Net using C#. I know sql joins. But how to get the data using C#

Ramesh Swaminathan19-May-09 1:22

Ramesh Swaminathan

19-May-09 1:22

string strQuery = "Write your SELECT query here";
using (SqlConnection connection = new SqlConnection("Database=yourdatabasename;Server=yourservername;Uid=youruserid;Password=yourpassword;"))
{
SqlCommand command = new SqlCommand(strQuery , connection);
connection.Open();
SqlDataAdapter da= new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
}

Reportviewer Print Option

padmanabhan N19-May-09 1:23

padmanabhan N

19-May-09 1:23

use that sql query in ur c# by giving connection string anf try to get it in a datatable.

Padmanabhan

nithydurai19-May-09 0:38

nithydurai

19-May-09 0:38

How can I show a printbutton in a rsweb:ReportViewer?

It shows the report and the other options, but no print button is shown.

I tried ShowPrintButton = "True"

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="625px" Width="684px" ShowPrintButton="True" ShowPageNavigationControls="True" ShowBackButton="True" ShowCredentialPrompts="True" ShowDocumentMapButton="True" ShowExportControls="True" ShowFindControls="True" ShowParameterPrompts="True" ShowPromptAreaButton="True" ShowRefreshButton="True" ShowZoomControl="True" >
<LocalReport>
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="Reports_DAL_ClientList" />
</DataSources>
</LocalReport>

</rsweb:ReportViewer>

Re: Reportviewer Print Option

Ramesh Swaminathan19-May-09 1:34

Ramesh Swaminathan

19-May-09 1:34

If you are using VS 2005, it does not support printing web page in local mode. The print button will not show even in service packs of VS 2005. But this functionality is added in VS 2008 and its redistributable.

Re: Reportviewer Print Option

manikanta.mnl29-May-09 20:39

manikanta.mnl

29-May-09 20:39

i`m using VS2008.Still i`m not getting the print button...
Please give me suggestion on this...

Waiting for your reply.. Confused | :confused:

Dispose all session when browser is closed .

sumit703419-May-09 0:34

19-May-09 0:34

Hi I want when user close his browser then all sessions will be disposed.
how to implement this. as session timeout automatically after 30 min.

thanks in advance

Manas Bhardwaj19-May-09 1:00

Manas Bhardwaj

19-May-09 1:00

sumit7034 wrote:
I want when user close his browser then all sessions will be disposed.

Do you think it is even a valid design.
What if some other user is still active and you dispose all the sesion when some one closes his browser. OMG | :OMG:

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

sumit703419-May-09 1:05

19-May-09 1:05

I want that the all sessions of that user would be abandon who close his browser.
as every browser has different sessions.

I want asp.net sessions to expire on closing the browser.

padmanabhan N19-May-09 1:06

padmanabhan N

19-May-09 1:06

//use this code when the page is closed
Session.Abandon();

Padmanabhan

sumit703419-May-09 1:09

19-May-09 1:09

what if i navigate to other page. or other page is opened in other TAB?

I want to dispose only when browser is closed not on page close.

padmanabhan N19-May-09 1:16

padmanabhan N

19-May-09 1:16

k then u are maintaining the session only by login...
so use this Session.Abandon(); in the page load of login before you start assiging the session...
so the session will be killed in the startup...

But if u r opening multiple tabs and closing one tab the session will remain...
so for this u can use query string instead of session

Padmanabhan

sumit703419-May-09 1:23

19-May-09 1:23

Thats not an Issue. the session will get expire automatically after 30 min

I don't want that server to keep session when browser is closed.

eg when u chat from gmail and if u close the browser u automatically get signed out from the chat.