|
In my Application I am creating Some Html Images Dynamically.when i select any Image i want Display Resizable Box..(Foe example when u select any control at Design Time it Display Rectangular Seletion Box Like Wise I want in my application)..
Plz Help me any One..
Thanks.......
|
|
|
|
|
how to insert and update record in grid view using stored procedure....
modified on Saturday, January 3, 2009 7:31 AM
|
|
|
|
|
Please don't ask question blindly . Try Google. There are lots of sample are available.
cheers,
Abhijit
|
|
|
|
|
After editing the new value in textbox, it sets to existing one.....how can avoid this.......
|
|
|
|
|
Check This[^]
cheers,
Abhijit
|
|
|
|
|
Label id = (Label)gvrecord.Rows[e.RowIndex].FindControl("Lblid");
TextBox fname = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtFirstName");
TextBox lname = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtLastName");
TextBox age = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtAge");
dbcom = db.GetStoredProcCommand("UPDATEVALUES");
db.AddInParameter(dbcom, "@eid", DbType.Int32, Int32.Parse(id.Text));
db.AddInParameter(dbcom, "@FirstName", DbType.String, fname.Text);
db.AddInParameter(dbcom, "@LastName", DbType.String, lname.Text);
db.AddInParameter(dbcom, "@Age", DbType.Int16,Int16.Parse(age.Text));
db.ExecuteNonQuery(dbcom);
This is the code i wrote for updating the values......i am not getting any error.....the values is not updating in the database why....
|
|
|
|
|
ksarchana wrote: why....
Try to Execute your stored procedure, manually from SQL Server with those parameter and check weather your procedure working fine or not. Then debug your code using Break Point.
BTW : Why you have deleted the original Message.
cheers,
Abhijit
|
|
|
|
|
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
|
|
|
|