hi everyone. please I am newbie. I am having a grid which is bound to different lookup tables, i want to add new rows depending on the number that is captured by a user in a textbox. eg.if the number in texbox is 4 the grid should automatically have 4 blank rows. please help. REgards

Hi everyone plz help. how do I integrate GPS coordinates to form?

Hi everyone, pls help,how can I format my datagrid to have a dropdown, I actually want one of the column to be a dropdown. Thanks in advance.

Thanks for your efforts,but it doesn't work the way I want it,maybe is because my question wasn't clear enough, ok my data in the Db is like this: Name TimeIN TimeOUT me 08:15 Null so I want it to be like this on a grid: Name Time TimeOUT Me 08:15 but when the TimeOUt field has a value in the DB it should display that field on the grid eg Name Time TimeOUT Me 8:15 4:30 I hope this clarify my question now.

Hi all. 1.pls help,I want to display a blank column on the grid when my field is null in the DB instead of NULL,and when theres a value the grid should display that value. 2.I have a button on my interface and I need it to dissappear after 20sec,how can I do that,I tried to use a timer but it doesn't dissappear, pls help with a code. Thanks.

Hi everyone. pls help,I want to display data from DB to the grid but my data looks like this: Code Name Time 1 Me 2/15/2007 10:18:00 AM and I want the grid to look like this: Code Name Time 1 Me 10:18 how do I display/formatt only that portion of time on my grid.

Hi Everyone. I am trying to delete data from datagrid here is my code: DataTable tbl = new DataTable("timesheet"); tbl = ds.Tables[0]; int i = this.iRowIndex tbl.Rows[i].Delete(); this.daDisplay.Update(tbl); I am getting an exception: "there is no row at position 0",whereas there is data in the database...what can be the proble,I can't seem to figure it out. pls help..

Hi Everyone. I am trying to delete data from datagrid

thanks,but is still not working because the datatype of TimeIN and TimeOUT is Nvarchar not datetime,I did that because I wanted to insert them as DateTime.Now.ToShortDateString();so how will I manage to get the difference of nvarchar datype fields. help....

Thank you very much,its working now. keep on the good srpirit.

Hi everyone. pls help,I am busy with the security access system which monitores arrival ,lunch and depature time,so I need to calculate the time length eg my table looks like this: Date Name TimeIN TimeOUT Length 12/2/2007 Myself 7:45 12:00 4:55 so how do I calculate that 4:55 which is the difference of TImeIN and TimeOUT,I need a sql statement or any calculation methods to do that. Thanks in advance.

let me clarify my question. I am busy with security access system for monitoring the arrival,lunch and depature time of employee,so when a user click an access card the system should check if that user has just arrived meaning that theres a record for arrival in the database,if not it should create it, so now I want a sql statement to check if theres null value in the table. my column names are: Date, Name, IN, OUT so if a user click an access card in the morning the record will be like this: DATE Name TimeIn OUT 07/02/07 Jomo 7:45 Null then when the user click the card during lunch, system willhave to check if the In and Out columns are null and insert that time on the null column, so when the user comes back from lunch it has to create a new record then the table will look like: Date Name Timein TimeOut 07/02/07 Jomo 7:45 12:00 o7/02/07 Jomo 1:00 Null so I need a sql statement which can always check if the time field is null so that it can insert time .

Hi everyone. I am stucked,busy doing an access system for monitering the arrival,lunch and depature time of employees.I need a sql statement that checks if the timein and timeout column are null in the table. pls help. kind regards Minkinin.

Hi Guys howz it? hmmm I'm still a newbie pls help,I have been given a task to write a class which will be used to send emails and sms,I 've no Idea where to start,I tried to google just get working application but I dont understand some of the concepts,pls help. Thanks.

just check this article it helped me. www.codeproject.com/cs/database/ImageSaveInDataBase.asp I hope it will help u too. :laugh::laugh:

Thanks Turbochimp!! I used a picturebox inside a panel with scrollbars & fixed size,and is working exactly as I wanted. Thanks a lot Guys!!!:laugh:;P

Hi guys howz!! I 'm trying to retrieve an image from the DB,how can I get the size of that image and display it on a picturebox,or what else can I use to display an image,'cause the picturebox doestn't have a scroll so as to be able to scroll & see the whole image?? pls help with a c# code. thanks in advance

Thanks a lot Colin,this is exactly what I wanted and is working perfect;P

pls guys help,how can I update more than one record in the table,actually I need to update dates,adding 12 months to the dates. eg. data from DB date approved expiry date 2005/05/12 2005/11/12 2005/05/28 2005/11/28 2005/06/28 2005/12/28 so how to I add 12 months to the date approved so as to get the expiry date extended with 12 months. getting something like this: latest data expiry date 2005/05/12 2006/05/12 2005/05/28 2006/05/28 2005/06/28 2006/06/28 pls guys pls I need a C# code to do that.;P

Hi Guys I'm still new in development,I need a C# code to scan a document & to save it to the DB pls help..:zzz: