2,634 Topics
 | |
| | Dear Experts How to apply primary key on sno column in the following dataset [CODE] dim sql = "select * from employees" Dim da As new SqlClient.SqlDataAdapter (sql,con) 'ds.Clear() da.Fill(ds, "employees") TextBox1.DataBindings.Add("text", ds.Tables("employees"), "sno") TextBox2.DataBindings.Add("text", ds.Tables("employees"), "Name") TextBox3.DataBindings.Add("text", ds.Tables("employees"), "City") TextBox4.DataBindings.Add("text", ds.Tables("employees"), "Phone")[/CODE] Please help  |
| | I'm creating a printed report of an event; each event has one or more groups, each group has one or more people. The report page is set externally; I can't change that. Each page of the report has a place for up to two groups and up to 6 people. … |
| | I am trying to generate random images from access database using hashset as it is said to be unique and there won't be any repeated images appearing. But, it doesn't seem to work. How can i get it to work? By the way, i am very new to the concept … |
| | With regards to another thread, [url]http://www.daniweb.com/forums/thread251069.html[/url] on how to compare the current date to retrieve relevant data (Details there), now I have issue on storing this query result on a VB.net variable. It works in this way. It is an academic work to do a ecommerce website, and I need … |
| | I have a dataset with a field defined as a system.datetime datatype. In my visual studio 2008 that has crystal reports 12, I have a report that should display this date field. This worked fine in an earlier version of visual studio 2008. However, since I have installed the updates … |
| | I have an excel addon and a user defined function the formula of which does some computations. The results after executing the formula must be stored and retrieved when the same excel file opens again. I am using a DataSet object to store the results from the formula at present. … |
| | Hello, Everyone. I have receive the above mention error. I don't why this error is occurring. [CODE]using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; namespace TurnkeySolutions.App_Code.DAL { [Serializable] public class DBBridge { public DBBridge() { // … |
| | Hi, what I am trying to achieve is to extract a certain word from a .txt file, eg. "word". I am also running an XML file into a dataset. Within this dataset I want to locate the column which has the name "word" (same string from txt file). Once I … |
| | First of all, normally i create web apps, so i'm a newbie to winforms. I have created a dataset with data from my DB and using that as my datasource for my gridview, a little bit of code: [code] // Define Connection string string DB_ConnStr = ConfigurationManager.ConnectionStrings["SupportTool.Properties.Settings.DB_Contact_ConnStr"].ConnectionString; // Define SQL … |
 | hi, i got an problem i wants to update the serialnumber in the database, if i was updating the serial number as (for eg: 3 in place of 4), it was updated. if i was updating the serial number as 3 in place of 4.. here serial number 3 is … |
