True, if you do something like that. Then you should probably maintain it yourself because i don't have 10 hours trying to figure out what you were trying to do

I'm using VB.NET and Informix database I'm trying to get last serial id whenever i perform an insert statement. Here is what i have so far Insert into Table1 values (0,"Mouse") SELECT DBINFO('SQLCA.SQLERRD1') FROM systables WHERE tabname = Table1 My problem is, sometimes i get 0 as the ID although the row has been inserted Can someone please help Thanks Read, Read, Read instead of asking Why, When, Who, and How?????

use StreamWriter and just save your file a excel file dim dtData as new DataTable dtData.Columns.Add("Column1") dtData.Columns.Add("Column2") dtData.Columns.Add("Column3") dtData.Columns.Add("Column4") dtData.Columns.Add("Column5") dtData.Columns.Add("Column6") dtData.Columns.Add("Column7") Dim fInfo As FileInfo fInfo = New FileInfo("C:\test.xls") Dim sw as System.IO.StreamWriter("C:\test.xls") Dim sepator as string = "\t" Dim intColumnCount as integer = dtData.Columns.Count for i as integer = 0 to intColumnCount -1 sw.write(dtData.Columns(i).ColumnName) if i < intCount-1 then sw.write(sepator) end if next sw.Close() i hope this helps Motivation alone is not enough, if you have an idiot and you motivate him/her, you now have a motivated idiot

Thanks but i did that ecxatly, but its not working!!! i have got this on my web.config file: on my page i have this line session("fileName") = strFilename on Session_start i have Session("Started") = "True" on Session_End i have FileIO.FileSystem.DeleteFile(Session("fileName").ToString) but still it not firing... Motivation alone is not enough, if you have an idiot and you motivate him/her, you now have a motivated idiot

I have a page that creates gif images in asp.net. i stored the image name in my hashtable. now i want to delete the file when the user closes the page or when the session ends. The session_start fires ok. I have set my sessionState on web config file to but session end does not seem to fire. Please please help please help Don't argue with a fool because he/she will bring you down and beat you with exprience

I have tried that but it didn't work. I have tried a different way... I pass a variable to HTML Hidden tag FileName.Value = "C:\MyExcel.csv" Then here is A tag GetFile This work like fine, but it display the excel file on a html page. Here is what i'm doing. I have an aspx page with a button and ExportToExcel icon. When clicking on the button is should create a table using a DataTable which is returned from Database Class and create and save a csv file to C:\. On click on Export to Excel icon, it should open the saved file. Is there an easier way to do this.

Sorry for that i'm using VB here is my code Dim ExcelObj As Excel.Application Dim workbook As Excel.Workbook ExcelObj = New Excel.Application workbook = ExcelObj.Workbooks.Open(strFullFileName, 0, True, 5, "", "", True, Excel.XlPlatform.xlWindows, ",", False, False, 0, True) 'workbook = ExcelObj.Workbooks.Open(strFullFileName) workbook.Application.Visible = True workbook.Close() workbook = Nothing ExcelObj.Quit() ExcelObj = Nothing

Try this code.... i hope it helps VB. If IsDate(Text1.Text) then Text1.Text = Format(Text1.text, "dd/mm/yyyy") Else MsgBox ("Wrong Date"), vbCritical Text1.SetFocus End If

Hi I have been trying to open existing excel document from my asp.net page, it does not give me an error but it does not open the excel file. Any help i will appreciate that Thanks if isTrue Then call Stop() Else call Start()

Thank you very much, it works fine What you stand for, Put your life on

i have this button on my asp.net page, all i wanr with the button is to call a javascript function which is on a separate script. how can i called a function on the script called ValidateControl from clicking a button Thanks you vry much

Thanks All is all

Thanks I understand this using a listbox, but i'm using a ListView with 3 column and 2 rows. So what i want is get Cell1, cell2, and cell3 at the same time and insert them Aints never sleep at all, so why should I?

Please help i have a customer id in textbox, a listview listing 2 to 3 items. So what i want is to insert this into a database with out the id on the textbox changing. Which means i want to add 3 rows at the same time, without changing the id in the textbox. ID on TextBox = 1 Sample on ListView Name Descr Amount Mouse Black 20 Keyboard Black 30 USB 256MB 200 This is what i want the output to be like sample on Database 1 Mouse Black 20 1 Keyboard Black 30 1 USB 256MB 200 Please Back of i'm coding!!!!

Yes is like that

Thanks but my problem i want to close form1 before opening form2

try ToShortDateString()

How to check if the form is already open, so that it cannot be duplicatly openned

Thats real extreme. whooooooo can i get a glass of water!!!!

Thanks I have something with it. Please don't be mad at me when i have a program again with this You are what you are