hi sir i am connecting the reportviewer to dataset but i am fail.i am using following code.please help me. using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using Microsoft.Reporting.WebForms; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ReportViewer1.Visible = false; } protected void Button1_Click(object sender, EventArgs e) { } protected void Button1_Click1(object sender, EventArgs e) { ReportViewer1.Visible = true; SqlConnection con = new SqlConnection("server=DC-12\\SQLSERVER2005;uid=sa;pwd=start;database=Vikas_Data"); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "seldata"; string pn = TextBox1.Text; cmd.Parameters.AddWithValue("@pn", pn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataAdapter adap = new SqlDataAdapter(); adap.SelectCommand = cmd; DataSet ds = new DataSet (); adap.Fill(ds, "table"); ReportViewer1.LocalReport.ReportPath = "MyFirst.rdlc"; ReportDataSource rds = new ReportDataSource(); rds.value=ds.Tables[0]; ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.Refresh(); } } there is no error .but data will not be show in report viewer. please help me .as soon as possible .what may be the issue.

hi sir, please try to understand my problem.and me some help.i am waiting for your help. thanks

thanks sir i tried your suggestion.but problem was same.if i am login from pc1 and at the same time i am trying to login from another pc then both are working while according to my requirement second should be on login page.that means both ip of the system are same is it possible? on the page load i am doing this. string ipaddress = Request.ServerVariables["REMOTE_ADDR"]; if (usr_val.Tables.Count > 0) { if (usr_val.Tables[0].Rows.Count > 0) { string ip = usr_val.Tables[0].Rows[0]["ipaddress"].ToString(); HttpBrowserCapabilities bro = new HttpBrowserCapabilities(); bro = Request.Browser; if(ip==ipaddress ) { if (bro.Browser.ToString() == expl.ToString()) { Session["Roles"] = "Admin"; Session["customer"] = usr_val.Tables[0].Rows[0]["userid"].ToString(); Session["sessionid"] = usr_val.Tables[0].Rows[0]["sessionid"].ToString(); Response.Redirect("Admin/AdminHome.aspx"); } } } } is there another way for take the ip of client system?

