2,634 Topics
 | |
| | I am trying to create an Inventory/Stock Control system as a windows application using vb.net with an Access database. This is my first time trying to use vb.net and im having difficulty making the application interactive. I am unable to update records to the database from the front end. I … |
| | I have a list of questions, each has its own category. I want to be able to select 5 random questions from each category and then display them ordered by category in something like a nested repeat region. I have the sql for obtaining the random 5 for each category … |
| | i dont know how to read from database SQL. i try this : [CODE] string sql = "Select * from Table1 "; DataSet ds = new DataSet(); string connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataAdapter adapter = new …  |
| | Hi, I have table in Database and i need to get the get the values of column and check for the values. If the value in row of that column is null...the imagebutton in grid view should be disabled. I am unable to get the rows values. Can anyone help?? …  |
| | I've been wanted to get this calendar to show data from a HTML dataset just like on this example.. [URL="http://tv.adobe.com/watch/inside-the-dreamlabs/dreamweaver-cs4-javascript/"]http://tv.adobe.com/watch/inside-the-dreamlabs/dreamweaver-cs4-javascript/[/URL] but i havent been succesfull. Does anybody know what can i do? I think my major problem is when im trying to declare the variables on the event handler. I … |
 | Hi all... Someone give me the difference between typed dataset and untyped dataset.. Regards, Balagurunathan S |
