2,634 Topics
 | |
 | Hello Everyone, Im trying to read an item from combobox. but somehow i getting "system.Data.DataRowView" this only. here is my code DataSet ds = new DataSet(); ds.ReadXml(AppDomain.CurrentDomain.BaseDirectory+ "\\MYFiles\\Books.xml"); CmbXmlbooks.DisplayMember = "BName"; CmbXmlbooks.ValueMember = "Isbn"; CmbXmlbooks.DataSource = ds.Tables[0]; //Im reading the data from a xml file private void CmbXmlbooks_SelectedIndexChanged(object sender, EventArgs …  |
 | This is a fingerprint verification application. When verifying,it loops through the table. if the current fingerprint template is the first one on the table row it verifies it correctly. But if the current fingerprint template is located on the 2nd or later rows, it loops through the table and at …  |
 | I want to filter data by day and month only excluding the year. For example I want to find people born from day 1 to day 15 in september without including years so what i did is like... Private Sub ButtonFilter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonFilter.Click … |
| | I am new in vb.net. The image has been stored in sql server as <binary data> and i dont know how to convert it to display in picture box.Please tell me what are the changes should i made to get it to work.Here is the code which i have done …  |
| | Hi, I'm having CLI0100E Wrong number of parameters. SQLSTATE=07001 exception when I try to [code] private void PopulateTable() { bool IsConnecting = true; while (IsConnecting) { try { cn = null; cn = new OleDbConnection(strConn); cn.Open(); sSqlCommand = "select a.sicil_no ,a.adi||' '||a.soyadi as isim,b.unvan_aciklama,a.ilkgir_tarihi,a.ayrilma_tarihi,a.sua,a.dogum_tarihi " + "from per015_ssk a,per003_ssk b"; …  |
 | i have a logical error in my code where by i will read data into my four textboxes from sql database and the textboxes will be filled but when i click on a textbox the data will appear in the metrogrid(from metro framework) but when clicking another textbox the data … |
 | Hello everyone! Basically a user is able to select one or multiple rows using checkboxes in a GridView and then a delete button which deletes selected rows. The problem is, the code behind for deleting works until I started using UpdatePanel. It just broke and I have no idea what … |
 |  Why can not save to the database? my script Imports MySql.Data.MySqlClient Imports System.Data.Odbc Public Class Arsip Const DSN = "DSN=arsip" Dim conn As OdbcConnection Dim cmd As OdbcCommand Dim da As OdbcDataAdapter Dim dr As OdbcDataReader Dim ds As DataSet Dim table As DataTable Sub koneksi() conn = …  |
 | Hello Dear Friends, I need some help to check avilidity of the username on Leave event of a textbox in Database SQL Server, but i cann't get. it code is bellow private void textBox6_Leave(object sender, EventArgs e) { cmd = new SqlCommand("SELECT * FROM usertab WHERE username='"+textBox6.text+"'",con); SqlDataAdapter da = …  |
