2,634 Topics
 | |
| | Hello, I have created multiple tables in a dataset when I load a page. Some of the information for those tables are on a form. After making changes to the data on the form, I want to go back to those datatables to write to the SQL table. Here is … |
| | Hi can you pls help me for code to check the duplicate data before instert or update records.... i work with Ms Access database 2003 with disconnection mode (dataset) into vb.net 2008  |
| | here is screenshot. http://i.stack.imgur.com/0LAQZ.png and here is 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.SqlClient; using System.Data.SqlTypes; using System.IO; using System.Drawing.Imaging; namespace SampleApplication { public partial class AddNewUser : Form { public AddNewUser() { InitializeComponent(); } // set the … |
 | I'm trying to delete a row from gridview manually, i mean that i can use SHOWDELETEBUTTON=TRUE, that's easy but i want to delete it via button code, so far i have done this but couldn'y figure out that what to do more .aspx <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %> …  |
| | hi I'm having problems in my crystal report where all the selected rows in my datagrid will show up in my crystal report but instead it showing me an exception selectcommand.connection has not been initialized here's my code in my form where the datagrid is: Dim cmd As OleDbCommand = … |
| | Please Help: I am making an internet Cafe system that will login his/her account If user still have time left on his account(database) then login success and countsdown hours and minutes to zero if user logsout it will update the database "timeleft" of the current user If 5 minutes remaining …  |
 | Hi! i have a slight problem here,I have the following master tables M_employee EMPID Name 1 abc 2 xyz M_Division DIVID EMPID DIVISON 1 2 arts 2 1 science M_Designation DESGID EMPID Designation 1 2 Teacher 2 1 Scientist and based on the ID's present in the master table i …  |
| | like answers should be technical, i know the code to fill and update everything, but i actually don't know precisely that how it does ? like i change row in GRIDVIEW and click update, it changes(updates) data in database too, some says that SQLDATA-Adapter do this but even in my … |
 | I want to retrive data from table to combobox I used this coding though I didn't get an error the outpiut(data) is not displaing in the combobox Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click MessageBox.Show("Please Insert the Sample note no", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) Try myConnection … |
