No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
37 Posted Topics
 | Hi Guys, If you have a Text Box which you are putting in the Decimal Places such as "15.50". Then Submitting this to a Access Database then on re-fresh the data shows in the grid view as "15.5". Where abouts should this be modified so that it shows Decimal Places? … |
| | Hi Guys, I hope you can help me out... I have a slight issue in where the 'Search Box' Code I currently have seems to sift through the Populated Data Grid View fine. However, when selecting an Account that has been filtered by the use off the 'Search Box' it … |
| | Hi Guys, Hope you can help. (Bit of a N00b still).. I've written an Functioning Program (Good start!) However, I was wondering if there is a way for the data that is being shown currently in the Grid view to be shown with 'Decimal Places? The Data is Being pulled …  |
| | Hi Guys... looking for a quick answer on excel Formula.. Anyone know why my text "Please Chase" is not showing up? =IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase")  |
| | Hi Guys, is there a Code snippet which allows me to check if a certian ADO Connection has been setup on a clients Local machine and if not then disable certian Radio buttons? The reason I ask is I have a 'Read-Only' Connection to a DB (Don't ask.. that's all … |
| | Hi Guys, OK, i've been through nearly all the properties possible in VS2010 to try and find how to do this most basic of tasks. Look at Screenshot 25... This is how it shows at the moment. Now look at Screenshot 26... This is How I WANT it too look …  |
| | Hi Guys, I have a Dataset which has been populated correctly now (after a bit of a blonde moment earlier). I've decided to go for a ComboBox Drop-Down option which currently is showing the "companyname" Column of the DataSet. However, How do I go about Getting Text boxes to To … |
| | Hi Guys... Putting together a Tiny little app which shows VPN Details for use 'In-House' but for some strange reason my DataSet won't fill? Can anyone spot the mistake? :S private void Form1_Load(object sender, EventArgs e) { //XML Load of Document. This loads the XML Document and the value of … |
| | Good morning Guys, I've got this code currently running: private void button1_Click(object sender, EventArgs e) { SqlDataSourceEnumerator sdse = SqlDataSourceEnumerator.Instance; DataTable table = sdse.GetDataSources(); foreach (DataRow row in table.Rows) { instanceCombobox.Items.Add(row["ServerName"].ToString() + "\\" + row["InstanceName"].ToString()); } Which gives me the Instance and Name of the SQL Server over the Network. …  |
| | Hi guys... I have a radio button that one checked will connect to an ADO Connection. The following code being used is: private void radioButton3_CheckedChanged(object sender, EventArgs e) { //Fields Disabled until a new Account is created.// txtAccRef.Enabled = false; txtAccName.Enabled = false; txtAccAddr1.Enabled = false; txtAccAddr2.Enabled = false; txtAccTown.Enabled … |
| | Hi Guys.. Can any experts in Excel/C# Help me with this one? I think I'm nearly there. Currently I have a DGV on a windows form which pulls data from a Datasource. I want to export the findings to and Excel report template. I've managed to export the data into … |
| | Hi Guys, Is there a best practise when having an ADO connection to speed up the process? Currently the method I am using below works fine but it's a little slow in getting the data. Is there any hints, tips or tricks I can utilise to speed this up? //Opens … |
| | Morning Guys.. Have a Monday Morning Blank out here! I have the following Debug code setup: //XML Load of Document. This loads the XML Document and the value of a Single Node then inputs this to a text box// XmlDocument doc = new XmlDocument(); doc.Load("C:\\twDB.xml"); XmlNode node = doc.SelectSingleNode("/DataBases/DataBase/Connection"); this.textBox1.Text … |
| | Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there … |
| | Hi Guys.. Hoping you can help here.. I'm dabbling with Linq as I'm wanting to pass a Node Value from the XML file into the Connection String. Currently my Code seems to be working and holding the Value in the System.(Code Below:)(Screenshot attached also) XDocument testXML = XDocument.Load("C:\\twDB.xml"); var DataBases … |
| | Hi guys, I've been cracking on with this project for a few days now and had lots of useful pointers to help along the way. I've now hit a little snag where I think I have written the correct update Statement but It seems to error at the last point. …  |
| | Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions … |
| | Hi Guys, Right... I've managed to run select statements with associated Joins to show the data I want in DGV's which is great. Seems to be working fine. I'm not to the point where I need to be able to Insert, Update & Delete Rows in my Database. I am … |
| | Hi again guys... I have a little but of an issue with a select statement I cannot seem to fathem out. Below is the code: else if (radioButton3.Checked == true) ; { //Looks at the row Selected in the GridView and then takes the Account Number and Stores in a … |
| | Hi Guys, Have a random problem as to why my headers are not being shown properly in the form? Possibly a simple anwser but can't see the wood for the tree's at the moment and another pair of eyes is always great. Code below: private void radioButton1_Click(object sender, EventArgs e) … |
| | Hi Guys, I've just picked up an old projcet I was working on (about 6 months ago) and trying to get my head around my own messy N00b code. I've managed to get the grid views working with links back to the tables and showing data in the correct places. …  |
| | Hi Guys... I've had some great help from the members in Dani Web so thanks for all the support so far. Now My first ever credible application is working I would like to try and setup some type of Licencing for it. I've come across many tutorials in regards to … |
| | Hi Guys, Currently I have a form that load an XML file and populates Text Boxes with certian Values from that XML. I also have an 'Admin' form which accept new values. What I am wanting to do is the following: When the Admin screen is loaded from a button … |
| | Hi Guys, I've been working on a little something where details get put into an XML File and then squirted into another form which has been working fine. I've now added another section to the XML file to hold the Company Name and it gets written to the XML without … |
| | Hi Guys, I'm quickl writing a little application which sends an email via SMTP and has the option to add a attachment. This is working fine however, When I went to send a email without attaching a file the Error Message I get is the following **"The Parameter 'fileName' cannot … |
| | Hi guys, Needing some help here please. I have a 'Save button' setup on my form which seems to be working perfectly. It allows vales to be taken from text boxes and then presented on a datagrid view and also saved to the underlying databse. **The Code for this save … |
| | Hi Guys.. I've found a little tutorial which seems to show exactly what I have been trying to do which seems to work upto a certian extent. The code I am using is the following: **Code:** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; … |
| | Hi Guys - newbie here.. I have been working with OLEDB connection for the past few weeks and now have this connection in ADO and i'm not sure how to proceed. **The Connection information is the following:** private ADODB.Connection adoConn = new ADODB.Connection(); private ADODB.Recordset adoRS = new ADODB.Recordset(); and … |
| | Hi Guys, I have a form with a DGV and some text boxes.. I am trying to get the program to update the rows shown on the DGV by using the values in the text boxes. Below is my code so far: private void btnOrderEdit_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbCommandBuilder … |
| | Hi Guys, **<-- Newbie Here!** I seem to have an issue with an INSERT INTO statement when trying to add some textbox data into a DataSet and then update the backend table called 'cashOrders' in a Access Databse. The Following code is being run from the 'Save Button' private void … |
| | Hi Guys... I seem to be having an issue when trying to create a new row in a Dataset. Below is the following Connection Details to the Access DB. private void radioButton3_CheckedChanged(object sender, EventArgs e) { cashCustom.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Orders.mdb"; cashCustomerDS = new DataSet(); cashcTable = new DataTable(); cashCustomerDS.Tables.Add(cashcTable); cashCustom.Open(); … |
| | Hi guys, I hope someone can help. I have a list view being populated by a Table (cashCustomers) in an Access DB which has customers Information. * CashAccRef * CashName * CashAddress1 * CashAddress2 * CashTown * CashAddress3 * CashAddress4 * CashAddress5 and the following Orders table (cashOrders) * ID … |
| | Hi Guys, I'm currently working on a small item that I hope you will be able to help with. I have used an example Code to get connected to 'Sage Line 50' data and it seems to work correct. Currently it populates the Combo Box with the Database Scheme and … |
| | Hi guys, Currently I have a list view which is populated from a table in a Access database. It currently shows 3 columns of data which is fine. When I click on the item It populates the left hand side whith is full off text boxes such as 'Name', 'Address … |
| | Hi again guys... Right, Having issue with a ADODB connection as I have never used one before. Currently trying to read files out of a folder using the ODBC connection that comes with the Software I want to extract data from. I have managed to get the connection to the … |
| | Hi guys, I have an issue with the code I've written in C# where the listview will connect to the database without a problem but it will only populate the 1st row of the table BUT.... it will duplicate it for the exact amount of records I am expecting to … |
| | Hi guys, I'm new the this forum where I'm hoping to get some friendly advice for a bit-of-a-newbie C# programmer. I've been through 2 differnt beginners courses on the code so now i'm ready to get my hands in the code! I'm currently having a problem with loading all data … |
The End.