- Strength to Increase Rep
- +4
- Strength to Decrease Rep
- -1
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
- PC Specs
- Intel Pentium D 3.00 Ghz1gb RAM80 Gb HDDWindows Xp SP 2
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 |
|
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. … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 |
|
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 … |
|
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 |
|
Re:
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 … |
|
Re:
[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 … |
|
Re:
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. |
|
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 |
|
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. |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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) … |
|
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 |
|
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 … |
|
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.. |
|
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 |
|
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 … |
|
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 … |
|
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 … |
|
Just want to ask, how can i create a log file on vb.net, what libraries should i need for this to work,. thanks |
|
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 |
|
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 |
|
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 |