Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:823339
More Search Options
RSS Available
Matching Posts
Re: Button click even to open crystal report
I guess this didn't work like I thought it would I am still having some problems. I have a Windows Form button that when I click on it I want to be able to bring up a Crystal Report in a new FOrm. The Form has a Crystal Report Viewer in it. How do I do this with the code I have below, this is the button click code(need to know what goes inside the button click code: private void btnReport1_Click(object sender, EventArgs e) { }
Posted to
Web Forms
(Forum)
by
bootzilla
on 12/31/2009
Re: Button click even to open crystal report
Thanks this helped.
Posted to
Free For All
(Forum)
by
bootzilla
on 12/24/2009
Button click even to open crystal report
I have a button click event but I don't know what code goes in it to open a crystal report that I have created. The code for the button click is below. I tried typing the name of the report hoping intellisense would pick it up but it doesn't. private void btnReport1_Click(object sender, EventArgs e) { } }
Posted to
Free For All
(Forum)
by
bootzilla
on 12/24/2009
Incorrect syntax near '*' error
Can someone assist me in why I receive this error on the update statement below and how to fix it. I have this statement as a part of a stored procedure. WHen I execute the entire procedure I get this error but when I highlight just the update statement and execute it updates with no errors. update monthlyinv1 set totalmiles = monthlyinv1.miles * monthlyinv1.qty, totalrate = monthlyinv1.routecost * monthlyinv1.qty from monthlyinv1 inner join RouteMaster on monthlyinv1.ROUTENO =RouteMaster.PUROUTE
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/23/2009
Re: Incorrect syntax near '*' error
I tried this and still get the same error. I can't figure out where the error is at.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/23/2009
Re: Incorrect syntax near '*' error
Here it is: ALTER PROCEDURE [dbo].[MonthlyInvReport1] --declare @date DATETIME -- --set @date = '20091223' -- --select -- cast(datename(week,@date) as int)- cast( datename(week,dateadd(dd,1-day(@date),@date)) as int)+1 --AS @S char(1), @M char(1), @T char(1), @W char(1), @R char(1), @F char(1), @A char(1), @counter int, @date DATETIME AS --Run for Sunday-- IF @S = 'S' BEGIN --highlight this section and run-- insert into monthlyinv1(monthlyinv1.ROUTENO,monthlyinv1.MILES) SELECT PUROUTE
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/23/2009
Re: Incorrect syntax near '*' error
THanks that did it.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/23/2009
Need help doing a calculation in SQL update statement in stored procedure
I need help with a calculation in a SQL update statement in a stored procedure. I am doing a insert-select combined statement by inserting into a table while selecting from another table. I then update to the table that I was inserting with fields that are not in the insert-select combined statement(hopefully this makes sense). On the update statement below I am trying to calculate the Mileage rate minus fuel times the total miles ran. So basically I need 1.3748-0.028 X DailyCSV.EMILEAGE. I am not
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/21/2009
Re: Need help doing a calculation in SQL update statement in stored procedure
I don't understand when you say I need a decimal (12,4) for Mileage_Rate and E_FuelSurcharge. Where would that go in my code and how would I code that? I am using an update statement because I am not able to insert all of the fields into the table using the insert statement because some of those fields aren't available to be inserted from that table. So I do an insert first and then go back and do an update for the rest of the fields.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/21/2009
Re: Need help doing a calculation in SQL update statement in stored procedure
Come on. SUrely there has to be someone who can help here. I tried setting a variable in my stored procedure like this and get an incorrect syntax error near '=': SET y = (DailyCSV.MILEAGE_RATE - DailyCSV.E_FUELSURCHARGE * DailyCSV.E_MILEAGE)
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bootzilla
on 12/21/2009
Page 1 of 34 (339 items) 1
2
3
4
5
Next >
...
Last »
Channel 9:
E2E: Brian Beckman and Erik Meijer - Co/Contravariance in Physics and Programming, 1 of 2
TechNet Edge:
Windows Server 2008 R2 Quick Look #3 - PowerShell V2
ASP.NET:
2009 Blogged - Greatest Hits
WindowsClient:
2009 Blogged - Greatest Hits
Channel 9:
Nikolaj Bjørner and Leonardo de Moura: The Z3 Constraint Solver
Channel 9:
MEF & Silverlight 4 Beta - Part 2, Imports & Exports
Channel 9:
MEF & Silverlight 4 Beta - Part 1, Introduction
WindowsClient:
The (Near) Final Word on Multi-Monitor Taskbars for Windows 7 - Ultramon vs. DisplayFusion
WindowsClient:
Looking back at 2009, and forward to 2010
Silverlight:
Polling Video – A Viable sub-second alternative?
TechNet Edge:
Windows Server 2008 R2 Quick Look #2 - Active Directory Recycle Bin
Channel 10:
I'm a Windows 7 PC Themes
Channel 10:
24 Years of Windows Box Art
WindowsClient:
Silverlight tutorial: HOW TO build CommandLink Control in Silverlight with Expression Blend 3 and Behaviors
ASP.NET:
Converting an RGB Color To Hex With JavaScript
Silverlight:
Silverlight HVP Design – Configuration & Scenarios
Channel 9:
Channel 9 Live at PDC09: Day 3 Welcome
Channel 9:
Channel 9 Live at PDC09: TWoC9 Day 3
Channel 10:
Microsoft's Mobicast: Stiched Cell Streams
Channel 10:
Festive Bing
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online