|
Hey there,
I am trying to edit a datagrid. Whenever I click the edit button the grid enters edit mode. But when I change the text in the textbox and click the update(link button) the textbox always goes back to the previous text that was in it.
How do I extract the text from the textbox in the datagrid without losing my change.
below is my code for the update process:
public void Update_dgMilage(object sender, DataGridCommandEventArgs e)
{
TextBox StartMiles = new TextBox();
TextBox EndMiles = new TextBox();
TextBox PersonalMiles = new TextBox();
TextBox BusinessMiles = new TextBox();
TextBox TotalMiles = new TextBox();
StartMiles = (TextBox)e.Item.Cells[3].FindControl("txtStartMiles");
EndMiles = (TextBox)e.Item.Cells[4].FindControl("txtEndMiles");
PersonalMiles = (TextBox)e.Item.Cells[6].FindControl("txtPersonalMiles");
BusinessMiles = (TextBox)e.Item.Cells[7].FindControl("txtBusinessMiles");
TotalMiles = (TextBox)e.Item.Cells[8].FindControl("txtTotalMiles");
string connectionString = ConfigurationSettings.AppSettings["connectionString1"];
OracleConnection con = new OracleConnection(connectionString);
con.Open();
string SQLText = @"update appl_support.HSC_LEASED_CAR_MILES set RPE_MILE_START = '" + StartMiles.Text.ToString() + "', RPE_MILE_END = '" + EndMiles.Text.ToString() + "', PERSONAL_MILES = '" + PersonalMiles.Text.ToString() + "', BUSINESS_MILES = '" + BusinessMiles.Text.ToString() + "', TOTAL_MILES = '" + TotalMiles.Text.ToString() + "' where LCM_PKEY = '" + e.Item.Cells[1].Text.ToString() + "'"; //e.Item.Cells[1].Text.ToString()
// assign query and execute
OracleCommand cmd = new OracleCommand(SQLText,con);
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
//gets datagrid out of edit mode
dgMilage.EditItemIndex = -1;
getLeaseMilage();
}
Please Help anyone
|
|
|
|
|
I think you should be checking IsPostBack to enter the EditEventHandler to avoid the superflous databind.
|
|
|
|
|
Hi!
I'm retrieving mail body text and I need to convert it into multipage tiff file if text does not fit in one A4 size Page. I'm using System.Drawing.Printing.PrintDocument class. I'm facing these problems.
1. It passes the file onto Printer but I need to save it to the disk.
2. I'm not able to get all the text in tiff file, only some portion is returned.
If there is any other class in Dot net framework 2.0, which can be useful here Please let me know.
Many thanks
Saurabh Gupta
Software Engineer
|
|
|
|
|
Hi
PrintDocument.Print always causes a Print. to save a multipage Tiff you must do the following:
1. take a look at http://www.codeproject.com/cs/media/SaveMultipageTiff.asp[^] this shows you how to create multipage Tiffs
2. a Multipage Tiff contains one or more Bitmaps so:
- Create a new Bitmap for each page you want to print and set the Size of it to the size of one Page
- Create a Graphics - Object with Graphics.FromImage
- Paint on the Bitmap like you would on the Printer
- Use the Library from 1 to save your Bitmaps into 1 Multipage Tiff Document
hope this helps
greets
m@u
|
|
|
|
|
hi every one
iam a beginer learning c#. please suggest me some good books
(M.BALA SUBRAMANYAM)
|
|
|
|
|
C# 2005 Step By Step.
Use this with Express C# (its free) and you have your self a very cheap starter pack for development.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
|
See if you can lay your hands on the following book
- Microsoft Visual C#.NET step by step.
by John Sharp,Jon Jagger
Its been given a good rating by several publishers. 
Keshav kamat
|
|
|
|
|
You can also go for the following most trusted series of the complete reference
C#: The Complete Reference
By Schildt, Herbert
Still I will try to find more easier books for beginners.
Keshav Kamat
India
|
|
|
|
|
This is again one of the best book for beginners
C#: A beginners Guide
by Herbert Schildt
Its been given a 4.5 rating.
I remember, I just happened to glance through this book.
Its certainly good.
Keshav Kamat
India
|
|
|
|
|
hi,
When I give a button a colour, I can see it in design window. But when I simulate the program the button will be gray. There is something like appearance = "default" but I can't see it by the button (in the properties window).
Could it be that there is a bug in Visual studio 2003 when I program for WindowsCE.
The weird thing is, I can change the font and textheight and also the colour of the form.
Only the color of the button I can't change.
greetz
|
|
|
|
|
Could be your target OS or framework does not support colored buttons. Try using an image button instead.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
hi i want to create a dsn in sql server authentication pls help me..
|
|
|
|
|
Take it this is a file DSN ?
http://www.connectionstrings.com/[^]
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
|
I make a program and when I run it I can create a component (textbox,...) and I can move and resize this component. I pt a property grid to see component's property and I can see them. But when I move or resize the component the propertygrid didn't auto update. I can't use propertyGrid.Refresh...because that include multiple operations ...
Do you have any idea?
10x
|
|
|
|
|
I think I knwo what you mean, I assume you are developing ASP.NET ie web
You can try and put the grid in Div and set the grid to be 100% width and height. Scroll bars should also kick in as required. Try and use flow layout as well
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
I need that in a WindowsApplication in C#
|
|
|
|
|
Hello
I'm using windows xp the debugge engine always appear if there is any error
in the apps running specialy with the internet explorer 7. I want to stop it
from doing this .
Dad
|
|
|
|
|
Go into the settings for IE and turn off script debugging there.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thanks
but I fond it disabeled although the debug engine appear and turn off the web page can i turn it off from the .net
-- modified at 13:01 Tuesday 6th March, 2007
Dad
|
|
|
|
|
Hi
I am creating SSIS package programmatically from flat file to oledb destination. I am creating the source column using IOreader. after executing the package i found junk datas in the oledb destination.
It is due to column and row delimiter value. Both are same.
But i am setting column row limiter as , and row delimiter as "\r\n".
After executing the package i am seeing both row and column delimiter are same how to solve this problem could any one help me please.
I cant copy and paste the code due to restricted access to net.
kesavan
|
|
|
|
|
Hello,
I want my app to install some programs befor it's installation
but I dont know how.
Dad
|
|
|
|
|
Use a custom installer class that will do this
You can override Install(), Commit(), RollBack() and Uninstall() to do what you need. This is not an easy task in .NET 1.1 and many (even MS) opt for 3rd party install tools such as Wise.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
Hello guys,
I am really in need of a book advice about CsGL. I will appreciate any help (book, website etc.)
Thanks in advance and best regards.
.:: Something is Wrong ::.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