| | I am unable to insert data into database, plz help me out. This is my 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; namespace labsoft { public partial class test_group : Form { Form opener; public test_group(Form parentForm) { InitializeComponent(); opener … |
| | Can't Update my User Table "Hours" "Minutes" "Seconds" from the current value of the timer where it has stopped I used button to stop the time Imports System.Data.OleDb Public Class frmMain Public hh As Integer Public mm As Integer Public ss As Integer Public totalsec As Integer Public timercount As … |
| | i'm trying to hide EDIT button in a column when i click it but it doesn't. Actually, i manually created EDIT button in gridview, it worked :) but now after clicking edit button i want it to disable so i can put UPDATE button while editing. i tried but it …  |
| | like i am setting a button i gridview which when i click then shoulf turn row into editable mode, i could use Automatic EDIT button of Gridview but i didn't on purpose, it went good when i developed a delete button, +1, but stuck with this edit , it throws … |
| | Good day! Im developing a client server application that send dataset from the server going to client. I have successfully send my dataset from the server after converting it to xml string. My client had also successfully recieve my xml data from the server. I had also successfully load my … |
| | I am making a login system that records time in and time out for students.. but the student can't sign in if already "Signed In" and student can't sign Out if already "signed out" that is why i have three form. **THE CONCEPT OF THE PROGRAM: When i log in … |
| | filter combobox in a datgrid based on another combobox vb.net Hi ,, i have problem with combobox i have two combobox and two tables table manages (ManageID, ManageName) table Departments (DeptID, DeptName, Dept_ManageID) 1- CboEmp_Manage 2- CboEmp_Dept Public Class Class1 Public sub FillCombobox (ByVal cbo As Combobox, ByVal TableName As …  |
 | string s = "select * from StudentDetails"; SqlDataAdapter da = new SqlDataAdapter(s, con); DataSet ds = new DataSet(); DataRow therow; try { con.Open(); da.Fill(ds, "StudentDetails"); TextBox1.Text = "" string s = "select * from StudentDetails"; SqlDataAdapter da = new SqlDataAdapter(s, con); DataSet ds = new DataSet(); DataRow therow; try { … |
| | Hi friends, thanks all for your contributions here at DaniWeb Community. I want to ask one thing; I have a table where I keep values for students marks (StudentID,Marks). Let's say there are 50 students. I want to be able to display on the form the class rank for each …  |
| | Hi again............ I'm having problems in saving the data in my datagrid to my Database Imports System.Data.OleDb Public Class Form2 Dim con As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\RMC\Documents\Vehicle.accdb;") Dim cmd As OleDbCommand Dim adpt As OleDbDataAdapter Dim cb As OleDbCommandBuilder Dim sql, lol As String Private Sub Form2_Load(ByVal sender As System.Object, … |
| | Hi I'm new to .NET technology and learning ASP.NET using C# database connectivity and I'm getting the error[B][COLOR="Green"](PLS HELP):[/COLOR][/B] [B][COLOR="Red"]Could not find installable ISAM.[/COLOR] [/B] in the following code: [B]using System.Data.OleDb; public System.Data.OleDb.OleDbConnection conn; public System.Data.OleDb.OleDbDataAdapter adapt; DataSet ds; ds=new DataSet(); conn=new OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0;Datasource=C:\\Inetpub\\wwwroot\\pracs\\emp1.mdb"); conn.Open(); adapt=new OleDbDataAdapter("select * from emp",conn); adapt.Fill(ds,"emp"); … |
| | i just found this code it was really nice, as im just a beginner i can't solve it. when i execute the code the text inside the combobox is not my database but instead a text "System.Data.DataRowView" im really newbie in vb.net im really curious how will this work. thanks …  |
 | Guys i need help it says there is a data mismatch in criteria expression need help fast!! Dim statement2 As New OleDbCommand("select * from Student_registration where Student_code = '" & studentnotextbox.Text & "'", conn) Dim statement2 As New OleDbCommand("select * from Student_registration where Student_code = '" & studentnotextbox.Text & "'", … |
| | I have 2 forms. One is a typed list having 3 controls (fields) loaded from access database (copied to project as part of .xsd). The values in this list represent recommended values of items and will also be applied to another 3rd form eventually. In the 2nd form there are …  |
| | [CODE]Public Class Form5 Dim connection As OleDb.OleDbConnection Dim mystr As String Dim cmd As OleDb.OleDbCommand Dim adp As OleDb.OleDbDataAdapter Dim ds As New DataSet Private Sub Form5_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) connection.Close() End Sub Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load mystr … |
| | I want to bind database value to combo box in C# windows form. I know this is a common problem for begginers. I search in the internet about this. Acoording to that I modified my code. But my problem is, it is not raised any error message and data not … |
| | Hi, Imagine a vector of structures with each structure containing various variables. struct Data { double x double y double z } vector<Data> Dataset vector<Data>::iterator it //input some data from a file into DataSet How can I iterate over this vector, comparing say, x at the nth row to the … |
| | I'm making a class dataset. In it, I'm trying to set the minimum max and the mean. In my given test, I am asking the user to input as many grades as they would like so what I did, for example in minimum is this.. class Dataset(object): def __init__(self, grade): …  |
| | So far I can compute and update seperately a specific row when type it in a text box. What I want now is to read and update rows automatically up until the last record. Imports System.Data.OleDb Public Class Form1 Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=G:\Raw Data.xlsx; Extended Properties=Excel 12.0;") … |
| | 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 …  |
| | I have a winform that uses a reportviewer to show a list of records. The form load correctly shows all the records in the dataset. The form also has a ToolStrip across the top of the form that allows the user to enter four pieces of information to search by. … |
| | Okay, I have used databases before, but I always created the bindingsources and other things i needed via the visual designer, and now I want to create them with code, so I can make a button to refresh the database without closing it, the problem is that I don't know … |
 | Hello to all. I want to know how i can merge 2 different rows of a dataset when the ID of the 2 different rows are equal. Can you help me? THX |
| | I have a DataGridView whose DataSource is a DataView based off of a Datable. I am allowing the user to filter the DataGridView based on value in cells within a Column. After the user selects the value to filter - I create a filter string and apply it to the … |
| | my problem is how to add new records from database using dataset? jhermzb_22 |
| | I have a large data set (12,000 rows X 14 columns); the first 4 rows as below: x1 y1 0.02 NAN NAN NAN NAN NAN NAN 0.004 NAN NAN NAN NAN x2 y2 NAN 0.003 NAN 10 NAN 0.03 NAN 0.004 NAN NAN NAN NAN x3 y3 NAN NAN NAN … |
| | I am building an application that needs to access a database. I installed SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages. Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see … |
| | hi to all im new here, i have some difficulty in displaying records from database to my combobox here is my code in the form_load [code] Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim con As New SqlConnection con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\lito\Documents\QMP_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" … |
| | Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …  |
| | Dear friends, I have a set of values as follows (filename is string; values are floating; notimportant... is self-explaining): filenameA, value1_1, value2_1, value3, value4, notimportant filenameA, value1_2, value2_2, value3, value4, notimportant filenameA, value1_3, value2_3, value3, value4, notimportant filenameA, value1_5, value2_5, value3, value4, notimportant filenameA, value1_7, value2_7, value3, value4, notimportant ... …  |
| | Hi Everyone, Thank you for viewing for my enquiry. It is about ASP.NET C#. This problem is the stored procedure and dataset/UI. When i try to search 1000 records, the dataset count is 1 only and the stored procedure return 1000 records. I have manually used the SQL profiler and …  |
| | I have a login form that asks for credentials for access to select areas of a large app I wrote. I am trying to add a form to allow for password changes via that app instead of me having to update the SQL DB manually. DB has 1 table called … |
 | I've built a classifier after following an online tutorial. I take a bunch of tweets, use a HTML parser to get rid of unescaped syntax, remove everything shorter than 3 words and make a dictionary out of them. I then work out the frequency distribution of the words and so … |
| | Okay,First of all let me introduce myself as newbee to this language. this is my third day with program,I usually Practice at college where Visual studio 2010 is installed. I have VS2012 ultimate. If I sound silly forgive me,but I am really desperate here. 1st Problem,I couldnt create New SQL … |
 | Hey boys and girls, I need help, I am working on a project that requires me to build a business tier (.dll) for a c# program, I've only ever used SQL server. The problem comes in as follows, at university I was tuaght how to import a datasource via the …  |
| | When i run my program there's an error in conn.open() and tells "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Please help me to solve this problem... Here's my code: Dim ds As New DataSet Dim dbSource As String Dim …  |
| | Is there any way to show the highest value from a access db column in a textbox which you put in the load of a form? Found something by searching around, but did not get it to work at all. Maybe because i cannot open a connection in the load … |
 | Back in December 2011, reports were circulating regarding a data breach at one of the big Chinese social networking sites, Tianya.cn that suggested the login credentials of some 40 million users were potentially exposed. Clear text usernames and password combinations were stolen by hackers during the breach, although a Tianya …  |
| | I got a small problem with getting a filter to work for my database. When i test them seperatly it works but when i all add them together they stop working. This is the code i use currently. All of the fields in the database are text, except for the … |
| | I have been searching codes to draw line charts using jfreechart on internetand encountering the constant problem of pack(). When I copy the code I find on net the compiler compiles it. But when I try to use it in my code, the compiler shows error. I don't find its …  |
| | I want to compare a date in a database to today's date and it they are equal. Display the contents of the related date in the database in datagridview on a new form. This is my code Private Sub TimerAppoint_Tick(sender As Object, e As EventArgs) Handles TimerAppoint.Tick Dim TheDate As …  |
The End.