2,634 Topics
 | |
| | I have a Windows application written in vb.NET 2.0. I recently upgraded it to framework 3.5. For some reason it started to change ‘,’ into ‘.’ in numbers and change the date format, on some of the client computers where it is used. But only in this specific application. I'm … |
| | Dear All , The question is simple , but may be It is very simple for me that I can not see it . I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file … |
| | I am using MsAccess DB and Vb.NET 2008. This is a code to check the Database for duplicate entries but m geting an Error. [B]" Fill: SelectCommand.Connection property has not been initialized."[/B] And this points to [B]LINE NO 14[/B]. What could be the cause..? thanks in adv [CODE] Dim con … |
| | hi guys, I am using Column properties in SQL Server 2005. I was all ready assisted with this in SQL and it works fine. Now I need to get it to work in a Visual Basic 2008 Data-Grid. I don’t necessarily need general help with “Add new data source” => … |
| | I successfully populated my listview with an image using a dataset. I used the large icon view for my listview. I can only show a single text for an image using this. [CODE]ListViewItem lvi1 = new ListViewItem(dr["userID"].ToString()); [/CODE] How could I put another text near the image in listview? Subitems … |
| | Hi, i have problem that i cant see data in data base. code has no error. i dont know whats wrong. i m using Visual Studio 2008. [CODE] Imports System.Data.SqlClient Public Class frmpurchase Dim cmd, cmd1, cmd2, cmd3, cmd4 As New SqlClient.SqlCommand Dim adp, adp1, adp2 As New SqlDataAdapter Dim … |
| | what is your more preferred approach for filtering a dataset in a datagridview? dataRow.Filter or Stored Procedure using select command for filtering? tnx pleas help me to decide ..  |
| | I am using Visual Studio .net 2008, which has a Crystal Reports builder. I have gotten to the point of building the report from a view I have setup on my SQL server. Instead of using a table on the server, can I use a table from my DataSet? I … |
| | Hi apologies as I guess this has been covered on a number of occassions, but I am very much new to web devt and am struggling to patch code snippets on google results on similar sounding queries into my own. I have been coding a page, which has an iframe, … |
| | hi guys, I am using Column properties in SQL Server 2005. I was all ready assisted with this in SQL and it works fine. Now I need to get it to work in a Visual Basic 2008 Data-Grid. I don’t necessarily need general help with “Add new data source” => … |
| | hi people! I badly need a help regarding this program.. I want to insert this two data in my database... [CODE] try { OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\lenovo\Desktop\C CONTRUCTS\C CONTRUCTS\CONSTRUCTION.accdb"; conn.Open(); OleDbCommand ccmd1 = new OleDbCommand("INSERT INTO [ORDER_DRIVER]([DELIVERY_NO],[DRIVER_ID],[STATUS])" + "VALUES(" + "'" + textBox1.Text + "'" … |
 | Hi Daniweb, I spend a lot of time googling this problem and found no answer yet. The problem is I added a new column in my table, I have a dataset linked to that table and a source of data of my datagridview. Now, when I'm going to add a …  |
| | Hello, Building on the thread: [url]http://www.daniweb.com/forums/post1491690.html#post1491690[/url] I need to tease out the sums of three values from Rows that meet multiple parameters. Here is a sample of the dataset: id | blkidfp00 | fips | transtech | pop | hu | busfirms 1 | 55001950100100 | 550039 | 10 | … |
| | I made a project in Visual Studio 2008 that is consist of three forms named 'Main Menu', 'First Menu' and 'Second Menu'. My main menu has a datagridview that is being populated by a dataset. [CODE]datagridview.DataSource = ds.Tables[0];[/CODE] My Main Menu form has a button that will show First Menu … |
| | I am able to save an image from a picture box into the database of SQL. I used a byte array and filestream to read the image. [CODE]FileStream fs = new FileStream(imagename, FileMode.Open, FileAccess.Read) byte[] picbyte = new byte[fs.Length] fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length)) fs.Close()[/CODE] For some reason, I can't retrieve the … |
| | Could someone help me with my problem here? I am using C# and working on a project in visual studio 2008 with SQL server express as the database. In visual studio 2008, I have a project and two forms. The first form that is named 'Informations' has a single datagridview … |
| | I have made a system, when use select Model,then the F.Grade dropdownlist will show the F.Grade belong to user select Model. So I put display F.Grade code into Model dropdownlist. But it is very slow when user use down arrow button to find model. This is because when down to … |
| | My form1 has a datagridview that is being populated by a dataset. I need to get the row's values selected on the datagridview to another form, which is form2 that is consist of textboxes. I am quite confused whether to pass the dataset to form2 or use a datareader to …  |
| | I used to fill a listview with dataset that is set to details view. Now, I need to fill the listview with images and by that I believed that I'd set the view to large icons. How to do this? this is how I feel the listview [CODE] foreach (DataRow … |
| | Hi all, i am using visual studio 2008 and trying to add a dynamic image into the crystal report, i dont want to use dataset, how could i assign a URL to the image, and just change the image with the same name (ex: c:\logo.jpg different image than the existing … |
| | In oracle database birthdate store as 01/01/47 but in asp.net i used dataset to fetch this record and i get the bithdate value as 01/01/2047 visiual studio 2008 oracle 11g |
| | I have a main form with datagridview attached to the form. i calling datagridview when the form load, but am getting the 'property access must assign to the property or use it's value. Please help me correct the error. Attached is the form to help analysis the problem. thanks Gyamfi … |
| | object reference not set to an instance of an object I'm develop a C# window form application in VS2008. when run the exe file in PC. It come out message box.(object reference not set to an instance of an object). When I change the connection string to normal style like … |
| | I have two combobox, which is 'names' and 'types' and it's being populated by a dataset. It contains an additional item "-- ALL --" to indicate that all items of a particular field are being shown. I have an SQL select statement to filter the records according to the selected … |
| | There's an error saying that the combobox is already b, inded to a datasource, thus cannot add new items. This is how I populate my combobox [CODE] cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_distinctevent"; cmd.Connection = con; da = new SqlDataAdapter(); da.SelectCommand = cmd; ds = new … |
| | Hey guys, I am trying to write down a code for generating 'ID' automatically and then store it in table. There some errors, i couldn't rectify. This is my code : [CODE] int ctr = 1; int len; DataTable dt = new DataTable(); DataRow dr; DataSet ds = new DataSet(); … |
| | hi im having errors with listview binding navigation specifically in last >> and first << here's my code [CODE] Dim inc As Integer Dim MaxRows As Integer Dim dr As DataRow Dim ds As DataSet Public Sub navigaterecords() txtMed_ID.Text = ListView1.Items(inc).SubItems(0).Text txtMed_name.Text = ListView1.Items(inc).SubItems(1).Text txtfname.Text = ListView1.Items(inc).SubItems(2).Text txtMname.Text = ListView1.Items(inc).SubItems(3).Text … |
| | I binded data to a combobox using a dataset. [CODE] companycb.DisplayMember = "company"; companycb.ValueMember = "visitorVisitID"; companycb.DataSource = ds.Tables["tblVisitorVisit"];[/CODE] I need to remove the duplicate values from the combobox. Is there any other way instead of doing it using an SQL Distinct query? |
| | hi. I was trying to choose data from the combobox then When I choose something.. it will also generate the other data into the textbox. I just wanted to choose a STUD_ID in the combobox and the fname and the lname should show in the textbox. actually.. I just did … |
| | I have a base class kaysonsSPdetails. which is internal and DemoDVD which is public and inherits SPdatabase. [CODE] internal class kaysonsSPdetails { /// <summary> /// This method is used to connect to databse is returns an open connection /// </summary> private System.Data.DataSet connecttodabase() { throw new System.NotImplementedException(); } } public … |
 | [CODE] #define cinGetValue(value,status) \ { \ string inputLine; /* raw user input text*/ \ istringstream convert; /* string converstion variable.*/ \ \ getline(cin,inputLine); /* get a string of data from user input (could be empty) */ \ convert.str(inputLine); /* load 'convert' with user input */ \ convert >> value; /* … |
| | Hi there guys really hoping for some help after searching Google for a stupidly long amount time and coming up blank. I am using Crystal Reports 10, Asp.net 1.1, SQL Server and Visual Studio 2003 with VB. I have an Image field in the database that I need to retrieve … |
 | I don't know how to title this thread, forgive me if it's bad. I'm trying to determine the best way of handling this and I'm getting nervous about it. The basic setup I have is a server system that is run when the application is open (it's not a service, … |
| | Hi all, I'm currently make my final year project program at university, and have been puzzled by this problem for sometime now. The issues I am having is that when I try to update a value in a specific column of a specif row. The program has a paddy and …  |
| | hi all, i have image path name in database and i am fetching it this way. [code] con.Open(); string img= "select imgPath from Tbl_Image where imgId='1'"; SqlCommand cmd = new SqlCommand(img,con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); [/code] i got path name in ds. … |
| | Hello expert, I had a problem in C# datagridview. I want display last month data or ?days only when form load. I know use SQL query. But the problem is at datetime and string. my idea is today date - 30 days. [CODE]private void OT_Load(object sender, EventArgs e) { ConnectionStringSettings … |
| | private void tbNuevo_Click(object sender, EventArgs e) { ... connections up in the Load.... botones("NUEVO"); limpiar(); txtNombre.Focus(); oCC = new OleDbCommandBuilder(dtc); DataSet dst= new DataSet(); dtc.Fill(dst, "contador"); iPosact = dst.Tables["contador"].Rows.Count - 1; DataRow dtr = new DataRow(); [B]dtr = dst.Rows.[iPosact]; //error in this line vUltimo = dtr["regnum"]; // error in this … |
| | I have a datagridview and a status strip on my form. When I click a row or cell, the label from the status strip should change according to it's row number. My datagridview is being generated at run time by a dataset. |
| | Hi guys I'm a newbie, and can't figure out the problem with the following code. I get the error inthe line in Bold. Please help [CODE]private void Form1_Load(object sender, EventArgs e) { con = new SqlConnection(); con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\KAMESH\\Documents\\Visual Studio 2010\\Projects\\bankDBApp\\bankDBApp\\bankAcc.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; con.Open(); MessageBox.Show("Connecting to SQL Database", … |
| | I have a DataSet displaying data on a DataGridView. The current method I am using to filter the grid is as follows: [CODE] foreach (DataGridViewRow row in dgvXML.Rows) { foreach (DataGridViewCell cell in row.Cells) { if (cell.FormattedValue.ToString() != String.Empty) { //Highlight cell if the value from the textbox is found. … |
| | im working on an attendance monitoring system and im having a hard time on saving a picture on my picture box, at the "add employee" section of my program. i want to save the path of the picture on the emphoto field of my database and the actual photo on … |
| | I'm having trouble filling a ComboBox from a dataset. When the program runs, the combobox has the correct number of lines, but they all appear as System.Data.DataRowView Any ideas? [CODE] Dim tblModels As New DataSet1.modelDataTable tblModels = Me.ModelTableAdapter.GetModel Me.cmbModel.DataSource = tblModels [/CODE]  |
| | Hi I've design a datagridview with 6 columns. But i got a code somewhere in internet,the code make my datagridview added with 8 more columns from database. i dont know how to put the data from database into specific columns in the designed datagridview. on database, i have 8 columns, … |
| | Hi people I need some help here. Here is the CODE : [B]for Form1:[/B] [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.SqlClient; namespace practice { public partial class Form1 : Form { Form2 obj; public Form1() { InitializeComponent(); } … |
| | Who can teach me how to make Class to store database location When want to use just call the location. Everytime I will write again the connection. When database location is change, I will change the database location one by one. This is time consuming and difficult to maintain program. … |
| | Hello All, I am writing my self a simple little address book application and I seem to be having some trouble with updating the dataset. I have written the code and I cant see for any reason why it shouldnt work, but during run time, when I delete an entry …  |
| | I'm having difficulty to implement a select query for my database using datagridview to bind to and textbox for searching a particular value in my table. I have this stored procedure [CODE]CREATE PROCEDURE usp_searchvisitor @keyword nvarchar(20) AS SELECT * FROM tblVisitor WHERE lastName = @keyword OR firstName = @keyword OR … |
 | Hi I can successfully parse data from a form in one page to a table in another page, but I'm having problems displaying the data in the same page as the search form. Below I have set up a simple one field search and table in the same page. I … |
| | I'm working on a Windows Form Application in Visual Studio 2010. I have a Database that I am using to pull data to dynamically create checkboxes inside a loop. In between each of these, I'm creating a child loop to create more checkboxes from a sorted DataSet. At the end … |
| | I have below xslt file and want to implement code for altenet color row. I'm implementing below code, but it will color out coloumns and not the rows. I think I'm applying style on <TableCells>...where need to put code..please help..thnx [CODE]<xsl:if test="position() mod 2 = 1"> <BackgroundColor>#e0e0e0</BackgroundColor> </xsl:if> <xsl:if test="position() …  |
The End.