Posts
 
Reputation
Joined
Last Seen
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
1 Commented Post
0 Endorsements
Ranked #3K
~35.4K People Reached
PC Specs
Intel Pentium D 3.00 Ghz1gb RAM80 Gb HDDWindows Xp SP 2
Favorite Tags
Member Avatar for jbutardo

Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks

Member Avatar for edgar.alexander.315
0
2K
Member Avatar for jbutardo

Hi, I have this datatable that I need to loop for my excel exporting function. And I have to export data that exceeds the row limit of excel worksheet. now I want to know how to create a query of limit on the datatable.select in such way like in sql. …

Member Avatar for Maligui
0
204
Member Avatar for jbutardo

Good day! I need help.. I have to check if the textbox value is in the dropdownlist items, and I don't know how to get this in javascript. I wanted to validate it in such a way that if the textbox value is in the dropdownlist item values, then the …

Member Avatar for code739
0
190
Member Avatar for jbutardo

Hi, I have this question about the control triggers, I have this project that have textbox, using it's textChanged function and setting the autopostback in to true. Now, when I trace the command I have notice that the function have been triggered twice, and I just want to know now …

Member Avatar for |-|x
0
278
Member Avatar for jbutardo

Hi, I have a VB.net program in which there is a checkbox and a textbox. The textbox contains a name or a user and by default the checkbox is on checked=true, now, I want the checkbox checked to be false, whenever the user change the text inside the textbox without …

0
75
Member Avatar for jbutardo

Hi, I have this textbox that has been inputted by date in the format of MMM-yy using a datetimepicker. TEXTBOX Jan-11 Now I need to get the exact date on the textbox to be inserted in a string. string1 = Cdate(txtbox1.text.trim) but in this code, the inputted text on the …

Member Avatar for poojavb
0
171
Member Avatar for jbutardo

Hi, I have this fileupload control which saves excel file on my server, but somehow, if the excel file is larger than 4 mb it does not save the file, i used this code fileupload1.SaveAs can you please help me on why does this happen? Thanks

Member Avatar for desynch
0
419
Member Avatar for jbutardo

Hi, I have this program that uses OLEDB connection in order to import the excel sheet into datatable, now I am using windows xp and the server that I'm about to use would be in windows 7, what connection string do I need in order for me to connect to …

Member Avatar for jbutardo
0
231
Member Avatar for jbutardo

Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks

Member Avatar for jbutardo
-1
146
Member Avatar for poojavb

Hello All, Actually I am facing issue in creating an ASP.net application. I have created a project in VB.net but now my seniors are saying that the code should be in ASP.net and it is taking hell lot of time for code conversion, designing and all other stuff. Actually I …

Member Avatar for poojavb
0
337
Member Avatar for adhani85

[CODE]Imports System.Data.SqlClient Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDbCommand Imports System.Data Partial Class Main Inherits System.Web.UI.Page Public strSQL As String Public strConn As String = ConfigurationSettings.AppSettings("strConn") Dim objConn As SqlConnection Dim objAdap As SqlDataAdapter Dim objCmd As SqlCommand Dim objReader As SqlDataReader Private Sub cbfGenerateTable() Try objConn = New SqlConnection(strConn) strSQL = "SELECT …

Member Avatar for thines01
-2
166
Member Avatar for PF2G

Can someone tell me what's wrong here: [CODE] Dim sql As String = "SELECT * FROM courses" Dim con As New MySqlConnection Dim dt As New DataTable(sql) Dim cmd As New MySqlCommand(sql, con) con.Open() ComboBox1.Items.Add(dt)[/CODE] It doesn't show the courses.

Member Avatar for jbutardo
0
113
Member Avatar for jbutardo

Hi, I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. how can I create a sample template using vb.net code? Thanks

Member Avatar for jbutardo
0
1K
Member Avatar for jbutardo

Hi, I have this program that would upload files from the client to the server, Now I want to validate the filesize before uploading it into the server.. How can I create this kind of validation? Thanks.

Member Avatar for jbutardo
0
552
Member Avatar for jbutardo

Hi, I just have this program that needs to create a downloadable template for the excel file that will be used later in my program, now I have this templates in my server and I think that i'll just import this file first and then put it in the data …

0
139
Member Avatar for jbutardo

Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to …

Member Avatar for jbutardo
0
1K
Member Avatar for jbutardo

Hi, I just have a program that needs a dialog box, but I have problem since I want the dialog box to do something. for example, I have a javascript dialog box that would create a message "You have an error, Do you want to save the Log File", Then …

Member Avatar for jbutardo
0
139
Member Avatar for jbutardo

Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if …

Member Avatar for jbutardo
0
935
Member Avatar for jbutardo

Hi, I'm having a little trouble about message box, Since the website has been deployed in the IIS, the msgbox won't work anymore, Now I need a new alternative to create a message box that could also have a validation, something like if msgbox("do you want to save this?", msgbox.yesno) …

Member Avatar for jbutardo
0
324
Member Avatar for jbutardo

Hi! I just have this program that validates if the selected file is an excel file, and I want this to have a separate function for validation so I can use that function to other program, can you please give me an example on how to do this function.. Thanks

Member Avatar for jbutardo
0
274
Member Avatar for jbutardo

Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection …

Member Avatar for jbutardo
0
245
Member Avatar for jbutardo

I have this OLEDB connection string connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2 I just want to know what is the meaning of HDR and IMEX, and what are their purpose on the connection string Thanks..

Member Avatar for jbutardo
0
1K
Member Avatar for jbutardo

Hi, How can I create a dialogbox, I think that will allow user to open or to save as a textfile? Is it possible? If yes, how can it be made? Thanks

Member Avatar for Pgmer
0
134
Member Avatar for jbutardo

I have this error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near and I don't know how does this happen because whenever I check the SQL that I have made including the inserted …

Member Avatar for jbutardo
0
339
Member Avatar for jbutardo

Hi, I have this program that validates error and then logs it in a text file, but here is the problem, I want to know how show the text file that has been made after the logs have been written, for example, I have validated all the errors, and then …

Member Avatar for jbutardo
0
329
Member Avatar for jbutardo

I have this question. I have already imported all the excel data in the datatable, but now I want them stored in a 2 dimensional array, meaning I want to have this kind of thing in the array, something like array[x][y], where x is the row and y is the …

Member Avatar for Oxiegen
0
142
Member Avatar for jbutardo

Just want to ask, how can i create a log file on vb.net, what libraries should i need for this to work,. thanks

Member Avatar for jbutardo
0
18K
Member Avatar for jbutardo

Hi, I have this sort of problem whenever the datatable has an empty cell, it shows cannot find column 6 or depending on the number of the datatable column cell. Why does this happen and how can I resolve this? Thanks

Member Avatar for jbutardo
0
2K
Member Avatar for jbutardo

Hi, How can I create an array of a class that I have declared? I have this class named parts with properties of frame, engine and date, and i want to know how could I store them in an array .. thanks

Member Avatar for Reverend Jim
0
163
Member Avatar for jbutardo

Hi, I have this fileupload in my program and I want to set it's extension to .xls only, Is it possible? If yes, how can I set it so it's file filter will only be .xls? Thanks

Member Avatar for jbutardo
0
192