4,457 Topics
 | |
| | overload resolution failed because no accessible 'new' can be called with these arguments.. the error shows at the Dim *dataadapter* As New SqlDataAdapter(sqlCmd, connection) Imports System.Data.SqlClient Public Class Form1 Private Sub BtnGenResult_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnGenResult.Click Dim ConnectionString As String = "Data Source=(local)\SQLEXPRESS; AttachDbFilename=D:\PKBW Batching …  |
| | i want to save my picture in database i have these codes but then there is an error . " command text was not set for the command object " how to solve this problem? thank you.! Try If imgName <> "" Then Dim fs As FileStream fs = New … |
| | Dim ADP As SqlDataAdapter = New SqlDataAdapter Dim CONN As SqlConnection = New SqlConnection("Data Source=|DataDirectory|\dbTesting.sdf") Dim COMM As SqlCommand = New SqlCommand("SELECT * FROM tbTesting") Dim DS As New DataSet CONN.Open() Dim DR As SqlDataReader = COMM.ExecuteReader() DR = COMM.ExecuteReader() TextBox0.Text = DR("Test").ToString This was my coding in order to … |
| | I am currently in the process of creating a open source dating script. I am nearly there. Just one thing that I can see that is an error now. When a user completes there profile, other users can see the answers, but the person who the profile belongs to can't. … |
| | I've been scowering the web for a good 3 hours this morning looking for an alternative to our OSTicket installation. I've looked at quite a few items. I have some requirements that I'm basing my selection on. * LDAP Integration (**Not a deal breaker**) * Email Notification (**When an ticket … |
 | Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = … |
| | Hi i need some help with updating changes to multiple rows in the GridView. I was able to add multiple rows simultaneosuly when i click the 'save' button however when i'm trying to update multiple rows i'm getting a problem. Is there is a specific way to that? thanks using …  |
| | **PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; …  |
| | I'm using Netbeans 7, JEE project with application client, stateless ejb with remote interface, and JPA entity clasess made from sql script. Interfaces are in separate library project which is referenced in ejb and client project. **And the problem is the remote method that use custom interface object made from … |
| | I am working in sql2000 database as backend and Vb6 as frontend. Its for bank scenario I am trying to display the balance corresponding to particular account number. Do try to help. Following is my code. ************************************* Private Sub Command1_Click() Dim con1 As New ADODB.Connection Dim cmd1 As New ADODB.Command …  |
 | I've a DataGrid Control in my application and a button. When i click a button it should display the contents of the Logins table in the DataGrid. For this I've coded the following, but its giving me an error "Rowset is not bookmarkable.". I've searched a lot, many suggestions include … |
| | Hi All, I sware I am loosing the will to live, I have tried to accomplish this by my-self for about 2 weeks now and I am still at square one, I prey someone can help me. I am writing an application for booking conference rooms and I need a … |
 | I'm trying to read a DBF file into a DataSet and then write a selected number of columns to a MDB. I've been successful reading the DBF into the Dataset with this code; Public Sub sReadDbf(ByVal dbffile As String) mydbfConn = New System.Data.OleDb.OleDbConnection mydbfConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ sAlohaPath … |
