2,634 Topics
 | |
| | Hi guys, I have an issue with the code I've written in C# where the listview will connect to the database without a problem but it will only populate the 1st row of the table BUT.... it will duplicate it for the exact amount of records I am expecting to … |
| | System.Data.DataRowView Hello people. Ive got a problem with a listbox of mine. I have three lisboxes, one listbox1 is for product category, another lisbox2 is for the product itself in which it will appear after the user has chosen a product category AND another listbox3 which acts like a shopping …  |
| | I have an inventory system I am making for my business. I have a form that has a listbox control that lists all the orders that have been submitted. I also have a datagrid that lists the items in the order based on what is clicked in the listbox. I … |
| | i have this code...i m retreiveing did from selected name........ i want to assign this to varible because i want to use this variable to another place... i hope i will get help here.. [code] MyDataAdapter = new SqlDataAdapter("select D_Id from tblDepart where D_Name = '" + D_Name + "'", … |
 | Hi all, I am writing a service to get a count from a table on an SQL server. THe SQL box is in the same domain, and the service is runnign under the same account as the SQL box. The box service is running on is Win 2008 in the …  |
| | Hi. I am having connection issue while connecting to using below string provider=IBMDADB2;Data Source=XXXX.XXXXX.COM:5000;Database=C2RCU0;Uid=s858;Pwd=cccc Getting error like database not found. But What i found was connection to mainframes it self was not happenning. Do i need to provide any other information or what i am missing here.. sConnection As String …  |
| | <?php error_reporting(E_ALL ^ E_NOTICE); set_time_limit(0); $hd = mysql_connect("localhost", "root", "") or die ("Unable to connect"); mysql_select_db ("movie", $hd) or die ("Unable to select database"); $res0 = mysql_query("SELECT * FROM users", $hd) or die ("Unable to run query"); $count_users = mysql_num_rows($res0); $res1 = mysql_query("SELECT * FROM movies", $hd) or die ("Unable … |
| | Dear Experts, **Problem :** I need to save a datatable to a binary file , in binary format , in order to make the process fast because the datatable may contain up ten millions rows. So , XML is not favorable because it makes the file large sized , and … |
| | Hey, im trying to dynamically add an image to a gridview for each row if it meets a condition. DataTable dtSub = new DataTable(); dtSub.Columns.Add("ID", Type.GetType("System.String")); dtSub.Columns.Add("FirstName", Type.GetType("System.String")); dtSub.Columns.Add("LastName", Type.GetType("System.String")); dtSub.Columns.Add("Tutor", Type.GetType("System.String")); dtSub.Columns.Add("test", typeof(System.Web.UI.WebControls.Image)); //not sure if this is correct?? DataSet ds = new DataSet(); ds.Tables.Add(dtSub); Session["myds"] = ds; foreach …  |
| | Dim cmd As OleDbCommand = Nothing Dim smd_search As String = "select * from Old_info where UG_PG='BSc'" Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Bavu's\project\vb files\dms\SPA_Database.accdb") Dim myDa As OleDbDataAdapter Dim mydataset As DataSet cmd = New OleDbCommand(smd_search, con) myDa = New OleDbDataAdapter(cmd) mydataset = New DataSet() Try If con.State … |
 | Hello, I have a datagridview and I allow a user to fill in some checkboxes which call stored procedures to show only certain data based on the criteria given by the user. [COLOR="Red"]I then want to take all that data that is currently shown in the datagridview and copy it … |
 | Ok, so the scenario is a database which stores customer contracts (to keep it simple) so that every time a contract is expired and renewed a new version is created in the database to reflect any changes (terms, price etc). My page needs to display a list of the latest … |
| | this is my csharp 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.Configuration; namespace MutlitableDatasetApp { public partial class MainForm : Form { //form wide dataset. private DataSet autoLotDS = new DataSet("AutoLot"); //Make use of command builders to …  |
 | Hey guys! can you please help me.... I need my user to login to the application, My program must detect to wich depearment to user belongs to, for example if the sales person logs into the application the sales form should be called.... and so on! Having a little problem … |
| | I have a bound datagridview and a dataset with tables. I have two sets of comboboxes bound to the same field "Restaurant" in the tables (mirroring each other). In the "NewEmployeeRestaurant" combobox I change the value and it reflects in the datagridview. I can shoot around clicking all over the … |
| | Hi All, I am using Visual Studio 2010 and for my database I'm using SQL I am trying to make a multi user login and valdate the input with my datatable the problem is that i made a login page but it's just check the username and the password but … |
| | hi...... projot here I am facing a problem in the code i have to populate the combo box from datagrid view from database just help me in doing it this code is giving me an error my contact no is 9049776416 Imports System.Data Imports MySql.Data.MySqlClient Public Class supplier_update Dim con1 … |
| | i used this codes to show the records but this doesnt works .. but when use the query ("Select * from Schedulings") it works .. it shows the all records. but i want to show the records that satisfy this query.. ("Select * from Schedulings where YearLevels = '" & … |
| | Hi, I am using an asp.net web application in which I want to retrevie database table names into my dropdown list box. I have wrote code for this there are no errors but I dont get any table name to my DDL box. Kindly help, Thank you. MySqlConnection connect = …  |
| | hi!! im a new to vb.net and im having a problem, pls help me ok here it is... i created a listview, and i have a button5 "view records" if i click the button, all the records should be shown to the listview but yeah i doesn't work here are … |
| | hello :) i am working with Search module of a student.. there's a link on the form that when clicked the schedule of the student must be shown on Listview in ScheduleStud Form.... actually i used the showmyrecords() on the other forms but when i used it in this module.. … |
| | i have one combobox and it is containing some items when ever i changed that item the output is generated according that it means i store databases in my combobox the default item is "select" like this I have so many forms when ever i changed my cbdatabaselist that database … |
| | Hi All ! I want to Import an Excel File to a DataGridView as FirstRow (Except A1 Cell that's null)will be Column HeaderCell in DataGridView and First Column in Excel file (Except Cell of A1=null) will be Row HeaderCell in DataGridView .Here is my code : ~~~ string connectionString = … |
| | So I am trying to write data to a SQL directory the code is suppose to take a finger print and store it in a directory and for some reason the data in the DataRow myRow is always null I have tried everything. sqlCommandText = "select * from xluser where … |
| | Hey, I'm pulling data from a table, and storing it into a DataRow. Per [MSDN](http://msdn.microsoft.com/en-us/library/system.data.datarow(v=vs.110).aspx) , I should be able to get an item from the row simply by `dRow.Item("time")`, but I only get the option of using ItemsArray. Is there any specific reason this would happen? Thanks. Link to … |
| | Dear All, I have a small probelm with updating my database. Here are my codes ~~~ vb Module AphidSimVar Dim myCon As SqlCeConnection = New SqlCeConnection("Data Source=|DataDirectory|\AphidModel.sdf") Dim myCmd As SqlCeCommand Dim myAdap As SqlCeDataAdapter Dim myDataSet As DataSet Dim myTable As DataTable Dim myBuilder As SqlCeCommandBuilder Public Sub ShowData() … |
| | hello again :D i want to update my database if an enrollee have balance or dont have.. if they have balance , the record of payment of student will be updated.. here's my code : Dim cn As OleDbConnection If TextBox1.Text = "" Then MsgBox("Enter a Student Number! ", MsgBoxStyle.Information, … |
| | Dear All, I have few question regarding using Treeview in my project. The screen of my project is been attched. I can populate the data from database in treeview using following code: ~~~ vb Imports System.Data.SqlClient Public Class Tree Private Sub Tree_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles … |
| | My textbox6 represents the dateprinted of my asssessment form.. i code it like this : TextBox6.Text = My.Computer.Clock.LocalTime.Date then in the my SAVE Button coded like this : Dim cn As OleDbConnection If TextBox1.Text = "" Then MsgBox("Enter a Student Number! ", MsgBoxStyle.Information, "Warning") ElseIf TextBox1.TextLength = 9 Then con …  |
| | My textbox6 represents the dateprinted of my asssessment form.. i code it like this : TextBox6.Text = My.Computer.Clock.LocalTime.Date then in the my SAVE Button coded like this : Dim cn As OleDbConnection If TextBox1.Text = "" Then MsgBox("Enter a Student Number! ", MsgBoxStyle.Information, "Warning") ElseIf TextBox1.TextLength = 9 Then con … |
| | hello! i'm trying to implement an audit trail in my system and what i wanted is that when the user click the login button, infos like username, level of access, time in and date will be save in the database and fortunately i have done it and here is my … |
| | hi... anybody want to help me to solved my problem i want to get value from gridview column into textbox. i have DGS4 as my gridview . and i want to use query like i used bellow. i uses some code from @luc001 but it stil not working. this is … |
| | hello friends, i m developing an windows application in VS2010 using Visual C# and MS Sql 2008 R2. i have a form consisting of datagridview and a Combobox. Name of DataGridView is "dgAccount" having three columns "Name","RollNo","City". Name of Combobox is "cboName". The Name of my DataBase is "dbAC". The … |
| | i dont know what to do with this codes. when i used this to other forms it runs without error except for the one form. error says : "The ConnectionString property has not been initialized." but then i already initialized it. please help me. Public Sub showmyrecords() Dim lvi As … |
| | hi everyone! below i will be showing you the codes of my scheduling module for an enrollment system..my problem is that on how to set conflict here is the code: Option Explicit On Imports System.Data Imports System.Data.OleDb Public Class Scheduling Dim con As OleDbConnection Dim com As New OleDbCommand Dim … |
| | I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: MySqlConnection myconn = new MySqlConnection("server=localhost;user id=root;password=db;database=workers;"); // myconn.Open(); string strSQL = "select * from details"; MySqlDataAdapter mydata = new MySqlDataAdapter(strSQL, myconn); MySqlCommandBuilder cBuilder = new MySqlCommandBuilder(mydata); … |
| | hi :D please help me with this problem. i'm a newbie in vb.net i have 6 columns in my listview that should show the data from the database.. but when i coded it like this : Public Sub showmyrecords() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) …  |
| |  hi everyone! below i will be showing you the codes of my scheduling module for an enrollment system..my problem is that on how to set conflict. i included a screenshot of the interface for further understanding... i hope you could help me... here is the code: Option Explicit … |
| |  i have here below codes of my maintenance module..my problem is that when i click the edit button and search for student number it makes error in saving but when i use the listview to edit it saves successfully...please help me i'll be attaching a sample screenshot here's … |
| | i have codes for adding data to listview from database but there's a problem .. Public Sub showmyrecords() Dim lvi As ListViewItem Dim dt As New DataTable Dim ds As New DataSet ' Dim intCount As Integer ds.Tables.Add(dt) Dim da As New OleDbDataAdapter("Select * from Schedulings where YearLevels = '" … |
| | I wana know how can i use a value from a sql table that i added from another form? It basically supposed to validate that whatever was the last recorded added in the other form(eg formA) , i must then use those same values from the sql , into another … |
| | Hi all, I'm a VB newbie in this respect so please be patient with me! I have an app that requires the user to input a bunch of values for various things in textboxes, datagridviews and propertygrids. I want this user input to be written to a text file in … |
| | Hello again, I am trying to set a filter button into my application and I need a little bit of help.. Acually I want the user enter the city of the customers (etc:Brampton-Ontario ) and the program prints out the customers of the ontario. If there aren't any records to … |
| | I have an application that can filter a datagridview based on date using a datetimepicker. The "date" column in my database is a datetime data type, hence it will contain a date and time stored within but there is some data which have only dates. My problem is my datetimepicker … |
| | hello, I'm creating e-menu system for a restuarent... It has 3 users... and in staff user i want , when the staff see orders of the custmer from StoreOrders1 table which will be displayed in DataGrideView ... i want a botton to move the records of StoreOrders1 to ReceiveOrder table.. … |
| | hi every 1/ . i am having problem in sql query. if i double click on the dataset. i am not sure which statement to write to restrict the user so that he/she cannot enter the date in the past. i have droped the data set on the form and … |
| | hi Every one i am having problem in deleting record from textboxes and gridview. i have customer table and booking table. what i want to do is when i click the delete button the customer and its related booking should be deleted. i have written a code which onlt deletes …  |
| | Hi I am working on a project in c# where a part of my application should allow user to generate schedules for courses for this there will be a table named "session" in database which will store all the information of the schedule which has been created by the user … |
| | i have this problem : Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information. ... the button used to delete record in my project is button6 at the end of the code my code : [CODE]Public Class Form1 Dim … |
| | I'm trying to create a webpage that will allow the user to input a vendor number(text box) and if the number exists populate the form with vendor name, phone and state using a stored procedures. Below you will find the stored procedures and after it my webpage. Stored Procedures: SELECT … |
The End.