|
search using the keyword "crystalreport push method" in codeproject. Yu will get the result.
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi senthil its easy refer this code...,
Here i am getting values from another page so used session...,
and in crystal report i am sending the values like this:
in ur webpage backend code use this code:
Private report As CrSalaryReport = New CrSalaryReport 'CrSalaryReport ur crystal report name...
CrystalReportViewer1.ReportSource = report
CrystalReportViewer1.Visible = True
CrystalReportViewer1.DisplayToolbar = False
report.SetDatabaseLogon("sa", "Pwd") 'sqlserver login & password
report.SetParameterValue("EmpId", Session("EmpId"))'Parameter1
report.SetParameterValue("EmpName", Session("EmpName"))'parameter2
after that in crystalreport see in field explorer,parameter field add there ur parameter names...,
u can send number of parameters like this...,
It will work nice...,
Regards,
Magesh,
Magi
|
|
|
|
|
Hi
In prev. i ask worng question
I am trying sorting tech. in VJ#
Iam able to sorting fine but i stuck in retriving the Values from file
can nay 1 give me an idea on this
thx
keerthi
|
|
|
|
|
kirthikirthi wrote: I am learning J#
Unwise - J# is being discontinued.
|
|
|
|
|
Thx for reply
I dint get u
I know some basic only in Java
Iam trying in c# and VJ# .net
THX
Keerthi
|
|
|
|
|
J# is being discontinued. Therefore it will not exist soon. Learning a technology that is about to cease to exist is pointless.
|
|
|
|
|
This sounds just like the hundred or so other homework questions people post here daily.
Here's a tip - try it yourself. If you get stuck on any specific part feel free to come back and ask for specific help.
|
|
|
|
|
|
What specifically is it that you need help with? You have just posted your assignment, you don't expect anyone to do your homework, do you?
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I'd been looking around the net for a code that can delete rows in a data grid table but I just can't find any suitable ones.
What I need is that I can multiple delete it and with a message prompt before it delete all the selected one. It don't sound complicated but i just can't seems to get it done.
Would appreciate some help to open up my mind, thanks.
J Liang
|
|
|
|
|
1.First create a template column for data grid
<asp:templatecolumn>
<itemtemplate>
<asp:linkbutton runat="server" id="lnkDelete" text="Delete" onclientclick="return confirm('Are you sure?')" commandname="Delrecd" commandargument="<%# Eval("ProductID")%>">
2.set an event in DataGrid as
OnItemCommand="mydatagrid_ItemCommand"
3.Now in the code behing file in mydatagrid_ItemCommand function
protected void mydatagrid_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName.ToString() == "Delrecd")
{
SqlConnection con = new SqlConnection("connstring");
con.Open();
int pid = Convert.ToInt32(e.Item.Cells[0].Text);
String updtstr = "Delete from products where ProductID=" + pid;
SqlCommand cmd = new SqlCommand(updtstr, con);
cmd.ExecuteNonQuery();
con.Close();
mydatagrid.EditItemIndex = -1;
binddatagrid(); //this method bind data in datagrid
}
}
just follow this u will get what u want bye
PIYUSH
|
|
|
|
|
Hi Piyush,
Thanks, but at later checking, I was wondering is there a different between data grid and data view as it seems mine is data view, that whether the code used is the same.
J Liang
|
|
|
|
|
Hi All,
I have 2 webforms .First Form have one Textbox.I want to display the value of Textbox in webform2 using javascript and then compare both the textboxex using javascript.Pls send me the code.
Thanks.
|
|
|
|
|
u may use the Cross Page Posting feature if u r using ASP.Net 2.0
sreeram
|
|
|
|
|
Hi,
In my application,When member's session expires I want to redirect the member to home page where he can relogin there.This functinality is working fine in internet explorer but not in firefox.It is showing an error "Unable to Validate Data".
Can anybody helpme why this is not happening in firefox please
Thanx in Advance.
Bhanu
|
|
|
|
|
Posting the code what you used for redirection will be much helpfull
|
|
|
|
|
How to update a gridview if we have used sqldatasource and updatecommand is storedprocedure,How We can get the edited fields of gridview as a parameters for our stored procedure used here??????
PIYUSH
|
|
|
|
|
Use the SqlDataSource for this or code it your self.
I asume you will not use the SqlDataSource.
Steps:
1) fetch the GridViewRowUpdate event
2) compare old and new value
3) create sql statements
See sample(you should call your Storedproc with SqlCommand class)
Protected Sub GridViewDetectorInstellingen_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridViewDetectorInstellingen.RowUpdating
Dim newvals As IOrderedDictionary = e.NewValues
Dim oldvals As IOrderedDictionary = e.OldValues
'note TDBP1 is column name in Grid
Dim begin As String = newvals.Item("TDBP1").ToString()
Dim einde As String = newvals.Item("TDBP2").ToString()
Dim oudbegin As String = oldvals.Item("TDBP1").ToString()
Dim oudeinde As String = oldvals.Item("TDBP2").ToString()
Dim keys As IOrderedDictionary = e.Keys
'Keys are the key columns from the main key of the source table
Dim dim1 As String = keys.Item("Dimension1")
Dim dim2 As String = keys.Item("Dimension2")
Dim kid As String = keys.Item("KID")
Dim sql As String
Dim pos As Int32
If Not IsNothing(begin) Then
If begin <> oudbegin Then
pos = begin.IndexOf(":")
If pos > -1 Then
begin = begin.Remove(begin.IndexOf(":"), 1)
End If
sql = "update Elementen0 set [Value] = " & begin & " where Dimension1 = " & dim1 & " and Dimension2 = " & dim2 & " and OID = (select ID from Objecten where KID = " & kid & " and Naam = 'TDBP1')"
globalstuff.ExecuteNonQuery(sql)
End If
End If
If Not IsNothing(einde) Then
If einde <> oudeinde Then
pos = einde.IndexOf(":")
If pos > -1 Then
einde = einde.Remove(einde.IndexOf(":"), 1)
End If
sql = "update Elementen0 set [Value] = " & einde & " where Dimension1 = " & dim1 & " and Dimension2 = " & dim2 & " and OID = (select ID from Objecten where KID = " & kid & " and Naam = 'TDBP2')"
globalstuff.ExecuteNonQuery(sql)
End If
End If
'no update through SqlDataSource permitted
e.Cancel = True
'update is done through code behind so stop editmode
Me.GridViewDetectorInstellingen.EditIndex = -1
Me.GridViewDetectorInstellingen.DataBind()
End Sub
Mdv
|
|
|
|
|
i am using history.go() to go back to previous page on click of the back button .The problem is if i am adding something to the database and then going back with the back button the gridview is not getting updated since it is history page . so how can this be solved . How can i refresh the page.
pls help me out .
|
|
|
|
|
Why are you using javascript history.go() it cause the page come from Cache ?
You are trying to do 2 opposite things
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
In GridView i have used <asp:sqldatasource> for Data access and want to update through a stored procedure i have set the attributes as
UpdateCommand="Cricketers_UpdateRow" UpdateCommandType="storedProcedure"
Now for th stored procedure i want to get the updated parameters through cells of gridview than how can I get these parameters?
PIYUSH
|
|
|
|
|
|
Hi All,
I have 3 webforms .First Form have name Textbox and show button when i click show it displaying corresponding names in datagrid with checkboxes when I try to check one particular item then it will navigate to next page for updating the name,Here user should not give the same original(currentname).For that i need to print a message please select different name using javascript How?
It is simple update of name but name should different in two form. i.e should not use same name for updating.
Thanks.
|
|
|
|
|
siddisagar wrote: with checkboxes when I try to check one particular item then it will navigate to next page for updating the name,
How you are sending the name ? Assign the name in some hidden textbox. Then get the value using javascript for checking.
|
|
|
|
|
I have to compare two values in next page using javascript I haveto pass this value using Hidden field.Pls send me the code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
