|
Go through a tutorial on the Web. They're free.
|
|
|
|
|
|
Hi guys. I hope somebody can help me here. I am reading a file and checking a Database if the record exists, if the records exists I am updating the database with some other information. Now, this was working a few days ago but for strange reason it is not working now. Can somebody please have a look at the below?
foreach (GrpCombi grp in res)
{
dataTable.Clear();
dataAdapter = new OleDbDataAdapter("Select * From [Analysis] WHERE HOLDER_IDENTIFIER = '" + grp.AccountNo + "'", conn);
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dataAdapter);
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count != 0)
{
MessageBox.Show(dataTable.Rows[rowPos]["HOLDER_IDENTIFIER"].ToString());
dataTable.Rows[rowPos]["SapoBal"] = grp.AccountBal.TrimStart(myChar);
dataAdapter.Update(dataTable);
progressBar1.Invoke(new updatebar(this.UpdateGroupProgress));
}
else
{
sw.WriteLine(grp.AccountNo + "," + grp.AccountBal);
}
The error I am getting is on the line dataAdapter.Update(dataTable);. The error message reads as follows:
System.InvalidOperationException was unhandled<br />
Message="Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."<br />
Source="System.Data"<br />
StackTrace:<br />
at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow)<br />
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)<br />
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)<br />
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)<br />
at SasolDataAnalysis.Form1.GroupImport() in C:\Documents and Settings\Bernard\My Documents\Visual Studio 2005\Projects\SasolDataAnalysis\SasolDataAnalysis\Form1.cs:line 233<br />
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)<br />
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)<br />
at System.Threading.ThreadHelper.ThreadStart()<br />
I added a message box to capture the record if it is found, which it does but when it does the updating it fails. Any hel;p would be greatly appreciated.
Cheers
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Have you specified in the database table that the HOLDER_IDENTIFIER is the primary key?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
No. But the table does not have a primary key. Could that be the p[roblem?? That it doesn't have a primary key??
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: No. But the table does not have a primary key. Could that be the p[roblem?? That it doesn't have a primary key??
Yes. It doesn't know what to put in the where clause to identify the record to update if there is no key.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
|
Hi I'm writing an app that will have some Word automation, but I can not be certain if the user has already got an instance of word open, if they do i wish to use there unstance do my automation or else start a new instance. My problem is if they have it open my code makes a new instance and will close down the both instance when i finish can any one help.
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using Word=Microsoft.Office.Interop.Word;
using System.Runtime.InteropServices;
using core= Microsoft.Office.Core;
using System.Diagnostics;
namespace WordProcess
{
public partial class MainForm : Form
{
Word.Application wordApp;
Word._Document wordDocument;
object document;
object wordFalse = false;
object wordTrue = true;
object dynamic = 2;
object wordMissing = System.Reflection.Missing.Value;
public MainForm()
{
InitializeComponent();
}
void Button1Click(object sender, EventArgs e)
{
System.Diagnostics.Process[] wordPro = System.Diagnostics.Process.GetProcessesByName("winword");
if (wordPro.Length==0){
Process p= Process.Start("WINWORD.EXE");
p.WaitForInputIdle();
}
try{
object filePath =@"C:\test.doc";
object filePath1 =@"C:\test1.doc";
wordDocument = new Word.DocumentClass();
wordApp = (Word.Application)Marshal.GetActiveObject("Word.Application");
wordApp.Documents.Open(ref filePath, ref wordMissing, ref wordFalse, ref wordMissing,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordTrue,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing);
wordDocument.SaveAs(ref filePath1, ref wordMissing, ref wordFalse, ref wordMissing,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordTrue,
ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing);
wordDocument.Close(ref wordFalse, ref wordMissing, ref wordMissing);
wordApp.Quit(ref wordMissing, ref wordMissing, ref wordMissing);
}catch(MarshalDirectiveException mw){
MessageBox.Show(mw.ToString());
}catch(Exception ex){
MessageBox.Show(ex.ToString());
}
}
}
}
|
|
|
|
|
Instead of quitting if you would just kill the process that your application started, then it should work fine.
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
the problem is it checks for a process and will start one fine but if there is one running the application will start a second instance of Word up that is ties to the first
|
|
|
|
|
In that case easiest way I can think of is start new winword process through your application and then kill it without harming any other word document.
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
thats something I'm looking at present myself main problem is making sure i only close down the new process any ides would be great thanks.
|
|
|
|
|
AFAIK that if you use the System.Diagnostics.Process class and persist the object you can use it to close the specific instance of word that you opened.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
dan neely wrote: AFAIK
I am sorry but I dont know what this means.
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
As Far As I Know.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
|
i made 3 forms . 1.. frmMain(it is the mdiContainer) (form)
2........frmEditable (form)
3....... frmTools (form)
now
i just want that when i click on the rectangle button from frmTools form a rectangle must should be drawn on frmEditable form.
namespace I_M_Editor
{
public partial class frmMain : Form
{
Bitmap m = new Bitmap(2, 2);
double Zoom = 1.0f;
// PictureBox pictureBox1=null;
IDrawableImages img = null;
// IDrawableShapes shp= null;
public frmMain()
{
InitializeComponent();
img = new Images();
}
private void frmMain_Load(object sender, EventArgs e)
{
frmToolBox frm = new frmToolBox();
frm.MdiParent = this;
frm.Show();
frmEditable frm2 = new frmEditable();
frm2.MdiParent = this;
frm2.Show();
}
protected override void OnPaint(PaintEventArgs e)
{
}
private void tsxOptionOpen_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.InitialDirectory = "c:\\";
openFileDialog.Filter = "Bitmap files (*.bmp)|*.bmp|Jpeg files (*.jpg)|*.jpg|All valid files (*.bmp/*.jpg)|*.bmp/*.jpg";
openFileDialog.FilterIndex = 2;
openFileDialog.RestoreDirectory = true;
if (DialogResult.OK == openFileDialog.ShowDialog())
{
m = (Bitmap)Bitmap.FromFile(openFileDialog.FileName);
}
}
public void Rect()
{
Graphics g = this.CreateGraphics();
Pen p = new Pen(Color.Red);
g.DrawRectangle(p, 260, 260, 100, 100);
}
}
}
namespace I_M_Editor
{
public partial class frmEditable : Form
{
public frmEditable()
{
InitializeComponent();
}
private void frmEditable_Load(object sender, EventArgs e)
{
}
}
}
namespace I_M_Editor
{
public partial class frmToolBox : Form
{
public frmToolBox()
{
InitializeComponent();
}
private void lblRect_Click(object sender, EventArgs e)
{
((frmMain)this.MdiParent).Rect();
}
}
i want to draw it in frmEditable(form).
frmTools(form) contain tools from which i click lblRect (its a label)
,a rectangle should be drawn on frmEditable('s form).
can anybody correct it... if can then plz do so........
hghghgh
|
|
|
|
|
Your problem is not with the drawing part, you want to pass data from one form to another form I think.
i.e: You want to know that a rectangle was selected in the first form and draw a rectangle in the second form.
So the easiest way to exchange data between forms is to pass the reference of one form to the other form that is:
Form1 form1Ref;
public Form2(Form1 fRef)
{
InitializeComponent();
form1Ref = fRef;
}
After this you can reach the public member variables/function of form1 from form2. So if you keep the info of selected settings in a variable in form1 you can get them from form2.
PS: I recognized that unnecessary white spaces and unindented codes really disturb me. Why don't you tidy your code 
Good luck
zafer
|
|
|
|
|
Inter-child communication should be done through the parent form. This can be done with events and/or delegates.
Set up some events in frmTools, and after creating an instance of it in frmMain, subscribe to it's events.
Now that frmMain is listening to frmTools - it can pass the instructions onto your frmEditable instance which you can find in frmMain's MdiChildren collection.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
I have a textbox that I validate the value of. On the same form, are two buttons, OK, and Cancel which return DialogResults. In the validating event ii check to see if the textbox is empty, to stop empty values being inserted into the DB.
However, if I open the form and then want to cancel it (eg: close the form) because the validating event has been fired, I cannot click the Cancel button.
Anyone know a work around for this?
Regards,
Gareth.
(FKA gareth111)
|
|
|
|
|
Hi,
Validating is a bit problematic when using default events. As you noticed, you cannot move the focus from the control as long as it's not validated.
However, you can resolve this in many ways. One that comes first in mind is that you create a single validation method where you actually do the validations. This method can be called whenever you want that validation occurs and it can use error providers or such to indicate problem controls. If you return a boolean from this method indicating if validation was succesfull, you can use that boolean for example in OK button so that it doesn't perform it's actions if validation has failed. However, cancel button doesn't use the return value since it's going to cancel the whole operation. Make validation events to call this method, but nevermind the return value and never set cancel to false in validation event.
Hope this helps (and was understandable),
Mika
|
|
|
|
|
Mika,
I'd rather not do it that way, do you know of another work around?, or am I stuck with handling it my self?
Regards,
Gareth.
(FKA gareth111)
|
|
|
|
|
Sorry to say, but nothing comes in mind since if you set Cancel to true in validating-event, you cannot move focus away from the control.
Is there some particular reason why you don't want to use centralized validation?
Mika
|
|
|
|
|
|
Well, you could have Form1 register for Form2's OnClosed event. That way Form1 would be told when Form2 was closed.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
