2,634 Topics
 | |
| | Hi all, I've only just stared using VS2008 VB so please excuse me if this seems a very basic question. (I've amended my example to the Northwind Database to avoid any confusion) WHAT I HAVE I have a dataset called KeyData made up of two tables Customers and Orders. I …  |
| | i have been google it for answers but still cannot find the main problem.. when i debug, this error msg coming from exception section, but before that, when i put my cursor at conn (Button1_Click) to see the value it shows conn = nothing. But conn in other function got … |
| | Can someone please help. I have a dataset that is populated with a csv or a tab seperated txt. I get the datset fine but when I try to insert into a table in sql with bulkinsert I am getting an exception. The table does not allow nulls in the …  |
| | Hi guys, I've been using asp.net 2.0 over the past 2 years making simple web applications but have never used it with MySQL. I've been asked to create a website for a relative. The site will be a vehicle leasing company. After speaking to owner and understanding his requirements i … |
 | I have created my own dataset: this.abcTableAdapter.Fill(this.dataSet1.abc); And I created DataGridViewComboBoxColumn called AllGrades: DataGridViewComboBoxColumn AllGrades = new DataGridViewComboBoxColumn(); for (int grade = 5; grade <= 10; grade++) { AllGrades.Items.Add(grade); } AllGrades.DataPropertyName = "Grade"; AllGrades.HeaderText = "Grade"; AllGrades.Width = 60; AllGrades.MaxDropDownItems = 6; AllGrades.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; dataGridView1.Columns.Add(AllGrades); In a dataGridView I …  |
