2,634 Topics
 | |
| | i have a datagrid which show values in a dataset. I can add new values fine with the below code, but when i delete one of the rows (highlighting a row and using the delete key) i get the error: 'Update requires a valid DeleteCommand when passed DataRow collection with … |
| | Hi I have a form which adds data to a dataset, which can be viewed in a datagrid as it happens and then they finish and this adds it to the database - but after a short while the data that was added seems to rdissapear ffrom the database! Wondered … |
| | Okay heres the dilemna.... I have a Dataset("LineItems") that Stores information about so many records. To source to this DataSet("LineItems") is not its intended ouput. Meaning I pull this info in from one database and output to another. My problem is i have no idea on how to write an … |
| | Hey, I created a datalist with a nested repeater. In the nested repeater, I need to limit the amount of records shown (only 10 allowed). However, just limiting the second query into the dataset doesn't work, only grabs 10 records. So I need to figure out a way of only … |
| | Hi All I have a select statement: [size=2]Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1 Now I want to store / retrieve the values of the field that I am querying without using dataset. Is this possible? If yes how can I do this? Is it possible that I declare … |
| | Hi, I have to display a logo in crystal report in runtime. I have tried two solutions given in [url]http://www.devx.com/codemag/Article/33658/1954[/url] (Tip 6: Better Handling of Dynamic Images) Dim data As New DataSet() Dim row As DataRow Step1 (Passing Image URL into dataset): my code is as follows [code=asp.net]Private Sub LoadImgUrl() … |
| | Hello, I am facing a problem in my project as i m trying to clear the old data from the datagridview but not been successful. I have tried 1. Me.dgv1.Rows.Clear(), 2. Me.dgv1.DataSource=Nothing 3. Cleared the dataset, but none of them is working properly. If any1 has any clue then do … |
| | Hi, I have a Windows form bound to a DataTable through a BindingSource. When I call EndEdit on this BindingSource, it does not always change DataTable to show the modifications, and calling GetChanges on the DataSet returns null. Here's the situation in more detail - I have a DataSet, and … |
| | Hi please can someone help? I have been pulling my hair out for days trying to understand how to open a XML data store in an application. I don't understand the basic principles, as i have opened it int a dataset using readXml, but then been unable to access any … |
 | [CODE=VB.NET] Dim dr As DataRow Dim dt As DataTable Dim ds As DataSet ds = DataSet2 dt = ds.Tables("firm") dr = dt.NewRow() dr.Item("f_num") = 9999 dr.Item("f_name") = "samir" 'txt_FarmName.Text dr.Item("f_floor") = 10 'Val(txt_FloorCnt.Text) dr.Item("f_type") = "C" ' Left (com_CusType.Text, 1) ds.Tables("firm").Rows.Add(dr) [/CODE] as I am reading from an example? there … |
 | Hi guys I think this is simple question,now Iam frustrated coz i could not find the error.Below I mention the coding I wrote.I Highlighted the text where exception occurs.Exception is "Object reference not set to an instance of an object."(Null ReferenceException) Pls help me [CODE]private void button2_Click(object sender, EventArgs e) … |
| | Hello Peopel!!!! I have a problem with a definiton. I have defined a form, in dll, then i had to include the file in the same form, after compiling i'm getting worning Public symbol '_DllCustomers' defined in both module CUSTOMERDLL.OBJ and CUSTOMERFORM.OBJ here is the code [CODE] //--------------------------------------------------------------------------- //CUSTOMERDLL.CPP #include … |
| | I'm developming a programm thet will use a dll forms, the problem i'm getting i have several forms in each dll, some of them have to use functions from other forms. For example, i have a DLL "Customers" which includes Customers form, Customer Selection List, which is a a different … |
| | I am trying to create a property for my UserControl that will allow me to work with data that the user selects. I have the property working correctly, in that it will drop down a list of data sources in the test project. I am working with the Northwind database … |
| | Hi all, I am developing an application which reads an excel file which has the following records and inserts into a table in SQL SERVER 2005 database [Enterprise Edition]. Data: Product Version CustType ------------- ------------- -------------- Norton SystemWorks Basic Edition 2009 CS Norton 360 2 CS Norton 360 2 CS … |
| | Hello , Im having the doubt in dataset. When i click in the dataset and drag it and place it in the webform. one dialog box will be opened. and it asks for "typed" or " Untyped" Dataset?. if i click in typed dataset, "Edit in Data Designer" is disabled. … |
| | hello sir , Q:-How to display data in datagrid from multiple tables in SQL server 2000 and vb.net 2003 its very imp for my project i have tried with following code Pl tell me the correct way to do it tables i am using are TABLES COLUMN CONSTRAINTS COLUMN NAMES … |
| | ok, I'm asking another question now.... Previously I had code to add the requester and asignee emails, if the are both empty then I need to build the list. Here is my code: [code] private string BuildUserList(int p_intSendToRoleID) { DataSet dstUsers = new DataSet(); … |
| | I have two datasets that are being returned from two separate stored procedures. I need to be able to merge these two datasets into one so that the resulting dataset can be used to populate a DataList. I tried the typical ds1.Merge(ds2, true), but the result was not correct (as … |
 | Hi Everyone Ive created 2 cascading drop down lists that gets populated using the cascading drop down tool from the asp.net AJAX control toolkit, Their use is that the user will select what country they are from and then the approriate states will be displayed in the following drop down. … |
 | Hi members! Im finishing my project, and so Im remaining with one thing only. Im new in implementing crystal reports, so is there anyone who knows where 1) I can get a sample app. with code. 2) I need to use reasults from a dataset and display them on a … |
