Comments by Salisu Shaibu (Top 48 by date)

Hello Seniors.
I know you've come out to help me.
And I quite appreciate that.
But expect you to identify the DataTable and a field from the study of "query".
Unless their is something else you want to let me know.
Just make it plain please, I'm here to learn.
Nice attempt.
Thanks.

Ya Afzaal Ahmad.
Thanks for the assumtions about me and my problem.
I truely don't know much about Objects but curiosity was my drive.
Your respond is indeed a blessing.
Thanks.

So sory to have left you to dance in the dark for long Bill.
Something happened and I could not follow up with solutions to my propblem.
The fact is, I'm working on individual students.
Trying to compute performances within semesters or accadamic sessions.
Being it accadamic, Physical, Social, Religous, etc.
While each feild or property could have two or more items to deal with in the manner examplified above.
Hope you understand, thank you.

Thanks for the info.
I'm going right away.
Thuogh I've solve it myself.
Thanks.

I understand; still remain.
Let me put it this way:
My query is working well without "where...." even if I use only " .... where YEAR = 'year'"; or ".... where [YEAR] = 'year'"; in string format.
If dont specify a row, the whole field gets update automatically.

I've checked but all is intact.Appreciating you all for the time and effort, I noticed something after discarding the query, I build it bit by bit while I test all my moves.
Problem only set in whenever I include "where ....." but I need to specify where to edit else all cells in a column ends up updated.
Assist me to move on please.
Thanks.

I use phone, I skiped some, they are all .Text.
Appreciating you all for the time and effort, I noticed something after discarding the query, I build it bit by bit while I test all my moves.
Problem only set in whenever I include "where ....." but I need to specify where to edit else all cells in a column ends up updated.
Assist me to move on please.
Thanks.

I replaced the ',' with 'and'.
It didn't work.
Appreciating you all for the time and effort, I noticed something after discarding the query, build it bit by bit while I test all my moves.
Problem only set in whenever I include "where ....." but I need to specify where to edit else all cells in a column ends up updated.
Assist me to move on please.
Thanks.

Appreciating you all for the time and effort, neither of your opinions got me to destination.
But I noticed something after discarding the query, build it bit by bit while I test all my moves.
Problem only set in whenever I include "where ....." but I need to specify where to edit else all cells in a column ends up updated.
Assist me to move on please.
Thanks.

Appreciating you all for the time and effort, neither of your opinions got me to destination.
But I noticed something after discarding the query, build it bit by bit while I test all my moves.
Problem only set in whenever I include "where ....." but I need to specify where to edit else all cells in a column ends up updated.
Assist me to move on please.
Thanks.

Note: All the txt(s) in the query are with .Text. THANK YOU!

Yeh Mr. DamithSL!
It was OK.
I had to close my access database and open again to see effect.
Thanks man.
+5!!

Sory, I mean:
Mr. Damith SL,
The output is "System.String[]" and no edit of the database at all.
Thanks.

Mr. Damith SL,
The output is "System.String[]" and no edit at all.
Thanks.

Thanks alot Afaal Ahmad.
What I realy mean is that - just like string, double or object type declaration, is there any type declaration that can keep data saved parmanently like Access, Excel, txt file database?
Guide me on how to do it please!

I'm so sory, u were right.
I've post the error message below.
Thanks.

I'm so sory, u were right.
I've post the error message below.
Thanks.

The message is:
Operation must use an updateable query.
Details:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException (0x80004005): Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at IVC_eRegister.clsDataManager.editDataBase(String query, PictureBox B, Control[] A) in C:\Users\Shaibu Salisu\Desktop\IVC_eRegister\IVC_eRegister\clsDataManager.cs:line 283
at IVC_eRegister.frmNewProgram.btnCreate_Click(Object sender, EventArgs e) in C:\Users\Shaibu Salisu\Desktop\IVC_eRegister\IVC_eRegister\frmNewProgram.cs:line 61
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
IVC_eRegister
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Saliheen.Inc/Sijeel/IVC_eRegister.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version

Mr. Richard, ur lnk was cool but I've been cracking my head on certain type or object that is still preventing me from using the codes I got from the link.
They are "arrColumnLefts" & "arrColumnWidths"; under Begin Print Event Handler and Print Page Event.
Please help me again to clear those codes off error on my program.
Thank you.

No error its just that I can't complete the codes to do what I really want to do.
Please help!

The issue is, I can't complete the codes to do what I really want to do.
Please help!

The solution was:
// put these two lines outside the loop.

Thank you!!!

You were very correct!

Mr. U're good.
Thank you very much.

Form application I mean. I've seen some mini-applications without Windows installer. My application convert SI unit of length to other 12 units.

The Tutorial set failed to open on my PC but I've download the windows SDK samples, perhaps after installation, I would find solution to my problem. Thanks very much.
Mr. NIXXXX

OK, thanks.

Sorry;
OS = Operating System.
What I am referring to, is that collection of words (e.g. in English(US), English (UK), Arabic, e.t.c) in the Operating System that gives window applications the ability to recognize error in spelling, sentences and punctuations, and also suggest list of words for users to make choice.
Hope I was able to communicate.
Thank you.

Well I appreciate ur contributions. I was truly being unprofessional in find solution to my problem. All ur advise are perfect. I must be attentive if I wanna learn better.
Thanks a lot guys.
U're appreciated.

I'm actually new to this and I thought that questions pour in online per seconds while the chance of getting solution to my problem keep diminishing by the minutes. How can I remain my question current to helpers online for hours please?

I got ur comment on the latest post Matt, I was only trying to be stubborn but now I know there is no other way.
Thank you.

I tried to use:
public void ClearControls(params TextBox[] A, params String[] B)
so that "NAME", "SEX", ... can be added on implementation but error line hints that "parameter array must be last parameter in a formal parameter list".
What am I supposed to do please?

10Q man;
Perfect!!!

Not exactly what I wanted but very useful to my code vocabulary.
U're appreciated.
Thank you.

Thanks a lot for taking me on revision, I was too minded on advance way of doing things and became ignorant of the simple ways I use to do things.
U're appreciated.

Thank very much. You solved the problem.

Thanks very much man, just perfect.
You're appreciated.
Shaibu.

@Wes Aday:
I mean, no execution!
Thanks.

@ OriginalGriff:
Thanks Man, its perfect but I actually prefer ActiveControl.Text.Contains(....) method for other uses.
You're really appreciated.
Shaibu.

@ OriginalGriff:
Thanks Man, its perfect but I actually prefer ActiveControl.Text.Contains(....) method for other uses.
You're really appreciated.
Shaibu.

Thanks very much Johannesnestler, I removed all the codes on my Program class and edited yours on it then, placed the btnOpen_Click as you'd advised.

My only problem now is MainForm.child2 = new this.MdiParent as MainForm;

Its displaying error.
Just a little more correction please.
U're appreciated.