2,634 Topics
 | |
| | I am currently having a few issues saving new information to a dataset. I could update the set, but on exiting and reopening the data all updates were gone. I found a few tips online but now get error messages when running the update command. Any help would be greatly … |
| | i am new with vb and this is my code that i work with.. there are errors in my code to view data from ms access into data grid.. can anyone help me to solve this problem? thanks... Imports System.Data.OleDb Public Class frmView Inherits System.Windows.Forms.Form Dim DB As OleDb.OleDbConnection Dim … |
| | Hi; I have a question regarding my curent use of datasets and classes. I currently have a class with public properties of connectionstring sqlcommand Im setting the 2 properties from my main form and then calling a public sub within the class, this sub reads the connectionstring, connects to my … |
| | HI, in my project, i have a table 'Orders' with orders submitted, where some have already completed and others are pending,,, The status of the order is denoted by a status ('completed' / 'pending') My problem is this,, I need to display the orders separately in two different sections in …  |
| | Hi, I need a very urgent help. My requirements is, I need to display my data in a datagriedview on monthly basis only. I have done the retrieving of the data from sql server to the datagriedview. But how do i show it only on monthly basis? Regards, Malini Imports … |
| | Having found the following post on datareaders [URL="http://www.daniweb.com/forums/thread278415.html"]Topic Posted On DaniWeb[/URL] i have managed to successfully create a datareader in a class that updates a listbox on the calling form with entries retrieved from a SQL server database. I was wondering if it is possible to achieve the same thing … |
| | I need a vb code as below This is my login page [ATTACH]16718[/ATTACH] This is my login page code Private Sub StudentLoginButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StudentLoginButton.Click Dim connection As New OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0;Data Source = ../Data/Student.accdb;") Dim command As New OleDbCommand("SELECT * FROM Student WHERE … |
| | I am rather new to vb and could use some help. I am using the latest version of vb and am working with a database to add some records. Simply, I would like to have a form that adds a new record into the tblContact table then enter a few … |
| | My form1 has datagridview, that is populated by a dataset. I want to pass the selected value of the datagridview to my other form which is form2. How could I do this? |
| | Hello all, I am currently working on a project that requires an update within an Access Database. There are photo folders, and the user defines the path name via a dialog box. That path name is stored to a string value, and through OleDBReader, the actual name of the photo … |
| | Hi all, I'm developing a graphing application that plots several lines from a protein sequencer that outputs its values in .csv format. I've read the csv into a DataGridView just fine, which is laid out like this: Cycle | A1 | A2 | A3 (all the way up to A12, … |
| | Hello all, I have an xml file with the information below: [CODE] <?xml version="1.0" encoding="utf-8" ?> <ServerNames> <Name>dfwnbonner1</Name> </ServerNames> [/CODE] I am trying to get the Name of a server into a listview. This works fine with the above xml but as soon as I add another server name in … |
| | Hello, i've a server and client code in which the error i'm getting is: on deserialization- but when i checked the byte[] length after serialization that i send they are 1550, and then over the tcpclient when i received the byte[] it was 1448 in length... any help or suggestion … |
| | ello, just wanna ask if u all familiar on how to make a code using VB. Act I already call my database from access to appear on web based app, but to make it COLOUR on a specific box can not be done. Before this, I tried to make it … |
| | Hi all! I have the following situation - three tables in the db : - um_users (id, name) - um_roles (id, description) - um_user_roles (user_id, role_id) I load into a data set two datatables : the "users" one, and another one build on the other two, like this : [code=c#] … |
 | Hi guys, I am using this code to update a record after searching but it gives me error here is my code please please help [CODE] Dim con As New SqlClient.SqlConnection Dim strCon As String = "Data Source=ITS;Initial Catalog=Payment;Integrated Security=True" Dim strCommand As String = "SELECT * FROM CustomerInformation WHERE … |
| | .Hello guys! I would like to ask for some help regarding one of my class projects. Here i have two classes named AddBook.cs and the other is ListCommand.cs, what i want to do is to transfer certain codes from AddBook to ListCommand so that whenever i want to use the …  |
| | I want to populate a drop down list fetching data from database along with a "select" listitem at the top of the srop down list. I am using dropdownlistname.items.add("select","0") and dropdownlistname.items.insert("select","0") and then i am fetching data from database in a dataset and then binding the data into the drop …  |
 | I am Working on Conecting to a database in windos forms C++. I use MVC++. here is a link to my DB file so people can see what i have tried to do in the DB. [URL="http://www.mediafire.com/?yfr52oqcknakk9g"]http://www.mediafire.com/?yfr52oqcknakk9g[/URL] you need access to see this. i have finaly figured out how to … |
| | I don’t have a problem, but sometimes I just love the way this system works. I got the message {"Cannot convert object of type 'System.Int64' to object of type 'System.Data.SqlTypes.SqlInt32'."} {System.Data.DataException} This was the command System.Data.DataRow dr_Test0 = this.XML_DataSet.Tables[0].NewRow(); I also love how they obfuscate code. Finding the designer code: …  |
| | Hello Everyone I have been looking on the net and I found a few things but I am a bit think :P. I need more of a walkthrough kind of things. I am currently making a programe for a game and I need to access a database that has information. … |
| | Hi, I have a database linked to my VB.NET project using the data source wizard. I've created a log in form using a table in access that has the details required to log in. The code is: [CODE]Imports System.Data Public Class Form1 Dim conn As OleDb.OleDbConnection Dim strSQL As String … |
| | Hi everyone , i try to validate a [string ID] when user input it in a textBox(C#)for searching datarows in database , but it does not send a message "False Input" if i input a wrong string ID which is different from database . protected void button_search(object sender, EventArgs e) … |
| | Dear all, I have something very weird, never experienced it before with c# express edition - i have a piece of selection query that selects all the records within a specific month. - this query works very fine in msaccess, but doesnt work in the run time in c#. so …  |
| | .NET4.0 / VS 2010 The treeView never populates past Jobs. I have a SQL table with the following: Node NodeName ParentNode 0 Jobs 0 1 Child1 0 2 Child2 1 3 Child3 1 4 Child4 3 5 Child5 4 6 Child6 4 private void FillTree() { con = new System.Data.SqlClient.SqlConnection(); … |
| | The software developed should extract the details of an audio CD ( like album name, artist, genre, year released) and then transfer them to a database. I am using an access database. so far i hv been able to get the attributes except the year. Also how do I prevent … |
| | Hi all, Have been working with datagridviews with datasets, bindingsources, comboboxes, etc. I was having a problem that prompted me to ask a question. First, the problem that I was having. I created a datagridview that was bound to a dataset and then added code that created columns and some … |
| | Hi all. This is the scenario that i have right now. i have a stored procedure created in MS SQL 2000 and is linked to my C# program. The stored procedure contains four select statements (which means it will return 4 tables). In my program, I have four datagrids and … |
| | Someone please help me before I smash my computer. Every time I try to update a database using my data adapters update method I get the following error.....[B]Object variable or With block variable not set.[/B] I can't for the life of me figure out why this is happening. Here's the … |
| | Hello sir, I have add one listbox in my code. i'm assigning data to the list box at runtime from DataSet. The Value member of the ListBox is EmployeeID and Display member of the ListBox is EmployeeName. [B][U]User Can Select Multiple EmployeeNames at Run time [/U][/B]. Now I want to … |
| | This is my first attempt at a report in VB.net As a simple start I have form1 with a button to call the report I defined the Dataset for the report using a stored procedure with no parameters although idealy the next stage would be a parameter in the stored … |
| | hello i have project for billing and codeing. i work in team, when i start create database i totally forget about naming convention and i choose my name. now i need to change that database name according to my team member's database name. should i able to change my database … |
| | Hi all, I'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held … |
| | Dear all, let me explain how my datagrid work. The datagrid have 10 columns and 21 rows. The datagrid value will be updated every 5 minutes. Actually what I want is to compare the value before 10minutes with the current value which show in the datagrid. The value that I … |
| | hey can u help me out with the below problem The problem i that when i click on country i should be able to select the corresponding states...i have done this in asp.net and it works fine but here when i try to select the country here nothing happens and … |
| | Hello, I'm trying to create an app where the user can search the database using different controls. For example let's say the user can search by date (calendar control), country (DropDownList), states (DropDownList) and cities (DropDownList). So far I have the DropDown controls working. The user selects whatever they want … |
| | im trying to open a document...but every time i get a dialoge box asking if i want to pen,save or cancel.i just want to open the document.can someone tell me wot im doing wrong?here's my code [code] if (objView.extension == ".pdf" || objView.extension == ".xls" || objView.extension == ".xlsx" || … |
| | 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.SqlClient; public partial class userreg : System.Web.UI.Page { SqlConnection con; protected void Page_Load(object sender, EventArgs e) { } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { … |
| | Im having a little bit of trouble with an update statement. if any one could take a look at it and help me with what im doing wrong that would be great. [code=c] private void button6_Click(object sender, EventArgs e) // Button6 is OK { ///////If Null///// if ((textBox1.Text.Length == 0) … |
| | im trying to open a document...but every time i get a dialoge box asking if i want to pen,save or cancel.i just want to open the document.can someone tell me wot im doing wrong?here's my code [code] if (objView.extension == ".pdf" || objView.extension == ".xls" || objView.extension == ".xlsx" || … |
| | Hello everyone, I am a beginner to VB .Net. I am making a project to create an OleDb connection using Visual Studio 2008. I did the same thing in VB .Net but unable to do the same in Visual Studio 2008. Can any one help me with the step by … |
| | How can I connect to a SQL server(not SQL Compact Edition)Database from my Smart device. I am a bit stuck on this because the connection string does not seem to work it gives me a (Null reference error) I checked the SQLcommand text and that was working properly as well … |
| | Hello All, I am trying to add data from a dataset to an access table(.mdb). I am getting this error when I try to insert the values in the table. This is the code [code]DataSet ds = new DataSet(); Console.Write("The NAME IS: " + FileName.Text.ToString()); ds.ReadXml("C:\\Dallas_Test\\Offense_7_1_2010\\" + FileName.Text.ToString()); ADOX.Catalog cat …  |
| | Hi I am very new to C#. Below is the program which i am trying. { string connstring = "Data Source = .\\SQLEXPRESS;Initial Catalog = SAMP; Integrated Security = True"; SqlConnection conn = new SqlConnection(connstring); SqlCommand comm = new SqlCommand(); comm.Connection = conn; SqlDataAdapter myadapter = new SqlDataAdapter(comm); DataSet myset … |
| | I am learning VB and am working on a tutorial on databases. The recordset is a disconnected set. I am getting a concurrency exception. I might have 3 records. I delete all 3. Then I add a record, it adds it. Then I attempt to delete it and it fails. … |
| | I have a datagridview generated by a dataset. I'm new to windows form, how to do this? |
| | How to update database table using commandbuilder without having Primary Key. We Tried this Attempt; [CODE]obj.con = obj.Class_DBConnection(); OracleCommand cmd = new OracleCommand(); string fromsrvno = "000000067334"; string tosrvno = "000000067350"; qryStr = "select distinct * from test_m_srvdetail where SDBM_SERVICE_NO between'" + fromsrvno + "' and '" + tosrvno + … |
| | [COLOR="Green"]handles clouse require a withevent variable defined in containing type or one of its base type[/COLOR] [U]i got this error in the following code[/U] Imports System.Data Imports System.Data.SqlClient Imports System.Text Partial Class _Default Inherits System.Web.UI.Page Protected Sub submit2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit2.Click Dim i As … |
| | Hi guys i'm using ASP.net ans SQL server 2005 with stored procedure to do simple search from a table in database.Plz help me out The error i get Function or procedure expects @searchKey which was not supplied. protected void btnSearch_Click(object sender, EventArgs e) { string constring = ConfigurationManager.AppSettings.Get("con").ToString(); SqlConnection conn … |
| | I just downloaded and installed C sharp for 2010 The connection to the database via the DataAdapter and then to the DataSet does not work. I am trying to tie the db to the textboxs on the form and then navigate the db with buttons like next prev etc. [CODE] … |
The End.