2,634 Topics
 | |
| | Hi all first post! I am attempting to read an XML and display certain portions of the XML in a datagridview. I was able to get one table at a time, but I am having trouble figuring out how to get ALL the info I want from the XML and … |
| | well I have been looking for the solution for two days for this small question but still no proper answer so plz don't ignore or put crap comments this is what I want ,I got two tables in my Access DataBase which connected with One-to-Many Relationship and I also use … |
| | hi, i have Ms Access database having three fields ID username password and i want to make form that update them, my table name is studentLoginData [CODE] MessageBox.Show("the password is matched"); String conString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Documents and Settings\\Wasif\\My Documents\\studentLogin.mdb"; SqlConnection objConn = new SqlConnection(conString); try { objConn.Open(); } … |
| | i am writing an application on my pc to insert record on a microsoft access database on another pc that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the access database is in the folder c:\inetpub\wwwroot\db.mdb. i have the … |
| | Hi, I have a code which generated dynamic gridviews based on a column ('c_AnalyticalSystemID"). Now I have a samll problem in passing cell parameter into a textbox which I clicked on a datagridview. the code is : [CODE] private void button1_Click(object sender, EventArgs e) { string query = "select t.c_AnalyticalSystemID,t.c_RetentionTime,t.c_IonType … |
| | HI I ama reading text froma file that have word like "you're" and it gives me Unclosed quotation mark before the character string ') error.Can anyone help me with this .Thanks [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; …  |
| | Hi, i am getting error Line 1: Incorrect syntax near 'Valuesstuntto'. and its an sql error.Can anyone help me with this thanks. [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using GermanDict; using SimpleFrenchDict; using System.Web; namespace DicttoData { … |
| | I'm trying to return a dataset from another function to be used in another function, but i am running to trouble. So i have this Binddata function which populates the dataset and then returns it, that goes thru the debugger and runs fine at my ASP.NET page. But when i … |
| | Hi, I have the following code in my form. I would like to retrieve data from the MS Access database to ListView1. What will be the code? [CODE]Public Class frmContacts Dim inc As Integer Dim MaxRows As Integer Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da … |
| | :?: Hi all I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object" Here is my code Thanks [CODE]Imports System Imports System.Data Imports System.Data.OleDb Public Class ExellFrm Private Sub …  |
| | Hi , I am trying to insert the arraylist to database using sql .I have my code below.Can anyone help me with .My issue is that my insert statement doesnt work. Thanks [code] using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using … |
| | I have a gridview that was bounded to a drop down list. When a value is selected from a drop down list, the grid view will display only data that related to the value that is selected. But, data in the gridview cannot be edited. My problem is, i want … |
| | Hi I'm new to databases under vb.net although I've used them extensivley under VB6. I have a main form with a DataGridView on it. Thats connected to the following bits- _TWC_Viewer_SubmissionsDataSet, ViewerDataBindingSource, ViewerDataTableAdapterm and TableAdapterManager. All this was etup by the VB wizard. The database table is named ViewerData. This … |
| | Hi I'm trying to use a dropdownlist in the DetailsView, but when I click the insert button I see in the table that the field Maker just contain NULL value. I haven't been using the GridView or DetailsView that much so I need help. Is there a way to insert … |
| | hi, I found on the net that to make a query one needs to create a dataset. therefore i have created a datatable to this dataset with 3 columns into into. Now i have created a query to display the information according to the query. the problem is that i … |
| | All, I have a DataGridView bound to an XML file, then I add an unbound column of checkboxes to the DGV. [CODE] private void btnReconcile_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml(txtPath.Text); DataSet modds = new DataSet(); DataTable dt = new DataTable(); dt = ds.Tables[0].Clone(); foreach (DataTable … |
| | I have binded a textbox to a column in a SQL Server 2005 Database, when i fill the dataset it displays the data, but when i click the save button it doesn not save the changes to the database. I used this same code to do a Datagridview and it … |
| | This is my first c# application so I'm still figuring things out. Ok here is my setup, I have a MySqlDataAdapter filling a Dataset The Dataset acts as the DataSource for a BindingSource The BindingSource acts as the DataSource for a DataGridView The DataGridView successfully displays the data! The data … |
| | hii all i am new in asp.net.i am trying to implement a grid view with all functionalities(insert,update delete). i have successfullly done edit,update and cancel.but not able to insert(new record) in grid view.As soon as i click on insert i get exception as: Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar … |
| | Hello. I need to include an excel file in the installation project of an application. I've added it to the install project under application folder. I need to read that file into a dataset during runtime. The file needs to be included on install so that the customer can change … |
| | I've got this code that creates a Table and a graph, the values have to be int for the graph. But in the table I want t display the values as... 1,000,000 How can I do this?? [code] public partial class output : System.Web.UI.Page { int max = 0; int … |
 | I have been working on a form that reads records from a SQL database. I have the binding working in that it populates all of the fields with the correct data. But if I am viewing record 1 and record 2 changes while I'm looking at 1, then browse to … |
| | hey, i have a problem in adding data from MS SQL(mdf file) database to datagrid view: the code is below please can someone help me with this. C# Syntax [CODE] db.openConnection(); String query4 = @"Select TActionDes,TAssignedTo,TDueDate,TStatus,TDateComplete,TComment From TopicAction Where TopicNo = @topicNo and Phase = @phase"; SqlCommand command4 = new … |
 | I want a row to add data grid view that is linked to dataset and datatable. Aftet that I want to that [COLOR="Red"]new row [/COLOR]in the first cell i want to put a new value (data) [CODE] myConn.Open() myCommand1.CommandText = "select * from groups" myCommand1.Connection = myConn myAdapter1.SelectCommand = myCommand1 … |
| | I have a piece of code that works for adding multiple rows to a dataset but I think that it is a lot of code and thought maybe someone may know a better way of doing it. I need to add rows to the dataset based on the selection of …  |
| | I have been using examples from the textbook creating a OleDbDataAdapter using the wizard, everything works fine loading the data into the dataset, but when i try to update the dataset, it doesn't save tod the database, can someone please tell me what im doing wrong: I created the data … |
| | Hi, I have an issue involving retrieving a set of child rows in a dataset. I have populated a dataset with three tables Categories, Projects and Tasks. In the dataset relations I have set up a relationship between Categories and Projects and between Projects and Tasks. [CODE] Private Sub Defaults_Load(ByVal … |
| | I've got a DataSet that shows a table through Gridview, and the same DataSet also creates a graph. But my problem is that e.g. Date format is different for both, so I was wondering can you change format in a GridView populated by a DataSet? For the graph date has … |
| | Hi, I am using dotnet 2.0 version, I've bulk of records in a grid which i've to insert into database at a time, so i used dataset.getxml() function and stored in the database, I've used the same concept to update. But when coming to delete. i am facing problems Since … |
| | [CODE] Dim myConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Userpass.mdb;Jet OLEDB:Database Password=1234567890" Dim ds As New DataSet() Dim con As New OleDb.OleDbConnection(myConnString) Dim daCust As New OleDb.OleDbDataAdapter("Select * From Userpass1", con) Dim m_dtContacts As New DataTable Dim m_datarow As DataRow Dim m_cbCommandBuilder As OleDb.OleDbCommandBuilder Private Sub Form5_Load(ByVal sender As System.Object, ByVal … |
| | Hi all, I have problem with Dataset. I couldn't use dataset in ASP.net editor. I created new object. dim ds as new dataset. I can't write dataset. If somebody know, plz let me know. thanks . |
| | Hello. I am new to using databases in applications and i have a code to select data from the database. However, the first time the application starts, new data is inserted into the database which is needed after. But, the data does not appear until the whole application is restarted. … |
| | can anyone write the code for the following algorithm. my mail is <EMAIL SNIPPED> Object list = [1,2,3...n], where n- number of tuples/records m- number of attributes Phase I The steps involved in this phase are detailed below: Step 1: Construct a dissimilarity matrix ‘d’ using the measurement in definition2. …  |
| | Hello all, I have a problem binding a combobox in a windows form, what i'm trying to do is the following: I need to bind the combobox to a column (ex: customerID) in a dataset. this column is a foreign key. howerver, I want the datasource of the combobox to … |
| | [code] Dim thisMonth As Integer DateCollected = DataSet.Repair.Rows(2).Item("DateCollected") thisMonth = Month(Now) For........ If Month(DateCollected) = thisMonth Then partsprofit = (partswholesalerpricetotal) / (partstotalcost) * 100 Else End If Next [/code] Basically i am writing up some code that loops through all the records in a table looking at a column called … |
| | We have a MDI main form, which contains a main menu and holds the properties and routines to - select, read and write a selected DAT-input file, and to convert the data to and from a MS-Access database - open forms like grids and specificly an InpMatrix (which shows INPUTMATH … |
| | hi all, i have some dates in my dataset n i want to filter it with 'between' keyword like this: [code] dataset.Tables[Table_Name].DefaultView.RowFilter = "DATE BETWEEN '"+startDate.ToShortDateString() +"' AND '"+endDate.ToShortDateString()+"'"; [/code] But rowfilter doesnot support between keyword.. so i tried this: [code] dataset.Tables[Table_Name].DefaultView.RowFilter = "'" +startDate.ToShortDateString() + "'<=DATE AND DATE<='" + … |
| | I need help to create a search button vb.net to search a access database that is binded in vb.net. I want to search for 2 items in the database and display then in the datagrid. the code i done is here. [CODE] Dim da = New OleDb.OleDbDataAdapter() Dim con As … |
 | Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the … |
| | My situation is that on my windows form , I have several Comboboxes containing several different categories of food products for sale in a transaction. I have a textbox located next to each ComboBox so whenever I choose an item from the Combobox the cost of that item that I … |
| | Hi All, can anyone please tell me what's wrong in this code I'm trying to get some data from an access database and show them in a CheckedListBox The sql quary includes a variable('sport') and it's values is passed by the user when I run the following code an exception … |
| | Dear All, I have search a lot of forum or blog for this problem and have yet come up with a solution.. Hope anyone can help me here... Thanks a lot!! I am using Ms Visual Basic 2008 Express Edition (vb.net) Here is my code: [CODE] Private Sub btnUpdate_Click(ByVal sender … |
| | Hi I am working on a project for my course. I am creating a library system. However I am getting a lot of errors right now. Whenever it adds the record it does not add it to the database. Whenever it updates the record I got this message [B]Syntax error … |
| | I'm lost. I've been trying to do this for a while now and I can get halfway what I need. But I can't tell if it's working or not, or where my problem is. I don't want to use the wizard in VS to add a data source, I'd like … |
| | For some reasons I'm getting no data populating in my crystal report. I have set the datasourse of my crystal report to the dataset. I filled my dataset with data straight from the database. My dataset is not empty, I always check it first before populating data to the my … |
| | hi expert.. i have problem in create report using ssrs.. i already create the .rdl file and setup the datasource and dataset.. the problem is..when i want to view report i dont know how to map between my webform n the datasource.. this my code now... from the 1.aspx.cs [code] … |
| | Hi, Im trying to input a search box in my forms so that when I type in a customers name it will show there record. I've managed to do it in my transaction form, but not in any other standard forms. In my transaction form I've got this code: [CODE]Private … |
| | Hai... I'm Doing my project in asp .net(vb .net coding) If anybody guide me means it would be great pleasure for me... I want to display names in the list box So i used the coding: [code] If Not Page.IsPostBack Then Try myda = New SqlDataAdapter("Select name from agent", connection) … |
| | Hello All... This is my first post so please be gentle with me and I will try to explain the issue I've been fighting with for 3 days. I am trying to update a gridview element from a different thread. This update task is part of an outer foreach loop … |
| | i write this code to know if the combobox= any item in dataset.table("exemple") but is false what can i doing can you help me code: For i As Integer = 0 To ds.Tables("ligne").Rows.Count - 1 If ComboBox6.SelectedItem = ds.Tables("ligne").Rows(i) ..................... |
The End.