2,634 Topics
 | |
| | Hi, I have an interesting question. I have this C# Application and I need to generate a report. I want to be able to print the report or save it to a file. Unfortunately I don't want it to depend on a third party software ( Crystal Reports, MS Word, …  |
| | Hi! everyone I hope u help me! I have a datagridview how will i insert a record through datagrid.... I did't have dataset, staightly stored the database...... |
| | Hey guys I have chosen to create an Epos system for my final yr project which doesnt seem to be one of the wisest decisions ive made. I am using Access to store all my data in the database and I am using vb.net 2005 as the GUI for the … |
| | Problem ::: Last night, I’d been invited to a party. After dinner, the host invited us to do a lottery game and gave each of his N guests (including me) a ticket. Each ticket was a white square piece of paper in which a positive number (with no leading zero) …  |
| | I have a page that a client asked me to make that consists of the following: [code] Repeater1 (Client Data) Label1 = Number of Records Repeater2 (More data where ClientID supplied = ClientID on the table) (Limit 4 recs) Label2 = Number of Records Repeater3 (More data where ClientID supplied … |
| | hello guys, i really need help....i have a transaction table in ms access N i want to retrieve last 10 transaction from the table from my vb form...how am i suppose to do it???i used the folloing code but it is displaying all transactions of a specific account number. N … |
| | hi all, i am trying to find record in datagrid using a textbox (and/or a button) but it is not working. here is the code DataSet.Tables(0).Rows.Find(txtName) nothing happens when I type in textbox or when I press the Search button. can u tell me what wrong with it? |
 | im having trouble using the PUSH method to generate a report . this is my code. [CODE] Try cr1.Visible = False Dim myConnection As New SqlClient.SqlConnection myConnection.ConnectionString = "Data Source=someplace;Initial Catalog=somedb;User Id=someid;Password=somepass;" Dim MyCommand As New SqlClient.SqlCommand MyCommand.Connection = myConnection MyCommand.CommandText = "Select * from asset where assetid < 10" … |
| | I'm using a typed dataset with several master:detail levels. I've already discovered I must set EnforceConstraints to false to load the data or I will get constraint conflicts. Now I am trying to discover how to delete related child records when a master record is deleted. The master gets deleted … |
| | I am using a typed DataSet in C# Express 2005 to build a master:detail relationship. I can do so by dragging the master table from a Data Sources window to the form, and then the detail table from the end of the list of objects in the master table. Two … |
| | [COLOR=green] Hi, I am using C#.net 2.0 with Webforms and displaying data from dataset in the GridView. On button click, I need to Export the Gridview data to Excel but save as a zip file. Please let me know how to do this. Thanks gs[/COLOR] |
| | hi i can not bind text box at runtime successfully in vb.net2003 the code is describe below imports system.data.sqlclient dim conn as new sqlconnection dim cmd as new sqlcommand dim adp as new sqldataadapter dim ds as new dataset // [COLOR="Green"][U] form load [/U][/COLOR] conn.connectionstring="" cmd.commandtype=commandtype.text cmd.commandtext="select * from master_dept" …  |
| | Can someone tell me why this SQL Command at the end is not working? I am a noob, but I have tried everything I can think of and I am getting nowhere. There is no literature on how to do something like this... It would have to be my first … |
| | Hello All. [B]I have 3 tables in database, they are:[/B] - [B]DEBT:[/B] ACCT, DESK_KEY, SECT_KEY, DESK_DATE, SECT_DATE - [B]DESK: [/B]DESK_NAME, DESK_KEY(primary key) - [B]SECT : [/B]SECT_NAME, SECT_KEY(primary key) [B]The Application works like the following:[/B] I have a browse button and a corresponding textbox, you should choose an Excel Sheet and … |
| | I have written some coding to add a new row to an existing data table. After clicking the submit button I get following error. "Update requires a valid InsertCommand when passed DataRow collection with new rows." Please tell me what the additional code I should add. The "add" method is … |
 | Hi! I have coded a project in vb.net. It contains code that retrieves around 15 lakh records from the database and displays them in a grid. I use data adapter and fill the dataset with it. Then I specify the dataset as the datagrid's datasource. Now the problem is that … |
| | This is an example of editing in DataGrid and Default Paging Html Design Code : - <asp:DataGrid id="DataGrid1" DataKeyField="id" runat="server" Height="224px" AutoGenerateColumns="False" PageSize="5" AllowPaging="True"> <Columns> <asp:BoundColumn Visible="False" DataField="id" HeaderText="Category Id"></asp:BoundColumn> <asp:TemplateColumn HeaderText="Category"> <ItemTemplate> <asp:Label id=lblName text='<%# DataBinder.Eval(Container.DataItem,"name")%>' Runat="server"> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox id=txtEdit Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"name")%>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> <asp:EditCommandColumn … |
| | Hi! I wish to copy the records in a dataset into an aary? How is this possible? Secondly, I would like to know whether using "=" operator while comparing is better or using an "in" operator is better For example,putting the following in a for loop Select city from empinfo … |
| | I have a device control panel that consist of a veiw and settings buttons. the buttons are binded to a dataset that populates the devicenumber and deviceUID I have a javascrip function [code] function gotoGeo(username, name, duid) { top.main.location.href="../TrackApp/main.aspx?selectedTab=" + selectedTab + "&deviceName=" + name + "&deviceUID=" + duid; } … |
| | I have a device control panel that consist of a veiw and settings buttons. the buttons are binded to a dataset that populates the devicenumber and deviceUID I have a javascrip function [code] function gotoGeo(name, duid) { var username = document.getElementById('txtUsername'); top.main.location.href="../TrackApp/main.aspx?selectedTab=1&deviceName=" + name + "&deviceUID=" + duid + "&username=" … |
| | Hi, I'm trying to access XML data in C# I have stored in a row in a database under one column. My database software is Sybase SQL Anywhere 8. The code is as follows" [CODE]OleDbDataAdapter da = new OleDbDataAdapter("SELECT UIData FROM prog_parents WHERE ParentName = 'Blank Panel'", connection); da.Fill(ds);[/CODE] The … |
| | Hi, I'm working on VB.NET Express and SQL Server Express. I have a DataGridView control in the form, with 8 columns, of which one column, which has default values, is hidden and one column is already filled with default values. I want to populate the DataGridView with records that exists … |
| | Hai.. Is there possible to use module class in web application.. in web application i have one module class.. the module class one variable declared to assing particular value then i am go to mywebpage to print that modulevariable the result is shown but the same time i have changed … |
| | I have another problem. Same dataset as before. I have a huge collection of floats. I have a multi-dimensional list. About 37 per list, and over 60,000 lists. So something like: [[16166.00, 4123.15, ...], [761.1364, ...]]. I'm trying to find the [url=http://en.wikipedia.org/wiki/Euclidean_distance]Euclidean distance[/url] between one list with each of the … |
| | Keywords: ASP.NET app with VS2005 running on Win2003 with IIS6, and SQL2000 on a WinXP Box I've betting the following for days... it's driving me insane: [B]Server Error in '/' Application.[/B] [B]Security Exception Description[/B]: The application attempted to perform an operation not allowed by the security policy. To grant this … |
| | I’m selecting data from tables in a SQL Server 2000 data base, and putting the result into a Dataset. I’m writing the dataset out to a file in XML format using ds.WriteXml(myXmlWriter, XmlWriteMode.IgnoreSchema). The table names are in singular (i.e. table customer is called “customer”), if I have more than … |
| | I’m selecting data from tables in a SQL Server 2000 data base, and putting the result into a Dataset. I’m writing the dataset out to a file in XML format using ds.WriteXml(myXmlWriter, XmlWriteMode.IgnoreSchema). The table names are in singular (i.e. table customer is called “customer”), if I have more than … |
| | OleDbConnection cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\\tblImp\\db1.mdb"); cn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter("select * from tblImp", cn); da.Fill(ds, "tblImp"); tablecontrol.datasource() = ds.Tables[0]; tablecontrol.DataBind(); table is not populated with data from access database. help me plz. |
 | Hey all! A industrial psycologist friend of mine asked me to find a way to look at an array of numbers (presented in an excel spreadsheet - 1 number per cell) and find the CELL with the highest value. I thought i could do this by selecting the array and … |
| | hello someone there could have met a similar problem. please help me out Am using this commant to save data to an sql server database. me.validate() me.bindingsource.endedit() me.tableadapter.update(me.dataset.datatable) but when i click the save button on my winform it brings an error "System.Data.DBConcurrencyException: ConcurrencyViolation: The UpdateCommand affected 0 of the …  |
| | Hello, I am trying to add some reporting features to a quite large asp.net web application. I have created a webform that contains a few fields for filtering data to be displayed in a Crystal Report. I have created a sample report that has a few parameters but I cannot … |
| | hi every one after connecting to an excel file I want to import the firts row into a combobox in the connection function I added thhis MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from[sheet1$]", MyConnection) MyCommand.TableMappings.Add("Table", "Attendence") DtSet = New System.Data.DataSet MyCommand.Fill(DtSet) '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ComboBox1.datasource= DtSet.Tables(0) [COLOR="Red"]i think this is error[/COLOR] and when …  |
| | Dear Frens, I m beginner in VB.net. I have developed an Address Management System where I want to add my searched grid into Crystal Report. Unfortunately, I don't know code to make report from datagrid. or certain data set. I have succeeded in making report from primary dataset from crystal … |
| | hi, i want to convert typed dataset to untyped dataset?? vice versa.......please healp me........very urgent |
| | hi ive been trying to insert specific data into a certain textbox from an access table, ive managed to pull the information from one field onto a listbox but i cant grab specific data and load it onto a textbox: here is the code, if anyone can help please that …  |
| | Hi all, i am a new to VB.NET and i have a project to be completed urgently. I need to insert information from textboxes into a database, I have created the connection using Jet Engine, the connection is working well because I can display records. However I cannot insert new … |
| | Hi there. i'm having trouble joining tables. I'm using Access database. Initially, i have 2 tables called thresholdTable and Configuration. In the thresholdTable, there's a column called 'Config' and i've linked it to a column called 'Confuguration' from the Configuration table. Right now everything's working. However, i added another table, …  |
| | Hi there, I have a combo box that contains 10 names. For eg. I select John's name. It will retrieve his left250 value from Access database. It will then display as a label. I've managed to do this so far. However, when i add in a new name in the … |
| | Dim conn As New SqlConnection(connstr1) Dim sql As String sql = "Select * from address1" 'Dim da As SqlDataAdapter Dim cmd As New SqlCommand(sql, conn) conn.Open() Dim ds As New DataSet() da = New SqlDataAdapter(sql, conn) da.Fill(ds, "Address1") maxrows = ds.Tables("Address1").Rows.Count inc = -1 conn.Close() 'If next_record <= maxrows - … |
| | Hello, I have to create a webapplication in ASP.net / C# with an Oracle Database in background. At first: I have no idea to do this! I read some things about ADO.net, DataSets, DataGrid and DataAdapter. But I think I don't got it completly. Now my responsible wants to display … |
| | Dim conn As New SqlConnection(connstr1) Dim sql As String sql = "Select * from address1" 'Dim da As SqlDataAdapter Dim cmd As New SqlCommand(sql, conn) conn.Open() Dim ds As New DataSet() da = New SqlDataAdapter(sql, conn) da.Fill(ds, "Address1") maxrows = ds.Tables("Address1").Rows.Count inc = -1 conn.Close() 'If next_record <= maxrows - …  |
| | Hello, I get this error message when I try to do an update on my form. Can somebody help. Please see the my code below. Imports System Imports System.Data Imports System.Data.OleDb Imports System.Windows.Forms Public Class Incilistfrm Inherits System.Windows.Forms.Form Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\Project\MyDatabasev1.mdb") Dim cmd As OleDbCommand … |
| | I just have a general question regarding column formatting using the DataGridView. I've connected to a database and bound a datatable into an object that I've instantiated of type DataSet. I've proceeded to create new DataColumns and add them to the DataSet before I populate the cells in any of … |
| | I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, … |
| | hi all well i m new to asp.new.. i have a problem that i m having two tables in a single dataset.. not i want to display that.. so i bound dataset to the gridview.. can anyone tell how to display both the table data in a single gridview. regards … |
| | how to convert typed dataset to untyped dataset???  |
| | i used visual studio 2003 ,i am newbie i Created a simple database access and link it below ,i want to use dataset and oledbapdater compare the input from textbox with username and password colums in file .mdb . [url]http://mkptrans-nt.com/BaiTapTn.mdb[/url] [B]interface drag drop [/B] [B][U]Login page :[/U][/B] [url]http://mkptrans-nt.com/pic1.JPG[/url] [B][U]Viewmark page … |
| | Hello[U],[/U] In VB.NET 1.1 and using WinForms, I am exporting the data displayed in a listview to a CSV file but I am specifying the filename and location while conversion. I need a dialog box where the user can choose the location to save the file. I know I have … |
| | [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] str [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]String[/COLOR][COLOR=#000000] = "select * from table1"[/COLOR] [COLOR=#008000]'try to write "select distinct * from table1" [/COLOR][COLOR=#0000ff]Dim[/COLOR] con [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]String[/COLOR] = ConfigurationSettings.AppSettings("preeconn") [COLOR=#0000ff]Dim[/COLOR] cmd [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlCommand(str, [COLOR=#0000ff]New[/COLOR] SqlConnection(con)) cmd.Connection.Open() [COLOR=#0000ff]Dim[/COLOR] da [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlDataAdapter(str, con) [COLOR=#0000ff]Dim[/COLOR] ds [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] DataSet da.Fill(ds, "table1") [COLOR=#0000ff]Dim[/COLOR] maxrws [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]Integer [/COLOR][COLOR=#0000ff]Dim[/COLOR] i … |
| | In the VS command prompt that is part of the VS SDK you can enter the following to generate an xsd file from an xml file: xsd XMLfilename.xml This will generate an xsd file with the same name as the xml file Then you can enter: xsd [.xsd file generated … |
The End.