ASP.NET Discussion Boards

First Prev Next

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

Re: getting data

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.

Re: getting data

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#

Re: getting data

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);
}

Re: getting data

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

Reportviewer Print Option

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

sumit7034

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

Re: Dispose all session when browser is closed .

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.

Re: Dispose all session when browser is closed .

sumit703419-May-09 1:05

sumit7034

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.

Re: Dispose all session when browser is closed .

padmanabhan N19-May-09 1:06

padmanabhan N

19-May-09 1:06

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

Padmanabhan

Re: Dispose all session when browser is closed .

sumit703419-May-09 1:09

sumit7034

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.

Re: Dispose all session when browser is closed .

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

Re: Dispose all session when browser is closed .

sumit703419-May-09 1:23

sumit7034

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.

Re: Dispose all session when browser is closed .

Fareeth Rahman19-May-09 4:56

Fareeth Rahman

19-May-09 4:56

Use Session.RemoveAll() in Session_End procedure of Global.asax file

Example

Sub Session_End(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the session ends
Session.RemoveAll()
End Sub

Fareeth

rdlc report error, pls help

AllPhee18-May-09 22:29

AllPhee

18-May-09 22:29

Hi all,

I have a problem with my rdlc report.When i run the website on my local machine the report works fine. But i get this error message(below) after i deploy the website on to a remote server.

I tried to search but i still cant get the solution. I really need assistance pls.

An error occurred during local report processing.The definition of the report 'Main Report' is invalid.The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

rgds.

allphpro

Re: rdlc report error, pls help

Ramesh Swaminathan19-May-09 0:11

Ramesh Swaminathan

19-May-09 0:11

It seems that somebody has given a solution in the following links:

Link1[^]

Link2[^]

Hope this will help you.

Re: rdlc report error, pls help

AllPhee19-May-09 3:39

AllPhee

19-May-09 3:39

Perfect,

Thanks Ramesh.

allphpro

Exporting to word in asp.net with c#

sarang_k18-May-09 22:16

sarang_k

18-May-09 22:16

Hi all,

I having a datatable and i want to export it to word format.In that format i want to define header footer and other type of formatting.

so can any one tell me how to do it.

Thanks in advance.

Re: Exporting to word in asp.net with c#

padmanabhan N18-May-09 22:34

padmanabhan N

18-May-09 22:34

assign the datatable in a gridview then give a button as "Export to Word"

//double click the button and write this code
protected void btnword_Click(object sender, EventArgs e)
{
Response.AddHeader("content-disposition", "attachment;filename=Information.doc");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.word";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htmlWrite);

//GridView1.RenderControl(htw);
Response.Write(stringWrite.ToString());
Response.End();
}

Padmanabhan

Re: Exporting to word in asp.net with c#

sarang_k18-May-09 22:41

sarang_k

18-May-09 22:41

No without using gridview i want to do

Re: Exporting to word in asp.net with c#

padmanabhan N18-May-09 22:47

padmanabhan N

18-May-09 22:47

u want to export the whole .aspx page to word am i correct.....

Padmanabhan

Last Visit: 31-Dec-99 18:00 Last Update: 30-May-24 15:01

Refresh

ᐊ Prev 1...1971 1972 1973 197419751976 1977 1978 1979 1980 Next ᐅ

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