2,634 Topics
 | |
| | I've added a dataset , and a table adapter to my C# project. In this query , I get table data , then filter , then I will iterate and fill a listbox.(The dataset and tableadapter was added via DataSources boxes) [CODE=CSHARP] listBox1.Items.Clear(); ETPDataset.t_USR_UsersDataTable tbl = (new ETPDataset.t_USR_UsersDataTable()); ETPDatasetTableAdapters.t_USR_UsersTableAdapter tblAdap … |
| | Hi All I am trying to connect to access 07 via a windows app using msvs 05 in c#. I have the code which ive adapted from another working app but its now not working. Initialy the form should open an display the data rows in a table called events … |
| | I am creating a page to search for a user in a database and display the results in a gata grid (Which i have done) Then i would like to select one of the results and use this record by holding it as a variable and pass it back into … |
| | Hi guys, Im having trouble with this code, when i had it working with static variables set, it was fine, now i am using a passed variable, its not working... Might not be anything to do with it, anyhow... [CODE]Public Class frmContacts Dim con As New OleDb.OleDbConnection Dim ds As … |
| | I am having a weird problem with innerHtml that I'm hoping someone can help me with. The code displays two sections (one "EP offers" and one "LP offers" section as indicated in the code below. The code that works just fine locally, but when I upload it to the host … |
| | Hi everyone, I don't understand why this doesn't update my actual MS Access 2003 mdb file. During debug phase, I learned that it updates the dataset and creates new rows. But it doesn't reflect into the database. Why is it so? Please help me out. Thanks in advance.[code]else { //Auto … |
| | hiii I am doing application in vb.net and Oracle10g. On running the project there is some "Query Engine Error C:\document\Local\temp\....3434834-453493434.rpt" error but when same dataSet object when set as source to Datagrid the grid is filled corretly.......... any idea where m i going wrong............... |
| | [code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace CarsRUS { public partial class Cars : Form { private SqlConnection conn; private SqlDataAdapter daAddresses; private DataSet dsAddresses; private DataGrid dgAddresses; private const string tableName = "CarRUS"; public class Customer { …  |
| | Dear freinds i have a big problem!! i hope somebody can help me out.. The situation: I have a small application where i store customers and orders.. In my database i have a tabel called Customers and a tabel called Orders. These 2 dabases are joined on Customer ID - … |
| | Hi, In my application im generating a crystal report by dynamically adding the dataset. Up to now all are fine, But now i need to add new table to dataset and use that in the report. What i did was, 1- Create the the xml schema file for new dataset … |
 | This is the code I have: [CODE] public class BusinessLayer { public Employee[] GetAllEmployees() { Employee[] employees; DataSet myDataSet = DataBaseLayer.GetAllEmployees(); /// How can I convert the myDataSet to Employee List return employees; } }[/CODE] |
| | Hi, I am developing a s/w. I am trying to update data in table. While I save the data, it will update into table. I have a gridview which binds table data through dataset. While I update the changes it is not reflecting in the grid view. What I will … |
| | can anyone help..plz i have a form called transaction view.in this form there is two datetime picker.dtpstart and dtpEnddate.i want to pass these two values to report such that the report will display transactions occured in the range specified by th e datetime picker there are 3 tables in my … |
| | Hi, I would like to encrypt the class object and session state which contains dataset data. Plz help me if those are possible. Thanks and Regards krishna v  |
| | hi! I am trying to insert data from textboxes in sql server 2005 database using dataset(table adapters) in c# windows application herez the simplest coding that i know but its not working. I have made two tables in my database i.e. product and country table. In country table adapter i … |
 | Hi all i have question again, this is my code: [code] private void btAdd_Click(object sender, EventArgs e) { SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); DataView dv; string sql = null; string connetionString = "Data Source=GOD_LOVE_ME;Initial Catalog=ProjetDB;Integrated Security=True"; sql = "Select * from Material"; SqlConnection connection = … |
| | hi.. im retriving some data from a database to a dataset...i want to show the data in a gridview..but my problem is, i want data to be shown in last to first format. i mean, if the dataset contains, A as first record & z as last record, then the … |
| | Hi all, I'm newbe need your help. I have code: [code] public void Material_Load(object sender, EventArgs e) { SqlConnection con; SqlDataAdapter da; DataSet ds; con = new SqlConnection(); con.ConnectionString = "Data Source=GOD_LOVE_ME;Initial Catalog=ProjetDB;Integrated Security=True"; con.Open(); da = new SqlDataAdapter("select * from Material", con); ds = new DataSet(); da.Fill(ds); DG1.DataSource = … |
| | I am having a problem updating an access database with new information from an updated dataset. the database consists of 4 columns: User_ID, Login_Name, Password, Access. The following code makes a connection to the database, fills a dataset with the data from the database, reads a txt file with user … |
| | I am using .net 2005. I have created a GridView with one column having a command button. The DataAdapter, DataSource, DataSet were created in code, not with wizards. When the command button is clicked, I can't figure out the syntax for retreiving the value from the first cell in the … |
| | I am trying to search a database using a user defined string from a text box. I am getting an error message with the "objectadaptor.Fill" Here is the code: [code] Imports System.Data.OleDb Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Partial Class Search Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal … |
| | So I have a radiobuttonlist that returns a list based on a sql query. The app displays the results from the column named "printer". I am also selecting the column_name "default_printer" Basically what I want is for the selected index of the radiobuttonlist to be where "Default_Printer" = "1". I'm … |
| | hi, i am not able to display heirarchical data in my gridview when it is coming from a single table,,,,,,it works fine when i use more than one table....plzzzz its urgent [CODE=C#]using System; using System.Data; using System.Configuration; 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; public … |
| | hi i have a table with 1 milion record. i want to sort and read in 1000 groups. i can read diffrent groups but i want to apped 2 datset to each other. how can i do that? pleae help me. thanks |
| | is there a way to caputre the values in a datagrid and bind them to a sql table? I have a datagrid bound to a sql query with some editable cells and I wanted to know if the updates could be sent back to the sql table. is there a …  |
| | Hi guys, I've created a program to write form data to an access database. Currently I am extending it so that I can read the data back from the database. I have created a new dialog with a datagridview to view the table data. I wish to be able to … |
| | Hi all, my code is like.. [COde]string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\ifocus\\Excel Worksheet.xls;" + "Extended Properties=Excel 8.0;"; OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); myDataSet = new DataSet(); myCommand.Fill(myDataSet, "ExcelInfo");[/code] and My EXCEL data is like ------------------------------------------------------------------------------------- Gold --- [B]in@GLDM.1[/B] -- 14,917.00-- [B]Gold MCX[/B] -------------------------------------------------------------------------------------- ALUM--- …  |
| | All, I have a customized DataGridView where I have implemented extra functionality and bounded datasource in the same custom DataGridView (Using C# and .NET). Now, I could able to use it properly by placing it on a panel control. I have added label as button on panel control to display … |
 | Hi Everyone I'm designing a program with a front end vb.net (2007 Express version) app and a back-end Access 2007 database. I've added the following query to the database dataset (SAUJSDataSet). I have a table which contains information of students and there is a search form where the user can … |
| | I have a gridview which is bound to dataset initially. Then i edit the gridview data by clicking the edit button. after editing when i click the update button, value should be updated on gridview itself. Later when i click submit button all updated records should be updated to sql … |
| | I have a datagrid bound to a sql proc. I have made the last column in the datagrid into text boxes so the items are editable. how do i return the values from these cells? Basically I want to be able to sum the entire column, as well as set … |
| | Hi, How to display values from database into datagridview using SQLAdapter and Dataset. |
| | Hi to all, I am using dataset to retrieve value from dataset but I can't do it, control automatically goes to next sentence without retrieving any value.. [code] Dim scd As Integer = ds.Tables("collage_detail").Rows(x)("sc") Dim cd As Integer = ds.Tables("collage_detail").Rows(x)("c_id") [/code] collage_detail is my table name . |
| | Hi, Any advice please. I have various forms (e.g. frmCustomers, frmProducts), each having bindingSources and tableAdapters. The forms have the required Fill methods triggered from their constructors. It appears that the DataTable filled only exists in the App for as long as the form does. What I want is a … |
| | I think my thread title is a bit incomplete. coz these are my questions.I need answers to these questions for the completion of my thesis. [B]I Know this is sort of a long message but im detailing the situation for better understanding of my questions.[/B] And because these thread is … |
| | In VS2008 Is there a way to run an insert query against 2 different DataSources. I have a source that I would like to select about 10 fields from and insert into a different source. Example .. DS1 select 10 fields of data DS2 Insert those 10 fields of data … |
| | Hi buddy's, I need your guide regarding to pull data form other database to other database....I'm already pull the data into Dataset using this command :- [CODE] oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn) da = ds.fill [/CODE] then i need to insert to other database … |
| | I am reading in files containing 238 x 1 feature vectors. Attempting to grab the first 2 numbers in each file to create a 2d plot using numpy. I've got a decent start, just am stuck on how to fill the np array that I want to plot. [CODE] import … |
| | [B]hi every body i have a trouble with viewing the report from using the following environments[/B] C# - Crystalreport - Oracle database i regularly use the basic way to call a view form the database and extract the data form it like that [CODE]cmd.commandtext= "Create view as select * from … |
| | My file directory is full of filenames with "male" and "female" being part of them. I want to loop through the directory and distinguish between the two. [CODE] import os maleDataSets = 0 femaleDataSets = 0 females = [] males = [] filePath = "Dataset/parameter feature vectors" for file in …  |
| | I cannot seem to get the datagrid to update with the correct data from the combobox selection the program just crashes. Do I need to bind to the combobox some how?? Any help or advise would be apreciated [CODE] Private Sub cboBarcodeInCust_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … |
| | [code] <connectionStrings> <add name="ConnectionString" connectionString="Data Source=(local);Initial catalog=sonia;User ID=sonia;Password=sonia;" providerName="System.Data.SqlClient"/> </connectionStrings> [/code] [code] public partial class Frmgrid : System.Web.UI.Page { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlDataAdapter da; DataSet ds; protected void Page_Load(object sender, EventArgs e) { try { da = new SqlDataAdapter("SELECT * FROM Products", conn); da.Fill(ds, "tb1"); DropDownList1.DataSource = ds.Tables["tb1"]; … |
| | hi, i am trying to retreive data from a sharepoint list but its returns all columns such as ows_MetaInfo, ows__ModerationStatus ,ows__Level ows_ID ,ows_owshiddenversion, ows_UniqueId ,ows_FSObjType rather than just the fields i want from the list. I thought the "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns> tag would filter these colums out Can any1 help? heres my … |
| | hi, i am trying to retreive data from a sharepoint list but its returns all columns such as ows_MetaInfo, ows__ModerationStatus ,ows__Level ows_ID ,ows_owshiddenversion, ows_UniqueId ,ows_FSObjType rather than just the fields i want from the list. I thought the "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns> tag would filter these colums out Can any1 help? heres my … |
| | I have a DataGrid that I create dynamically in codebehind. I add events to the datagrid, it works fine except of the SortCommand event. It will not fire. If I change my page_load to create and bind the datagrid everytime when a postback it works. But I don´t want to … |
| | Alright, so my issue is that I have a staff profile. When you press the button it brings you to the Edit Profile page with text boxes with the original information in them so they can be edited. Now I ask for the edited information to be updated when the … |
| | PLease help!!!!! How the ... do i fill my dataset with data using sql server, datatable, and adapter... I've passed the select statement [ Select * from [TableName] and a ref of my datagrid to this procedure. Public Sub FillDataGrid(ByRef DataGrid As DataGrid, ByVal SelectCommand As String) Try Dim adSQLAdapter … |
| | Hi , I am busy converting a VB6 project to c#. Now in vb6 , the columns have intellisense like so... [code=VB] rsIBBSData!DrOrCr = 1 'rs is the recordset [/code] But in c# , i would either have to create an sql query , or use datarow with a column … |
| | Hi, I have a dataset which is having 5 tables. I want to get only two tables from that dataset and assign into a single datagrid. How can i do this? Thanks in advance... |
| | Hi, i'm trying to add a checkbox to a datagrid but don't seem to get anywhere. I got to add a new column but that's where it stops. I'm reading data out of my database and then deleting the first column of that dataset's table as it is not needed, … |
The End.