| | hi frnds, i was a get a problem, i want to update the serialnumber by using a text box,,,, suppose i am updating the serial number as 3,,,,it was updated,,,, but if i wants to update the serial number as 4 ,that is already in the database it is also … |
| | I am working in vb.net, visual studio 2008, with the crystal reports that comes with it. I have a push model: creating a dataset, putting data into it, making that a report source, and putting the report source onto (or into) a crystal reports viewer control (not neccessarily in that … |
| | hi, I have been doing my ASP.net project in C#.I am a beginner to a programming world.i have Performed executed some sql queries by writing some Connection strings..But i am looking for finding another method,which i could get simpler by calling some function like "studadapter.fill(dataset,"src table")" which is to fill … |
| | I have a scenario where i have a DataSet bound to a combo box, and i would like to read a row from the DataSet based on the item selected in the Combo Box. For e.g. I have a dataset that has 1 table containing 2 fields say ID & …  |
 | I get into DataSet CostumerNames and Hours (type DateTime) of their registrations. I would like to sort customers my time of registration (time of a day). I show both in listView. This is my code: [CODE] string DanesRezervacije = "SELECT Stranka.ImePriimek, Naročilo.RegisterTime FROM Stranka, Naročilo " + " WHERE Stranka.IDStranke … |
| | Hi folks, Basically, i'm writting an app that pulls info from and AccesDB file and then fills in information in a form. Where i'm lost is that my form is to be in another form. I have my main form, frmMain.vb, that is my start-up form. When i pick a … |
| | I have a problem with a combobox and no page on the Internet has been able to help me so far. So I hope that one of you can. I have a form (with information about clients) with textboxes binded to a dataview. One of the columns in the dataview … |
| | Hey guys, I'm working on my DBMS project,it's about creating a visual basic application that links the user to a database. I've created the connection and added the dataset with the relations i've made in MS access. Since i'm a beginner in visual basic,i've come up with this simple layout: …  |
| | [CODE]Private sub button1_click( ) Data Set Dim ds as new dataset Ds = new dataset(“student”) Connectionstring Dim connectionstring as string = “provider =Microsoft.jet.oledb.4.0;data source = student”; Dim connection1 as oledb.oledbconnection = new oledb.oledbconnection(connectionstring) Command object Dim command1 as oledb.oledbcommand = new oledb.oledbcommand(“select * from student”) Command1.commandtype = command.text Connection1.open() Comand1.connection … |
| | Hi, I'm using web service wich return DataSet object . [CODE] localhost.Default Mse = new localhost.Default(); DataSet ds = Mse.GetData(); GridView1.DataSource = ds; GridView1.DataBind(); [/CODE] How to set GridView control to be sorted by ID column (DESC) on page load? |
| | Hi everyone, please i created a[COLOR=#000000] C# windows application to implement a form with a ListBox, a TextBox, an Edit button, an Insert button, a Delete button, a Update button and an Exit button in the form. I want my C# program to be able to copy the columns of … |
| | hi frnds,,,, here i want to access the data base and showing in the grid view without help of datasourse it will shows the error, the error is "The IListSource does not contain any data sources"" here my coding is as follows..... [CODE]Protected Sub Page_Load(ByVal sender As Object, ByVal e … |
| | Hi experts, I am a student working on a project for my company. I work using Microsoft Visual Studio 2005. Language is vb.net. I also work using windows application. I have a form(EmailContacts) which contains a datagridview and a button to add the data to a textbox of another form. … |
| | Hope I chose the correct forum. I have a dataset object with one table that comes to me from a common custom component's GetDS method. I need to pass XML to another process (chunked as byte array). I have it all working but the XML is missing some attributes that … |
| | How can I put a progress bar inside this code: (I was trying to use PerformStep method for counting rows in data table, and put this code, but no luck: [URL="How can I put a progress bar inside this code: (I was trying to use PerformStep method for counting rows … |
| | Hi all, I'm currently stuck with a simple problem, which I cannot seem to get it to work for the past few days. I'm trying to get the CheckBox type from a ControlCollection and it is displayed within a Table However, it don't seem to work regardless of how I …  |
| | The scenario is: i have a textbox, a button and a grid view that make up a simple webpage where you can search and edit/delete an entry. the grid view's datasource ID is set to NONE. And this is the code for populating the grid view that is found in … |
| | hi i had got a problem that i want to display the difference between two dates to be displayed in a grid view ,here the first date can be taken from a textbox. when the button is clicked the difference between dates to be displyed in days, here iam using … |
| | Hi All, I am stucked at one point in one of my web based application; this application is like a HR questionnare and evaluates the employees. I am populating a gridview with the following code in VB.NET [CODE] Dim SQL As String = "Select App_EmpCode, App_EmpName, App_EmpDesig, App_EmpDept, App_EMManager,App_EmpManager, App_EMDGM, … |
| | I'm getting data form sql table in DataSet object. How to make theese results to slide horizontal in marquee? All rows to be in one line in the marquee. Thanks |
| | This issue only happens in FF (IE and Chrome seem to work fine). I have a Spry paged dataset (at bottom of page with big blue arrows.) dealpigeon dot com/indexMore.php When I change the page in a paged region (by clicking on arrow), it is refreshed as expected. But in … |
| | I want to export these xml tags from c#.... [code=xml]<Mujeeb> <ID>1</ID> <NAME>Table</NAME> <ORIGINAL_NAME>Table</ORIGINAL_NAME> <TYPE>Table</TYPE> <FORMAT> <ID>0</ID> </FORMAT> </Mujeeb>[/code] But the code i code output different result even after i created the Child and Parent table relationship. [code=xml]<Mujeeb> <Mujeeb> <ID>0</ID> <NAME>Table</NAME> <ORIGINAL_NAME>Table</ORIGINAL_NAME> <TYPE>Table</TYPE> </Mujeeb> <FORMAT> <ID>0</ID> </FORMAT> </Mujeeb>[/code] Not sure why … |
| | It gives an incorrect row count and the column count only shows 1. So when I try to handle the true number of columns in the CSV file it reports an OutOfIndexRange error. Any and all help would be greatly appreciated. Example Data: [QUOTE] "Name.ID","Type of Call","Name","Phone Number","Start Date","Server Log … |
| | I'm a beginner in .net programming environment.I am using c#. i have a text box(txtSearchKey) for user to enter the text key. i have a combo box(cmbSearchBy) to specify in which field of employee table ,search key should be used to retrieve data. when i use the above code i … |
 | HI I wrote below coding part,but its generate the exception.Below I mention the code and error Error [COLOR="red"]Data type mismatch in criteria expression.[/COLOR] [CODE] DataSet Serach_sumbitdata=new DataSet(); OleDbConnection conn7 = this.getconnection(); conn7.Open(); string str = "Select * from Customer where SubmitDate between '" + str1 + " 12:00:00 AM'" + … |
| | I used below code to display some data using crystal report.i used separate dataSet() object and connected it to the crystal report setDataSourse. There are no compile errors,but after running it gives me the error [B]"Load report failed". [/B] plz help.. The code. [CODE] String ConnectionString = ConfigurationManager.ConnectionStrings[0].ConnectionString; SqlConnection con … |
| | I keep receiving the same output for each record when I run it on the test data. I've tried numerous things...any suggestions? I've worked on this for almost twelve hours straight, not counting previous work. I'm hoping one of you guys/gals who know whats going on can point me in … |
| | So far, this has worked relatively nicely. However, I am having trouble in outputting to two separate files, and I'm hoping that you guys and gals can help me out. I'm reading in from a file, and outputting to two different files, based on what the input is. If anyone … |
| | Hi, I have a dataSet that has many .mp3 files in it. I have displayed them in a form, When i click on the cell that has the .mp3 i want. It should save to a temp file. Any Ideas thanks |
| | Hi, I have a MP3DataSet that includes .mp3 files, i have a form, which shows all the files in the dataset, on the form i also have the windows media players. I am trying, when the user clicks on a song in the dataset to play on the WMP, any … |
| | I'm having problems trying to fill in the DataSet using SQL Server 2005. Basically I have a table in SQL Server and I want to retrieve those information and be able to display it in a web browser using DataSet. Whenever I run my code I always get error message: … |
| | Hi everyone, I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables. [Code] SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business FROM Receipt … |
| | Hi all I'm having trouble with some of the login controls for my website. I've successfully set it up so when a user registers it enters the details into an Access database. I'm now trying to get the login to work but can't see how to implement this. I've had … |
| | Hi All, I have a very simple DataSet linked to a ListBox. I need the User to be able to add Data and have used the following code (in a ToolStrip command button): [CODE]Dim newFileRow As DataRow = Database1DataSet.Tables("tbl_Files").NewRow() newFileRow("File Name") = fleName newFileRow("File Path") = flePath newFileRow("Times Opened") = … |
| | Hi all. pls, I'm building a report which holds data from a dataset in tabular form in the details and in the footer section, the details section returns all rows but the footer does not, it returns only the last row of the table though the dataset were set & … |
| | I want to retrieve only one column from dataset or datatable. the dataset has one table and that table has many column. But I want only one column from that table. How can i do it? And that will be still in a dataSet, not in a string. |
| | I'm hoping someone here can help me. I am very new to C# and programming in general and am stuck on the following after researching and trying different solutions for the past 2 weeks! I'm trying to read from an XML file into datagridview. I also want to add extra … |
 | I'm having a problem with loading my MS Access Database. I can get it to load but it won't load in a row. My friend told me to try this but it puts all the information in a column instead of putting all the information spread out accross the row. … |
| | Hi, I am using sql data base the image save in database but it doesnt get viewed in data grid view though rest of the items are viewed. Please help me to come out of this solution. Regards Creativz [code] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; … |
| | Hi guys, I don't know if anyone out there can help me with this. I will start of by explaining exactly what I am doing. I am currently developing a web based online examination system in ASP.net. Now I have set it up and it works perfectly except for one … |
The End.