| | Hello everyone, I’m hoping someone in the DaniWeb community can help me. I have a VB 2005 project to complete. I have two related tables called CurrentInventory (which is the parent table) and a child table called TrackingInventory. I want to update an existing row in the dataset for the … |
 | Hi Nowdays Iam developing application that use for read excel .So Once I run and close the application there are more than 5 excel.exe process are running.How to stop these process.Below I mention code which I used. [CODE] xlApp = new Excel.ApplicationClass(); DataSet ds = new DataSet("DataSet"); xlWorkBook = xlApp.Workbooks.Open("C:\\Test.xls", … |
| | Hi, I am using these: ASP.Net 2.0, VB.Net, SQL Server 2005, Visual Studio 2005, Typed dataset & data table adapters using xsd file and BLL classes. Example scenario (copied from somebody who asked the same question and not answered with examples.) Table 1 Main ID (autonumber) field1 field2 field3 Table … |
| | Hello everybody! I have such problem: I'm going to make a little application, which will interact with MSSQL databse, located on remote server. Server is my and I can administrate it remotely. There is MSSQL 2005 there. I created a database there, but can not connect using code from my … |
| | Would anyone have any example code in VB that illustrates how I can merge the tables that are generated when XML is read into a dataset. An example of the XML would be: [code] <process> <block1> <name>name1</name> <dated>01/04/2009</dated> </block1> <block2> <text>A</text> <UID>1</UID> <title> <label>label1</label> <value>value1</value> </title> <description> <label>label2</label> <value>value2</value> </description> … |
| | Hello, I am new to C# and .NET. I am working on a application which will run on a number of machines at the same time. All instances will access a single access database in a shared directory. All instances will be able to update the database. What I need … |
| | I have a combobox that has state abbreviations. It is filled from a dataset table, which is read in from an xml file. The combo box populates just fine. I want the selected value and text to change when I load a record from an accounts table in the dataset. … |
| | Hi guyzzzz,,, I m Building HTML Script in .cs Page with sum Dataset Value..... But i have an button generated runtime named Cancel & onclick i need to call a javascript function But I am not able to generate String Proper...Can u help me... sqTsc.Append("<html><head><title>BOTH APPOINTMENT'S</title>"); sqTsc.Append("<style type=text/css>.style1{font-family: Verdana, Helvetica, … |
| | I am trying to access one colum in one row in a SQL Database. Dim qryDraw As String = "SELECT LastDD FROM dbo.comDate Where DrawNo = 2 " Dim cmdDraw As New SqlCommand(qryDraw, Connection) Dim pagesize As Long = 0 Dim adpDraw As SqlDataAdapter = New SqlDataAdapter(qryDraw, Connection) Dim dataSet … |
| | [code]Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As String = "Provider=Microsoft.Jet.OLEDB.12.0;Data Source=G:\Visual Studio Projects\test\dbtest.accdb;Persist Security Info=False" Dim cmd As String = "SELECT * FROM Table1" Dim adapter As New OleDbDataAdapter(cmd, conn) Dim topics As New DataSet("Table1") … |
| | While i thought this would be really simple im really struggling on filtering a gridview twice! I can bind data to my gridview on the choice of my first dropdown box from a dataset but i would like to then filter those results from a selection in a second dropdown … |
| | I am new to C# and .NET and am having a problem. I have a windows form application. I created a Ole data adapter to look at an Access Database with 3 tables. I then created a dataset which gets loaded by the adapter when the process starts. I then …  |
| | I am quite new at c# development but i have a good understanding. I have an app that includes a strongly typed dataset from a datasource called RouteFormatData.mdf I have three tables in the database, AddDetails, NetworkCodes and Products. I have a table adapters for each table, the problem i … |
| | I went through many threads here, I also found a few threads related to what I need, but none worked. So please if anyone can check if there's any mistake in my code or tell me what exactly I should do... Actually I am able to view the data which … |
| | hello everybody :) im new in vb and now try to develop one system using visual studio 2005 and sqlserver 2000.. i succeed to generate the data in datagridview but then it display all data not i had selected in combo box.. as shown below :- Imports TMSForm Imports TMSBusiness … |
| | I have datagridviews where I've removed the ability for users to edit them directly. I have made add and delete buttons for users to add rows and remove selected rows. Occasionally, and I'm not sure why, I get the "Prepare: CommandText..." error, as well as "Update requires a valid ___Command..." … |
| | ok i understand some basics of vb but am still relatively a new... my problem.. code is for saving values into a database and displaying on the same form on a datagrid which is connected to the database... Imports System.Data.OleDb Public Class Addbooking Inherits System.Windows.Forms.Form Public cN As OleDbConnection Public … |
| | Hi, I am using JFreechart to create a graph of some data that i have produced using a program i have written. The problem that i have is that i have to manually input the data into the dataset to create the graph.Is it possible to generate the data that … |
| | Hello, I've just recently gotten back into VB. I am currently developing a Database for a sort of hobby project, and I am having trouble with displaying it properly. Here is my situation. I have a ComboBox which allows a user to select from a series of categories. Each category … |
| | Hi, I have a problem with my login control. I changed the code in order to use my own database (SQL Server 2005) and no matter what i do i get the message "Your login attempt was not successful. Please try again. "!!! in the web.config file i chose my … |
| | the code seems to be fine dont know why its not working. when i execute the same sql directly in database it works fine. the error is get is oledbexception was unhandled syntax error in from clause. please help me thanks is advance. Private Sub Button2_Click(ByVal sender As System.Object, ByVal … |
| | I am new to .Net and I am having some problems. I have read the Kate Gregory book for visual C++ .net and successfully implemented her application to look up employees in a database table. I followed the same format to write an application I am working on. The adapter … |
| | Hi! I am writting an windows form application in Visual C++ .NET 2003 and have an issue. When a user makes a change in the datagrid, how can I detect that a change has been made eithor with the datagrid or the underlying dataset? Also how can I identify the … |
| | Hi everyone, I am a newbie both on this forum and Borland C++ and hope you can help me to figure out the problems which I encountered during my project. Here we go, I wrote a program that reads SysLog messages and store it in a database.These log messages are … |
| | This is my first post. I am trying to use Visual Studio 2003 which is what is available at work. I am having to problems: first I don't seem to be able to set a watch on a variable, the contex menues are grayed out. The second is I am …  |
| | I am new to .NET and have been unable to get data from a CSV file to a dataset. Most examples are VB and C# which need to be converted. The code below compiles clean but does not fill the dataset. I have been unable to set a watch on … |
| | // i m getting error when i update ID field of table.. all others field can be updated bt nt the field which i have used as where conditions of update command..! using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsApplication1 … |
| | Hi I wrote below coding ,and last Message "Test" never appear in my project ,it means while loop never works.Plase tell me what is problem in my coding [CODE] public partial class Form1 : Form { public static int Number_Records; public static DataSet ds; public static DataTable dt; public static … |
| | Am using Vb.NET 2008 and SQL 2008. I have a problem, when the execution reaches daAdapter.Update(dtTable) then I receive this error ""String or binary data would be truncated. The statement has been terminated"" Then the record fails to update. What could possibly be the error? Below is the complete code. … |
| | Hi, I am working on VB.Net. I have a sub form with a datagridview, that is being loaded with the criteria taken from another form. Hence this form is called with parameters. Here is the code that calls the sub form. [CODE] Dim frmHis As New frmHist(ds, rb) frmHis.Show()[/CODE] where … |
| | Hello .. I'm Doing Some School Work & Im In Need Of Help. I Need TO Update A DataBase, I Have Generated A DataSet That Is Complete With Data From A MS Access DataBase, & I Have Bound The COlumns To TextBoxes And ComboBoxes As Appropriate But I Cannot Seem … |
| | Hi..Can u please tell me how to load the contents of a XMLDocument into a dataset or a datagrid? |
| | I hav a program with 2 textboxes in which I hav to display data fields from sql tables and insert values in to table through these 2 textboxes. the program goes like this Dim ds As New DataSet Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load … |
| | I have a clarification, with my project I added a dataset ,is having dataset [xsd] file name- DataSet1 and datatable table name -datatable1, also it's having the fields "id,item" with my form I have coding Dim ds As New DataSet1 Dim t As DataTable = ds.Tables.Add("datatable2") t.Columns.Add("id", Type.GetType("System.Int32")) t.Columns.Add("Item", Type.GetType("System.String")) … |
| | I have to navigate between the records from the dept table. But when I am tryng to do that I get stuck at teh second record. and teh inc value gets reset to 0. Please let me know an alternative to this. I guess maintaining session state is an option … |
| | Hi, I have a DataGridView on a form that is being populated from a SQL table dataset by giving criteria from a previous form. I have 6 columns in the dataset, of which the last column should be combo box column containing items "Done" and "Pending". How do I make … |
| | I need some help with BindingSources (in C#). This is what I'm working on: From the C# tutorial at Programmer's Heaven ([url]http://www.programmersheaven.com/2/Les_CSharp_13_p9):[/url] private void btnLoadData_Click(object sender, System.EventArgs e) { string connectionString = "server=P-III; database=programmersheaven; uid=sa; pwd=;"; SqlConnection conn = new SqlConnection (connectionString); string cmdString = "SELECT * FROM article"; SqlDataAdapter … |
| | Hello everyone Im doing a dummy project in asp.net. I have a table named trains with following fields: 1. Sno(Primary key, Identity Increment, integer) 2. Train_no(varchar(100)) 3. Train_name(varchar(200)) 4. Route(varchar(1000)) 5. Start(varchar(100)) 6. End(varchar(100)) For this i have created a stored Procedure in this way: [code]Create Proc [dbo].[sptrainselect] @select int, …  |
| | I bound gridview with databse..property Checkbox -true . I have three columns roll,name ,roll. I want that on button_click, roll nos are displayed whose checkboxes are checked in gridview-- SOURCE TAB [code] <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"> <Columns> <asp:TemplateField > <ItemTemplate > <asp:CheckBox ID ="chk" runat ="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField … |
| | I am just learning Datasets, and as luck ALWAYS has it can not start out simple. I am pulling from an ODBC file which can be connected to on the Dataserver or Table adaptor, but then they come in with no tables. So I am forced to work with runtime … |
| | [MS SQL Server 2005, Visual Studio 2005, ASP.Net 2.0(with VB.net coding) website] Hi, I have a brand table which is inter-related with many other tables. SQL generation code below. [CODE] /****** Object: Schema [Product] Script Date: 03/27/2009 10:15:22 ******/ CREATE SCHEMA [Product] AUTHORIZATION [dbo] GO /****** Object: Table [Product].[Articles] Script … |
| | I bound gridview with databse..property Checkbox -true . I have three columns roll,name ,roll. I want that on button_click, roll nos are displayed whose checkboxes are checked in gridview-- SOURCE TAB [code] <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"> <Columns> <asp:TemplateField > <ItemTemplate > <asp:CheckBox ID ="chk" runat ="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField … |
| | I'm having trouble formatting the datetime field in a gatagrid. I am able to format the date using: <asp:BoundColumn DataField="MyDateColumn" DataFormatString="{0:d}" ... /> But Since I'm using two tables, I'm creating the datagrid manually instead of using "GridView" from the Toolbox. My Code: ================ [code]Dim comm2 As SqlDataAdapter = New … |
| | Some of you may have seen my earlier thread “PasswordHash NULL problem”. I’ve started a new thread because investigation has shown that the problem is actually quite different than I previously stated. Also please note that this is unrelated to another of my previous threads, “dataAdapter.Update problem”, which incidentally has … |
| | When I try to save a new (inserted) record via the following code: [CODE]DataRow row = dataTable.Rows [currRec]; // update data in DataSet from data entry WinForm row.BeginEdit (); row ["Title"] = txtTitle.Text; row ["FirstName"] = txtFirstName.Text; row ["MiddleName"] = txtMiddleName.Text; row ["LastName"] = txtLastName.Text; row ["Suffix"] = txtSuffix.Text; row … |
The End.