2,634 Topics
 | |
| | Hello, I hope someone can give me some help. I have a datagridview (Unbound), wich calculate several numbers, and I use this following code to save 5 of the columns to a XML file. My problem is that I would like to load this file back to my datagridview, and … |
| | Hai all,, Currently I'm writing code in ASP.NET using VB language. I got an issue regarding dropdownlist. In my form, I have a treeview and a dropdownlist which are populated with data from database. When I click a node in treeview, the dropdownlist should be populated with values based on … |
| | I want to concatenate Emp_ID and First_Name column but it gives multistep error. my other table works fine except for the EMPLOYEE table. [code] try { con.Open(); ds = new DataSet(); dt = new DataTable(); ds.Tables.Add(dt); cmd = new OleDbCommand("SELECT Emp_ID + First_Name FROM EMPLOYEE", con); cmd.CommandType = CommandType.Text; dAdapt … |
| | Hello all, I was trying this problem of checking if the input integers can be ordered using the STL implementation of the stack. The program reads from a file named "input.txt" which in its first line has the number of integers that follow in the second line. The second line … |
| | how can i use to show the selected value from data set i think there is a problem of dataset use to take out value from data set my code is [code] protected void Page_Load(object sender, EventArgs e) { SqlDataAdapter adap = new SqlDataAdapter("SP_selectallbooks", con); adap.SelectCommand.CommandType = CommandType.StoredProcedure; //DataSet ds … |
 | Hi Experts: When i run this page on my online website with mysql (already with Oracle), this errors orrurs. Exception Details: System.Data.OleDb.OleDbException: [1]: 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 'exec print_pack.check_print … |
| | I have a web page in which there is a textbox that asks my users to enter a start date. What I'm trying to do from there is that no matter what the end date is, my page will calculated that from the text box, store it as a variable … |
| | Im trying to select data from a MS access database, i have done this for SQL server before with no problem, but now with a Access database i get a run time error for "No value given for one or more required parameters". Below is my code [CODE] Private Sub … |
| | Am developing an application with c#. I want to know how to insert data set values into the database |
 | I have a file that I can get to show correctly in grid/web - however I need to be able to download a CSV. I do not usually work in asp so out on a limb with a deadline here! [CODE] <%@ Import Namespace ="System.Data" %> <%@ Import Namespace="System.Data.OleDB" %> … |
| | I am trying to export a datagridview ti excel, but i get an error I do not quite understand. I have made two click-events using two buttons looking like this: [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cnn As SqlConnection Dim sql As … |
| | Hello! any expert can help me. Please. I'm design a form with click Search button to search date and display data in datagridview. but when I set my access database OTDate column as Date, It will cause data mismatch problem. however, set OTDate column as Text is fine. But it …  |
| | Hi I am using the following to auto search db [CODE] Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) Dim cmd As New SqlCommand("select firstName, existing from tenant Where (existing = 1)", conn) Dim da As New SqlDataAdapter(cmd) Dim ds As New DataSet Try conn.Open() da.Fill(ds, "List") … |
| | Hi I have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results something like [CODE]Private Sub TextBoxId_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBoxIdSearchExist.TextChanged Dim cmd As New SqlCommand("select * from pay Where t_id='" + tId.Text + …  |
 | can anyone help me add a title to a graph? the code i run to create the graph is [CODE][B]Dim strConn As String = connectionstring Dim conn As New SqlConnection(strConn) Dim sqlProducts As String = "SELECT * from VW_OEEBrakeDowns_ByYear where Year ='" & Me.lbyear.Text & "' and LineNumber =" & … |
 | Im using Microsoft Visual Studio 2010 Microsoft Acess 2010 This is for practice Lets See First off i was able to get to insert records(Code Below) Now im trying to get the program to prompt a message when the id or field exists on the key down event and not … |
| | I have an XML file that is displayed on a DataGridView driven by a dataset. I am having trouble setting up a filter where a user can enter information in a textBox then have the DataGridView filter to find results. The XML File is displayed on the DataGridView using this … |
| | can someone help a newbie with .net the code i have is working fine to pass one parameter to crystal, can someone help me pass a second parameter called "line"? [CODE]Imports System.Windows.Forms Imports System.Data.SqlClient Imports OEE_NEW.Module1 Imports System.Data Imports System.IO Imports System.Data.SqlTypes Imports System.Windows.Forms.DataVisualization.Charting Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.ReportSource Imports CrystalDecisions.Shared … |
| | Hi all, Im adding a column after the dataGridView is populated. Then I want to add LinkLables to that column. how to do this. PLZ help me. I've tried this.But it gives me an error. this is my buton click.its ok. [CODE] private void button1_Click(object sender, EventArgs e) { Search …  |
| | hi.. i just made two function related to excel . 1. Merging all sheet of excel as tables in single Dataset 2. Exporting a dataset to Excel File .(all the tables of dataset as sheets) i just wanted to share.. i hope it becomes helpful to you. ps: Dont forget … |
| | Hi all, I have built a small event handler to zoom in on a graph on pyplot figure, and then I use the builtin pickline event handler to select a line. I plot multiple lines from a large dataset of ordered series, so when I choose one, I need my … |
| | Hi, i connect database with vb.net and also i receive a single value from my receiver through serial port. now i want to match this single data with one field of database. how can i do it. plz help me. i have attached my code. Public Class Form1 Private Sub …  |
 | I have form where 4 buttons(Platinum, Diamond, Gold and Reset) are there, I have 3 Panel Control one for each of the first 3 buttons, what I want to do is that when I click on any one of the first three buttons the Panel for the respective buttons should …  |
| | I have a csv file that needs to be imported into sql server using vb.net. I got it working with the following code with one exception: [code] Private Function ImportLeadFile(ByVal projectfile As String, ByVal sLeadFile As String, ByVal DATABASE As String) As Boolean Dim objConn As nsSqlClient.SqlConnection Dim ds As … |
| | I have added a panel control at the design time and I want to add some buttons in the panel at the runtime, the code for adding the buttons in working perfectly, but the problem is with the Panel control, when the Buttons are added at the run time, the … |
| | I am creating a business software package in visual basic.net that will handle invoices, quotes, purchase orders, inventory items, customers, etc. This program is multi-user meaning that different people could each be running an instance of the program on their computer, with each instance modifying a central database. The problem …  |
| | Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New …  |
| | Keep getting this error. Using ASP datagrid [CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim connectionString As String = WebConfigurationManager.ConnectionStrings("connectionstring").ConnectionString Dim selectSQL As String = "SELECT * FROM checkInOut" Dim con As New SqlConnection(connectionString) Dim cmd As New SqlCommand(selectSQL, con) Dim adapter As New … |
| | i have a problem when i want to use my 2nd table i see "there is no row at position 0" and when i look my projects folder i see my database's backup file and i was opened it then i cant see my 2.nd table in backup file. what …  |
| | Hi Im new here-I wanted to create a Login System. I am using Visual Basic 2008 Express Edition, Microsoft Access 2007/2010 Beta. Ok this is my current code-the main problem I have is that I dont how to compare what the user puts into the textboxes and then check that … |
| | hi can you any one help me to correct error i using c# write private function no error get but not get correct result when debugging this is my code [CODE]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.OleDb; namespace WindowsFormsApplication1 … |
| | Hi there I am writing/revising an asp.net (vb) website the main function of the site is to fetch data from a SQL server and present it to users based on 'filters' that they apply (It for football statistics) currently a session variable is used to store the unique match_id's, and … |
| | I have a winform with 3 textboxes; 1 for Day, 2 for Month & 3 for Year plus a button when clicked opens a new form which has the reportViewer1 control there to display the report. I have no problem with just adding a dataset and adding fill & get … |
| | Hey everyone, kinda new to all this...really need some help: Ok so I want to creat a log in and registration form in VB connecting to a sql database. Databse Name: Users Table Name: UserDetails Table Fields: ID, Username, Password The ID field was specifed as primary and self incrementing … |
| | Hi guys, I dont know what is the problem with this im trying to refresh my datagridview here my simple code to refresh. [CODE]this.TableAdapter.Fill(this.DataSet.Table);[/CODE] But nothing happens still the same. Please help. ;) |
| | [CODE] private void FillList() { listView.Items.Clear(); DataTable dtPeople = GetPeople(); listView.BeginUpdate(); foreach (DataRow dr in dtPeople.Rows) { ListViewItem listItem = new ListViewItem(dr["id"].ToString()); listItem.ImageIndex = 0; // Get child rows from a parent one. // person_name is a name of relation between two // tables. DataRow[] r = dr.GetChildRows("person_name"); if (r.Length … |
| | Hi All, I am using JSP and servlet technology for making graphs. Below please find my jsps, Display.jsp [CODE]<%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ page import="java.awt.*" %> <%@ page import="java.io.*" %> <%@ page import="org.jfree.chart.*" %> <%@ page import="org.jfree.chart.axis.*" %> <%@ page import="org.jfree.chart.entity.*" %> <%@ … |
 | Here is the code which is working fine for me on another form but creating problem when i use the same code on another form it gives me this error message when i try to insert a new record in DB "Value cannot be null Parameter name: Data Table" and … |
| | i am getting a problem during oledbdataadapter update at runtime my code is like this [code] con.open(); oledbdataadapter oda=new oledataadapter(commandtext,con) // first dataadapter dataset ds=new dataset(); oda.fill(ds,"labs"); for( some condition) { string commandtext2="bla-bla"; oledbdataadapter oda2=new oledataadapter(commandtext2,con) // second dataadapter dataset ds2=new dataset(); oda2.fill(ds2,"class"); cmd.commandtext="sql statement"; oda2.fill(ds2,"subjects"); my code logic here … |
| | i wonder why my code have an error.. this my code and i will highlight the error[CODE].. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connection As New SqlClient.SqlConnection Dim command As New SqlClient.SqlCommand Dim adapter As New SqlClient.SqlDataAdapter Dim dataset As New DataSet connection.ConnectionString …  |
| | hi all in form1 I place 3 button and 1 datagridview ,btn refresh,btnload , btnnew and Datagridview dgv1 1. I change the value of a cells in datagridview (right after Form1 is loaded),and then click btnrefresh 2. I click btnnew to clear the dgv1 3. I click btnload to re … |
| | I've been looking everywhere for an answer to a simple question, but i'm having issues, so i thought i'd join and post here. I'm having issues with a simple concept. I load information from a SQL database, and i want to add a 'Passport' link URL relating to column cells …  |
| | Hi all, I got a problem with part of my application, it's an exception I've never seen before. Overload resolution failed because no accessible 'New' can be called without a narrowing conversion: 'Public Sub New(original As System.Drawing.Image)': Argument matching parameter 'original' narrows from 'Object' to 'System.Drawing.Image'. 'Public Sub New(stream As … |
| | [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New DataSet Dim da As New OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim cn As New OleDbConnection Dim cmd As OleDbCommand Dim sql As String 'sql = "INSERT INTO Employees(GivenName, LastName, Gender, JobPosition, Month, …  |
 | I had this little project of a POS System, that i've already finished, and i try to retake it again to add more features And suddenly in a Summary Report for the sales of the day i keep getting this error message [CODE]Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)[/CODE] And im cranking … |
 | HI, I have a DataSet which returns three rows say A,B,C. Data will be in the Following format. A B C 1 5 9 2 6 10 3 7 11 4 8 12 Now i want to convert this into xml in the below mentioned format.. [code=xml] <chart showValues='0' caption='Cost … |
| | I am doing project in 2010... I am trying to add new data source... I have clicked data->Add new data source... it shows the window "Data Source Configuration" i select database as shown in image1 Then i select Dataset... as shown in image2 And when i select the New Connection … |
| | My original query for data from the database was: [CODE] Dim SQL_RecentWorkOrders As String = "Select * from workorder WHERE date>#" + dtToday.AddYears(-YearsToGoBack).ToString + "# ORDER BY worknum DESC"[/CODE] The updated query is as follows: [CODE] Dim SQL_RecentWorkOrders As String = "SELECT * FROM workorder INNER JOIN customer ON workorder.custid … |
| | hey i got 2 tables named tbplayer and tbpair in database named dbgame.mdb tbplayer has 2 field player_id and player_name.. tbpair has three field pair_id(autonumber), player_1 and player_2 i have create combobox to get player id in tbpair from tbpair.. so i don get code.. my sample code is [CODE]Imports …  |
| | hello all suppose I have fill a datagridview (named it mydgv) ,Can I populate a dataset with the data from the content of mydgv ? if yes how thank you denny |
The End.