|
ALTER PROCEDURE [dbo].[UPDATEVALUES] @eid as bigint,@FirstName as varchar(50),@LastName as varchar(50),@Age as int
Update Name set FirstName=@FirstName,LastName=@LastName,Age=@Age where eid=@eid
END
stored procedure is executing properly.....
|
|
|
|
|
First, write stored procedure in sql. next, in front end get txtbox value
in some other variable and call that stored procedure name.
Make also sqlconnection......
|
|
|
|
|
while editing the new value is not set into textbox......The textbox shows only the existing value.......
|
|
|
|
|
Then try three tier architechture.. That problem may arise in file system.
also use DatabaseFactory
|
|
|
|
|
see this
http://www.codeproject.com/KB/cs/N-Tier22.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
Hello friends,
My idea is given below.
While clicking a button, mas-word should open within the browser with an existing Template file (.dot). After typing its contents and clicking save button, it will come back to the aspx page. Then I will fill other details of the file in aspx page and finally click Submit. Then the word file should be saved into SQL server table.
I should be able to open that word file later from SQL server table itself.
Can anybody give the code for this logic
Regards
Shivan
Shivanandan C V
|
|
|
|
|
My Suggestion, Never store files on SQL Server, Stored files on Hard Drive and Store the path into Table , retrieve the files name from database and open the file from corresponding path !!
cheers,
Abhijit
|
|
|
|
|
Shivan Nandan wrote: While clicking a button, mas-word should open within the browser with an existing Template file (.dot).
That's not possible in web application. You have to provide an option for user to download the template file. Let them fill it and come back to your webpage for uploading it.
Shivan Nandan wrote: hen the word file should be saved into SQL server table.
Try to avoid keeping files in SQL server unless there is a strong need for that. Keep the file in server HDD and store the path in database. Files are kept in SQL server database in BLOB fields. You have to use varbinary(max) type.
|
|
|
|
|
N a v a n e e t h wrote: Try to avoid keeping files in SQL server unless there is a strong need for that
Just for curiosity, why not to store the documents into SQL Server.
|
|
|
|
|
That realy depends. I felt difficulties to manage the files which are kept in database. On a shared hosting, you will have limited database space and more HDD space. So keeping files in database will increase DB size and you will run out of the limit easily.
For accessing the file, you need to query the database, and write to response with correct content type. If the file is in HDD, you only have to take the file path from DB and redirect to it.
Since files are stored in varbinary column, I think no SQL functions can be applied to it. So IMO it is pointless. Please correct me if I am wrong
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
