2,634 Topics
 | |
| | dear all I have the following sample code which i am trying to use to connect to sql*plus in visual studio 2010 but i keep getting the error message connection string is not well-formed. see my code below [CODE] protected void Button1_Click(object sender, EventArgs e) { string oradb = "User … |
| | I want to perform calculation in gridview :NetAmount=(ServiceAmount*Quantity)*Discount I had written code in rowdatabound but it is not working,i amnew to programming help me solve this proble i would appreciate if some one share ther knowledge my Axpx code is: <asp:GridView ID="GridView1" runat="server" Height="156px" Width="618px" AutoGenerateColumns="False" BorderWidth="1px" HorizontalAlign="Justify" onrowdatabound="GridView1_RowDataBound" BackColor="LightGoldenrodYellow" … |
| | I am designing a project in asp.net. I one page i have created a gridview having template field as checkbox. When I select any row in gridview using checkbox,that checked row goes to a new gridview on button click. Now what i want to do is to save that new … |
| | Hi all, I have a datagridview in which I add programatically a combobox column with its datasource set to a datatable I fill from a query, then I populate manually (for good reasons) the DGV, but just when I try to add the first row, this error shows up: Fielld … |
| | Hi again !! I am making a widows application wherein i have a form containing two datagridviews.. The first one( named dgv1) consists of all the data from the database and a checkbox column.. While the user selects the rows using checkbox, the data are displayed in adjoining datagridview(named dgv3).. … |
| | Hi, Myself Vishwasdeep. I am doing a project work on asp.net. I am getting an error/exception on my code. [CODE] using System; using System.Collections; using System.Configuration; using System.Data; 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; using System.Data.Sql; using System.Data.SqlClient; namespace WebApplication2 … |
| | Hello, I'm a newbie working with vbnet but i'm trying to create a project were I enter a name in a textbox and save it to a access database. I'm trying to create the OledbConnection but i'm getting this error: "oleDbException was unhandled" this is the code i'm using: [CODE]Private … |
 | I'm writing an application to update a database with student records. I've used this particular code before, but with just a single column, but i added multiple columns to this one. when i call the sub to save the records it gives me this exception: syntax error in INSERT INTO …  |
| | Hello, I have three C# winforms 1) ReportParameterFrom contains a DateTimePicker 2) ShowReportForm contains MS reportViewer 3) The report itself. The report is filled from a DataSet,one of the dataset fields is a date. This field is invisible in the report, the report is about Daily sales. What I want … |
 | Hi there, Im new to vb and i am using visual basic express 2010. i have put together a database and can do quite a lot with the app i have created. i am not very familiar with detailed programming so i have created my update query thru the dataset … |
 | Hello, [[All sample links may not work after the thread is solved, I will keep them up as long as I can though]] I'm trying to make a graph work, which it does, not when CSS is present on a page though... In my setup I use graph.php to create … |
| | Please Help me to solve that i just wana to search Data feilds from SQL Database and to show on different TExtboxes of VB.net forms..... [CODE] Dim Bio As New DataSet Dim Marks As New DataSet Dim Disp As New SqlDataAdapter Dim Dispp As New SqlDataAdapter Dim Bind As New … |
| | Hi All, Been trying to use the BindingSource.Filter on my program and everytime I fire it nothing is happening i.e. the text boxes I have setup and are not populated even though I can navigate through all the records inthe dataset using the respective navigation buttons... Code.. Private Sub ButFind_Click(ByVal … |
| | Hello to all, sorry if my english is not so good, I will try to explain the problem. I need to copy all data from a Table of a Acces mdb (connected with OleDB) to a Table of a MySql DB (connected with ODBC) I made a working solution, but … |
| | Hi, i have problem on inserting multiple images. i found in internet, many examples are regarding insert only one image. but now i want it to have multiple uploaded images that we can delete and view it first before we save it on database. how to store the images uploaded? … |
| | Here is my code,problem is i'm able to login even with wrong username and password. Can anybody tell wat is the mistake in my code.. [CODE] using System; using System.Configuration; using System.Data; 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; using MySql.Data.MySqlClient; …  |
| | I am having a hard time figuring out how to delete a row from the datagridview using a datasource that will also delete the row in SQL Database. [CODE] public partial class Form1 : Form { const String sStr = "Server= ************;Database=***; Integrated Security=SSPI"; SqlConnection sConn; SqlDataAdapter daCourse; DataSet ds; …  |
 | visual studio 2010 (vb.net window forms) access 2010 database multiple forms tab controls (2 tabs) groupboxes I have a BindingSource bound to a single row of a dataset.table The question is how to call and check the information of a single cell the cells are bound to textbox.text however on … |
| | I m running the Sql job as background thread and at the same time showing data from sysjobhistory table in gridview. While debugging the code its shows the data in old and new rows affected from table in gridview but when i put the application in debug or release mode … |
| | hi, i am new in C# , i have 2 text boxes in which the user will enter the department and name, 1- I want the application to retrict the user to only enter letters not numbers . This is my following code: [CODE] public string Directorates_Insert(string Directorate_Name, string Directorate_Head) … |
| | Hello.. I am developing a windows app and i have a form in which i have 2 datagridviews.. dgv1 is the main gridview with checkbox column and when the user checks the box, that row should be visible in dgv3 (other datagridview).. The code i used is : [CODE] Imports … |
| | Hello everyone, Please someone help me out from this problem. I have an datagridview which is bound to an datasource which contains two tables CompDetails and Orders. Now when i click on button and if texbox.text=1 data will be displayed fine, if i click the button for second time the … |
 | i really don't know how to slove the erro in my program.. ..can you please help me?? thank you in advance ,.. [CODE]Public Class Form1 Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Dim da As New OleDb.OleDbDataAdapter Dim ds As New DataSet Dim sql As String Dim … |
| | Having a problem with my sql, I am creating program for my ALevel and when I go to create a logins page I wish to have a button that will allow me to create a new login and save it to my database. when I click the button I keep …  |
| | My problem is let suppose my dataset is {A,B,C,D,E} and suppose my partition size is (2,3) Result would be (A,B) (C,D,E) (A,C) (B,D,E) (A,D) (C,B,E) (A,E) (B,C,D) (B,C) (A,D,E) (B,D) (A,C,E) (B,E) (A,C,D) (C,D) (A,B,E) (C,E) (A,B,D) (D,E) (A,B,C) I need to print all the possible combinations for the partition …  |
| | I have an xml file document and I am trying to display the xml contents in a datagridview. Can I please get some help with this? what am I doing wrong? I had it working when I pull one column at a time [CODE] Dim gridtable As DataTable = New … |
 | I am exporting data to excel but inserting rows is very slow about 2 seconds per row pls help using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; namespace Dashboard { public partial class Form1 … |
| | I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming from many different pages as a Session("searchtext"), and I'm using a UserControl to send the Session, all pages in … |
| | [code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; using System.Reflection; namespace Dashboard { public partial class Form1 : Form { public OleDbConnection con,con1; public OleDbCommand cmd,cmd1; public OleDbDataReader dr; public OleDbDataAdapter db; public string …  |
| | hi frnds, i m populating a datagridview with two columns i.e checkbox and papername.I m trying to show papercodes(not present in grid but in database ,in the same table where papernames are)in a single textbox with a comma seperator, when i checked papernames accordingly. this is my used code. [CODE] … |
| | Dear All, Pls. help me I have insert data to MS.Access and re-load data to DataGridView, it's always do at LoadAllData() but some time datagridview is not refresh. [CODE]Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\EmployeeDB\EmployeeDB.mdb;User Id=;Password=;" Dim conn … |
| | HI, At the moment I'm facing a problem. I have a datagridview1 in FORM1 and datagridview2 in FORM2. I want to duplicate the data in datagridview1 to datqagridview2 in another form. The code I used is: FORM1: [CODE] OdbcCommand bcCom2 = new OdbcCommand(); bcCom2.CommandText = "" + content + ""; … |
| | Hey.. I have a form consisting of datagridview and two buttons of update and load all.. I have used fillby method to obtain data from database. The query seems to be working fine, except that the data is not shown in the gridview. As in, for the qeury, if the … |
| | The Class has no error, but the test program has a constructor error on line 21. [CODE] /** * DataSet Class * * @version 10/3/11 */ public class DataSet { private int Sum; private double Average; private int Largest; private int Smallest; public DataSet(int Sum,int Largest,int Smallest, double Average) { …  |
| | Hi, I'm using c#2008 DB - oracle11G Below I coded for Single table - [Insert/update/delete] for Single datagridview. [CODE] private void Form1_Load(object sender, EventArgs e) { connectionString = "User Id=tommy;Password=hellotommy;Data Source=oracle_tommy"; cn = new OracleConnection(connectionString); cmd = new OracleCommand("Select id, name, dept, address, active from employee", cn); adapter = new … |
 | Hi everyone; I'm working on a c# service that queries the DB and checks if the right info is available for users. It's an Airline tickets reservation system. I am not sure why my code is breaking after it gets the query and it gives an error about sqlclient.. [CODE] … |
| | Hello everyone this will be my first post. I am happy that there is a forum like this with very supportive people.:) So on topic.. I am a student creating an Inventory System software for my school using VB on VS 2008. I am having trouble saving items from a …  |
| | i want to auto select first list box vale how [CODE]private void check_Click(object sender, EventArgs e) { for (int x = 0; x < listBox1.Items.Count; x++) { // Determine if the item is selected. if(listBox1.GetSelected(x) == true) { // Deselect all items that are selected. listBox2.SetSelected(x,true); } SqlDataAdapter adap = … |
| | Hi dude i am facing a little problem.When i first time implemented auto complete suggestion it work properly but now after one month i use many other field to extend them as auto suggestion all of them are working but give suggestion in a single line.Please any one give me … |
| | I don't know how to solve this problem. I want to create simple project in visual studio 08 in C# windows application which can save update delete data from database. here are the steps i use : open new project right click on solution explorer -add- add new items-service-based-database when … |
| | Hi To All, Once againg I'm in a big problem. I'm using C# 2008 and Access 2007. My DB contain 2 tables Customer and Booking. Both having Relation on CustomerID column. Customer -> CustomerID (PK) and Booking -> CustomerID(FK) Now I want to display the few columns from Customer and … |
| | [CODE] Imports System.IO Imports System.Data.OleDb.OleDbException Public Class Form2 Inherits System.Windows.Forms.Form Dim inc As Integer Dim MaxRows As Integer Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim sql As String Dim username As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) … |
 | Hi I'm working with sql server and ado.net datasets.Is there a way the dataset can be paged to the client for local access without contacting the server.If this is not possible how does one post back to the server from the client say in javascript after client side events like … |
 | I have one access database and one windows form. I have some text field and one picture box. I want to Store some data and image into my database, i have written following code to do the task but it says "Syntax error in Insert into statement". I am pasting …  |
 | Hello:), I am returning to a theatre ticket booking project after about three months and trying to get my head around how to show the prices in a list box (lstTotal). I have three radio buttons three for three ticket types. Adult Full Concession Friend When one of these is … |
| | I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I … |
| | I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I … |
| | Hi all, I am working on a Chart showing the activity per customer for the last 12 months + the current month (I work in a technical support team). Basically, my SQL query is providing me with the right result most of the time. It looks like this: Sep 10 … |
| | Hi, I'm trying to populate an asp:menu from a database on my master page and keep getting the error: Object reference not set to an instance of an object Here's my code on the master page: [CODE] <asp:Label runat="server" ID="errLabel" /> <asp:Menu ID="Categories" runat="server" CssClass="menu" EnableViewState="false" Orientation="Vertical" DataSourceID="categoryListSrc"></asp:Menu> <asp:XmlDataSource ID="categoryListSrc" … |
 | Dear Friends I have a dataset like below. 1 means Straight line with startPointX,startPointY,endPointX,endPointY. ////////////////////////////////////////////////////////////// 1 0.000000 24.600000 -15.500000 28.575000 1 -15.500000 28.575000 -37.700000 28.575000 1 -37.700000 28.575000 -37.700000 36.515000 1 -37.700000 36.515000 -59.920000 36.515000 1 -178.200000 52.000000 -138.200000 52.000000 1 0.000000 24.600000 0.000000 19.000000 1 -125.421613 36.515000 -138.200000 52.000000 … |
The End.