We have some list of files to copy from a ftp server. Sometimes the file in the source folder have files arrived on same date but @ different time and I would like to copy only latest file for each date. Ex: abc_sky_2014-01-15XYZ03-05-00.Dat abc_sky_2014-01-15XYZ03-08-00.Dat abc_sky_2014-01-16XYZ008-10-00.Dat abc_sky_2014-01-16XYZ008-13-00.Dat abc_sky_2014-01-16XYZ008-16-00.Dat From above files I want to fetch only the latest files for each date : abc_sky_2014-01-15XYZ03-08-00.Dat, abc_sky_2014-01-16XYZ008-16-00.Dat Can someone please help.
scottichrosaviakosmos
Posts
-
group by latest file -
check array value existsits working. cheers J.
-
check array value existsi have a function which returns a string array. the array may or may not have value. how to check if the array has any value. In the below code how to check in if codition. i want to keep the looping option as last. I would like to check in 1 line statement. I tried indexof, contain and exits option but all of them are for checking a specific value in array and not to check the whole array if it has any value presence. below is the sample code. main() { string[]victory=war(); if(victory as any value except null) then { } else { } } public string[] war() { step 1..... return some string array }
-
remove items from Listboxyes.
-
remove items from ListboxOk, let me explain in details. I have a form which has 2 listboxs, textbox and 2 buttons. lst1 and lst2. Also has 2 buttons "add" and "Remove". lst1 is populated from a database table which has 2 fields : "Name" ad "emailid". lst1 will show items "name" from table column "name". eg: ronny, danial... when i select an item(name) in lst1 and click Add button then the name will be added in lst2(lst2 is not connected to datasource). Also the displayvalue member or emailid with respect to the name selected in lst1 will be added to the textbox.(this is working fine). Now, when i select an item in lst2 which was added from lst1 and then click on Remove button then the item(name) should be removed from lst2(this is also working fine) and also the emailid corresponding to the value(name) selected in lst2 should be removed from textbox. emailid on selectitem of lst2 is not getting removes since the lst2 is connected to database. lst is adding its item from lst1. I hope now the scenario is clear.!:| Cheers
-
remove items from Listboxok, but what about valueid which is populated when i add items in lstbox2 from listbox1. i have a button "ADD". when i select item in listbox1 and click add button item is added to listbox2 and so as its valueid in textbox. but when i click on remove button the item will get removed from listbox2 but valuid for that item is removed from textbox. This is because listbox2 is not databound and valueid is generated from listbox1.
-
remove items from ListboxI have 2 listboxs. 1st one is data bound and secound one is populated by selecting 1st. eg: listbox1 jenny rock when i click listbox 1 items it also appear in listbox2. now when i click listbox1 item 2 things happen: 1. listbox2 populates with same item selected in listbox1. 2. a textbox which gets valueid from listbox1 item select. So now, when i try to remove item from listbox2 then itm should be removed from the list and the valueid in textbox related to the item should also be removed. I have tried o do this by selecteditem property of listbox but it didn't work. since listbox1 is data bound but listbox2 is not.
-
date manipulationdear i also can do this but i by taking variable u can pass single value but i want to achieve this by query.
-
date manipulationdeclare @tbldate table(stdid int, sdate date, eddate date) insert into @tbldate values (100, '20100102', '20100505'), (101, '20100203', '20100302' ) i want my result set as check if day in date is 01 if not then make day as 01 and increment month my 1. i have the solution but thats in 2 temporary table and i want full solution in a single table.
-
new lineselect gender,amt,age,[address],class , Case when gender= '' then 'gender,'when gender is null then 'gender,' Else '' End + Case when amt = '' then 'amt,'when amt is null then 'amt,' Else '' End + Case when age = '' then 'age,'when age is null then 'age,' Else '' End + case when [address] = ''then 'address'when [address] is null then 'address,' else '' End + Case when class = '' then 'class,'when class is null then 'class,' Else '' End As [Error Remarks] from mytable The above query is used to check if any of this row is blank or null display the result in a column name "error remarks" . Now the result i m getting is : gender, amt, age,address,class all this result is displayed in a single line in a single cell. now i want the result to be displayed in different line: like this: gender, amt, age, [address], class all this is single cell with the above query. i had tried char(13) and 10 . and the value is coming in new line but in sql server textmode and not in grid mode . i want data to be in grid mode.
-
How to populate textbox by databaseHi all, I am a beginner and have many doubts.some of them sorted out but in some i m stuck.here is the one: i have a databse and a table in that. ex tbl1 with columns firstname and lastname. i have 2 textboxes on my form and want to populate those text boxes from the table. i tried one techniquie using datareader but it is showing the last data of the table. i want on formload the first row to be populated on the specific textboxes. secound problem is that i want to transfer the data in this form to another page as it is and populate controls of another form by value of this form controls.
-
retrieve data from dynamic aspx form and its controlsI have generated dynamic database table in which the colums will vary as per the selection by the end user. Now, if my table name is car which i have generated dynamically on the button save click event it will have its colums like: colour, gears etc. So can i generate a dynamic form by taking the cars id and its column name as the textbox controls on the new form. The new generated form will also have the basic funtionality of add, edit,delete etc. If my table is car then to generate dynamically car.aspx form or if table is computer then computer.aspx should be generated.
-
WF : how can i use workflow with asp.net web formi have a flow example : page A, page B page C. and i have to go from one page to another like A>B>C and these pages are web forms .How can i make a sequence flow from web forms . please tell me in detail as i am new to programming .
-
Windows Wrokflow foundationWindows Workflow foundation(WWF): I am new to .net 2008 and i am a fresher. I have just learned some bits of practicle programming but know i want to know basics and use of WWF in .net 2008. since i am working on simple webforms and database which is of basic level so i want to know why we use WWF and how we use this. even on net i have found most of the learning examples in console application ,which is not comfortable for me . Please give me some links for some WWF learning videos or learning materials for beginners.
-
Windows Workflow FoundationWindows Workflow foundation(WWF): I am new to .net 2008 and i am a fresher. I have just learned some bits of practicle programming but know i want to know basics and use of WWF in .net 2008. since i am working on simple webforms and database which is of basic level so i want to know why we use WWF and how we use this. even on net i have found most of the learning examples in console application ,which is not comfortable for me . Please give me some links for some WWF learning videos or learning materials for beginners. please guide me as a teacher to fresher. Thanks.
-
Search Pagefolks i was not asking for u to do allt this things , but since i am a fresher so i was expecting that i ll be getting help in steps , ie what to do and how to do . the first problem i m facing is to fetch tha data from table i dont know hoe to fetch and if somehow fetch then how to populate according to demand. but i m realy upset people making fun of my problem , but u people had also been freshers one stage , anyway, if u cannot help then please dont make fun of someone .
-
Search PagePlease solve my issue . i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview. now i am going t describe everything:. i have a table suppose tbl_update which having following coloums: tb_id int file_id int App_Type nvarchar(50) Role_id int Field_Name nvarchar(50) Old_Value nvarchar(50) New_Value nvarchar(50) Form_Name nvarchar(50) Cycle nvarchar(50) Date datetime(50) Now about the form: In the form i have 5 Dropdowns whose id's are: 1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct) 2)case name (should populate from File_id coloum of table) 3)Cycle (should populate from cycle coloum of table) 4)formName (should populate from form_name coloum of table) 5)fieldname (should have to populate from field_ name column of table) now the conditions are as : 1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown, and also when i select cycle the case name should be changed and affected or should be populated. 2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then fieldname dropdown should be populated. And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the button search the searched value will be shown in a gridview. please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query. I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle . i am attaching the snapshot of the database table so that a clear view can be made. Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever he/she finds suitable for validations can add that also. Please , this is very urgent.... hope will get support from members. Thank You.
-
redirecting page to another pageihave a asp.net page having some textboxes and dropdownlists , and one checkbox , i want that when i check checkbox and click the sibmit button then this data of the page should be redirect to next page but with the checkbox to be transfered as checked and readonly. and also i have three textboxes whose values are taken froma datebox which i created from javasript. so i want this date value also to be transfered to the next page. the next page is of data updation so in the next page all this value will be send and when in that next page i can click update button and then i will get be redirect or get a update success message on the same or another page . my 1st page name is first_page 2nd page name is secound_page database table name is enf_data please tell me how to do all this.
-
dropdownlist data fetchplease nelson send the reply fast , if posible then by today . thank you
-
dropdownlist data fetchi have one dropdownlist suppose: ddl_Technologytype and a textbox: txt_technology. i have a database name: tech . and 2 tables in this database : tb_techtype and tb_ tech ddl_technology have some items , such as ASP,C, VB,JAVA.. and one item as OTHERS . Now the issue is that when i select the item OTHERS from ddl it shows the textbox ie txt_technology. and now i have to enter some text to the textbox. So, i will enter the text and then i will click submit button, at this time if the text that is entered in textbox is already present in the ddl then we have to show a message popup "Value is already present in the list" and if text in textbox is not present in ddl then should get added in ddl items when next time i open the page . and we have to use the database, and would also like to know the process without database . Please can anyone help me out since i am a beginner , i want solution from both using database and without database. Thank you.