2,634 Topics
 | |
| | Hey everyone. I'm trying to get a dataset to a page from a web service and im having problems. I have been using the MS page here: [URL]http://support.microsoft.com/kb/310143[/URL] and copied it exactly(o so i thought). And for some reason my datagrid (DataGrid1 in my program) is not being populated and … |
| | hi there, i have posted my code...please am seeking help, syntax wise Here's my code , please i do need help myda = [COLOR=green]New[/COLOR] SqlDataAdapter("Select Distinct COUNTRY from FO_TestingLines_TBL order by COUNTRY", ConfigurationSettings.AppSettings("myconnection")) ds = [COLOR=green]New[/COLOR] DataSet() myda.Fill(ds, "AllTables") OPERATOR.Visible = [COLOR=green]True [/COLOR]COUNTRY.DataSource = ds.Tables(0) COUNTRY.DataTextField = ds.Tables(0).Columns("COUNTRY").ColumnName.ToString() COUNTRY.DataValueField = … |
| | Hi there, i'm working on a project in which i'm creating, editing and deleting customer records from a MS access db. I'm using vb.net 2003. As with creating and deleting records i dont have any probelms. the problems arise when i come to update the data base if i edit …  |
| | [B]How do I display data (not dataset) on the form just like you see the inbox mail (not allow editing on the data and no first empty column on the left of dataset)? I want to display the master list of names first, then click on the name to bring …  |
| | My program will not build due to an error related to the section of code below shown inbetween the following symbol. ~~~~~~~ ~~~~~~~ The error which i recieve is the following: Object reference not set to an instance of an object. any help would be appreciated, thanks again Imports System.Data … |
| | I am trying to show info at the bottom of my data grid I get error saying object reference not set to an instance of an object Here is my code [B]Imports System.data Imports System.data.OleDb Imports System.Configuration Partial Class supplier Inherits System.Web.UI.Page Dim ConnString As String = ConfigurationManager.AppSettings("ConnString") Dim dbPath … |
| | Hi, im facing some problem when i have to verify user at my login function. Im using Visual Web Developer with vb programming and MS SQL Server 2000 as my database. Basically my login form have few textbox for user to input the id and password, 1 radiolist for user … |
| | hi..i'm doing my final year project on creating Questionnaires template. i have problem with viewing my OptionLIst. I have 2 dataset..all i want to do is to preview all my Question & Answer..i can view them, but i need to create textboxes or checkboxes besides the OptionList.. [code] Private Sub … |
| | i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login. ALSO i can login well using the sql server … |
| | i want to connect to a sql server running on another xp computer. i have made the sql connection, sql data adapter (using Data controls, not connecting manually from code). i can fill the data adapter from the design view by right clicking on the adapter, Fill dataset and i … |
| | I am trying to enter data into a datagrid and I get this message No value given for one or more required parameters. Can anyone see what is wrong. Here is the code Imports System.data Imports System.data.OleDb Imports System.Configuration Partial Class supplier Inherits System.Web.UI.Page Dim ConnString As String = ConfigurationManager.AppSettings("ConnString") … |
| | This is what I have so far. I need to retrieve data and show in a grid view supplier ID supplier name and a command field to click more details that will include more detailed info. I am have problems on how to get the rows. i need to retrieve … |
| | Visual Basic 2005 How do I go about adding a column to an SQL database. Everytime I did it in the past it was a disaster and I literally had to start all over again from square one. I would go into Dataset Designer to add the column then I …  |
| | Hi, Iwant to excute select procedure SELECT Location, name, marks FROM ins WHERE (column1 = ' " & textbox1.text & "') column1=ID # i allready did the databinding to text box's what should I write in the butten I tried DsIns.Clear() OleDbDataAdapter1.Fill(DsIns) Ins is my dataset name all of my … |
| | Hi, I have created a stored procedure that would insert new records in one of my database tables. I have tested the procedure in SQL Server 2005 and it works all right. What I want to do next is to connect the stored procedure to my form in VB.Net so … |
| | hai, i have created a webservice file and made "web reference". in that i want to edit the .wsdl file and want to change the IP address....can anyone post me the coding? i want to put the wsdl file into an dataset and want to edit it...help me plz...its very … |
| | dataset does not appear in datasourse when i make a new dataset sometimes and sometimes not appear in datasource |
| | hi..good day to all.. i have a datagrid that combines 2 related tables as below: <body> <asp:datagrid id="dlQuestion" runat="server"> <ItemTemplate> <b>Question :#</b> <%# Container.DataItem("QuestionNum") %><br> <%# Container.DataItem("Question") %> <asp:DataList runat="server" Id="ChildDataList" datasource='<%#Container.DataItem.Row.GetChildRows("myrelation") %>' RepeatColumns="1"> <ItemTemplate> <%# Container.DataItem("OptionList") %> </ItemTemplate> </asp:DataList> </ItemTemplate> </asp:datalist> </body> the code behind as shown below: Dim … |
| | :sad: I am trying to connect to a mysql database. ideally, i'd like it dumped into a grid view so i can edit it... no matter how i try it, i get this error- [B]Compiler Error Message: [/B]BC30002: Type 'ODBCConnection' is not defined. here is the code for this page: …  |
| | Hi All, I have an application where user can export the results of search action to an excel file so he can locally store it.. I have done this with very simple code which is [code] Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("content-disposition", "attachment; filename=StackRanking.xls"); Response.Charset = ""; System.IO.StringWriter sw = new System.IO.StringWriter(); … |
| | i am using vs.net 2003. I have do the delete function in the datagrid. Bu the problem is when i run in IE, the "Error on page" msg will occur the the bottom of IE when i click "delete". Please help me.... below is my is the print screen for … |
 | Hi everyone, I am still fairly new to SAS programming and I have somewhat of a problem. I am writing a program that will input a Microsoft Excel Spreadsheet and convert it to a SAS dataset. From there, I want to insert everything in that dataset into a table in … |