| | using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class exam : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } public void function() { my e = new my(); SqlConnection sqlcon = new … |
 | Hi, everyone! I have a new problem with my graduation work. :( My application must open database at runtime and modify data in this database. The database is random. For that reason I have no idea in which table will be inserted data or update or delete. The problem is … |
| | Hi all, I have a small problem that i cant figure out. i have a program that i want when a user select a date from a datetimepicker, it filters evrything from the datagridview that are for that date.. Hare is the code i have Private Sub Button1_Click_1(ByVal sender As … |
| | Dear freinds i want to get specific data in gridview specifc cell with the help of sql query from sql table i put the following query but it doesn't work [code] Sql = "select e.item_no from nitmtbl e,purchaseitem g where e.item_name=g.item_name and g.item_name='grovita sp'" Da = New SqlDataAdapter(Sql, Class1.Connection) Da.SelectCommand.ExecuteNonQuery() … |
| | Hello Forum, I am having trouble retrieving data from a stored procedure that I have set up as a Data Adapter using VB.NET 2005. The Database is SQL Server 2000, and what I am trying to access is a simple Stored Procedure that will validate a users login access. Details: …  |
| | I need to know how to show my search item in a data grid? There is error in grid display part. Can you help me to solve it? Imports System.Data.OleDb Imports System.Text Public Class mainpage Inherits System.Windows.Forms.Form Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim cn4 As OleDbConnection Dim …  |
| | i am using database with table RESUME and column PageIndex in it which type is number in database but when i want to store this PageIndex value to an integer i get exception error **Specified cast is not valid.** here is the code [CODE] string sql; string conString = "Provider=Microsoft.ACE.OLEDB.12.0; … |
| | hello mates, i am working on a project of online resume management system and i am encountering an exception while creating resume. [b] Exception: Data type mismatch in criteria expression. [/b] i have attached the database tables list, here is my code for Create Resume-1.aspx.cs [code] using System; using System.Data; … |
| | this is my simple application , i try to updata ,but it is not working, in this example it shows only first reocrd and, try to update first record(i want to know the method of updating, so i can updates other records too) data base has only two fields id,name … |
| | Hi I'm trying to load a treeview from 4 tables in the database, i'm using the code attached. The problem is that only 2 of the nodes show up, as soon as I get down product level, the node will not show up. Can anyone see where I went wrong?[code]private … |
| | Can any body explain me[B] Adding parameters to AddParams method [/B] I cant understand the code in this code it try to delete a row from article table, for that i use SqlDataAdapter,DataSet and DataTable , //Preparing Delete Sql Command [CODE] dataAdapter.DeleteCommand=conn.CreateCommand(); dataAdapter.DeleteCommand.CommandText="DELETE FROM article WHERE artId=@artId"; AddParams(dataAdapter.DeleteCommand,"artId"); [/CODE] This … |
| | I'm trying to import all data from an Access DB using Visual Basic 2005. I'm new to Access and so far I can only import one record at a time. Any help would be appreciated!! Here is the code I have so far (obviously to bring one record at a … |
| | I Want To Search Date From .mdb Database file, Table Name is Purchase, and The Field is Purchase Date, its Type is DateTime and Formate is ShortDate in MS Access Database File, I Conceted it to Vb.net Form, and Tryed to Search Date, but it Returns Error. the Code to …  |
| | Hello Forum, I am new to SQL Server and have inherited a database from another developer. I have a Stored Procedure that I'm trying to use in my vb.net program to fill a form with multiple datagrids. The Stored Proc looks like this: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go … |
| | hi guys i need help with date time picker.What i am trying to do is to select data from table according to teh date selected by the user .My code looks like this but it doesnt work, it doesnt pull anything, can anyone help me with where am i going … |
| | Hi, I have the code here as in the following: [CODE] <%@ Import Namespace="System.Data" %> <%@ Page Language="C#" Debug="true" %> <script runat="server"> sub Page_Load if Not Page.IsPostBack then dim mycdcatalog=New DataSet mycdcatalog.ReadXml(MapPath("alice_music_list.xml")) cdcatalog.DataSource= mycdcatalog cdcatalog.DataBind() end if end sub </script> <html> <body> <form runat="server"> <asp:Repeater id="cdcatalog" runat="server"> <HeaderTemplate> <table style=";font-family:Arial;width:56%;margin:1em … |
| | Hi Folks: The following is the complete coding for an application which I wrote to move data from sql 2000 to MS Access 2003. The coding looks fine to me but I am still getting an error. Could someone tell me what I am doing wrong. Thanks in advance Bob … |
 | Hey All! I'm working on a project where there is a lot of data input from the user. There are numerous combo boxes to help minimise user input and prevent input errors. One of the combo boxes (ComboType) needs to be populated with all the records from the relevant database … |
| | Hi Guys, I am getting index out of range error.My code looks like this [code] private void submit_Click(object sender, EventArgs e) { if (form.dataGridView2.SelectedRows.Count == -1) return; // column header clicked - do nothing // get the row just clicked DataRowView drv = form.dataGridView2.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) … |
| | hi there, i am still facing the same problem with runtime error object canºt be found when trying to access ms access database remotely.i made the database in the wwwroot folder and give authority read write ,....the code is in the client side i am accessing a server that has … |
| | The Xml: Micfosoft(TM)'s modified Books.xml: The price attribute of the last book item was modified by me, now it appears two times, once as attribute of book and second time as a separate item inside the book item. [code=xml]<?xml version='1.0'?> <!-- This file represents a fragment of a book store … |
| | Hi , I need help with select staement.I am trying to to look for a word in column word .If i find that word then then show a message box that this word exist in databse.Can anyone help me with this.my code is something like this [code]private void dataGridView2_CellContentClick(object sender, … |
| | hi. I am working on a project which keeps its data access, business logic and UI in separate projects of a solution. Is there a way to access a strongly typed dataset in one project of a solution from another project of the same solution? I need these to fill … |
| | Hi, I am trying to learn how to create relations I got a sample from a web site and it works great, but when I tried to make one; it is not working. Can some one tell me what I am doing wrong. It gets down to the last relation … |
| | Hi All, In my application's DataGridView there are 3 ComboBoxColumns. Out of which two are filled by Enumerator type and one from DataSet. I set Generic Class object as DataSource to DataGridView. Based on the values in this object I want those ComboBoxColumns values to be selected and relevant DisplayMember … |
| | Hi, I am a c# learner and I have got a problem - I have not much clue, please help. I have a windows form with two text boxes and a button called 'save'. If I click the save button - It should connect to the sql server express then … |
| | Hi! I´m communicating via webservices with the Server (where's installed the database) and the c# application. So, **i dont have direct access with the database** Somehow, i receive a DataSet with 3 tables inside: [url]http://img339.imageshack.us/img339/5171/90768184.png[/url] And would like to populate 3 combobox like this: [url]http://img97.imageshack.us/img97/6145/29315365.png[/url] Which (as you already see) … |
| | :unsure: I dont know y this happens...i try a lot of times but....anyways, the problem is that, the crystal report does not show the actual result when an sql query is being used to extract data, even from a single table...while it runs correcty in MS Access where i have … |
| | hi guys i am trying to fill datagrid from database.I using the following code.Can anyone tell me what am i doing wrong. [code] public Form1() { InitializeComponent(); richTextBox1.Text = "Word: I \nDefinition:"; richTextBox3.Text = "Word: I \nDefinition:"; label2.Text = "Hindi"; dateTimePicker1.Visible = false; SqlDataAdapter dtadp = new SqlDataAdapter(); DataTable dtbl … |
| | Hi All, I'm new to web dev and c# so please bare with me I am trying to create a dynamic gridview in a web form for users to to answer questions with (code below). The dificulty im having is that i am nesting a dropdwonlist in the gridview and … |
| | In C#.Net, I have a dataset containing only one column,.. i want to remove the first row,.. Can anyone help me? |
| | This is an example I have grabbed from W3School, and for the purpose of my question, I have modified it and put in the code here: [CODE] <?php // Make a MySQL Connection mysql_connect("localhost", "admin", "1admin") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); // Get all the data from the "example" table … |
| | Hey all, having a little trouble transferring my listview items into a database. I have transfered all of the listview items into a List<> for use during the population of the items in my database here is my dataaccessor class, it contains the reader writer and writer statements generator: [CODE] … |
 | Hi i am using vb to make a hospital system which works with a access database i am having an issue with the updatign function to the database this time round instead of hard codding the connection i used the connection/data source wizard in microsoft visual studio 2008 and there … |
| | Hello all, I'm somewhat new to programming but I had a quick question. I have created a program to take a text file and convert it into a datatable. Unfortunately, however, I seem unable to attach this file to a database. I am getting an invalid object error stating that … |
| | The DataTable's Rows show likw this, how do I fix it. [B]Month1[/B] [B]Month2[/B] [B]Month3[/B] 1 2 3 1 2 3 1 2 3 [code] double C146_Calc = 0.0; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // create the table DataSet ds = GetTable(); outputView.DataSource = ds; outputView.DataBind(); … |
| | Hi All, I'm new to web dev and c# so please bare with me :) I am trying to create a dynamic gridview in a web form for users to to answer questions with (code below). The dificulty im having is that i am nesting a dropdwonlist in the gridview … |
| | Hi all, When I click on the add button I get "exception class EdatabaseError with message 'DBedit2: Field 'RoomNumber' not found I am trying to get the max roomnumber to insert a new room max(roomnumber)+1 Its a fundamental hole in my knowledge here, on how to get a result from … |
| | Hi Guys, I am trying to insert hashtable in databse but one of the key in hashtable is null.Can anyone help me write an exception for this.Or if i can just move to the next key . Thanks a lot [code] private void btnUrdu_Click(object sender, EventArgs e) { SqlConnection cn … |
| | Hi folks: Can anyone tell me what I am doing wrong in the coding below: [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim ConnectionString As String = "Server=hp;database=library;integrated security=SSPI" MessageBox.Show("Connection established") Dim sql As String = "SELECT snippetID, snippetName, snippetSource, snippetCode FROM snippet … |
| | i can't able to display series2 dataset value in chart Any one explain me how to solve this problem Need Help Thanks in advance[code]dataset.addValue(plan, series1, category); dataset.addValue(actual, series2, category); CategoryItemRenderer renderer = plot.getRenderer(); renderer.setItemLabelPaint(Color.white.brighter()); for(int i =0;i<var.length;i++) { renderer.setLabelGenerator(new LabelGenerator(var[i])); renderer.setItemLabelFont(new Font("Serif", Font.PLAIN, 20)); renderer.setItemLabelsVisible(null); renderer.setSeriesItemLabelsVisible(0, false); renderer.setSeriesItemLabelsVisible(1, true); } … |
| | I have been able to extract a single column with help here but now I want to get two, but the same process does not seem to work. [code=pascal] Procedure Tform1.showroom; begin adoquery1.close; adoquery1.SQL.Clear; ADOQuery1.SQL.Add('Select roomname,description from Rooms'); adoquery1.Open; end; procedure TForm1.FormCreate(Sender: TObject); begin ADOConnection1.KeepConnection := false; datasource1.DataSet := adoquery1; … |
| | Hi All. I am relatively new to programming so this may seem like a trivial question, but here goes. On my form I have a datagridview which is bound to a 'Supplier' table in Access 2003. Once I click on a record on the DataGridView, textboxes below which are also … |
| | Hi All! I am new to Vb.net & ado programming so this really just for educational purpose. basically i have a form with a datagrid set to readonly. i have 5 textboxs. when a cell is clicked its value in the row is output to the following textboxs on the … |
The End.