2,634 Topics
 | |
 | I used this code to retrive from one record to another first tried to retrive the first record................. varible decalaration Imports System.Data Imports System.Data.SqlClient Public Class Form3 ' Dim connectionstring As String = Module1.connectionString Dim sqlconn As New SqlConnection(connectionstring) Public sqlDataset As New DataSet Dim da1 As OleDb.OleDbDataAdapter Dim myCommand1 … |
 | Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this … |
 | hi all i make a store procdeure in visual studio wpf when i run a code the error is not solve here is error "Procedure getguestinfo has no parameters and arguments were supplied." and here is the code public class guests { private int guest_id; public int Guest_id { get … |
 | hi it 's working but the Grid view not disp.lay the details Dim cn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;" & "Data Source=D:\Task_one_one\TaskNew\TaskNew\App_Data\db1.mdb") cn.Open() Try Dim myTable As DataTable = New DataTable("MyTable") 'Dim ds As DataSet = New DataSet myTable.Columns.Add(New DataColumn("Emp Id")) myTable.Columns.Add(New DataColumn("Start Time")) myTable.Columns.Add(New DataColumn("End Time")) myTable.Columns.Add(New DataColumn("Hours")) myTable.Columns.Add(New … |
| | I found a tutorial online that so far has been aswesome. I downloaded the access db and so far can read and browse through it. However, when I try to write back to it (btnSubmit_Click), nothing happens. All other buttons work fine, I can still browse, and I get absolutely …  |
| | Hi, I'm updating an application to .net from VB 6.0. It uses crystal reports to display reports but we get issues around versioning and having to have the client install Crystal so we would prefer not to depend on Crystal. I was originally going to use an XMLReader object to … |
| | I am trying to cluster a sparse matrix with using K-means algorithm. I will use Apache mahout but I did not find any example about how can it be implement with Java. Is there any tutorial or function javadoc about it? I have tried KmeansDriver's run() function but I did … |
| | I used this code delete recods from table ............ in VBP is database name Sell-is a table name The DELETE statement conflicted with the REFERENCE constraint "FK_Sells_Product_Details". The conflict occurred in database "VBP", table "dbo.Sells", column 'P_Id'. The statement has been terminated. Dim check As Integer Dim cmdproduct As New … |
 | Hi All, Got an issue that I know is quite common and read through lots of guides but cant see where I am going wrong. Got the code below which when form is loaded goes and grabs user from a table of usernames and puts them against a combo box … |
| | Hi every one I'm trying to retrieve UserID (which is autonumber in ms access database) using C# and assign it to string u.I'm totally new to C# and trying to get more skills.... here goes.. string connStr, selectCmd; connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\library.accdb"; selectCmd = "SELECT * FROM users WHERE First_Name … |
| | i am trying to get crystal report of my Marks_master Records From Table . I tried Following Code But It is Giving Me Exception As : System.IO.FileNotFoundException was unhandled Message=Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one … |
 | How can I change the color of bar chart based on value in database column? For example, in table "STATUS" in my database, I have 3 type of value. What I want is: 1) If the value = 0, then color will change to blue. 2) If the value = … |
| | Hi! I'm writing little software just to get some practice in c#. I have listview in form 1 where program displays first name and last name form access database. When admin selects name/surname in listvioew and press show usercard(form2) I have a label in form2 and I want it to … |
| | I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to … |
| | When I try debugging this, it comes up with an error on the line "If txtUsername.Text = ds.Tables("AddressBook").Rows(inc).Item(1) Then". It says NullReferenceException was unhandled. Object reference not set to an instance of an object. Public Class MainLogin Dim MaxRows As Integer Dim inc As Integer = 0 Dim con As …  |
| | Public Class txtSurname Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As OleDb.OleDbConnection 'Dim con As OleDb.OleDbConnection Dim dbProvider As String Dim dbSource As String Dim DS As New DataSet Dim DA As OleDb.OleDbDataAdapter Dim sql As String dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data …  |
| | Hi friends i am getting outofmemoryexception, Here is my code which is in italic i have to optimized these nested loops to avoid the exception. I am telling the background here ,I have a condition in which i have Dataset A,Dataset B and Dataset C.Dataset A is parent & the …  |
| | Hi All, I have a factory which has some concrete sub classes for generating reports (.txt, .csv,.xls) I want to make the interface of the concrete classes to be generic so that i can pass in diff types of parameters (Instead of DataTable i need to use DataSet or some … |
| | Hi, I want to get last working day data from database(SQL database). For example, if today is Tuesday, I want to get Monday data. I can get the data directly using strtTime = Date.Now.AddDays(-1).ToString("yyyy/MM/dd") & " " & "06:15:00" But the problem is if today day is Monday. Since the … |
 | Hey guys its me again...im having some problems modifying the data in the DataGridView The 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 'where UserID='3'' at line 1 and it highlight this … |
| | Friend Sub Inventory_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'Connect to database dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data Source= C:/Inventory.mdb" con.ConnectionString = dbProvider & dbSource 'Open database connection con.Open() MsgBox("Inventory is opened now") 'Import the data on tables sql = "SELECT * FROM Brands" sql1 = "SELECT * FROM … |
| | I'm pretty nee to all this stuff, I have no problems reading from the database but writing new records and updating fields etc is proving to be quite difficult. The following code is just meant to create a new record in a table, I started the field count at [2] … |
| | 'Inline Code Example HereHello i'm having this error message when adding to multiple table: '"The DataAdapter.SelectCommand property needs to be initialized." 'I need to have my data saved into both table(tblStudentInfo, tblPayment) when btnFinish clicked. Please 'help, i'm working on this for days and haven't had any luck. 'For reference … |
 | I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this … |
 | i have a page (APPLYforJOB.aspx), now if an registered user ahs signed in and clicked on APPLY for job Button then he will be promoted to page to fill his info but if he is hasn't logged in then he will be redirected to LOGIN.aspx page, I did it successfully …  |
 | I am trying to search a dataset I have populated from several XML files for certain words in each column. The dataset table is "item" and the columns I want searched is "descritption". "description" are several articles from an rss feed. I want to search the articles for sports players … |
| | Hello, Im working with visiual Studio 2010 in a Windows Form Application using C#. I created a DataSet (Project / Add Component / Data / DataSet) Then Creat a new Table(worktable) and add 3 Columns(one,two,three) to it. The Forms Window got a DataGridView wich is connected to to the DataSet …  |
| | Imports System Imports System.Data Imports MySql.Data.MySqlClient Imports System.IO Imports System.Diagnostics Module Module1 Dim myConnection As MySqlConnection Dim MySQLConnectionString As String Dim CommandLineArgs As System.Collections.ObjectModel.ReadOnlyCollection(Of String) = My.Application.CommandLineArgs Dim FILE_NAME As String = Nothing Dim dir As String = "C:\Mytest\" Dim strDate As String = Nothing Dim serv_type As String = … |
 | hello, i need some help here, i already bind my database coloumn 'NAMA' to my combobox 'cbNAMA', and now i want to show data from my database on textbox by selecting the row using cbNAMA but i got this error "System.InvalidCastExeception: Conversion from type 'DBNULL' to type 'String' is not … |
| | Hey so I have a customer form which has two buttons and displays contact data,containing a simple cancel and proceed. The main functionality is behind the proceed on_click handler.Becuase I want to determine whether the the entered details belong to a new person or just edit. I have got the … |
| | Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that … |
| | am using asp.net 3.5(c#) + sql server 200 DB, doing this GIVES me an error , *Error:The multi-part identifier "email@yahoo.com" could not be bound* why ??? using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; … |
| | Hi friends! I'm looking for an easy way to enable a user of my app to print the contet of a GridView.However, I think an easy way will be to convert it into a Crystal Report or pdf (many people say to pdf is terrible), so, I'd like to convert … |
| | hi every one, ihave to develop one code that need to update gata grid using simple dataset with out any db connection. can any one suggest  |
| | Hi, i have a dataset with 2 columns. 1 column is in String datatype and another one is in Timespan. Now i want to generate a chart from the dataset. While i'm trying to generate the chart, it has error: *"Series data points do not support values of type System.TimeSpan … |
| | i had a problem with this codes.. this codes will retrieve image from database that will based on the employeenumber. Dim CN As New OleDbConnection(cnString) CN.Open() daImage = New OleDbDataAdapter() daImage.SelectCommand = New OleDbCommand("SELECT * FROM EmployeeProfile ", CN) dsImage = New DataSet("dsImage") Dim dataTable As DataTable = dsImage.Tables(0) If … |
| | Damn, this is so much easier in a form...Anyone know how to export from a DataSet to Csv file in a console application? string sp = "SLA2Day"; var outCsvFile = @"C:\Download Report Sheets\file.txt"; SqlCommand spcmd = new SqlCommand(sp, thisConnection); spcmd.CommandType = CommandType.StoredProcedure; DataSet dsData = new DataSet(); DataTable dt = … |
 | Hi. I'm fairly new to VB.NET programming, and i'm currently developing an application for the sake of experience. What i know about Visual Basic programming might be considered dangerous, but none the less, i'm trying. I'm having difficulty getting past the idea of how to update a record in a … |
| | 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 …  |
| | hey everybody, i am new to vb.net environment pls help me to sort out my problem. let me explain it. in my project i need to clone/copy the content of the two fields from one table to another table in same database.i have tried my level best but got the … |
| | I have a problem that hopefully someone can shed light on. My OleDBdataadapters and OledbTableadapters have gone on strike!! In a simple vb.net 2005 pro project I have an Access 2003 .mdb with 2 tables each with 1 primary key and all other fields allowing zero length and not required. … |
| | Can someone tell me how to add an additional item to a combobox that is bound to a datatable? I have populated the ComboBox with data from table sSQLCbo = "SELECT region.ID, region.name FROM [STORES] ORDER BY store.ID" Dim ds As New DataSet da = New OleDb.OleDbDataAdapter(sSQLCbo, con) da.Fill(dt) con.Close() … |
| | 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 … |
| | Hi All, Quick one, I am calling a web service that returns a dataset but the company doesn't know what structure is in the dataset anymore as the original programmer has left. The webservice code calls a stored procedure that they can't access. Is there anyway to call the webservice …  |
| | 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 … |
| | I am using flot graphs for jquery in mvc3 razor web app. I'm loading partial view containing a plot graph to a div. I have a pop up window coming from another event. After popup window closes following error gives. *This only happens in IE* Following is the error: "Microsoft … |
| | hey frds, help me i don know the how to copy the content from one table to another(in access) using oledb,dataset.. for clear understanding i gve eg., there r 2 tables, the 1st table with the fields studentID,StudentName, Course,Year and 2nd table with the fields studentID,StudentName, Course,Year,marks,grade. here i want … |
| | 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 … |
| | Hi guys, Needing some help here please. I have a 'Save button' setup on my form which seems to be working perfectly. It allows vales to be taken from text boxes and then presented on a datagrid view and also saved to the underlying databse. **The Code for this save …  |
| | 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; … |
The End.