2,634 Topics
![]() | |
hi how do i update multiple rows? right now i can only update one row. it works like this now: user keys in customerIdNo and pwd1. a match in database will display pwd1 in textbox. textbox is databind to password field in access database. user can change the displayed pwd1 … | |
Ok, I need to make a program that will let the user enter a sentence. then find all of a certain word (and) and print out the count of how many times that word was in the input. I would like to do this in a while loop. Not sure … | |
Hi, I am a SAS newbie and am tearing my hair out... I have a time series of stock return data for multiple companies. What I was trying to do is: 1) for each period in time, sort the data into 20 quantiles (equal observations in each of the 20 … | |
I have a form which has a listbox, 5 textboxes and a datagrid, what I'm trying to do is when a user double clicks a row on the datagrid this then displays another datagrid on the second form with the details of the orders placed from the Items Table for … | |
Hello all i am in need of some help with a datatier layout. I understand the gui, bussinessRules, but i am really not making any progress on the data tier. i have been tring to get a grip on the this one for over a week. I completely understand the … | |
Hello, I am having a problem with adding a row to my DataSet. I think I know what the problem is, but not how to correct it. I have several bound text boxes that fill from the DataSet. The first column is a numeric and the next several are text … | |
I know that if I have a program with a connection to an Access database, if I change the name of a table in the database, when I try to access that table from within the program, it's going to throw an exception. My question is, how do I cause … | |
hi all i have a problem setting me back i have a table "students" with fields (StudentIdPk , StudentName , Country) as an example im trying to lookup the field country and put all the distinct values from this field into the combobox's list.(not much records) what i would like … | |
My homework is to write the [B]quicksort[/B] algorithm in 8085 assembly. So I tried to write it and of course it has too many bugs but my main problem is that I don't know how to handle the recursive character of the algorithm and control the loops. For example, what … | |
I am working on filling a datagrid based on results found from a user entering criteria in text boxes and clicking a search button. I have been toying around with Session() to store variables but I dont understand it too well and its giving me trouble. After the user clicks … | |
I am facing a huge problem. I did a registration page and i want to store the data into SQL Server. I created two stored procedures in SQL and two functions in visual basic to call the stored procedures before inserting the data into the database. My codes are based … | |
Hi I want access to AutoNumber Fields in a Filled Dataset for Example : [code] For i= 0 To Dataset11.Tables(0).Columns.Count - 1 If Dataset11.Tables(0).Columns(i).AutoIncrement = True Then MsgBox("This Field Is AutoNumber") End If Next [/code] But This Code Not Work !!! | |
I have created a class MyDataSet that inherits from the DataSet class. In the constructor of MyDataSet I read a xml schema from a file which specifies all the tables and columns of my dataset. Then when I drop a DataSet from the Data Toolbox in Visual Studio it ask … | |
Hey there i have been trying to bind a table from database to a listbox. I know this can be done quite easily but i keep having an error with i cannot figure out why. Whenever i declare selectedMain as linklist.selectedItem.value, it will alsways tell me "Object reference not set … | |
OK, I'm hitting the wall harder than a rookie Indy driver! I'm very new to programming in general, C# in particular, and I'm trying to teach myself. I'm using [B]C# Express[/B], which Microsoft claims is aimed squarely at people like me (novice). However, I can't seem to find the exact … | |
Okay this is a good one I believe. In a dataset, you can create single relations (ParentTable.PrimaryKey to ChildTable.ForignKey) using the dataset.relations.add method. You can use a string variable something like this: Dataset.Relations.Add("relationName",Dataset.ParentTable.columns(strParentKey),dataset.ChildTable.columns(strchildForeignKey) This method works fine for single to single keys generated dynamically using schema info. Now if there … | |
hi!!! actually i'm doing a project for e-survey. the problem is that when i create different types of control, an error message is displayed. but if i create only radio buttons, everything fine. can u plz see my problem. thanks ant ---------------------------------------- Imports System Imports System.Configuration Imports System.Data Imports System.Data.SqlClient … | |
I have two dropdownlists. I can choose say USA and then it goes into the DATA base but does not save it in the dropdownlist itself. I can not figure out why this is happening. > <code> > Edit mode the index of a dropdownlist does not start at the … | |
Hello, I need some help with setting up some SAS code to compare observations. I have over 100,000 observations with 26 variables. I have already read the data file into SAS and now it is stored as a SAS dataset. One particluar thing that I need to do is compare … | |
I'm trying to bind a radio button's checked property to an Access field defined as Yes/No and am having no success. I can programmatically read the dataset field and set the radio button, but I than have difficulty adding a new record and setting the dataset field to be updated … | |
Hello all. I am attempting to update one of two database tables using an SqlDataAdapter (getting any changes from my DataSet). I have tested my stproc, and it works fine. Here's the code: CREATE PROCEDURE [dbo].[procRobUpdate] @db AS NVARCHAR(3), @ID AS NVARCHAR(11), @Panel AS NVARCHAR(3), @Row AS NVARCHAR(2), @Col AS … | |
PROBLEM: ____________________________________________________________ Im trying to create an update on an oracle database and Im having some real trouble with it. If anyone has experience creating transactions and stored procedures from .net or asp and can help out I can use the assistance. My code is returning the following error and … | |
Hello, I can not fill a dataset and operate with a datatable when it is on other computer (not on the ASP server). I am using MS VIsual Studio .NET 2003 and ASP. I receive the following error when trying to fill a dataset: "The Microsoft Jet database engine cannot … | |
I have a datagrid that is populated with data. If the operator scrolls off to the click on a field that is off to the right (not initially displayed on the grid) ---- then the operator does something that needs to repopulate that data with a different set of information … | |
Hi I have a dataset which acts as a datasource to my datagrid. It just shows all the columns from a table. One of the columns is an image column. How do i show these icons\pictures on the grid? My code looks like this: dim cmd as sqlcommand dim da … | |
I am using ASP.NET, and the ASP.NET WebMatrix program, latest version. I am writing a page that is supposed to check the username someone has entered into a textbox against the list of users from the database, so that two people can't have the same username. Simple, right? Not when … | |
Dear All, I encountered the same problem with Miguel Piedade. [URL=http://www.codeproject.com/cs/miscctrl/DataGridZen.asp?df=100&forumid=31224&exp=0&select=886730#xx886730xx]http://www.codeproject.com/cs/miscctrl/DataGridZen.asp?df=100&forumid=31224&exp=0&select=886730#xx886730xx[/URL] [SIZE=2][b]Using SelectedIndexChanged to change another column on the datagrid[/b][/SIZE] Original Message as below, -------------------------- I have a DataGrid with our wonderful combobox for the ProductCode, and have some following columns that need to be filled with some other information … | |
Hi all, I want to make a report that the column headers are getting from one of the field in the dataset. Example, dataset ds has table A with 4 columns, col1, col2, col3, col4 I would like to use col1 values to be the column headers of the report, … | |
Hi All I' m a new member of Dani Web Community.my problem is with nested linked list implementation.when i insert second node in linked list, it always overwrites the first. my declarations are as follows: struct dataset { int key ; char value[30]; struct dataset *ptrdataset; }*ptrd; struct geometry { … | |
Hi, The following code compiles and runs fine from the hard drive but does not compile fine from a floppy disk. It gives me a cannot resolve symbol error for the DataSet dataSet = new DataSet(); line. Any ideas? The program is supposed to except user input for 4 integers … | |
Hello... In VB6 I was able to write a SELECT statement to query from a table named "tcm_planned_coil@l3." However, in VB.NET, the "@l3" interferes and the query will not execute. Does anyone know how I can get this to work? Below I have simplified the query...any help is greatly appreciated! … | |
Hi, I have two similar datasets and I would like to query them to find the records that are different in the first dataset from the second. Does anyone have a good way to to this? Thank you, Tim | |
In ADO and VB6, you can just place some textboxes and ADO Data control and bind those textboxes to the data control and columns. Simple that you can navigate through records easily by just clicking arrow buttons. Ever wondered how to do it with ADO.NET (and dataset)... The following link … | |
Hi, I have a problem that my program is writing only single line from the dataset whereas I want to write whole data from the data file to be read and written on the screen. Somebody help me. This is my program: import java.io.*; import java.util.*; class QueryAnswering { int … |
The End.