2,634 Topics
 | |
| | Hi. I create the table (MS SQL 2008) IdUrovniaKatHerakl - HierarchyId (not null primary key), KatName nvarchar(max) not null, LevelKat as RowId.GetLevel() KatId - int KatOpisanie nvarchar(max) How can I using C# in Visual Studio 2010 (RC) insert new data into this table? I do this: create DataSet and Create … |
 | I have a dataGridView with 4 columns. 3 of the columns i want to use a combobox. In the datagridview properties from the design view i already set the columns to DataGridViewComboBoxColumns. how do i from the code set the columns values from a dataset? I can get the data … |
| | Help With Add, Delete, Edit and Update Record (with Datatable Method) I Created a Software with OleDb .mdb database previously Using Dataset Method, but I was unable to Connect Datagrid with it on real Basis, I mean when I Clicked Next Record Button it only Moves in TextBoxes (Which were … |
| | [CODE]Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim conn As MySqlConnection conn = New MySqlConnection() Dim test As String Dim commandSQL As MySqlCommand If MsgBox("OK to delete parent: " + DataGridView1.CurrentRow.Cells(0).Value + "?", MsgBoxStyle.OkCancel, "Delete Progress") = MsgBoxResult.Ok Then 'delete it from the dataset test … |
| | Hello, I am working on a seemingly unique file uploading project where files that are dropped onto a server are programmatically uploaded to an ms access db (don’t ask, I’m already pushin for sql) I believe the problem lies in converting the ftp stream to binary and then to the … |
| | hii all i am trying gridview control in my application.code is executing without errors.but i am not getting output means(internet explorer is coming blank). [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.SqlClient; …  |
| | i am having problems editting my record where i basically want to select a record from the datagrid view and change any details where the data is displayed in the text boxes i have put on my form and click edit and have the data updated on to the database … |
| | Hi all, I'm stumped...everything on my page is happening twice. Every method is getting called twice. Any idea why something like this would happen? Markup of page: [CODE] <%@ Page Language="VB" AutoEventWireup="false" CodeFile="MatchActivitiesToReqs.aspx.vb" Inherits="ScoutingWithTheMouse.WebBrowser.Admin_MatchActivitiesToReqs" %> <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> <%@ Register Assembly="Telerik.Web.Design" Namespace="Telerik.Web.Design" TagPrefix="telerik" %> <!DOCTYPE html PUBLIC … |
| | [code] Dim da2 As OleDb.OleDbDataAdapter Dim cols As Integer = Attendance_QueryDataGridView.ColumnCount Dim rows As Integer = Attendance_QueryDataGridView.Rows.Count Dim a(cols) As String Dim dt As New DataTable("Attendance") da2 = New OleDb.OleDbDataAdapter(sql, con) da2.Fill(ProjectDataSet, "Attendance") Dim NewRow As DataRow NewRow = ProjectDataSet.Tables("Attendance").NewRow For z = 0 To cols - 1 a(z) = … |
| | Hi, I used to be able tpo do this but must of forgot something. I am trying to write to Excel sheet and while I have the right references, but something particuarly with the ranges I am doing wrong. Can someone please tell me what I am doing wrong. here … |
| | Today we were talking about using new databound controls in asp.net 2.0, i have been trying to persuade my partner to use these controls but he has been refusing and saying that those controls are not flexible enough. Then he challenged me to populate a dropdownlist in a formview; with … |
| | Hi, i need to search all cells inside a dataviewgrid in VB.net starting with "www" , once i found one cell apply a background color to the complete row and get the next cell with the same String. Part of my code: *********************** [code] Protected Sub Page_Load(ByVal sender As Object, … |
| | I have an following code in this I returned the dataset,but dont no how to use this dataset.Code is running,but not save the record in datase. I had use same code vb.net,it works. Plz help me... ==================================================== [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; … |
| | Hi again, This is a problem I've been struggling with for a while... I have an access 2007 Database where I store several different "Jobs" such as repair job, data recovery job etc. At the min I have a form where the user can view a customer's related jobs either … |
| | I have two tables 1) tblRequests and 2.) tblMainTags. The Fields in tblRequests are Tag_Request_No, Employee_ID , Accepted, Accepted_Date, and Accepted_Time. The Fields in tblMaintags are Tag_Request_No, Tag_ID, Completed, ... The fields 'Accepted' and 'Completed' are set to YES/NO. I want to display in a datagridview the two tables joined … |
| | Hi, I'm current working on a project that allows the user to store customer and job details. At the min, I have a form to view and add customer records, but also edit/delete etc. customer records. I also have a form to add a particular job type. I'm working on … |
| | hey im in the middle of creating a little program that allows a user to search and if in admin mode can delete and add a new record to the database i have my search part working fine i have made the query using the dataset.xsd query builder i used … |
 | I am trying to consume a web service using VS2008. The code below works in VS2005 but not VS2008 I, suspecting it's to do with WCF. Please can someone help me to solve the puzzle? 'Old code that works [CODE] Dim o As New MyWebService.Name Dim pr As New System.Net.WebProxy("100.0.1.1", … |
 | hi i wants to create an dll file for displaying selected data form database by using a gridview. for this iam creating a dll file , in that how to declare gridview1 ,,,, here my codeing is given below ..... please correct errors.... [CODE]Imports System Imports Microsoft.VisualBasic Imports System.Web Namespace … |
| | Hi Guys, For my application i'm trying to generate a datagridview with a comboboxcolumn in it. This combobox I wanna fill with some data from a table in my database. I've figured out how to add items to the combobox but I can't assign a value to it. The combobox … |
| | Hi guys, I will start by saying what I need my project to do! I have two Datagrids, One grid has all the customers garments on it with style number and contact length. The other grid has the users who have garment issued to them. the style number is in … |
| | Hi friends i am trying to bring a data from the field in an checkboxlist. I have successfully done this. Now i am not able to get the values of selected items...........plz help me i am using following code to bind checkboxlist with my database [code] Public Sub getchkbox() Dim …  |
| | i am writing a code where the user will update the staff,but my update command has some problems. i think its the comma's in my command,can somebody help me....... this is my code [code=vbnet] Imports System.Data.OleDb Public Class EditDeleteStaff Dim PwdCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "/Blindz.mdb; … |
| | problem: On the parent page, I have a textfield and an image icon.on clicking the image, a popup (child) should open. The child form has a textbox ,a listbox and a button Go. By default, the listbox should be populated with employee names. When the user types a letter, the … |
| | My assignment is: Your goal is to write a program that sorts a list of 4-letter words using different sorting algorithms and report the fastest method. First your program should prompt the user to indicate the number of words to generate. Your program should then generate a list of random … |
| | |
 | Hey guys, When I bind my data to the GridView, it populates the GridView with the correct number of rows from the database, but the rows are empty. Do you know how I can get the data to appear in these rows? Please look at the attached picture to get … |
| | I have created a dataset and from this I want to retrieve values of a column into a variable. How can I do this? |
| | Hi there, I’m having some trouble to construct a Master-Details form. When I navigate through each record on the master nothing happens on the details. This is so even if there exit a relation between the two tables in the database and in the dataset between the data table. Can … |
| | I want to insert,update,delete,select using dataset in vb.net |
| | hi i am trying to retrieve picture in picture box from db but my code is not working. [B]INSERTING PICTURE IN DATABASE[/B] [CODE] private void saveToolStripMenuItem_Click(object sender, EventArgs e) { button1.Hide(); button2.Hide(); comboBox1.Hide(); textBox1.Show(); foreach (object ab in barcodes) { string sto = ab.ToString(); string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and … |
| | Frankly speaking 100's of programmers read the problems and not 5 percent of them give suggestions or answers Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. when website published not while running through VS 2005 I am trying to export data … |
| | Hi all, I have a VS2008 winform application that connects to an Access 2007 database. However, I have been given the task of converting it so that it connects to SQL Server 2005 instead. (I've already migrated the data + database over without too many problems). The question is... is … |
| | Ok. So in the following section from my XML document, I have two attributes in the Unit tag. The first, [I]type[/I], and the second [I]uname[/I]. I wish to click, say a button that says "Troop" on it, and the program will search through the XML file and find the entries … |
| | Hi Everyone. I am working on an assignment with the following instructions... Enhance the DataSet class so that it can either be used with a Measurer object or for processing Measurable objects. Hint: Supply a default constructor that implements a Measurer that processes Measurable objects. I'm confused about how to … |
| | Hi, I would like to read data from an .asc file with a six-line file header. I just want the data without the header. I'd like to start at the 7th line and go until the end collecting the data into a single list. Each different data file I'm looping …  |
| | Sir, I am using 6 textboxes and three button one for insert data second for update and third for delete the data while inserting and updating the record it generate an error i.e. "Data type mismatch in criteria expression" in the backend i.e in MS Access I am using this … |
| | Can anyone provide a quick solution for INSERT the entire excel sheet into a access database. This is a click button event that just opens a excel sheet in a windows form. What I like to see is some example how to INSERT the same excel data into a access … |
| | Ok, I am trying to to make a double-click action when you click on a cell or row, within a dataGridView. The end goal is to have the single click select the whole row so that when you double-click any cell in the row it will load that row into …  |
| | hi, i m asha bhatt i have create check box list dynamically and i want to do the validation for that its checked or not this is my .aspx.cs 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 … |
| | Hey I usually use RTTI to access object when reading or writing them to a dataset so i have prior knowledge of what the field required Example [CODE] if vPropInfo^.Kind = tkFloat then begin if vField.DataType = ftDateTime then vField.AsDateTime := FloatToDateTime(GetFloatProp (thisObject, vPropInfo)); else vField.AsFloat := GetFloatProp (thisObject, vPropInfo)); … |
| | i can't save my data into access using vb.net [code] Dim SQL As String DB.Open() Dim Ad As New OleDbDataAdapter("Select * From candidate", DB) Dim Check_dataset As DataSet Check_dataset = New DataSet("check") Ad.Fill(Check_dataset, "check") If Check_dataset.Tables("Check").Rows.Count <> 0 Then MsgBox("Certificate already exist.!!", MsgBoxStyle.Information, "") DB.Close() Exit Sub End If SQL … |
| | Hi, I have a project developed in VB.NET 1.1 (using VS 2003). The project has forms developed using the DataForm wizard (Connecting to Access Database, having a dataset and couple of adapter as automatically generated through the wizard - See attached screenprint "Original Form In VS 2003.PNG"). I converted the … |
| | hi guys i have develope a database based system recently but its shows a error as in title do anyone can help me???? its realy urgent guys here is my code : [code] Imports System.Data Public Class Form2 Dim inc As Integer Dim maxrows As Integer Dim con As New … |
| | I NEED HELP WITH THIS BUTTON IVE ATTACHED THE FORM AND CODE ERROR. [code] public partial class Client : Form { public Client() { InitializeComponent(); } private void clientsBindingNavigatorSaveItem_Click(object sender, EventArgs e) { this.Validate(); this.clientsBindingSource.EndEdit(); this.clientsTableAdapter.Update(this.dataSet.clients); } private void Client_Load(object sender, EventArgs e) { // TODO: This line of code … |
| | Hi, I am Asha Bhatt. I am making simple form in asp.net and validation in java script. we this is my .aspx.cs code [code] using System.Data.SqlClient; public partial class InterviewSet : System.Web.UI.Page { string scon = "Data Source=RBWORKSTATION2\\SQLEXPRESS;Initial Catalog=onlineexamdb;Integrated Security=True;MultipleActiveResultSets=true"; //SqlDataAdapter da; SqlCommand cmd; // DataSet ds; SqlDataReader readsid; public … |
| | hi can anyone help me with this code that ive created for a login form, im having trouble with the username and password, ive highlighted the part that's giving me a problem. Error Message: The name 'inputName' does not exist in the current context : The name 'inputPass' does not … |
| | I have a process that does a lot of data manipulation and then prints a simple report directly to a printer. The overall priority is speed. Tens of thousands of records need to be scanned & processed individually so moving thru them quickly as possible is the goal. Pseudo code … |
| | I have a form developed using the Dataform wizard (VS 2003). The Form shows Master-Detail data. The details are showen in a Datagrid. The form automatically loads the data in the Form_load event. Now I want to store the data from the datagrid to a datatable. I am using following … |
| | Hi Experts, I use Visual Studio 2005. I want to retreive data into textboxes providing inputs at runtime. I used the following code.It works when if i provide input at design time but while providing the input at run time the following error message gets displayed. "Syntax error converting the … |
The End.