Hi group, I'm modifying a VB.net app where I need to loop through an Excel spreadsheet for data out of two column. In essence the code will need to read: For i = 2 to end of file propNo = Cells(i, 2).Value crms = Cells(i, 8).Value If crms = "Y" Then ' Go run the routine End If Next i Unfortunately I have no idea how to get this information from the spreadsheet. I did find a link here that may explain it, but I'm not sure I fully grasp it and it seems rather long and complicated. I know …

Member Avatar
Member Avatar
+0 forum 2

Hi Friend, Could you please help me with Row level Access Data reading? What I mean to say is(PFA Screenshot) [Click Here](http://postimg.org/image/cultofmhv/) Suppose I only need to read the Row with "EmpID" AA/0141/D/12749, how can I do it? Keep in mind that It is always going to be a random row based on an Employee's login detail.

Member Avatar
Member Avatar
+0 forum 2

Hi guys I've written a very simple program that reads in some files, does some cleanup on the data and then creates a sql statement to insert the data into a table. Now I have 125 of these fies of varying sizes and on some (not all) of the files (they are csv files) there are a large number of lines that are essentially empty entries (i.e. a bunch of empty commas). The result of my code is that it seems to hold onto the last correct strings (not the empty ones) and then tries to execute the sql statement. …

Member Avatar
Member Avatar
+0 forum 3

Can any guy tell me what is the differnce between a datareader and a dataadapter? Also what are the other method to search data through SQL queries??

Member Avatar
Member Avatar
+0 forum 1

Attached are two images that I took on a Windows 7 machine. They are portions of a document that was just opened in Adobe Reader X (Version 10.1.9). One image is of a yellow ribbon across the top of the document, warning about certain data security risks. The other image shows the options available when the "Options" box is selected. If I select "Trust this document one time only", several fields of the PDF are auto-populated. However, when I open the same document on a MacBook Pro (Mac OS X Version 10.6.8, Adobe Reader XI Version 11.0.6), the yellow band …

Member Avatar
Member Avatar
+0 forum 2

hi. well got my dipploma from http://wsi.tafensw.edu.au, and the site is at : http://marvinhunkin.bmtafeweb.com. now. need a accessible, screen reader, free version of a web host or free domain, with penty of. looking to develop my next project, a blindness site. with a podcast section, uploading documents, a blog, chat application, so should i learn to do this in word press. at http://www.howtobeblind.com, going to enroll in a free course, how to build sites using word press for the blind. i have jaws, window eyes and i have office 2010, so got it free, and nvda. so, any one able …

Member Avatar
Member Avatar
+0 forum 1

Hi I'm new to Python and have the following problem. I have a excel file (csv format) that I want to open and display as a 2d list. I can read the file but can not get anyother output other than the colum headings as a single letter [h][e][a][d][i][n][g] I would like to display the file in a list as it is in the file: [[heading1][heading2][heading3] [the] [cat] [sat] [on] [the] [mat]] I have the following code but can't seem to get it to work as I wish # Use the a file reader function to open the file, assign …

Member Avatar
Member Avatar
+0 forum 1

hi guys, I have IPad 2, and currently im using Bluefire reader for DRM PDFs and GoodReader for standard PDF's, I was hoping GoodReader can support DRM but it is not. Now am trying to find some Adobe DRM support ebook readers that is faster than BlueFire and lots of features like GoodReader: What I have tried are: Txtr - Tradebit - it cropped the page Kobo - cant highlight text, define and note Bluefire - slow interaction and slow in highlight text Is it true of DRM supported readers has less functionalities? I'm looking for Adobe DRM Reader with …

Member Avatar
+0 forum 0

I am not seeing why this code will not generate the output to my JFrame after it takes the input from the text file? How can I tweak this code to do that? Take input from file and display it on JFrame... JTabbedPane jtpane=new JTabbedPane(); JPanel jpan=new JPanel(); JTextArea txt=new JTextArea(); FileReader f = null; try { f = new FileReader("PatientCollect.txt"); } catch (FileNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } BufferedReader brk=new BufferedReader(f); String s; try { while((s=brk.readLine())!=null){ txt.append(s); } } catch (IOException e1) { e1.printStackTrace(); } jpan.add(txt); jtpane.addTab("Tab1",txt); this.add(jtpane); this.setVisible(true);

Member Avatar
Member Avatar
+0 forum 2

i have have to develop a website that can read/write in information from smart card readers and save into database. i'm using C# programming language and asp.net website to do it..i have no idea how to go about doing it.pls help me...If you have sample codes or if you have knowledge in doing it...thanks you so much sir.

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a XML file: <?xml version="1.0" encoding="ISO-8859-1"?> <Report> <config repstarttime="" rependtime=""></config> <cashdrops></cashdrops> <cashsheets></cashsheets> <cspdata></cspdata> <fdremdata> <fdrementry ENTRYID=""></fdrementry> </fdremdata> <SHIFTDATA> <SHIFT_CD_Index ShiftSystemIndex="1" Shift_CD_Used="1" ></SHIFT_CD_Index> <SHIFT_CD_Index ShiftSystemIndex="2" Shift_CD_Used="1" ></SHIFT_CD_Index> <SHIFT_CD_Index ShiftSystemIndex="3" Shift_CD_Used="1" ></SHIFT_CD_Index> <SHIFT_CD_Index ShiftSystemIndex="4" Shift_CD_Used="1" ></SHIFT_CD_Index> </SHIFTDATA> <Order> <OrderHead filelocation="" filesuccess="TRUE" Attendant=""></OrderHead> <NFC1DATA nfc1count="0"></NFC1DATA> <PAYMENTDATA paymentcount="1"> <payentrydata id="1"></payentrydata> </PAYMENTDATA> <CASHBACKDATA cashbackcount="0"></CASHBACKDATA> <Product> <productdata ProdCompActive="FALSE" ProdDesc="Product1" ProdIDNum="00001" ProdQty="1"> <productsession> <productsessiondata>[CONTENT1] *1;</productsessiondata> <productsessiondata>[CONTENT2] *1;</productsessiondata> <productsessiondata>[CONTENT3] *1;</productsessiondata> <productsessiondata>[CONTENT4] *1;</productsessiondata> <productsessiondata>[CONTENT5] *4;</productsessiondata> <productsessiondata>[CONTENT6] *4;</productsessiondata> </productsession> </productdata> </Product> <histdata id="1" SYS_ID="1" DTE="20120401"></histdata> <histdata id="2" SYS_ID="1" DTE="20120401"></histdata> <histdata id="3" SYS_ID="0" DTE="20120401"></histdata> <histdata id="4" SYS_ID="1" DTE="20120401"></histdata> <histdata id="5" SYS_ID="0" DTE="20120401"></histdata> <FooterDATA footercount="0"></FooterDATA> </Order> </Report> and I …

Member Avatar
Member Avatar
+0 forum 7

Hi, I'm doing a study planner in java. I'm doing a simple login system. For every user who registers a text file is created holding all of the information inputted during registration. This is the code of a method which the program uses to login the user: public void loginUser(){ r = new Registration(); r.username = txtUser.getText(); r.password = txtPass.getText(); try{ String line; SubjectFrame subject = new SubjectFrame(); BufferedReader f = new BufferedReader(new FileReader(r.username + ".txt")); while((item = f.readLine()) != null){ if(line.equals(r.password)){ dispose(); subject = new SubjectFrame(); subject.setSize(700,600); subject.setLocation(100,100); subject.setVisible(true); }else{ System.out.println("No"); } } f.close(); }catch(Exception e){ JOptionPane.showMessageDialog(null, "Wrong information!", …

Member Avatar
Member Avatar
+0 forum 3

Hi All, am currently working on a biometrics application to capture the fingerprint of users. I am working with the DigitaPersonal (UareU 450) fingerprint reader. The app works fine at the moment but i need it to be more sophistciated by making it save the fingerprints in sqlserver database instead of keeping the binary files in memory as this causes data loss whenever the application is shut down. I would greatly appreciate any help

Member Avatar
Member Avatar
+0 forum 3

Guys i am trying to make an ASP web application for a small organization. They want is that barcode reads the information of the bill which means that whatever User have taken from a grocery store, barcode reads the 1. Bill Number 2. Amount 3. Date 4. Store Name 5. Purchased from Credit Card / Debit Card / Cash It does from a any cellphone (such as Apple, Android, Blackberry) application too. It also creates it own column after fetching up the data from the bar code. So if user wants to create some changes they can make. Changes like …

Member Avatar
Member Avatar
+0 forum 1

Okay, so this is my final assignment for a class I am taking. I'm making a Book Library Database that keeps track of all books that are entered and changed, things like that. I figured a useful feature would be saving your data in a text file so that it could be loaded again any time. I successfully managed to get the program to save my data into a text file but I can't seem to Load that text file in a way that the lines are assigned to their correct variables again. I'll attach some code... (WARNING: It is …

Member Avatar
Member Avatar
+0 forum 11

Hi guys, I have some fundamental holes in my understanding of programming, so help would be appreciated, I’ve always had a problem getting my head around it. I don't have a very strong mental model of how the code flows. My main problem is i think i understand the syntax, but not really its application. Any links people found useful would be great. Couple of questions. The code below doesn't make sense to me (written by someone else) the application is basically a csv reader, but manipulates the data. Public Sub entryType() IsEntry = entryType.Other entryID = choiceType.Unknown If entryId …

Member Avatar
Member Avatar
+0 forum 1

We are having problems with a Cherry SPOS keyboard. The cardswipe is inserting '70' (without quotes) at the end of the stream. I have been unable to find a way to eliminate this in the programming. For our application, we need to complete the stream with a carriage return ... which I also cannot get the programming to accept. The remainder of the keyboard accepts / modifies programming with no issues.

Member Avatar
Member Avatar
+0 forum 1

So I have a number of CSV files with 6 columns of numbers in each file. I would like to perform a few operations (multiplication, division etc.) on each column in each of the CSV files using Python and instead of opening each file manually, I want to add the whole folder and perform the operations on them ALL AT ONCE. [CODE] import csv r = csv.reader(open('F:\python\sample.csv','rb')) w = csv.writer(open('F:\python\sample_calib.csv','wb',buffering=0)) for row in r: a = (float(row[0])-0.0376)/-0.0717 b = (float(row[1])-0.0376)/-0.0717 c = float(row[2])/1000 d = float(row[3])/1000 e = float(row[4])/1000000 f = float(row[5])/0.001178 w.writerow([a,b,c,d,e,f]) [/CODE] This is the script I am …

Member Avatar
Member Avatar
+0 forum 1

Hi everyone, Is there a way to read the text in a pdf file like reading notepad? And after that, I should be able to use it, for example, in a text area or show it to my users without using another program such as adobe reader. That's really important for my project. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 4

Hi, could some one help in briefing about what journal reader supplemental component is or a link which can do so. The solution am finding out is, i need to convert a bmp image to svg, when i surfed through net, i got this journal reader which can be converted to svg, can i convert a image to svg with this concept..? please let me know, thanks in advance.

Member Avatar
+0 forum 0

I have this assignment where I have to make an xml that has movies names and info. Then i have to make a StAX program that locates the xml file and reads it. The program should also be able to count the number of movies in the decade. Thats the part that i cant code. I am totally blank. Can someone start me off or give me a hint. my xml is [CODE]<!ELEMENT DVDS (DVD*) > <!ELEMENT DVD (title, performers, release_year, discs, price) > <!ATTLIST DVD id CDATA #REQUIRED> <!ELEMENT title (#PCDATA)> <!ELEMENT performers (performer*)> <!ELEMENT performer (#PCDATA)> <!ELEMENT release_year …

Member Avatar
+0 forum 0

I know this question has been asked dozens of times, but the code I have been looking at has not helped me. So far I have been able to connect to the string and the database from where I need to check the username, but in my page it is not checking whether the username is correct or not. Please someone tell me what I am doing wrong and what I need to change to make this work, I have been on this for literally a week and still no success. Thank you! [ICODE] protected void Verify_Click(object sender, EventArgs e) …

Member Avatar
Member Avatar
+0 forum 2

please some one would explain me why we use Bufferedreader() instead of using InputStreamReader() only.

Member Avatar
Member Avatar
+0 forum 1

Hey guys! I started learning Python 3 four days ago and I wrote a little command line RSS Reader (~120 lines) using the [URL="http://feedparser.org/"]feedparser module[/URL]. The rss reader currently has a menu, and also receives command line arguments (run the script with "-h" or "--help" for more info). It has functionalities like adding/removing URLs from the feeds and reading those feeds. What I'm asking from you is if anyone wants and has the time to go trough my code, try the script out and get me any feedback, like what should I do next, add any new features or point …

Member Avatar
Member Avatar
+0 forum 2

Hi i want to read chm and epub file in my application , how can i do this ?

Member Avatar
Member Avatar
+0 forum 1

Hi all, I've setup a class within my software package to read generic text files. For this, I'm using the getline( ) function and then parsing each line for specific types of files. In setting this up, I've come across the ACSII incompatibilities between Windows systems and Unix systems. I struggled for a while before realising that a text file that had been created on a Windows machine contained the return carriage, which showed up on my Mac as the ^M character. I was wondering if there is any general, accepted way to deal with these discrepancies. Is it simply …

Member Avatar
Member Avatar
+0 forum 5

It's only reading every other line. It's supposed to print out: 28 80.0 22 1 2 2 3 1 3 But it's only reading: 80.0 1 2 1 [CODE]//Load button - #=daynum, $=wallet, @=inventory, &=employees, !=customers if (btn2.getText().equals("Load")){ int id=0; File file = new File("savefile1.txt"); BufferedReader reader = null; try { reader = new BufferedReader(new FileReader(file)); String text = null; while ((text = reader.readLine()) != null) { text = reader.readLine(); if (text.contains("#")){ text=text.replace("#", ""); dayNum=Integer.parseInt(text); } if (text.contains("$")){ text=text.replace("$", ""); wallet=Double.parseDouble(text); } if (text.contains("!")){ text=text.replace("!", ""); customer.setCustTotalComplete(Integer.parseInt(text)); } if (text.contains("@")){ text=text.replace("@", ""); id=Integer.parseInt(text); BuyInvItem(id); inventory.setNewInv(InvId[id], InvPrice[id], InvName[id], InvSellPrice[id], InvAmt[id], InvBuyPrice[id], …

Member Avatar
Member Avatar
+0 forum 2

I am trying to update/modify/reverse engineer the software for a robot I have. The company went out of business and some friends and I are trying to add features to the program. I use RedGate's .NET Reflector to unpack the DLL and EXE files into VS solutions, projects, and code files. The problem is that each DLL/EXE (and there are at least a dozen) all have dozens of resources stored in them. Mostly they are BAML files, which can be converted to XAML files, but there are also PNG, font files, .HEX files used to the robots themselves, etc. All …

Member Avatar
+0 forum 0

Hey! I am developing a type of an rss reader. Which fetches latest 1-2 feeds from a webserver and publishes them to a subscriber. The problem I am facing is, this [URL="http://www.feedparser.org/"]feedparser[/URL] is using etag and modified date to recognise latest feeds. It works fine with the servers which support either one of these, but how to recognise feeds with no etag and modified date? I mean, I am not able to differentiate and get new 1-2 feeds from all the enties. There must be known way of doing this because this Parser is very popular. Can anyone here help …

Member Avatar
+0 forum 0

Hello guys! I just want to ask if how can I use java file reader? I badly need this for my program... Thank you in advance! :)

Member Avatar
Member Avatar
+0 forum 4

The End.