| | I am new to Vb.net and I'me trying to store data to the sql databse using text fields. Everything seems ok but i've tried several connection strings but they wont work.Could somebody give a hand, please? [COLOR=green]Private[/COLOR] [COLOR=green]Sub[/COLOR] btnSubmit_Click([COLOR=green]ByVal[/COLOR] sender [COLOR=green]As[/COLOR] System.Object, [COLOR=green]ByVal[/COLOR] e [COLOR=green]As[/COLOR] System.EventArgs) [COLOR=green]Handles[/COLOR] btnSubmit.Click [COLOR=green]Dim[/COLOR] conn …  |
| | I need to retrieve the Date only from Microsoft SQL Server and insert into Listview the code that i used was this SqlCommand cmd4 = new SqlCommand(); SqlConnection cn = new SqlConnection(); cn.ConnectionString = ("Data Source = LOPEZ-PC\\SQLEXPRESS;Initial Catalog=softwareengineering; Integrated security= TRUE"); cmd4.CommandText = "SELECT * FROM [rawinventory] "; cn.Open(); … |
| | I want to create a program that reads some data from a specified .txt source file (this part is absolutely no problem) and then write that data to the currently active/open file (something like copy & paste functionality where the copy function reads data from the source file and paste … |
| | **THIS CODE RETRIEVES DATA FROM THE DATABASE. PLEASE HELP ME DEBUG. I AM EXPERIENCING ERROR CALLED INDEXOUTOFRANGE IN: ** **HERE IS MY CODE:** Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Try Dim oradb As String = "Provider=OraOLEDB.Oracle; Data Source=TRAVELMATE-PC/XE;User Id=cj;Password=me;" Dim conn As New OleDb.OleDbConnection(oradb) …  |
| | Hi Guys.. I've found a little tutorial which seems to show exactly what I have been trying to do which seems to work upto a certian extent. The code I am using is the following: **Code:** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; … |
| | I have never used a background worker in vb.net, but from what I have read, I think it will help resolve an issue I am having during runtime. I am executing an sql statement, but it takes a bit to process. I think a background worker could help with this … |
 | Hi, i'm a newbie and get stuck with this problem for a few days. I have datatable with two column, line and duration. I want to sum the duration based on the line group. For example: LINE DURATION A1 00:05:20 A1 00:07:00 A1 00:02:10 A1 00:01:50 A2 00:02:01 A2 00:03:45 … |
| | Hello, i have encountered with a problem in one of methods comparing string from database to the string named pword that i initialized from textbox. Can anyone know the easiest for begginer to fix it? I would be very very greatful. SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\Studijos\\c#\\KursinisDarbas\\BazineAplikacija\\BazineAplikacija\\DuomenuBaze.mdf;Integrated … |
| | There is an interesting project on KickStarter that is close to successfully funding. I'm not the owner of the project, but I'm backing it and would be disappointed to see it fail. Please see if you would like to participate: http://www.kickstarter.com/projects/Musopen/open-source-bug-tracking |
| | I'm learning as I go here, but I'm stuck at the moment. I am trying to dynamically create a datagridview and populate it from a database using SQL. I have created my columns, but I don't know how to assign the data coming out of my sql query to its … |
 | Are there any open source video hosting complete websites? |
| | I am new to vb.net, I want the first column of the unbound datagridview to have defult value such as item1,item2. item3 on form load event . I would appriciate if someone tell me how to add defult values in a column like this and save all three rows in … |
| | Help please -I am still learning Visual Web Developer in VB.Net code Sorry to ask, there is probably an easy fix or I have this completely wrong. I have a DropDownList2 (CustName) and a TextBox16 (for CustID) I want the command to look at the SQL Table and fill the …  |
| | Hi can anyone see what the problem is below I am new to c# so not sure why this code does not excute? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace Eight_Stage { public partial class Form1 : Form … |
| | Hi, I am writing code for connecting to an access database in my windows 7 machine. Am using visual studio 2010 with access 2007. While debugging the code am getting the exception **"The 'Microsoft.Jet.OLEDB.4,0' provider is not registered on the local machine"**. Below is my code, Try connection = New …  |
| | Straight to the point. I want to create a software, as a self motivation to do more programming. A SOFTWARE, doesn't matter how ugly it is, how simple it is, as long as software and not just a simple 'HELLO WORLD' program. The question is, if i have a source … |
 | Through using Visual Studio to learn more about ASP.net and VB.net I would like to connect to a database. I create an .mdf database file but I've no idea how to connect to it (well, I have some code below...) that's not my only problem but I'll ask the next … |
| | Hello Guys, We need your recommendation for a good java reporting tool(open source or commercial) which meets the following requirements: 1. Embeddable in java web application(via reporting tool API calls) 2. Low run-time cost 3. Output to pdf/html 4. Has report designer/drag and drop etc. 5. iPad/iPhone friendly(if possible) Thanks |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … |
| | Hi need help i setting up both Adding and Updating datagrid cells in the Save_Click event. Right i used seperate click events for Add_Click and Updating_Click but i want to both of them in the Save_Click event rather than seperately. Thanks in advance Here is my code using System; using …  |
 | Hello, Can we perform bulk insert for SQL data? I have the complete SQL data in text files. There are multiple tables and the corresponding text files. I tried to do the bulk insert but always got some new error. Please help me to get an answer. My code Imports … |
| | If I execute the program from within Visual Studio, the program runs absolutely fine. Once I put the .exe from debug on a different computer, it gives a error of No Value Given for One or More required parameters. I know that it could be that the parameters are incorrect, … |
 | i have this connection string <connectionStrings> <add name="Tendering_Pro" connectionString="Data Source=HABOUSH-PC\SQLEXPRESS;Initial Catalog=TenderingProgram;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> <system.diagnostics> AND THIS MY CLAAS : Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Public Class BuyNewTender Private conn As SqlConnection Private _MSG As String = "" Private _ProjectTenderingNO As String = "" Private _TenderingNo As String … |
| | I am working on a open source script at the moment, but I am struggling on one final aspect of the script. I am a bit of a newb to PHP at this level, I have a working knowledge of PHP and MySQL, but this seems to be a little … |
| | Hey There, I'm a beginner when it comes to VB.net. I can do all the basic stuff, but I'm having issues with connecting to a database I've created. Ultimately, I need to feed data from a few text boxes to one table within the database, but I can't even get …  |
| | Hi Guys... I seem to be having an issue when trying to create a new row in a Dataset. Below is the following Connection Details to the Access DB. private void radioButton3_CheckedChanged(object sender, EventArgs e) { cashCustom.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Orders.mdb"; cashCustomerDS = new DataSet(); cashcTable = new DataTable(); cashCustomerDS.Tables.Add(cashcTable); cashCustom.Open(); … |
| | have a Problem in C# windows program that is I can't work with 2 database those are simple database in tables and Data. in this Project I want to open Access DataBase and Create New Access DataBase with another Name But with Same Tables And Columns And Rows and fill … |
| | I am 2/3 thirds of sams teach yourself java in 21 days and I would like to know what to do to get proficient with programming. I heard I should look at source code, if so where can I find some. What kind of projects should I do. Should I …  |
| | Hello, Can anyone recommend an [U]light weight[/U] IDE for C development? Preferably open source, but definitely free. (for Windows) It doesn't need to have its own version control - I'm using subversion - a plugin to subversion would be nice but it okay if it doesn't. Currently my colleague is … |
| | import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.PrintWriter; import java.util.Scanner; public class Concat { public boolean accept(File file) { //if the file extension is .txt or .java return true, else false if (file.getName().endsWith(".txt")||file.getName().endsWith(".java")) { return true; } return false; } public void copy(PrintWriter pw, String inputFile) { File … |
| | I have Table named Product Have Fields as Prod_ID int Prod_Name varchar(50) Price int Image varchar(50)----save as url I have form which have one DropDownList Having Boung To Prod_ID Coloum it shows all the data from prod_Id coloumn and have one gridview... if user selects prod_ID from dropdown then it … |
| | I am working on a ShoppingCart.... I am keeping it simple .... I have One DropDownList Product_Id whose values r retrived from database.... My Table have Following Fields... Product_ID Product_Name Price Image So whenever user seelects a product_id from dropdownlist thats value gets added to the gridview which will display … |
| | Hi all, Am new to C# and i have a form which registers users,But i want to create methods that which check if the TextBox conatins Letters (ie for coloumns that shouldnt take letters) and check for special characters and number for coloumns that should only have text. I have … |
| | Hello everyone, When using the following source codes to play a local .wav file, I always find .wav files can not played. Does anyone know what is the trouble? [Code] import java.io.File; import java.io.IOException; import javax.sound.sampled.AudioFormat; import javax.sound.sampled.AudioInputStream; import javax.sound.sampled.AudioSystem; import javax.sound.sampled.DataLine; import javax.sound.sampled.FloatControl; import javax.sound.sampled.LineUnavailableException; import javax.sound.sampled.SourceDataLine; public class …  |
| | hai! I am new to visual studio 2010. I am trying to develop a miniproject related on atm. But I have syntax error(missing operator) in query expression on 'Accountnumber=and PIN='. are you help me to correct this error? My coding is, op = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = F:\atm1.mdb") op.Open() cd …  |
| | Hey guys, This is Tougheart, (Kareem for real) a 26 years old guy from Egypt who is trying to get his feet wet in Java world. I'm originally a CS graduate, around 5 years ago now, but I didn't really work at programming for 4 years, trying to get back … |
 | Are there any open source/free to use, commonly updated... either dumps or APIs that will let someone have zip codes and addresses validated? Think monster.com or careerbuilder.com's location search, or something similar. Thanks Ryan |
The End.