| | Hi, Im having some problem with the dataset. Normally i drag the dataset from the toolbar and srop in the webform. and if i try to load its properties with the database. it does'nt work out. like if i right click and click in its properties. i cant set the … |
| | Hi , I am working in s/w company where i am working on vb.net. We have developed one desktop application which is running 24*7 at client side. We are running it by using scheduler. As it is running 24*7, it get crashed after 3 to 4 days. And we came … |
| | hi i have a window application, wherein i have to choose the database,its table and rowfields present in the table at runtime. Now i want to remove all the duplicates from database. my database is access and whichever row field the user chooses the duplicates should be removed leaving the … |
| | Hows it going everyone. Im pretty new to Crystal Reports, and I have been trying to create a report. The report that Im creating is loading a dataset and right now I am using 5 tables from it. Its loading the dataset at runtime, and the tables that Im loading … |
| | I have a condition for a datagrid (Please view the list.JPG from the attachment) in here you can see a set of data being load from the database. User can perform add, remove , dispose function Here is my condition: Since user allow to add, it also allow to remove … |
 | I have got 2 problems... 1) How can I find the visible no. of rows in a datagridview and the index of the top row during vertical scroll.I am using visual studio 2005 windows application in c#. 2) How to refresh datagridview's particular no. of rows instead of refreshing the … |
