|
Shivan Nandan wrote: Then the word file should be saved into SQL server table
Although there are different opinions whether this should be done or not, if you still consider storing the data into the database, perhaps this would help: http://www.codeproject.com/KB/database/SqlFileStream.aspx[^]
|
|
|
|
|
hi
in my project i want to display a report to employee by month wise achivement.
if user select starting date to ending date means it has to display
month wise . if user select 1st qtr means it has to display like this.
-------------|-------------|-------------|
....JAN......|.....FEB.....|.....MAR.....|
-------------|-------------|-------------|
target|achive|target|achive|target|achive|
------|------|------|------|------|------|
...5..|...4..|..5...|..2...|..5...|..4...|
Note:please avoid dots.
output screen is like this.. can u guide me. pls. how to do.
Frontend is asp.net using c# and backend is MYSQL
|
|
|
|
|
This is nothing but using Table and simple Database query .
cheers,
Abhijit
|
|
|
|
|
i heard in asp.net we can generate report by bar chart. can u tell how to do.??
|
|
|
|
|
jenny_anu wrote: i heard in asp.net we can generate report by bar chart.
Yes You are right !!
jenny_anu wrote: can u tell how to do.??
Which Framework version are you using , in .NET 3.5 SP1, Microsoft has provides Chart Control in build with VS2008 you can use that .
You can also use some third party componets like Dundas Chart.
or write custom code using System.Drawing , Have a look[^]
cheers,
Abhijit
|
|
|
|
|
There are lot more third party controls are available on net.Look for them.You can also use the the control provided by Microsoft.But it all depends on the requirement of your project,which suits you best use that one
Cheers!!
Brij
|
|
|
|
|
Use MochiKit, Javascript based charts.
|
|
|
|
|
can any one suggest me can i minimize loading time of crystal report viewer when i open report viewer in new page it takes 12 - 15 second to load and then execution of code stats...
on that page there is no other contorl exist except report viewer.
umerumerumer
|
|
|
|
|
From where and how many records are coming to the reports for display ?
cheers,
Abhijit
|
|
|
|
|
record displaying issue comes after the viewer gets load properly
so i thing record is not the problem. for you information only one record.
and one more thing it takes first time more time but not after it.
umerumerumer
|
|
|
|
|
Hello all
I have created a console application in c#.net to run some specific task on server.I have also create exe file so that it it will run at a given time.
When i set a task in scheduler then i have found that it dosenot allow to run exe file. It only allow file with some .bat,.cmd etc extension.
Can anybody tell me how can i create .bat or .cmd file of my console application.
Thanks
Rahul
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
rahul.net11 wrote: I have created a console application in c#.net
Then why you asked that question in asp.net forum ? Please place it proper place.
Any way for creating Batch file Try to use TextWriter
cheers,
Abhijit
|
|
|
|
|
Hi
Can you explain me in details how can i create using text writer any example?
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
rahul.net11 wrote: Can you explain me in details how can i create using text writer any example?
Try This[^]
cheers,
Abhijit
|
|
|
|
|
Thanks
i will try it and come back to you.
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Hi all
I have one procedure in sqlserver.
create procedure pro_UpdateCompanyData(@oldvalue varchar(50),@newvalue varchar(50))
as
set nocount on
Update CompanyType Set CompanyType.type=@newvalue where CompanyType.type=@oldvalue
Go
Type is my columnname in table CompanyType.
now I have one gridview on page.I did Editcolumn and add edit,update and cancle button.
i write some code on gridview_Rowupdated event.
SqlDataSource1.UpdateCommandType=SqlDataSourceCommandType.StoredProcedure;
SqlDataSource1.UpdateParameters.Add(new Parameter("@oldvalue", System.TypeCode.String, ((string)Session["oldvalue"])));
SqlDataSource1.UpdateParameters.Add(new Parameter("@newvalue", System.TypeCode.String, newvalue));
SqlDataSource1.UpdateCommand ="pro_UpdateCompanyData";
"@type is not a parameter for procedure pro_UpdateCompanyData."
this error arise in this code.
I am not getting this point.pls suggest me.
Thanks
monika
|
|
|
|
|
monika_vasvani wrote: "@type is not a parameter for procedure pro_UpdateCompanyData."
Error clearly says, you are passing wrong parameters to the store procedures.
cheers,
Abhijit
|
|
|
|
|
Dear Friend's
I have created a base class which use to set common "javascript" file to the form it's working fine but now i want to access one DIV control (which is server side) to initialize it's value as per business logic, how to access that control using the base class.....
i am creating my web form using Visual Studio 2005, using c# language.
Thanks and Regards,
Santosh A Sawant
Sasmi
|
|
|
|
|
I didn't get your point ? Do you want to access the div control from javascript which is a server side control ? Please confirm .
cheers,
Abhijit
|
|
|
|
|
No, this base class is use for some business logic inherit to my Page Partial class and i want to use it to access my DIV control which is server side control on that form.
Sasmi
|
|
|
|
|
Hi,
I know this query is not related with ASP.NET but didn't find suitable forum to post this valid web situation.
I want to know how can we prevent multiple login in ASP site using same userid and password?
Design suggestion are most welcome !!!
Thanks,
|
|
|
|
|
Jaiprakash M Bankolli wrote: I want to know how can we prevent multiple login in ASP site using same userid and password?
Using databases . When User login into your application , check is there any entry in the database with that user name or not. If not, make an entry and enter into the application. If yes, message that some one has already logged in into the application it the same credentials.
Check it on Login
if(UserIsInApplication(UserID))
{
Alert("Already Logged in with the same credentials..."
}
else
{
MakeDBEntry(UserID);
LoginApplicatin(UserID);
}
Note :
You have to implement all those methods, I have given just for your understanding
Remove the DataEntry from database when user log off Application , other wise user never be logged into the application .
Here is another Tricks , What happend , If user close the browser instead of Click on "Logoff"
[Added]
Jaiprakash M Bankolli wrote: know this query is not related with ASP.NET
Apologies. I didn't read this section . Extremely sorry.
[/Added]
cheers,
Abhijit
|
|
|
|
|
I had same design in mind but had stuck with the point that you have mentioned "What will happen , If user close the browser instead of Click on "Logoff"...
So if you have some more idea in mind let me know ...
Thanks anyways !!
|
|
|
|
|
Jaiprakash M Bankolli wrote:
So if you have some more idea in mind let me know
I had made a javascript function , that will call on the page unload if and only if , the user close the Browser ([X]), Alt+F4 and From Task Manager.
on that function , I have open a popup ( Location will not be visible to user means top=10000, left =200000 like that ) and from there I have callled the server side code to clear database .
What about yours ?
cheers,
Abhijit
|
|
|
|
|
That sounds good idea.. Let me try that, how did you trap browser close From Task Manager.
|
|
|
|