|
I have a web form in asp.net and C# on the basis of selection from the dropdown i fill a dataset then assign that dataset to a reportdocument
datasource. that data set fills, but when the report is loaded there
is no data . I also have a Dataset1.xsd file which has a table with
same structure as that is filled with data in SP
In crystal report i have selected project data as dataset1.tablename
Pls help....
Code is as below
int sbu = Convert.ToInt32(ddl1.SelectedItem.Value);
report=new CrystalReport1();
string conn1 = " ";
SqlConnection conn = new SqlConnection(conn1);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("sp_cis",conn);
DataSet Dataset1 = new DataSet();
DataTable Temp = Dataset1.Tables.Add();
Temp.TableName="CISTemp";
SqlCommand cmd = new SqlCommand("sp_cis",conn);
cmd.CommandType= CommandType.StoredProcedure ; cmd.Parameters.Add( new SqlParameter("@hlevelid",sbu));
da.SelectCommand=cmd;
da.Fill(Dataset1,"CISTemp");
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath("CrystalReport1.rpt"));
myReportDocument.SetDataSource(Dataset1); CrystalReportViewer1.ReportSource = myReportDocument;
CrystalReportViewer1.DataBind();
|
|
|
|
|
Hi,
I have a DataList listing the items a customer has added to their shopping cart. The quantity value of each item in the cart is displayed in a textbox (also happy to go with a DropDownList).
I need for the customer to be able to simply change the textbox value (or DropDownList value), and then this automatically update the cookie which corresponds to this item.
My problem is that i dont know how to transfer the DataList row data to a usable codebehind class/method. Normally if say using a button its a simple case of adding a CommandName to the button, which is called from the codebehind when the button is pressed.
Any help would be greatly appreciated.
|
|
|
|
|
I have created login1.ascx
and using that in newlogin.aspx
when user clicks a linklable in newlogin.aspx
I need to display login1.ascx but the rest of page should be transperant
reg..
prashanth,
s/w Engineer,
Syfnosys.
|
|
|
|
|
pashitech wrote: I need to display login1.ascx but the rest of page should be transperant
Once page is rendered and shown in the browser, there is no separation like user controls and page. All the controls including user controls will be rendered to produce the single page. That said, you won't be able to do what you are asking.
|
|
|
|
|
please refer to
www.seventymm.com
in the bottom(footer)
click on contct us
I just want to display like that, but directly user control
prashanth,
s/w Engineer,
Syfnosys.
|
|
|
|
|
Place a div that covers the entire page with a semi-transparent background image (png). Place the control on top of that div.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
hi,
i am developing a web application in asp.net (c#), when i m logged in related entries are made in database. similar with logout, now suppose if i logged in and my net connection is failed. how can i check this and make logout entries in database.
need urgently, please
thanking you in advance.
Ratnadeep Raul
Web Developer
|
|
|
|
|
AFAIK, there is no efficient method to do. You need to keep the time when user logged in. And update the logout time from a scheduled job by comparing the login time. This scheduled job should run at specified intervals.
|
|
|
|
|
hi,
i m developing chat application. i have used iframe which displays chat message. what i want is when i write message in textbox and click on send button. iframe should scroll down to show the latest message.
please someone help me, i need it urgently
|
|
|
|
|
Hi
I have a query which is inserting a value into datetime field in a database. It shows the error:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated."
Any help woudl be great thanks!!
DateTime dttimenow = DateTime.Now;
dttimenow.ToShortTimeString();
lbtime.Text = dttimenow.ToShortTimeString();
string sttiming = lbtime.Text;
SqlCommand insertusername = new SqlCommand("INSERT INTO table(Startdate) VALUES
('" + stdate + "') ", con);
|
|
|
|
|
delete from table
where field< dateadd(day,-1,getdate())
cheers!!
|
|
|
|
|
Hi,
try with the following statement for inserting value into Datetime field
string sttiming = DateTime.Parse(DateTime.Today.ToShortDateString(), System.Globalization.CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat)
instead of ur
DateTime dttimenow = DateTime.Now;
dttimenow.ToShortTimeString();
lbtime.Text = dttimenow.ToShortTimeString();
string sttiming = lbtime.Text;
code.
|
|
|
|
|
Hi,
I have developed one Web application. At that time my system had a FAT file system on it and this application worked properly. But now i have converted FAT file system to NTFS file system and whenever i am trying to run this application then it through the exception. I have used MS Access as a database. The error is as follows...
Server Error in '/ASG' Application.
--------------------------------------------------------------------------------
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Source Error:
Line 150:
Line 151: //Execute command
Line 152: cmd.ExecuteNonQuery();
Line 153: }
Line 154: //Repeat above steps until last line is read from file
Source File: c:\inetpub\wwwroot\asg\csvtodb.aspx.cs Line: 152
Stack Trace:
[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
ASG.CSVtoDb.BtnOk_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\asg\csvtodb.aspx.cs:152
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
I have checked security setting for the datbase. but still it returns same exception.
Any body can tell me what is the problem here?
Thanks
Pravin
|
|
|
|
|
|
|
How can I clear the history of a browser page... Urgent
Gopinath.R
|
|
|
|
|
I think you can't clear the history
you can disable the cache for your pages
Why do you want to clear the History of browser
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Probably the page is dodgy and he doesn't want so much evidence of it existing on the browser for a casual user to find.
|
|
|
|
|
i need to replace one page to another page without saving the browser url history in the same window. Coul u help me.
I got one solution ie window.location.replace(URL) but it only works in IE, not in firefox...
Gopinath.R
|
|
|
|
|
vingo_mail wrote: Urgent
If it is urgent then please pay for support. This is a volunteer forum and we can only help when time allows.
|
|
|
|
|
how weird wonder what this guy has been doing!!
|
|
|
|
|
Hi,
is there any way to bind the value to header text of gridview control???
i have the value in dataset.but i could not bind into grid...
Nothing is Impossible. Keep always Smiling...
|
|
|
|
|
u can try this
DataGrid1.Columns[0].HeaderText=ds.Tables[0].Rows[0][0].ToString();
|
|
|
|
|
very very thanks its works fine.......
Nothing is Impossible. Keep always Smiling...
|
|
|
|
|
Hi I have created a user control and I am using this user control in loging.aspx
my requirement is when user control is desplaying the rest of the page should become dull(I MEAN I WANNA APPLY OPACITY-AS I USED TO DO IN WINforms)but,
I am unable to meet this req. in webforms
please help me with a solution
thanks
prashanth,
s/w Engineer,
Syfnosys.
|
|
|
|