User Profile

george1106 · Aug 12 '08, 06:19 PM

link to excel reader

Hi! i've been using this article to solve some problems about reading excel files, it gets a dataset with all the worksheets the workbook has as datatables.

i hope it works, I can't remeber if it's allowed to put third party links, it's from codeproject. if it's not allowed, please tell me :D

this is the link

if it doesn't works, here it is
http://www.codepr...

george1106 · Jul 31 '08, 03:35 PM

I recomend u to use the asp.net controls, the asp:textbox so u can refer it by code directly. it is a better server control.
[HTML]
<form id="form1" runat="server">
<div>
<asp:TextBox ID="IdTextbox" runat="server"> </asp:TextBox>
</div>
</form>[/HTML]

in this way u can access the element easyly....

george1106 · Jan 28 '08, 06:04 AM

hi!
that sounds to me like u want to terminate some excecution.. try with a return(); statement. it finish whatever you're doing and bring you to the previes stack position in your app ejecution..

hope it helps :D...

george1106 · May 14 '07, 02:48 AM

Hi! try inserting a string with the next format:

year/month/day hh:mm:ss

something like String.Format(" {0}/{1}/{2} {3}:{4}", date.Year,date. Month,date.Day, date.Hour,date. Minute)

to give to the DB engine a common string wich is accepted at least in SQLServe, Postgres and Oracle

I hope it helps :D

george1106 · May 7 '07, 01:49 PM

Try defining the thread you are creating manually as a Background worker,
when you define the thread

thread t = new thread(new threadstart(fun ction));
t.IsBackground = true;
t.Start();

check that.. I'm not shure the property is named IsBackGround, it says something like that.. but with that property activate that thread finishes when the main thread finish.

I hopy it helps you :D...

george1106 · Mar 13 '07, 02:30 PM

Hi there!

I found the solution.. I just needed to create a new object with an IDBCommand wich I make an instance with the kind of the original connection (I used a switch)

IDBConnection conexion;
switch(original Connection.GetT ype().ToString( ))
{
case "System.Data.Sq lConnection":
conexion = new SqlConnection() ;
break;
case "NpgsqlConnecti on":
conexion...

george1106 · Feb 27 '07, 12:26 AM

you can't use it like that.. you should specify the screen.

ej.

Rectangle rect = Screen.AllScree ns[0].Bounds;

you must put AllScreens and the screen wich you mean to check, and then you can obtain the bouds.

i hope it help :D

george1106 · Feb 26 '07, 11:55 PM

talking in a sample.. you should put in the IsMDIParent = true

and when you make instances of the parent children, you whould write

Form forma2 = new Form();
forma2.MdiParen t = this;
forma2.Show();

that should work. :D

george1106 · Feb 26 '07, 02:50 PM

thank you. it helped a lot :D

george1106 · Feb 26 '07, 02:34 PM

Hi.

look, there are a few Objects in the framework... you can use them to know about your screen..

the main object to do it is the Screen Object. I use it to create a form that should not move out the screen...

if (this.Left > Screen.AllScree ns[Screen.AllScree ns.Length - 1].Bounds.Right - Properties.Sett ings.Default.ta manno.Width)
this.Left = Screen.AllScree ns[Screen.AllScree ns.Length...

george1106 · Feb 19 '07, 02:42 PM

Code:

/* these are my declarations: */
        /// <summary>
        /// conection to db
        /// </summary>
        private IDbConnection conexion = null;
        /// <summary>
        /// command used in multiple queryes
        /// </summary>
        private IDbCommand command = null;
        /// <summary>
        /// reader to hold data

...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

calling winlogon window :D

Leave a comment:

Leave a comment:

replicating a IDBCommand conection

Leave a comment:

Leave a comment:

Leave a comment:

DataTable.Load gets blanks