• Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in sql data import

    Excel is formatting the number. Open excel and set the desired format for those columns. First select the column: ![2c3a3bd75a4df2f9283ee563f1501fb8](/attachments/small/2/2c3a3bd75a4df2f9283ee563f1501fb8.png "align-left") Next set the formatting: ![c536ebac45fe03bdcf1984565daa2667](/attachments/small/2/c536ebac45fe03bdcf1984565daa2667.png "align-left") Click okay and …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in add text to a multiline textbox

    That would be an example of table structure. You will need to design your tables accordingly. Remember to [normalize](http://en.wikipedia.org/wiki/Database_normalization) your tables to ward off any redundancy that is not necessary.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching add text to a multiline textbox

    every combobox selection is replaced with what a user has selected, I want it not to be replaced so that all seleced combobox can be printed
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in add text to a multiline textbox

    It seems as if you are storing prices in another form? May I suggest storing prices into a database? Something as simple as: tblItems ID | Int ID Not Null …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Gave Reputation to Reverend Jim in Fun with Coding

    If you use BigInteger as in Private Sub FibWrite() Dim sw As New System.IO.StreamWriter("d:\temp\fib.txt") Dim n0 As BigInteger = 0 Dim n1 As BigInteger = 1 Try For i = …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Created Fun with Coding

    If you are browsing this forum, it is a safe assumption to believe you know of the [Fibonacci Series](http://en.wikipedia.org/wiki/Fibonacci_number). After having a couple of minutes, and some random thoughts, I …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Fun with Coding

    If you are browsing this forum, it is a safe assumption to believe you know of the [Fibonacci Series](http://en.wikipedia.org/wiki/Fibonacci_number). After having a couple of minutes, and some random thoughts, I …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Help on coding behind search button

    how can i code a search button to retreive all data by using client number or client surname
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Help on coding behind search button

    There are a few extra details that you have left out. 1) What kind of method are you using to store your data? 2) What kind of method are you …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching vb.net code

    using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in vb.net code

    As cgeir has said, we can't see any code thusfar. As for the SQL I will give you a little bit of a hint. "SELECT tb1.Column1,tb2.Column1,tb3.Column1 FROM Table1 tb1, Table2 …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Problem with oledbconection.

    You should just call Obj_CommandF.ExecuteNonQuery() Without the using statement. It is not needed. Also a note is that the command given has no qualifiers therefore will clear the whole table.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Problem with oledbconection.

    here a piece of vb code where i have a problem: If G_ObjConnectionTemp.State = ConnectionState.Closed Then G_ObjConnectionTemp.Open() End If ' at this stage the connection is verified to be open …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Problem with oledbconection.

    The [Using](http://msdn.microsoft.com/en-us/library/htd05whh.aspx) statement will close and dispose the object when it reaches the end of the using block.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Role based security

    how to insert y and n in database through checkboxes in a grid using telerik
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Role based security

    First and foremost, you might want to check Telrik's forums for assistance on the problem that you are having. From a 30,000 ft. view it sounds as if you are …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in VB.net User authentication login through SQL/VPS

    Just another note, if you wish to go one step further and not retreive the password from the database you can do something like this: Dim cmd As New OleDBCommand("SELECT …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching DataGridView multiple tables

    I am creating a pageant scoring system. I managed to display the field names from different tables : [Click Here](http://oi58.tinypic.com/5c0jz5.jpg) The first column "Participants" is from Participant table and the …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in DataGridView multiple tables

    My suggestion would be to join the tables from the backend then pass the joined row to your DataGridView. For example: "SELECT pt.Participant, cr.Chri_Percent FROM Participants pt, Chriteria cr WHERE …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching VB.net User authentication login through SQL/VPS

    I was wondering, how do I make it so users can login. I have an SQL database, I have a VPS, I have a VPS. I just need help setting …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in VB.net User authentication login through SQL/VPS

    When handling usernames and passwords it is best to define your criteria for both the user and the administrator. You will have to determine if you want [trap-door encrypted](http://en.wikipedia.org/wiki/Trapdoor_function) passwords …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching SQL Server..Express..compact Database's.

    I am new to VB, and have attempted to load all the free versions of the SQL available. Dispite many go's I still can not make any work. I go …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in SQL Server..Express..compact Database's.

    Please post the code you are using to connect to the database. We can't help if we don't know. :)
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in PC died and wont power up...

    If your motherboard has an onboard video, you might want to try running through onboard to get a confirmation on a possible bad GPU. As for the dust bunnies, you …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Installing 16-bit? 32-bit? game on Win 7

    Not sure if i'm posting to the right forum but basically I have an old game on CD I wanted to install (Fifa 99) but when i run it there …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Installing 16-bit? 32-bit? game on Win 7

    [DosBox](http://www.dosbox.com/) is a good DOS emulator. You may want to give it a try.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching How to connect mobile internet to win 8 PC

    Hi there, My friend just formatted his pc in office and installed windows 8 32 bit. He had a samsung mobile phone with 2G/3G internet. He is using internet from …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in How to connect mobile internet to win 8 PC

    As Anima had said. This sounds like a problem with drivers. You will need to check with the phone's manufacture to see if they have/support Windows 8 drivers.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching no bios

    won't boot no bios on the bottom of screen displays [please wait ] i have no operating system installed ; but it should still have bios so i can install …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in no bios

    If the computer boots, there is a bios. A computer will boot using BIOS then bootstrap the operating system. Have you tried going into the bios setup and verify everything …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching PC died and wont power up...

    Hi all, While I'm not super knowledgable I have been building my own for years with no issues, so here goes: PC was running (It is almost never shut off) …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in PC died and wont power up...

    If it is a video card, the computer would still power up. My thought is that it might be an overheated processor. It could have been a possible bad bearing …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Drawing a right triangle

    can someone give me an example that draws right triangle using asterisk using do-while loop only (without using for loop)
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Drawing a right triangle

    Think about it this way. You are drawing a square....yes a square. The square is devided from corner to corner. **HINT** You are drawing characters that the user can see …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Basic calculator

    In this code,while executing it does's show the result. For eg: Consider addition,in addition result it shows the second value to be added. How it can be corrected? Public Class …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Basic calculator

    Will this build? It seems you are missing your End Sub on your first sub procedure.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching how can i combine this two table in one crystal report

    str1 = "select distinct [Sched_Code] as [No.], [Course], [Year], [Section], [Batch]," & _ " [Subject],[subject_desc],[units], [Time], [Day], [Room], [Instructor], [Schoolyr] as [S.Y.], [Semester] as [Sem] from tblSchedule, tblcurriculum where tblschedule.subject=tblcurriculum.subjects" …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in how can i combine this two table in one crystal report

    I am not so sure that query is returning anything. You have to give a table.column on the select when two tables are being passed in on the FROM clause. …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Gave Reputation to kRod in Money Only TextBox

    I've been working on a Textbox that only accepts 0-9, Decimal Point, and the Backspace Keys. Also keeps it in the base form 0.00. Max value is 999999.99 can be …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Not Reading Port Properly

    Sorry for the hiatus. Have you checked to verify if the correct number of BUTTONX Outputs exists? For example, press button one 3 times then press button two 3 times. …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Not Reading Port Properly

    Hello Community, Why I the port I'm trying to read looking really weired. I'm using an Arduino to produce the port data (It just has two button inputting "BUTTONONE" and …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Not Reading Port Properly

    Are you using an interpreter on your Arduino? If not, then this should be posted in the C++ forum. Also, you will have to post your code the application if …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in deploying VB application

    The auto update feature provided in the MyProject > Publish section are for ClickOnce deployment. Have a look at [this](http://stackoverflow.com/questions/16636096/vb-net-program-should-auto-update) article that shows you how to update the application with …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching deploying VB application

    Hi all, I have a question about deploying a Visual Basic 2010 Express build application silently on remote computers. When I published the app, an setup.exe file was created in …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in deploying VB application

    With the following prompt that you described - I assume that you are using click once deployment. [Here is an article on MSDN](http://social.msdn.microsoft.com/Forums/vstudio/en-US/bbbb43b2-16af-491d-a65e-0502b76ab0c4/clickonce-and-silent-mode-installation?forum=vsto) where some one asked a similar question.
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in how to count days by dates?

    You need to look into using the [DateDiff](http://msdn.microsoft.com/en-us/library/b5xbyt6f(v=vs.90).aspx) Function. You will receive the day value by passing in the day interval and your two dates. DateDiff(DateInterval.Day,dtStart,Now()) 'Will return number of …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching how to count days by dates?

    Dear Bodies! I am developing a Cold Store Managemen system. I need to count days according to dates.for example 5 ton petato put in cold store room on 01/12/2013 .when …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in how to count days by dates?

    Hello! Please elaborate as to which programming language you are using. There are many ways to count the number of days between two dates, but we can not give any …
  • Member Avatar for Begginnerdev
    Begginnerdev

    Began Watching Monitoring local area network resource usage

    How can create a code that can help a network administator to use quotas to monitor network resources usage, and then add more resources as the user needs.(quota system)
  • Member Avatar for Begginnerdev
    Begginnerdev

    Replied To a Post in Monitoring local area network resource usage

    Are you interested in something like [this](http://www.codeproject.com/Articles/225747/NET-Network-Monitor)?

The End.