yes sir, actually i am sending you my code behind. please consider this. using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Login_Bl; using message; using General_Bal; using ChecknetConnection; [Serializable] public partial class Default : System.Web.UI.Page { LoginBl objloginbl = new LoginBl(); GeneralBal objgeneral = new GeneralBal(); public static DataSet usr_val = new DataSet(); public static DataSet usr_val_usr = new DataSet(); protected void Page_Load(object sender, EventArgs e) { txtUserId.Focus(); if (Session["loginfailed"].ToString() == "1" ) { WebMsgBox.Show("You Have Been Signed Out.As Another User Has Signed In With Your UserID"); } string ses = Session.SessionID; if (usr_val.Tables.Count > 0) { if (usr_val.Tables[0].Rows.Count > 0) { string sess = usr_val.Tables[0].Rows[0]["sessionid"].ToString(); string expl = usr_val.Tables[0].Rows[0]["explorer"].ToString(); HttpBrowserCapabilities bro = new HttpBrowserCapabilities(); bro = Request.Browser; if (bro.Browser.ToString() == expl.ToString()) { Session["Roles"] = "Admin"; Session["customer"] = usr_val.Tables[0].Rows[0]["userid"].ToString(); Session["sessionid"] = usr_val.Tables[0].Rows[0]["sessionid"].ToString(); Response.Redirect("Admin/AdminHome.aspx"); } } } if (usr_val_usr.Tables.Count > 0) { if (usr_val_usr.Tables[0].Rows.Count > 0) { string sess = usr_val_usr.Tables[0].Rows[0]["sessionid"].ToString(); string expl = usr_val.Tables[0].Rows[0]["explorer"].ToString(); HttpBrowserCapabilities bro = new HttpBrowserCapabilities(); bro = Request.Browser; if (bro.Browser.ToString() == expl.ToString()) { Session["Roles"] = "User";

yes sir, you both are absolutely right.but please suggest me where i am wrong in my second post. and give your suggestion for this. thanks

hi sir, if you never mind sir.i want your yahoo id thank you very much sir.

thank u sir, i was doing the same as you are saying.and i am entering browser name also in my loginentry table(temp table). so that suppose if user login from ie browser and now he opens new ie and enter login page of application then user should not have login page because user has logged in once and it shows direct user home page.but if he enter login url in mozilla or any other browser then he should have login page. but at the same time if i am opening my login page from another system then again user home page is displaying.but it should be login page.

Hi Sir, I want to add an facility to my application that if a user is login with user id Admin from pc-1 and then at the same time another user is login with same user id Admin from pc-2 then user on pc-1 should be log out and should have a message "You Have Been Signed Out.As Another User Has Signed In With Your UserID". please help me. one more issue is that if user does not logout and directly close the browser then user should be logout.

hi sir, i am new in asp.net.sir i want to know that is there any java script with the help of which we can stop page reloading at the time of using ajax control.and dropdown text selection. sir i know that update panel can do this.but sir i do not want to use update panel.i mean i want to stop my page reload without using update panel while i am using ajax. please help me sir i am posting my this question again. because first time i did not get any response.

thanks you very much sir for your support, i have an another issue.please suggest me.what should i do. when ever i am entering my url in browser ie and login page will display and i am doing successfull login.and now when i opened new browser and enter url it will show direct user home.it is absolutely right.but now sir when i am entering my url in mozilla or new browser.it should not show user home.it should show login page.but it shows user home. if you will try for gmail through ie.after login if you will open new gmail in mozilla it will not show inbox page while it will show login page. please suggest me how i can resolve this issue.

hi sir please help me my problem is that if once a user is logged in then there should not be visible login page again after entring url. i mean suppose i have entered gmail.com in ie and login then if i again open gmail.com in new ie then login page is not there.while inbox page is open.i also want the same for my application.and on login page load i have done this. if (Session["customer"].ToString() == "Admin") { Response.Redirect("Admin/AdminHome.aspx"); } and i am giving my value to Session["customer"] on login click button from txtuserid.so that's why it gives me error.object reference not set to an instance of an object. please suggest me another suitable way to solve this issue.

modified on Saturday, March 27, 2010 5:02 AM

hi sir, i am new in asp.net.sir i want to know that is there any java script with the help of which we can stop page reloading at the time of using ajax control. sir i know that update panel can do this.but sir i do not want to use update panel.i mean i want to stop my page reload without using update panel while i am using ajax.

hi sir, yes why not i can see you my java script.it is below.and i am using this on input textbox keypress event.but one more issue is that it's working fine if i am use it in mozilla or ie 6,7 but not in ie8 only. function number(e) { var key; var keychar; if (window.event){ key = window.event.keyCode; }else if (e){ key = e.which; } else return true; if((key == 8) || (key == 0)) return true; keychar = String.fromCharCode(key); keychar = keychar.toLowerCase(); if((key > 47) && (key < 58)){ return true; }else return false; }

hi sir, please help me sir.i want to block integer for textbox1 and character for textbox2.actually what java script i am using works fine for explorer 6,7 and mozilla but not in ie8.and i have enable all the script from tools-internet option-custom.but nothing works.please support. thanks

suppose your report mypersonal.rpt is in Reports folder then u can use string root = Server.MapPath("~Reports/mypersonal.rpt"); otherwise string root=Server.MapPath("mypersonal.rpt"); may this will help you. please post your comment if this helps you.

thank u sir but which application i am running locally same application i am deploying on server.but i am facing the problem on server.while all the dll's in web.config and bin folder are same as locally running application on server. please help me.

hi sir, please help me sir.i am new in asp.net and i am developing an application on asp.net.and i am using crystal report.sir my crystal report is working fine locally.but sir it is giving error on server when it loads.and the error message is this . An error has occurred while attempting to load the Crystal Reports runtime. Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly. Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information. i am unable to understand that what could be the problem.and for crystal report i am adding following assemblies in web.config and same dll in my bin folder. add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" add assembly="CrystalDecisions.ReportAppServer.CommLayer, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" sir please help me as soon as possible because date of submission of this project has passed.

hi sir, actually server datetime format is yyyy-MM-dd so that's why i want to convert my dd-MM-yyyy format to yyyy-MM-dd. and for this i am using str.ToString("yyyy-MM-dd").but this was not working. i am unable to understand why it converts in yyyy-dd-MM. please help me for this conversion. thanks,

hi sir, i want to convert my dd-MM-yyyy to yyyy-MM-dd. and i am using ToString("yyyy-MM-dd") but it return yyyy-dd-MM. please help me. thanks

yes sir, i am agree with you sir.but sir i am changing date to MM/dd/yyyy format.with the help of function.and it is right on locally while on server.it gives that error.