2,634 Topics
 | |
| | Ok so for some reason I can't get the current item I selected in my datagrid to display on my textboxes I'm new to vb net and programming itself so please bear with me. here's my code: [code] Imports System.Data.OleDb Public Class Form1 Dim con As New OleDbConnection Dim ds …  |
| | [CODE] Dim conn As New OleDb.OleDbConnection Dim dbprovider As String Dim dbsource As String Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim sql As String Dim maxrows As Integer dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbsource = "Data Source = d:\sprrg\scm\scm\sprrg.mdb" conn.ConnectionString = dbprovider & dbsource conn.Open() sql = "select … |
 | Private Sub autocus() Call main() Con.Open() Dim cmd As New SqlCommand("SELECT cust_order FROM Inventory", Con) Dim ds As New DataSet Dim da As New SqlDataAdapter(cmd) da.Fill(ds, "My List") 'list can be any name u want Dim col As New AutoCompleteStringCollection Dim i As Integer For i = 0 To ds.Tables(0).Rows.Count …  |
 | HI I am using - ASP.Net - C# - SQL Server Express 2008 R2 I have a table called customers which contains all customer details and a stored procedure which gets: - Total No Of Customers - Total No Of Customers in Region1 - Total No Of Customers in Region2 … |
| | Hi, I seem to be having a problem with displaying data in a second form. I've created a linear search algorithm which works just fine - it locates the records from the database. I now want to be able to display the record in another form, I've attempted this using … |
| | HELP ME PLEASE. I AM A 1ST YR COLLEGE STUDENT :/ Define an interface Filter as follows: public interface Filter { boolean accept(Object x); } Modify the implementation of the DataSet class to use both a Measurer and a Filter object. Only objects that the filter accepts should be processed. … |
| | Hi i have the following code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection Dim da As New OleDbDataAdapter Dim ds As New DataSet Dim dsnewrow As DataRow Dim cb As New OleDbCommandBuilder(da) Dim a As String con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB.mdb;Jet … |
| | Hi guys, i used the query for randomly selecting questions from access but it will give me same result, i try it by passing different different values also passing time in rnd fuction but i will display same result. [CODE] DataSet ds = new DataSet(); string strsel = "select * … |
| | Dear all, I am certainly not a web developer nor a computer scientist but a little biologist. I developed my tool to analyze some high-throughput biological results and I'd like to make it available online. My prototype : [URL="http://homes.esat.kuleuven.be/~sbrohee/test/new_gsea/php/"]http://homes.esat.kuleuven.be/~sbrohee/test/new_gsea/php/[/URL] Just to make it simple, the user must have the choice …  |
| | hello im working with vb 2010 and ms access as data base, just newbie.im trying to save the loged out date and time to my access table by selecting from tblloghist wherein my column SystemUserID is equal to my textbox SysID(located at my form) then it will save the timelogedout … |
| | hi all I need help plzzzzzzzzzzzzzzzz my project uses asp.net and sql database I use treeview to insert and retrieve hierarchical data from the database I used the following code the problem is when I added the code for the retrieval the insertion has a problem where I can't add … |
| | hi all i want have a one form to always return columns[0] of selected row . intermediate method is ReturnAllCode...s i writed a public method ReturnAllCodes that I want always return Columns[0] Of selected Rows form form that i want ... public int ReturnAllCodes(string WinTitle, string Query, string[] Fields, string … |
| | I am using rdlc reprot in VB (Visual Studio) with MS Sql Express. I want the output as given below : [ICODE]SrNo. Amount 1 100 2 100 3 100 4 100 Group Total = 400 5 200 6 200 Page1 Total = 800 ***************************PAGE1 END HERE**************** 7. 200 8. 200 … |
| | Hello This is my first post so I’m sorry if I ramble and don’t explain my issue clearly. I am binding a dataset (dsTest) with a table called “TempResult” to a datagrid (DatagridView1). The purpose of the datagrid is to display test labels (set elsewhere in the software) and to … |
| | Now i am tring to make a data set by creating it in separte DLL file(using VB net) the code i used in this dll fle aready workong in my form but i tried to use it by this diffrent way ,,,but no way this is the code of the …  |
| | I have a DataGridView containing information of cities of the world. User can retreive records and insert record of cities from DataGridView. Since every city is associated with a country, therefore in order to insert a new city user must insert country information too. For this purpose, i have created … |
| | I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below, could anybody help me? [CODE] Imports System.Data.OleDb Imports ADODB Public Class Form_Main Dim cn As OleDbConnection Dim StudentUpdateCommand As New OleDbCommand Dim …  |
| | I have two combobox in a form: Cb1 and Cb2 When I load the form, Cb1 and Cb2 are connected to a bindingsource. When I change Cb1, the code (below) changes Cb2 to show only the items according to Cb1 This is working fine. The problem is when I change … |
| | Hi All, I have many DateTimePicker (DTP) in a windows form (Say atleast 15 DTP) I need to do following things in the form 1)A Dataset is field with values from database (MS SQL) which contains the DateTime data and now i want to assign it to DTP and Doing … |
| | Hi all, I am trying to error check a piece of code and hope someone can help. This is from my previous thread which 'Codeoder' help me on.. [URL="http://www.daniweb.com/software-development/vbnet/threads/403994/1725770#post1725770"]http://www.daniweb.com/software-development/vbnet/threads/403994/1725770#post1725770[/URL] I have a RTB which I import with a set of 7 or 9 didit numbers, 7 for Staff and 9 … |
| | i want my order id to be autoincremented and stored in textbox and when i hit click, it gets stored in datagridview, so i can save my order in bulk from datagridview again. my code have some issue [CODE] 'i put this on formload (order page) Dim order As String …  |
| | Hi evryone, am working on datagridview contains a textbox and a combobox. string msql="Select * from Supplier"; private void txtgridsearch_TextChanged(object sender, EventArgs e) { objcon = new SqlConnection(objconstring); objcon.Open(); objcmd = new SqlCommand("INV_SP_Search_Supplier", objcon); objcmd.Parameters.Add("@supplierid", SqlDbType.Int, 0, "supplierid"); objcmd.Parameters.Add("@companyname", SqlDbType.VarChar, (50),"companyname"); objcmd.Parameters.Add("@contactname", SqlDbType.VarChar, (50),"contactname"); objda = new SqlDataAdapter(objcmd); objds = … |
| | HI ALL I HAVE SMALL PROPLEM I CANT SOLVE AND I THINK ITS SIMPLE I ONLY TRY TO FILL THE DATASET WITH TABLEADABTER BY SELECT WHERE IN FILL,GET METHOD BY SELECT STENAME, PATENT, RCOMER FROM FOURNI WHERE (RCOMER =@RCOMER) I ALWAYS GOT THE ERROR Error in WHERE clause near '@' … |
| | Hi everybody, Actually I'm trying to do small form that has a textbox for BARCODE which when I scan an item it will add on my listview but I recieved this error that I don't know what went wrong in my code "System.NullReferenceException: Object reference not set to an instance … |
| | Hi, What's the problem in the below code... [CODE] Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsNewRow As DataRow dsNewRow = ds.Tables("mr_head").NewRow() [/CODE] I am getting the below error : Object reference not set to an instance of an object.  |
| | I am writing an application which calculates profit from 3 column values. The SQL is as follows in vb dataset designer; [CODE]SELECT ID, Sale - (Weight * 20) * (Rate -5) AS Profit From AgencyRegister WHERE (DatePart('yyyy', ArrivalDate) = ?) ORDER BY ArrivalDate[/CODE] I want to add another column of … |
 | how can i write a code for deleting a row using gridview [CODE] # protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) # { # GridViewRow row = GridView1.Rows[e.RowIndex]; # # objCust.CustId = Convert.ToInt32(objCust.findCustId().Tables[0].Rows[0][0].ToString()); # # objCust.DeleteNewUser(); # # if (objCust.DeleteNewUser() == 1) # { # bindGvEdit(); # } # } [/CODE] … |
| | Hi The code below is not getting executed when i m trying to make a line chart JFreeChart May be theres some problem with the persistence file.Every time I try to run it shows Jasper Exception... It shows the following [B][I][U][I]errors[/I][/U][/I][/B]: **An error occurred at line: 30 in the jsp …  |
| | Hey everyone, I'm going to do my best to explain this easily, even though the code might not be the easiest to follow. I have an "Edit" form made out of a TabContainer and TabPanels that I am populating with results from a few different datasets, after a user clicks … |
| | Hi again! I have a database and some tables filled with data. [code=c#] var club = Baza.Clubs; //Baza is dataset, and Clubs is table var schedule = Baza.Schedule; // same as above for (int i = 1; i <= 90; i++) { if(schedule[i].day == 2) // BOOM! Breaks at first … |
| | hi, i really don't know what exactly it is called :P , but i'll try to be clear on what i need. i have a text box and a listbox. when the text box get focus, it loads the listbox and displays the content. What i need my code to … |
| | Hi! Im working on a really simple client server app I have a windows forms which is connected to ms sql db using string conn a dataset and a data adapter presented in a datagridview in a form in my table, theres a column for price what i want to … |
| | Hi, I have a form where i can enter new product. In that same form i have listbox where i show the current product from the database. I want to know how to update that listbox as i enter new product into the database so that user can see the … |
 | I have a connection string for my SQL database connection called my.settings.GCRConnectionString which was created when I created my dataset for the application. I want to change the value of the connection string but it give me an error saying it is ready only. Is there a way to update … |
| | Hi! I created a really simple CRUD app in C# using MS SQL as back end. I connected the DB using connection string and use dataset, and data adapter to pull data from the db Im searching for the simplest way of checking record if it exist in a table …  |
| | Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the … |
| | Hello, Any help will be much appreciated. I have created a page tht will show search results on a datalist. this page was running perfectly before the addition of following lines in the page Load and BtnSearch_Click respectively. if (Request.QueryString["query"] != null) { string searchParam = Request.QueryString["query"].ToString(); BindList(searchParam); } .................................... … |
| | Public Sub getconcom_name() ledcmbsrcitem.Items.Clear() Try obcon.cmd.CommandText = "select con_id,f_name + ' ' + m_name + ' ' + l_name as 'name' from contact where type='company'" obcon.con.Open() Dim dr As SqlDataReader dr = obcon.cmd.ExecuteReader Dim oDataSet As New DataSet() While (dr.Read) ' MsgBox(dr.Item(0)) ledcmbsrcitem.Items.Add(dr.Item(1)) End While Catch ex As Exception MsgBox(ex.Message) … |
| | Hi All, I always have trouble with this every time I create a desktop app which needs to update data from a database. So, I have created and coded my form to load data into a data grid view control, I can add data to the data grid view and … |
| | Hi All, My wife is into the slimming world diet and has magazines with her favorite diets marked, so I decided to write her a desktop application so she can save all her recepies and tidy all those magazines. So please see my code for my breakfast form below [CODE] … |
| | hi guys i have existing column in datagridview sample column name (Student ID, Last Name) now i have mysql table column name sample(STUD_ID,LNAME) STUD_ID = int Type, LNAME= varchar Type. i used these code to display mysql table in datagridview if their is no Existing column [CODE] void dlist(string sqlQry, … |
| | Hello, I'm a newbie in vb :D however with all the information and help this forum had provided i reach this far with my code BUT i can't proceed anymore. I'm trying to make a small software which will help me in my work. I can't get it to work … |
| | Hello first sorry for my english... my problem is when creating xml from dataset in my dataset i got tables with relations. here is my xml sample that i have created.. but i dont want this. in this one column orders are wrong <ozel> <vergiToplami>1107.46</vergiToplami> <kismiVergiToplami>0</kismiVergiToplami> <toplamKDV>1107.46</toplamKDV> <toplamIadeEdilebilirKDV>0</toplamIadeEdilebilirKDV> <tecilEdilecekKDV>0</tecilEdilecekKDV> <tevkifatUygulanmayanlar> … |
| | Let me be specific: I have the following components in my project: 1) Form 2) Textbox 3) Button 4) DataGridView 5) A class named Database - It has all the code stuff to interact with the database means it can insert,update,delete etc I type the desired name in the textbox … |
| | I have the following problem: I have sample form with reportViewer on it & report type is rdlc report on c#. I added a new dataset then selected tableadpater on it then selected the database from mysql and I selected the Filldata method & provided a query to retrieve data … |
| | Hi, I am very new to C#.I am trying to create a webform to save data in SQl server 2008 using c#.My problem is when i click on the save button, the code saves the 1st record every time instead of saving the new record.all my textboxes are showing the … |
| | Could you please tell me how to clear the old data from the datagridview in vb.net.. the below code is retrieving the data from table and display in a gridview for particular person. but when i wanna check the next person record if he dosen't have record so the previous … |
| | Hey. I am working on some sort of client + project management system. Each client can have many projects, many projects can have many staff. The Link (Junction) table allows for many staff members to be linked to the projects. I have attached the relationships which have been put together … |
| | Hello everyone! First of all this is about DataSets. I made a table with some examples in MS Access and now I need to add new rows into this table from C# console application. I added DataSet (MSAccessBase) and used TableAdapter for adding MS Access's table into project Solution. I … |
 | Dear Expert, Thanks for helping me. I am facing problem while deleting a company from my application. When I click on delete ([COLOR="Red"]on comp1.aspx[/COLOR]) it direct to other Page ([COLOR="red"]company_delete.aspx[/COLOR]) when i put password as in databse , Instead it delete it gives error of wrong password. ([COLOR="red"]company_delete_save.aspx[/COLOR]). I mean … |
The End.