|
|
|
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.
|
|
|
|
|
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........
|
|
|
|
|
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).
|
|
|
|
|
Check this,ConnectionStrings[^]
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
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
|
|
|
|
|
AndyInUK wrote: Code snippet would be really helpful if possible.
Google for SQL Joins
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.
|
|
|
|
|
I am asking in ASP.Net using C#. I know sql joins. But how to get the data using C#
|
|
|
|
|
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);
}
|
|
|
|
|
use that sql query in ur c# by giving connection string anf try to get it in a datatable.
Padmanabhan
|
|
|
|
|
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>
|
|
|
|
|
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.
|
|
|
|
|
i`m using VS2008.Still i`m not getting the print button...
Please give me suggestion on this...
Waiting for your reply..
|
|
|
|
|
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
|
|
|
|
|
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.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
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.
|
|
|
|
|
//use this code when the page is closed
Session.Abandon();
Padmanabhan
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
It seems that somebody has given a solution in the following links:
Link1[^]
Link2[^]
Hope this will help you.
|
|
|
|
|
Perfect,
Thanks Ramesh.
allphpro
|
|
|
|