| | How do i solve the error that originates from the below code. DataSet info1 = this.GetData.getInfo("SELECT 0 AS EmpNo,Er.EmpID,(Er.FName&''&Er.LName) AS [Employee Name], Ed.DeptNo AS [Department No],Er.Gender AS [Sex] FROM (EmpRegist AS Er INNER JOIN EmployeeDept AS Ed ON Er.EmpId = Ed.EmpId) WHERE Ed.DeptId=" + (object)DpetID + " AND Ed.Status=0 AND …  |
| | I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code: [CODE]Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Settings.accdb" NotifyCon.Open()[/CODE] Ultimately I am …  |
| | Suppose we need to populate and filter a Datagrid with the data coming from an Access table. It could be of course a table from Sql Server also. Form dataGridSelect contains two buttons and a DataGridView. Clicking the first button will populate the DataGridView the data comming from a Sql … |
 | I need to separate the questions to atleast up to unemployment and after clicking the button it will go to another page and it resume the user from answering the question.. Thanks in advance.. <?php include('connection.php'); ?> <?php session_start(); if(!isset($_SESSION['id']) || $_SESSION['privilege'] != 'user'){ if(session_destroy()) // Destroying All Sessions { … |
 | # Split a dataset based on an attribute and an attribute value def t_split(x, y, z): l, r = list(), list() for row in z: if row[x] < y: l.append(row) else: r.append(row) return l, r # Calculate the Gini index for a split dataset def gini_index(grp, class_values): gini = 0.0 …  |
 | Dear Sir I have access data table and vb . project .access data table include ID ,word and description Colum v b project include three text box and one list box. If I search any word in text box through word Colum .I want show description Colum next text box … |
| | Hi guys, I have developed a windows application using vb.net 2012 and sqlserver express edition 2012. the application is able to access the database on a local hot computer. but when I take it to another compter on the same domain (networ). it is throwing the following error "Cannot open … |
 | hello expert, i have three dropdownlist option consist of two string and one datetime that convert into string. If i want to choose first and second dropdown without the third one which is datetime, it occur error "the string was not recognized as a valid datetime. there is an unknown …  |
| | hi guys i have a big problem how to insert image to database i had try this out but it returns error(syntex error) [code] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click OpenFileDialog1.Title = "GET IMAGE" OpenFileDialog1.ShowDialog() End Sub Private Sub OpenFileDialog1_FileOk(ByVal sender As System.Object, ByVal …  |
 | I have problem in display image from access 2007 database to rdlc i work in windows form c# vs2015 Actually i need to display image from database to more records from access 2007 but i cannot in rdlc i do as following : In RDLC drag image control to report … |
 | ** Here's my codes: Public Class frmLogin Dim sqlcode As String Dim connstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Jim Clinton Amarga\Desktop\Class Records\Class Records\bin\Debug\dbClassRecords.accdb" Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click If cmbLoginType.Text = "Administrator" Then Dim sqlLoginCode As String = "select * from tblusers where User_username = '" …  |
 | Hi, i am using visual studio 2015 and trying to export data which i am importing through excel by the user selected Excel file. Now the importing part has been successfully completed i am using OLEDB Connection but Stuck in exporting the same data to a new Excel file. tried … |
| | I have an existing table in an Access DB that I want my user to be able to copy by pressing a button. When the user presses the button, they should be prompted for what is to be the name of the table. The program should then copy the existing … |
 | The other day I tweeted that MySQL unions are my new best friend. I just want to take that back. I just spent the past six hours (it's now 5 am) overhauling a MySQL query and removing one of the unions actually sped up performance. Dazah is really my first …  |
 | hey, I need help :) Now I realized that this problem. In my software there are many reports. I used report viewer (defualt comes with visual studio) control for reporting. All the other forms loaded to MDI paren form. I run one of report. Then I run another report then … |
| | I am using VB **Problem: **when i click on sort col and click on refresh button, than i get popup browers message "To display the webpage again, the web brower need to resend the infomation you've previously submitted." **Recreate this problem**: click on sorting col of gridview -> refresh page … |
 | Hello I'm new to python so I was thinking on building a simple neural network...I think I'm almost there and got an error, so I would really need a help right now. from PIL import Image from scipy.misc import imread import matplotlib.pyplot as plt import matplotlib.image as mpimg from pybrain.tools.shortcuts …  |
| | Hi I have writen a web service. this web service has a method that returnes a Table as XML format and I need to use it as a table. how can i use this web service as a table. is any way to convert XML format to Table format Thank …  |
| | Hi, I have a form (FrmOverView) that’s based on a dataset containing a number of related tables, one of which is named TblCustomer. This form shows, amongst other things, Tblcustomer details in a gridview. What I want is to open another form (FrmCustomerDetails), that shows individual customer details in greater … |
| | Hi! So, I have a dataset which is filled with data after a mysql SELECT Statement, I'll call the dataset dsResults.Tables("Results") Inside the dataset is data that I want to be filled into their respective text boxes. The columns in the dataset are expected to vary, for example, sometimes it …  |
| | First of all-I will guarantee I will mark the thread as solved when you kind people have helped me to solve the problem. Ok well Ive got a project which is to make a Quizzing System for my school using a database. It is a multiple choice quiz (so only …  |
 | Hello Guys! Please help me out!!! Curently finishing a small project, when my boss asked that the report should include the person Photo... CR won't display photo unless it is stored directly into DataBase. I read some where it is easuer to use Parameter to save both text and image. … |
 | Now, i have Set up the Connection to MySQL,and i have this Layout: |ID|Class|Name|Password| The Names are ALL shown in Combobox2.But i have a Combobox1 with Numbers.Now if i select 1, i want only the Users with Class 1 to show in my Combobox2,when i Select 2, only Class 2 … |
| | getting conversion error I am creating a website using a VB Error: if I print getID1 Conversion from string to type 'Integer' is not valid. Error: if I print getID2 NullReferenceException was unhandled by user code. Object reference not set to an instance of an object. ** # .aspx file …  |
| | I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used Form1 to add data to database using OLeDb command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following [code] Private …  |
 | Hi, Am trying to log my traces using common logging with log4net, am able to get my traces by using log4net but on top of it when i try with common logging dll then could nt able to get my traces .advices will be helpful. <configSections> <sectionGroup name="common"> <section name="logging" … |
| | I'm newbie to vb.net. Now I'm on report viewer component. I'm just trying to generate reports. It's okay with select data from one data table of mysql. But now I trying it advanced. I try to generate report data from two data tables. This is query I tried. It show … |
| | Hello. I'm new to programming and I'm using vb.net 2010 and I'm stuck with this problem. So here are the details, I have 2 tables in my database, a product table and a category table. In my product table I have product no, product description and category no. In the … |
| | Hi, I am trying to get the the number of rows that are populated in a SQL Server table. I am using the code below but it only counts one row everytime when I know in fact that there are 47 row in a particular table. Could someone please point … |
| | so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with … |
| | hello every one this my code to fill my combobox with the name of clients and i but the connection string in a module to let my prog workimg in any pc in the group But the problem here in the combobox says can not make the connection, I know … |
| | 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; using MySql.Data.MySqlClient; //Add Mysql Library using System.Configuration; namespace MindLab { public partial class ImportFile : Form { MySqlConnection myConnect; MySqlCommand cmd; string strSQL = null; public ImportFile() { InitializeComponent(); //InitializeOpenFileDialog(); } private … |
| | I'm just trying to connect vb.net application to my cpanel web host space's mysql database. I got some idea from internet and tryied. But It doesn't work for me. If you know about this help me. I think it was great help for others too. my whole code is this … |
| | hi i currently facing this prblem" the connection was not closed. the connection's current state is open" how to solve it Imports System.Data.OleDb Public Class frmOrderSummary Dim con As OleDbConnection Dim selected_Row As Integer Dim selected_ID As String Dim order_id, food_id, orderdate, quantity, food_name As String Const CONNECTION_STR As String … |
| | 'Private Sub ComboBox1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.SelectionChangedEventArgs) Handles ComboBox1.SelectionChanged ' Dim cmd As New SqlClient.SqlCommand ' Dim tbl As New DataTable ' Dim da As New SqlClient.SqlDataAdapter ' Dim code As Integer ' Dim ds As New DataSet ' Dim sql_empid As String = cmbaaa.SelectedValue.ToString ' Try … |
 | I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to … |
| | Dear all, I wanted to fill the combo box with the data from my SQL server database. There are two column in the table, product_id and product_name. for example: product_id| product_name ---------- -------------- 1| pencil 2| NoteBook I was successful in displaying the product name in combo box. The code … |
| | I keep getting "List index out of range" when trying to execute this code, but for the life of me I cannot figure out why, If anyone has any experience coding linux gDesklets this would help. File: StockWatcher.display [code] ... parser.dataSet = stockInfo.html ... [/code] stockInfo.html is an object containing … |
| | HI, I am new to C# programming, I am trying to populate data from databse using adatpter and dataset. I am missing some part in my code, that fails to update selected item at selectindexchnaged. Same part works fine at every form_load. DataSet sdnew = new DataSet(); SqlConnection conn01 = … |
| | how fixed this error " **Table is a not member of Data set"** pls need help .. vb.net window application Public Function inst() As DataTable Dim cmd As New SqlClient.SqlCommand Dim tbl As New DataTable Dim da As New SqlClient.SqlDataAdapter Dim ds As New DataSet Dim sql_select As String Try … |
| | how can i get the value ...which code write in button click event that get my id.. USE DATATABLE Public Function inst() As DataTable Dim tb2 As New DataTable Dim st As String Dim dfsty As DataSet Dim df As New SqlClient.SqlDataAdapter Try cn.Open() st = "SELECT EmMaster_EmploId FROM(EmMaster) WHERE … |
The End.