| | I have been searching for a solution for this, but all the things I've found do not apply to my problem, so I am giving all the details, and please someone help me I am using access database I am using typed datasets as my DAL I am using objectdatasource … |
| | i have written a vb.net coding for linkin my vb interface to my access database...its all the same....but some linking codes i wrote work,for other forms,but sum don work... this is 1...its a form to add staff in my system [code=vb] Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim ds … |
| | hi, i am a newbie in vb 2005 and i would like to ask for help regarding this problem that i encounter. i have no idea how to fill up my combobox or listbox using dataset. i am accessing data from sql 2000. please help... |
| | I am parsing XML file which contains this tag [COLOR="Green"]<TransferInfo xsi:type="ProductTransfer">[/COLOR] I want to get the [COLOR="green"]xsi:type[/COLOR] value. I am using the dataset to parse the file. The problem is that [COLOR="green"]xsi:type[/COLOR] is not one of the items of the [I]TransferInfo[/I] table. Is it possible to get that value, and … |
| | I am parsing XML file which contains this tag [COLOR="Green"]<TransferInfo xsi:type="ProductTransfer">[/COLOR] I want to get the [COLOR="green"]xsi:type [/COLOR] value. I am using the dataset to parse the file using VB.NET. The problem is that [COLOR="green"]xsi:type [/COLOR]is not one of the items of the [I]TransferInfo[/I] table. Is it possible to get … |
| | Below coding part give me exception once i run my program. [CODE] data = D01.Tables[0]; if (C == 0) { expression = "(New_SE_CODE is not null and SE_Code is not null and Shop_Code is not null and X is not null and Y is not null and Shop_Name is not … |
| | Hi everyone....i need some hep concerning data reader...i've aways use dataset for retrieving and updating data from an access database...now i would ike to know how to user the DATAREADER to do the same thing... Thanks in advance |
| | HI I got an error once I i run below coding,it give me error messages as No row at index 0.Pls help me slove this probelm.I think there is no row is datatable,So i want to know how to add row before it populate from data. DataTable data = new … |
| | Hello, Im using ASP.NET as front end and SQL Server as back-end. and i couldnt navigate the records. im not getting correct way. more over im having some doubts in the dataset also. normally im designing the dataset by picking the dataset from "Add New Items" only. because, if i … |
| | Guys I know there is a way of only writting 2 lines of code in VB.Net when Connecting to a database that are [ICODE]DataAdapter.fill(Dataset, "Tablename") [/ICODE]and then u can have all the buttons required such next, delete, previous, last and so forth without adding them but I dont know how … |
| | Im doing an application that runs on vb.net using oracle database. The function that i did is to select 3 combo boxes for the information to come out. The problem is i can only retrieve the records from the first selectedindex=0 of the ifelse statement and not from the others. … |
| | There are two versions of my application. First runs on a local server and the second version runs on a client machine. The application on the local server performs that following tasks 1. Pulls data from an online Mysql database and stores it in a DataSet 2. Makes changes in … |
| | PLZ HELP ME OUT ON THIS...ITS VERY URGENT..... Hi...plz help me out on this...i have stuck up here for past many days... 1) Plz tell me how to update the Database Table from the datagrid... here is my code : ITS A ATTENDANCE FORM CODE... I AM RETRIVING MY ATTENDANCE … |
| | Hey professionals, I use DataGridView that allows me to add new rows in table. But when I want to delete it by clicking on my deleting button with following code: DataGridView.Rows.RemoveAt(DataGridView.CurrentCell.RowIndex); ...it makes problems, others rows aren't problematic to delete but this is. But not on purpose I want to … |
| | :sad: hi every one I have a problem with rdlc report how can I view it??! I think something missing with my code.. can any one help pleeeeeeeeaaaaase :'( :'( :'( this is my code: Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click Dim thisDataSet As … |
| | Hi, Im using ASP.NET as front end and SQL SERVER as backend. i navigate the records in this using session variables. but its not working. [code=asp.net]Imports System Imports System.Data Imports System.Data.SqlClient [/code] After Inherits im writing [code=asp.net] Dim con as SqlConnection Dim com as SqlCommand Dim adp as SqlDataAdapter Dim … |
| | Hi Pls help me to slove this problem.I have a method and I pass a dataset to it.and inside the method it generate another dataset,i want to join dataset1 and dataset2.How do i do tha below I mention the coidng,it just testing coding.In dataset it contains Retailercode and dataset 2 … |
| | [code=asp.net]public DataSet GetData(String tn,String db1) { if(db1=="sql") { SqlConnection con = new SqlConnection("Integrated security=true;Database=master;server=COMP\\SQLEXPRESS"); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from '"+tn+"", con); DataSet ds = new DataSet(); da.Fill(ds); return DataSet; } else if(db1=="ole") { OleDbConnection con=new OleDbConnection("provider=microsoft.jet.4.0;Datasource=c:\\db01.mdb"); con.Open(); OleDbDataAdapter da=new OleDbDataAdapter("select * from '"+tn+"'",con); DataSet ds=new DataSet(); da.Fill(ds); …  |
| | hey thanks for questions,they really gave me direction. here its the error message below in red and code [COLOR="Red"]"child list for field books cannot be created[/COLOR]" Private Sub btnsearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsearch.Click 'search the database for specific records sConn = "Data Source=Click\sqlclick;Initial Catalog=bookinvetory;User ID=sa;pwd=sqlserver#1" … |
| | Hey people, I want to ask. I have following xml file: <Materials> <Material hrubka="5" popis="dobry popis" /> <Material hrubka="0,2" popis="bla bla" /> <Material hrubka="0,1" popis="bla bla" /> </Materials> I fill datagridview with this xml file. This file is automatically saved when the application is closed. I have a problem, when … |
| | Hello people, I've got a problem. Can anybody tell me how can I save data from DataGridView through Dataset to XML? I've found many useful codes that could solve problem like this: Dataset ds = new Dataset(); ds = (Dataset) (DataGridViewXY.Datasource); ds.WriteXml("XML_name.xml"); !but actually! it doesn't work because when I … |
| | Hi All, I urgently need help creating reports using vb.net 2008 build in reporting tool. I just want an example of how to pass a dataset to the report. I know how to do this using Crystal Reports, but I am clueless of how to do this using the build … |
| | I am encountring a strange problem. Consider d following code : NOTE: MY CONNECTION IS ESTABLISHED SUCCESSFULLY 1 .[QUOTE] Dim dtattendance As New DataTable dbadapterattend = New OleDbDataAdapter("select tbladmission.[admid],tbladmission.[vName],tblattendance.[status] from tbladmission INNER [ dgattendance.DataSource = dtattendance[/QUOTE] I DO GET DESIRED OUTPUT AFTER EXECUTION OF THIS CODE. However if i REPLACE … |
The End.