|
Hi,
I have a datagrid which I filled with a dataset. I set the datagrid to read-only..
I wish to delete the selected row of the datagrid. The only problem is how I determine which row is selected in order to deleted from the database???
I have already tried using the currentcell property of the datagrid and getting the row number to determine which row in the data table was selected.. the only problem with that is if I rearrange the elements of the datagrid (order alphabetically) then the currentcel row number does not much to the corresponding row in the database, thus I end up deleting the wrong row??
How can I get the correct selected row and match it up with the row in the actual database??
I greatly appreciate all help!!
|
|
|
|
|
mdolby wrote:
the only problem with that is if I rearrange the elements of the datagrid (order alphabetically) then the currentcel row number does not much to the corresponding row in the database, thus I end up deleting the wrong row??
I don't think this is true. It sort DataSet too so it will delete correct row. how do you delete it.But what ever you do you can perform it like this:
Your table must have a KeyField, when you select a row for delete get value of it and delete from databse by using that field.
Mazy
No sig. available now.
|
|
|
|
|
Hi,
i am just learning web services with .net and have created a small one, then deployed it so it is a .dll file.
can somebody point me in the right dirrection for connecting my web page to use this service
thanks
col
|
|
|
|
|
chekc out the articles here but basically create a wsdl file. use the disco and wsdl utilities with .net or click on the project name in the solutions explorer and click add web reference then naviaget to the wsdl file you created
I would read a tutorial article on here first though
|
|
|
|
|
Hi, All:
I'm writing a Windows Form client that utilizing DIME to invoke a web service layer on the server that in turn exposes Visual SourceSafe's COM interface.
The ObjectDisposedException occurred whenever I try to invoke more than one web method after I open the SourceSafe's database. I always receive "Can not access a closed file". The above mentioned exception is occurred in mscorlib.dll. Does any one knows how to find out about the file that causes this exception? Any advise will be greately appreciated.
Harry
|
|
|
|
|
Hi,
I need help in asp.net C# programming.
I have a requirement to add a picture and data table to Excel sheet programmatically from a C# asp.net application.
I am using Windows 2000 Server with Office XP installed.
Additionally I also installed Office XP PIA's (available as download in Microsoft site).
I have added Microsoft Excel 10.0 Object Library & Microsoft Office XP Web Components (COM) references to the project.
There is no probelm exporting data to the xlsheet.
I have a probem when I add picture to the xlsheet.
Following is the code, I am trying to execute.
using Excel = Microsoft.Office.Interop.Excel;
using OWC10;
private void Button1_Click(object sender, System.EventArgs e)
{
try
{
Excel.Worksheet xlsheet1 = new Excel.WorksheetClass();
OWC10.ChartSpace objChartSpace = new OWC10.ChartSpaceClass();
addPictureToExcelSheet(objChartSpace,xlsheet1);
xlsheet1.SaveAs(Server.MapPath(".")+"\\"+"test.xls","XLS","","",true,false,false,"","",true);
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlsheet1);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objChartSpace);
xlsheet1=null;
}
catch (System.Exception e1)
{
Response.Write(e1.Message);
}
}
private void addPictureToExcelSheet(OWC10.ChartSpace objChartSpace,Excel.Worksheet objSheet )
{
try
{
string strPicFileName;
Excel.Shape objPicture;
int sizeX = 800;
int sizeY = 600;
strPicFileName = Server.MapPath(".") + "\\flag_uk.gif";
objChartSpace.ExportPicture(strPicFileName, "gif", sizeX, sizeY);
objPicture = objSheet.Shapes.AddPicture(strPicFileName, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, 0, 0, sizeX, sizeY);
}
catch (System.Exception e)
{
Response.Write (e.Message);
}
}
I have also made my application to run as a single threaded application. (using ASPCompat = "true").
I get Exceptions & error messages.
Could anyone provide a better solution to my problem. OR tell me if I am missing something here.
Thanks in advance,
Vidya
Vidyar
|
|
|
|
|
I want to control the number of instances of my application and if this number is greater than a fixed number, give the focus to one of the opened instances.
Any suggestion??
Iván Fernández
|
|
|
|
|
|
hi, I am using following code to invoke my DLL and it's functions.
Assembly assemScenarioPreview = Assembly.LoadFrom(Some Path);
Type typeScenarioPreview = assemScenarioPreview.GetType(...);
Object obj = Activator.CreateInstance(typeScenarioPreview);
MethodInfo methodofScenarioPreview = typeScenarioPreview.GetMethod("Run");
methodofScenarioPreview.Invoke(obj, null);
methodofScenarioPreview = typeScenarioPreview.GetMethod("CleanUp");
methodofScenarioPreview.Invoke(obj, null);
In first chance it's get executed. but next time it throws an Exception.
"Exception has been thrown by the target of an invocation"
If I closed the client then then again ran the same code. it works..
What is the possible problem ..
|
|
|
|
|
Generally, a try/catch block around this will let you see what the exeption says about itself. Very useful stuff. Do something like the following, and you'll get information about the exception. (Also, be aware that the InnerException memeber may need to be looked at in some rarer occasions.)
try
{
// Your code here.
}
catch (Exception err)
{
System.Diagnostics.Trace.WriteLine(err.ToString());
// or
MessageBox.Show(err.ToString());
}
John
"We want to be alone when we hear too many words and we feel alone when it has been a while since anyone has spoken to us." Paul David Tripp -- War of Words
|
|
|
|
|
Please help me if you know the answer to this. I want to create a dataAdapter, that fills a dataSet. However, I have a stored procedure that I want to use, that takes one int as input. I have been trying this for a few hours now, and have come no closer.
|
|
|
|
|
Design time:
You have to set your parameter to the Parameters collection of the Command object.
Run time:
Use the Add method of the Parameters collection to create a Parameter object for the parameter in the stored procedure.
SqlCommand[^]
"If a jug falls upon a stone, woe to the jug. If a stone falls upon a jug, woe to the jug. Always woe to the jug"." - KaЯl
This signature was created by "Code Project Quoter".
|
|
|
|
|
Firstly, what is the best way to delete some text. What I want is the number "563.5423" to become "563.54".
|
|
|
|
|
See Remove or Substring or Replace methods of string object
Hi,
AW
|
|
|
|
|
when i use tabcontrol,i find that there is no property for the tabpage to visible or unvisible.i want make tabpage1 to visible but tabpage2 to unvisible,but beacause there some progress need controls on tabpage2,so i can remove tabpage2,i just want to make it unvisible.how can i make that?
thanks
|
|
|
|
|
Only by removing/adding from Controls
Hi,
AW
|
|
|
|
|
I have a figure that I want to fill with black color, but it don't work!!
private void button11_Click(object sender, System.EventArgs e)
{
System.Drawing.Graphics formGraphics = null;
System.Drawing.Pen myPen;
formGraphics = pictureBox7.CreateGraphics();
myPen = new System.Drawing.Pen(System.Drawing.Color.Black,1);
formGraphics.DrawLine(myPen, 4, 4, 50, 4);
formGraphics.DrawLine(myPen, 4, 4, 4, 100);
formGraphics.DrawLine(myPen, 50, 4, 50, 100);
formGraphics.DrawLine(myPen, 4, 100, 27, 120);
formGraphics.DrawLine(myPen, 50, 100, 27, 120);
SolidBrush Brush = new SolidBrush(Color.Black);
Point point1 = new Point(4, 4);
Point point2 = new Point(50, 4);
Point point3 = new Point(4, 4);
Point point4 = new Point(4, 100);
Point point5 = new Point(50, 4);
Point point6 = new Point(50, 100);
Point point7 = new Point(4, 100);
Point point8 = new Point(27, 120);
Point point9 = new Point(50, 100);
Point point10 = new Point(27, 120);
Point[] curvePoints = new Point[]
{
point1,
point2,
point3,
point4,
point5,
point6,
point7,
point8,
point9,
point10,
};
formGraphics.FillPolygon(Brush, curvePoints);
myPen.Dispose();
formGraphics.Dispose();
}
Any idea?
|
|
|
|
|
So I'm doing something like :
[Category("Visual"),
DefaultValue(XXXX)
]
public Color MyColor { get{..} set{..} }
What should I put in XXX to get my color initialized correctly .. whatever I put in it, I get a wrong value or color !!
Cheers,
MrPink
|
|
|
|
|
Color.Black is what you want?
Mazy
No sig. available now.
|
|
|
|
|
Well,
[
...
DefaultValue(Color.Black),
]
Does not work 
|
|
|
|
|
What about:
[
...
DefaultValue(KnownColor.Black),
]
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
Let me rephrase the question...
/\ |_ E X E GG
|
|
|
|
|
Were you going to rephrase the question in this post or another one?
John
"We want to be alone when we hear too many words and we feel alone when it has been a while since anyone has spoken to us." Paul David Tripp -- War of Words
|
|
|
|
|
funny he lost the thought
|
|
|
|
|
NO. I'm just to damn fustrated with this stupid little thing I need my program to do....
and I don't know how to do it...
it's dumb...
I don't know how...
and I just want someone else to do it...
/\ |_ E X E GG
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