| | Hello.. Im in urgent net to compile some Libary Management System written in .NET. The code seems very good, but I'm facing some problems I cannot solve/figure out myself, because I dont have any experience with .NET. It seems like DataSets (classes) wont be included in FORMViewer.cs - I tried …  |
| | Hi All. I am now doing this tutorial step by step ; [URL]http://www.azroc.co.uk/csharp/asp_net/asp_net_data_access_layer2.htm[/URL] ----------------------------------------------------------------------------- It shows on how to create a dataset and retrieve it.Then it will be show in the browser.But then, when try to run, it says got error at my aspx.cs file. Well,I run the codes by … |
| | [COLOR=#000000]Hi, I have 2 tables a parent and a child. I want to insert value from C# (Windows Form) to DB(MSSQL) in VS2005. Although I’m sending data to both of them but the new record will be generated only in parent table but not child. At the first I thought … |
| | Hi I am working in asp.net with C# web application, I have used visual studio 2003, i have used dropdownlist in my application to populate the data from mysql database, i have got problem while i selected the item from dropdownlist, its not selecting correct item i'm selecting from dropdownlist, … |
| | i m doing my project in c#.net my problem is that i retreived data from the data base into a dataset i have to display that data first i use the datarow to display it now i need to randomly display data how i wiil do this i.e each time …  |
| | Hi, I have a requirement to insert data from dataset into a table in the database. Actually i have records in the excel sheet that has to be inserted into the database. I have populated them in a dataset. Now this dataset has to be validated against some conditions. After … |
| | Hi.. I've problem here. I have checkbox chkdrugnegative..user can select more than one drug name. my problem is how to insert to database. how the table. i'm using pl/sql. here is my sample coding. Private Function adddrugtest() As Integer Dim oleConn As OleDb.OleDbConnection Dim roleData As OleDb.OleDbDataAdapter Dim oleCmd As … |
| | Hi, I need to export data from a DataSet Element to Excel. Does anyone know the easiest way to export the data from the DataSet to an Excel file on the client's machine? Thanks, Mike |
| | hi every one am asking if any one know about disgning a report in a report viewer control i have a question how can i put 2 data table in 2 table all in a list in a differant way i have a data set named [COLOR=#000000][B]Dataset: [/B]dsSItems_Log[/COLOR] [COLOR=#000000][B]· [/B][B]Datatable: … |
| | I am trying to access a field of a strongly typed dataset (i.e. .xsd) When I compile, it says: FirstNameColumn inaccessible due to it's protection level. Where do I check this access level please? Thanks |
 | hey people!! how are you all? I need some help here: 1) is there any way easyer to do this: [code] [COLOR=#008080][COLOR=#008080]DataSet[/COLOR] DS = [COLOR=#0000ff]new[/COLOR] [COLOR=#008080]DataSet[/COLOR](); [COLOR=#0000ff]foreach[/COLOR] ([COLOR=#008080]DataTable[/COLOR] t [COLOR=#0000ff]in[/COLOR] DS.Tables) [COLOR=#0000ff]foreach[/COLOR] ([COLOR=#008080]DataRow[/COLOR] r [COLOR=#0000ff]in[/COLOR] t.Rows) [COLOR=#0000ff]foreach[/COLOR] ([COLOR=#008080]DataColumn[/COLOR] c [COLOR=#0000ff]in[/COLOR] t.Columns) CBx.Items.Add(r[c]); [/COLOR][/code] 2) how can you order a combobox … |
| | Hi[COLOR=#000000]How to Export data from Dataset to Excel sheet in VB.net Windows Application and also How to convert Excel Sheets into Data set Using VB.net coding(Windows Application)[/COLOR] [COLOR=#000000]how to Convert Dataset into XL Sheet to the VB.net Windows Application only by using the default resource(dll) available in VB.net.[/COLOR] [COLOR=#000000]ie without … |
 | I have just begun reading a PDF on Assembly language. One of the terms it mentioned and encouraged the reader to research further is "pipelining". I looked this up and read a brief description on WikiPedia; a section of the article stated: "In [URL="http://en.wikipedia.org/wiki/Computing"][COLOR=#0000ff]computing[/COLOR][/URL], a [B]pipeline[/B] is a set of …  |
| | I get the following error "Timeout expired. the timeout period elapsed prior to obtaining a connection from the pool. this may have occurred because all pooled connections were in use and max pool size was reached." The below code is in the click event of the Upload button. This works … |
| | Hi, I am new to VB.NET, so please bear with me. I have a form with 2 datagrids. The first datagrid displays data from a dataset (ds1). Now based on certain criteria that the user selects from the textboxes and after clicking a button "Get Data", I need to loop …  |
| | Hi All, First time I am posting, so please forgive me if I miss out any information while asking you my question. I have a .net web app that I am building in 2.0 framework. I have a code-behind file that calls a method in a business logic class. The … |
| | Hi all. Could someone pls tel me whats wrong with my code for adding new records to the db. Nothing is being added to the db and before the form opens up when running it, it brings an error that the file name of my form is invalid. Could someone …  |
| | Hello everyone This is my problem- I am a C# student and I wrote a program for a address phone book. So when my teacher offered extra credit- I accepted- but the catch is he's not going to help at all. He said we can use any source but him. … |
| | First of I am not engllish speaker so if something its off forgive me please. Now on the topic, I have not touch VB in 4 or years and now changing from VB6 to VB 2005 Now I used to work with dataset on VB6 but the teacher is really.... … |
| | Hi, I am building class for my project ,but yhe problem i do not get the proper answer here is the code [System.ComponentModel.DesignerCategoryAttribute("code")] public class Buying : System.Data.DataSet { private ContractDataTable tableContract; private BuyerDataTable tableBuyer; // private SellerDataTable tableSeller; public Buying() { this.InitClass(); // // TODO: Add constructor logic here … |
| | What do i add to code be able to hit enter as well as clicking the button. <%@ Page Language="VB" %> <script runat="server"> Function era(ByVal yEAR As Integer) As System.Data.DataSet Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=Cresta Tunes.mdb" Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) Dim … |
| | Hi Guys, I have developed a desktop client application which runs on the local machines of some clients. I have another server application which is basically a filewatch application which runs every 5 secs . What this server application does is check the SQL database for any new updates, & … |
| | Hello Everybody, I want to know that how we can delete the record from the datagrid only, that data should not be deleted from the database. i.e., It should not be seen in webpage,but it should remain in the database. Please help me out soon.My existing code is: [CODE=asp.net] <%@ … |
 | Hi, guys! Got a problem here. :) I have a form that when it loads spawns a thread which in turn fills a publicly declared dataset with a table by a dataadapter and then binds a field from the table to a combobox. [code=vb]combobox1.DisplayMember = "fieldName" combobox1.ValueMember = "fieldName" combobox1.DataSource … |
| | HELP! I am trying to write a database app with three tables. I have figured out how to connect to my database with oledbconnect. From there I am confused as to how to get a select command to work. I have found plenty of info on selecting data from one …  |
| | VB.NET Code behind: [code] [COLOR=#0000ff]Private[/COLOR][COLOR=#0000ff]Sub[/COLOR][COLOR=#000000] Button1_Click([/COLOR][COLOR=#0000ff]ByVal[/COLOR][COLOR=#000000] sender [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] System.Object, [/COLOR][COLOR=#0000ff]ByVal[/COLOR][COLOR=#000000] e [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] System.EventArgs) [/COLOR][COLOR=#0000ff]Handles[/COLOR][COLOR=#000000] Button1.Click[/COLOR] [COLOR=#0000ff]Dim[/COLOR] dbconn [COLOR=#0000ff]As[/COLOR] SqlConnection [COLOR=#0000ff]Dim[/COLOR] dbcommand [COLOR=#0000ff]As[/COLOR] SqlDataAdapter [COLOR=#0000ff]Dim[/COLOR] dslogin [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] DataSet dbconn = [COLOR=#0000ff]New[/COLOR] SqlConnection("Server=localhost;UID=sa;PWD=sa;database=websiteDemo") dbconn.Open() dbcommand = [COLOR=#0000ff]New[/COLOR] SqlDataAdapter("Select UserID from " _ & "Login Where " _ & "Username = '" … |
| | Hi all, pls send Ans to these SAS Q's : book_date channel revenue nights member_no 2/2/2004 web 100 2 1234 2/3/2004 web 50 1 1222 2/3/2004 web 50 1 1234 2/3/2004 cro 100 2 1235 2/10/2004 gds 150 3 1236 2/11/2004 web 250 5 1234 2/11/2004 web 100 2 1238 …  |
| | I need to be able to confirm to enduser selecteditem from listbox. I have a textbox and picturebox to show selected item but only get standard text for dataset. How to convert to text and eventually save to new table for estimate? |
The End.