2,634 Topics
 | |
| | Hello, I need some help with my cascading dropdown boxes. Eveything works I just need to remove the duplicates from the States and Cities drop down box. Any idea how? I got it to work on the Country drop down but can't figure out the rest. Thanks. [CODE]private void FillCountry() … |
| | Hello, I have created a query as follow in ms access: [CODE]SELECT cont.id, cont.name, cont.mobile_num, cont.date_created, memb.group_id, grp.name FROM (contact AS cont LEFT JOIN contact_group_member AS memb ON memb.contact_id=cont.id) LEFT JOIN contact_group AS grp ON grp.id=memb.group_id WHERE cont.removed=False ORDER BY cont.id DESC;[/CODE] and I created a 2nd query to query …  |
| | Hello Everyone , I am working on [B]vs 2008 RDLC report[/B], i need to use [B][COLOR="Red"]two table which are from a single store-procedure[/COLOR][/B], when i am added a table adapter it is reflecting the first table, so how can i use the second table in the report.... |
| | I am trying to do simple insert, update, delete, select statements within VB .NET to access a MS Access database. I have tried all kinds of solutions offered on the web and while the code seems to work, no rows are inserted. Also, I have tried, unsuccessfully, to use the … |
| | Hi Everyone, I'm having problems with Datagridview Column I have a dataset containing a table called Inventory, which i databound to my datagridview. At my form load event, i set one column's backcolor to blue like this- dgvBrowseBooks.Columns("Title").DefaultCellStyle.BackColor = Color. But when i run the program, i get this error …  |
| | Hi, i want to know if its possible to bring upon many pictures in a single picturebox and navigating it. So far i have done the coding but when i run the program i cant see the picture being displayed following are my codes, and please help if theres any … |
| | Still learning here... this is my method to get the record count of a table ... it works, but it seems like a lot of coding for something so simple. Is there an easier way? [CODE] public int GetTableRecCount(string table) { //Set up the connection and adapters... OleDbConnection myConn = … |
| | Hi all ! I am currently trying to learn c# (for school). Now i got a problem with the ReportViewer @ Visual Studio 2010. I got my DataSets separated in a "Dataset" folder. (Example: [url]http://yfrog.com/mxexamplej[/url]) When i make a report (Report1.rdlc) i can add a "new" dataset. In the dataset … |
| | Hi, I thought I have mastered fighting segmentation fault thanks to the assistance of you guys. But still in this days I am getting seg fault. And there is no clue at all. I am writing a suffix tree using a trie. Here is the trace of segmentation fault: [CODE]aba … |
| | i have written this in else condition ..can anyone please check this... [CODE] else if (DDlDepartment.SelectedValue != null && DDLStaffid.SelectedValue != null) { con.Open(); string str1 = DDlDepartment.SelectedValue; string str2 = DDLStaffid.SelectedValue; SqlDataAdapter ad1 = new SqlDataAdapter("Select * from ManstaSalary where Department='" + str1 + "'and StaffID= '" + str2 … |
| | i am displaying data from a datasource using datagridview and i want to display the progress of the datagridview as it loads data from the dataset with progress bar how do i go about this. i'm using vb.net |
| | Hello guys and gals. As always any help is much appreciated. I am at a dilema. I am filling a datagridview with very lengthy results. Roughly 60k rows on average. I am filling them via an oracle database using a table adapter. The records then have a filter placed on …  |
| | Can someone please help with the following problem I am trying to update a sql database through a command builder but I keep getting an sql exception (Additional information: System error.). I dont know where I am going wrong because I thought the command builder should carry out the update … |
| | I am writing a web page, on this web page there is a txtStart and txtEnd. Next to them I have Calendar ImageButtons. I would like to code it so when the ImageButton is clicked a calendar popup appears and when they select a date on the popup it goes … |
 | Dear All, I have designed a form for a table Instalment from this form i am trying to update a column in other table which is hiring table please guide me how can i do this the code is as folloes thanks in advance. [CODE]Dim cnString As String cnString = … |
| | I'm trying to get a list of directories using the <CFDIRECTORY tag but the return dataset is only displaying the files in the directory and not the sub-directories. The directory I'm attempting to query has 1 file and many sub-directories but the result only returns the single file. Does any … |
| | Hello all I am new to the community and have been stumbing across a problem with my code. I have a program that is connecting to an oracle database. I am using the table adapter to fill a combobox to select a model. Then I am connecting to the database … |
| | I've tried reading through [B]datareader[/B] from the database. Tried dataadapter, reading from dataset and datatable. All of them generates an error when reading empty rows. Yes, I have used try and catch statements but the error still generated, that is transforming only in a messagebox. What I want is to …  |
| | i am writing an application on my pc considered as client, to insert record on a microsoft access database on another pc that u can consider it as server, that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the … |
| | I have a button for edit and delete. I include editbutton.enabled=false in page load when dataset if dataset is empty [CODE] SqlDataAdapter da = new SqlDataAdapter("select * from Book", con); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { dataGridView1.DataSource = ds.Tables[0]; } else { button2.Enabled = false; }[/CODE] Now, when the user … |
| | How to edit the datagridview column if it was populated using a dataset? I would like to edit the column header text and width. |
| | I'm learning C# on my own (I know C, Pascal, and about 8 proprietary languages) ... I'm stuck with VS2005 Pro (no budget) so I can't upgrade and I can't use Linq. I'm using Access just for simplicity at this point. What I'm trying to do, is what I've done …  |
| | hi i m trying a code to execute in order to generate a xml file at runtime. it execute well. but the xml file gives a error as The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the … |
| | hi Frd., i have done web page which will add values to the gridview once we select the add button it will open the popup after entering the pop-up it should display values in parent page once we return... But its not displaying just have look guys and solve the … |
| | I have a grid in dataset as following UserPatientStatusID RelevantPeriod TotalCount ProviderSpecialtyServiceName a OUT November2008 1 Not Available a ER September2008 1986 Not Available a ER April2009 1837 Not Available a ER December2009 2367 Not Available a ER August2008 1908 Not Available b ER February2009 1598 Not Available b ER … |
| | Good day folks... This may seem like an odd question and I apologize in advance for the limited information to work with in this case but I'll do what I can to give the needed info... My website [url]http://www.bariby-quance.com[/url] has a journal/blog component that I built within it that, on … |
| | i have this web service and a web form. what happens in the application is my web service returns a dataset and im binding that data set in to a data grid every thing is working when im using it with a win form but with the web form its …  |
| | Hello, my code is below: [CODE] private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'sampleDataSet.contact_Query' table. You can move, or remove it, as needed. //this.contact_QueryTableAdapter.Fill(this.sampleDataSet.contact_Query); OleDbConnection aConnection = new OleDbConnection(dbconnection); OleDbCommand aCommand = new OleDbCommand("select id, name, mobile_num, date_created from contact … |
| | Private Sub btnOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOk.Click If txtuser.Text = "" Then MsgBox("Please Enter a Username or Password, DOnt leave it blank", MsgBoxStyle.Exclamation, "Access Error") ElseIf txtPass.Text = "" Then MsgBox("Please Enter a Username or Password, DOnt leave it blank", MsgBoxStyle.Exclamation, "Access Error") Else End … |
| | Hello, I had start a thread for how to attach a database on our program. I was really thankful to daniweb. I have create project on windows application (C#) back end is SQL server2005 I have dettach my database from SQL servr2005 and attach database in Visual Studio 2008 But … |
| | Friends , I am working with [B]windows application with C#[/B].As i am new to crystal reports am having a doubt. Iam displaying the report fom dataset by passing two parametes. After passing these two parametes i am binding the data into a dataset. The code is given below Dataset ds1=new … |
| | Is it allowed? What I mean is, if I have two queries? Like I need to read a dataset to populate a gridview and other than gridview, in one form. |
| | hello there... acctually i m creating a desktop application in vb.net so on the data insertaton page i had got an error that is "the ConnectionString property not initilized".. so i m posting all my code here... kindly help me.. [code] Public Class Registration Private Sub Button1_Click(ByVal sender As System.Object, … |
| | SCENARIO 1 : I have 3 projects in my solution: 1) Web Project (Presentation Layer) 2) Class Library Project (Business Logic) 3) Class Library Project (Data Access Layer) Following are the dependencies among these 3 projects: 1->2->3 (It means I have referenced PL in BL and BL in DAL. In … |
 | [CODE]SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Data Source = kumar\\SQLEXPRESS; Initial Catalog = phonebook; Integrated Security = TRUE"; connection.Open(); SqlCommand cmd = new SqlCommand("Select * From contacts", connection); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds, "contacts"); comboBox1.DataSource = ds.Tables["contacts"]; comboBox1.ValueMember = "phone"; comboBox1.DisplayMember = "name"; … |
| | I'm calling a GUID with a system function and trying to insert it into a database as a primary key. i'm using vb 2010 .net framework with sqlce server making my datatables. the column is AutoNumber which i set up to be a uniqueidentifier. the length is not adjustable and … |
| | Hi I need to know how to keep data in a gridview after postback. I am using sqlDataAdapter with DataSet to fill the gridview. But if you want to go to the second page of the gridview list it loses the data. Would it be best to create a Session … |
| | Hi All Experts, Actually I am VB.Net Windows Application Developer Now i am going an ASP.Net Application. So, the Problem is that in Windows Application i Code this Project like given Below Actually i am Using SQL Server as DataBase and Store Procedure as Query. Becuase i had tried to …  |
| | Is there a problem with my code? i'm trying to refresh a few form checkboxes based on text typed into machinetxt.text with what is currently stored in the database. i put this into the refresh button click event. here is my code: [CODE]Private Sub machinerefreshbutton_click(ByVal sender As System.Object, ByVal e … |
| | I have been using the code below to edit SQL database fields from the data stored in a dataset. Problem is I have to repeat this long code for each database field to be edited....I find this very tiring...IS THERE A SHORTER WAY OF EDITING SQL Database FIELDS. (Am using … |
| | I have got problem in updating the access database. THIS IS MY CODE // [code] Dim con As New OleDb.OleDbConnection Dim spl As String Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter con.ConnectionString = "PROVIDER= Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Malai\Documents\database31.mdb" con.Open() spl = "select * from REMAINDERDETAILS" da = New OleDb.OleDbDataAdapter(spl, …  |
| | I have a spreadsheet (roughly 200x200 in size) that is a matrix of 0's and 1's that define rules. These rules cannot be expressed in procedural logic because they need to be easily accessible for change by a user for modification. The first row are header value strings and the … |
| | is there a way i can get my datatable to have multiple constraints that are attached to a unique id? an example of what i'm talking about is if i have a unique machine but it's on many lines, can i show that somehow in a datatable? the reason i'm … |
| | Hello All, I am binding a datalist to some table 0 of a dataset from the database. When I check the number of rows in the dataset table 0 it's coming as 129 but when I check the count of the datalist items(using Datalist_Name.Items.Count) inside the datalist item created event … |
 | Hello guys, Can anyone tell me why do I get the error message in the code below? The code fires onPageLoad. What should I change? [CODE]Dim con As New SqlConnection con.ConnectionString = "Data Source=s01.winhost.com;Initial Catalog=DB_10078_kdn;Persist Security Info=True;User ID=xxxxx;Password=******" Dim s As String s = "SELECT * FROM Users WHERE Seller_id … |
| | hi i would like to group rows in categories like that : [URL="http://img199.imageshack.us/img199/9152/capturegww.jpg"]http://img199.imageshack.us/img199/9152/capturegww.jpg[/URL] I konw how to do this with OutlookGroupBy but its not possible to put the same row into severals categories So is there a way to group rows while beeing possible to put the same row into … |
| | I am currently stuck in one part of my application. I have two combo boxes that i am having the users select from. The first combo box is simply bound to a datatable. that is working properly. The second one i need to populate off another datatable after sorting out … |
| | [TEX] [B]PFA the image of the chart that has been created using jfreechart, I need to append another series of data as percentage value. That value will be overlapping with already present percent value, since my interval is 25,000. Intervals are being generated by itself in JFreechart depending on the … |
| | Hi, I'm having problems applying my 'AsciiToString' function to the DataView. I tried this AsciiToString(filter); but that did not work because the text 'publisher LIKE' was in the way. Any idea how I can remove that from my filtered string? Thanks. [code] private void BindRepeater(string term) { DataSet ds = … |
| | I'll preface this by giving a bit of an overview of what I'm trying for here. I'm trying to create a quasi-blog. Something that I can "post" journal type entries directly to a page in my website but without all the luggage that comes with the readily available blog engines … |
The End.