2,634 Topics
 | |
| | i want to show records from other tables but this error occurs [CODE]Sub fillorderdetail() conn.Open() Dim adpt As New SqlDataAdapter("select * from orderdetail", conn) Dim ds As New DataSet adpt.Fill(ds, "orderdetail") DataGridView2.DataSource = ds.Tables("orderdetail") conn.Close() End Sub [/CODE]  |
| | evrytime i add new controls to a form in vb.net the designer regenerates code and asks me to make corrections, so i have to keep on changing the object declarations to global using the 'global' keyword evertime it regenarates code,especialy dataset objects.how can i prevent this? Thanks  |
| | I have a question about h5py. I've read almost all of the tutorials online but I must be missing something. I'm wanting to read data from an h5 file that already exists. Here is the first part of the file as it looks from being h5dump'ed just so you can … |
| | Hi In my program I have a Dataset that populates a Rdlc file and it was working Fine until I Encrypted the Accdb file and now when I run the App I get "Not a valid password" error at this line [CODE]Me.Services_QryTableAdapter.Fill(Me.CFIDataset.Services_qry, RprtID)[/CODE] I have tried Modifying the connection for … |
| | I attempted to set up pagination for the datalist control. However when I click next link the next image doesn't display. Then when I click previous the first image is displayed. Did I miss something in the code? [CODE] <table border="0" width="800" bgColor="#ffffff" height="644"> <tbody> <tr bgColor="#ffffff"> <td height="173" colspan="2" … |
| | Well, My code is working fine I just need a way to reset the DataAdapter1 into 0 (like reset) So if the user hit the button search 2 times to shows up only 1 time the elements of database "product".. If i used the code below and hit 2 times … |
| | Bonjour a tous, i have a very strang proplem it made me mad , i have antyped dataset and simlpy want to update a record by using dataadapter but the aupdate method affect only ONE Item here is the code : [CODE]Dim cb3 As New OleDb.OleDbCommandBuilder(da3) DSBANQUE.Tables("BANQUES").Rows(INC2).Item(0) = BANQREB.Text DSBANQUE.Tables("BANQUES").Rows(INC2).Item(1) … |
| | I use button for by clicking it to delete one row in the DataGridView. This is the code: DataGridView.Rows.RemoveAt(DataGridView.CurrentCell.RowIndex); I use xml file as the source of dataset which is sourcedata of the DataGridView. It makes problems when I [B]delete last row[/B]. What can I do? pls, help |
| | Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset through SQLDataAdapter and Dataset, it is taking around 10 min to get the data on the localhost. And when I am running the same code on the live server it … |
| | Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take … |
| | Hello all I'm Looking for a simple way to populate a Crystal Report from a Dataset. i've seen some options but i cant find one that makes me feel cool about it. also how can i set up the report to display the data? Thanks in advance! |
| | Hello, I have one dataset as one arraylist. In that the columns values are in string as high, low, medium.. so how i display that values as string in c or java? pl reply me  |
 | Hello experts, I never used [B]"Dataset"[/B] in my project. But I know this is used for the set of tables. Can I use this to authenticate from more than one table? Tables in my Database are: Login, Student, Student Details, Fee, Teacher, Teacher Details. I want to use dataset in … |
| | Well something is missing of me (again :P) and I need some help.. I am trying to get files for my database and load it into comboBox. But for some reason I get systax error.. As I mention into other post I am not familliar with VB so please check …  |
| | the given error is that this crdb_adplu.dll is missing or cannot be found in the path specified: file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' i already tried downloading it and adding it to the folder and editing the config file with : <startup useLegacyV2RuntimeActivationPolicy="true"> … |
 | Hi everybody, its Leo again I'm having some problems calculating the values for two diferent fiels of the datatable. it return " [COLOR="Red"]Object reference not set to an instance of an object[/COLOR]" this is How I feed the datatable [CODE] Dim daProd As New SqlDataAdapter Dim conProd As New SqlConnection …  |
| | hi every 1 i am trying to make a search criteria based on last name.i have dragged and dropped customer dataset as details view on my form and booking as gridview(customer id is foreign key in bookings table so now when i scroll through customer i could see the relaive …  |
| | i want to populate a listbox from a sql database and foll is the code i encountered error with: Dim con As SqlConnection Dim cmd As SqlCommand Dim lrd As SqlDataReader Dim dsitemlist As New DataSet con = New SqlConnection("Data Source=DHAVAL-PC\SQLEXPRESS;Initial Catalog=final;Integrated Security=True") con.Open() 'cmd = New SqlCommand("select Stud_RollNo from … |
| | Hi, I've got two tables ina database which I'm trying to update at the same time. I'm using the code below to update: [CODE] Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=KingfisherDB.mdb;") Conn.Open() 'Define data adaptor and fill data sets DA = New OleDbDataAdapter DS = New DataSet Cmd = New OleDbCommand Cmd.Connection … |
| | I start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database.. |
| | Hello friends, hope you guys are dong well. problem again and really looking up to my expert friends here. I'm new and trying to write Edit code in VB.NET. the problem is [B]Select * From Application Where Sl_No='" + txteditno.Text + "'", con) [/B]is not displaying and record although it … |
| | hi every 1. i have a form and i dropped customer dataset as details view on the form and booking dataset as gridview.So now when i insert a record i can scroll through different records and with respect to the customer its shows me related booking aswell. Wat i wanna … |
| | gents please help on the following. I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt. My question is: How can I save this dt … |
| | i am try to systemdate and rem_date compare but error message is "Incorrect Syntax near'='" [CODE] Dim adp As New SqlDataAdapter("select * from reminder", obcon.con) Dim dset As New DataSet adp.Fill(dset) datagridview1.DataSource = dset.Tables(0) obcon.con.Open() Dim cmd As New SqlCommand("select rem_id,rem_hour,rem_min from reminder rem_date=" & Date.Now.Date.ToString & "", obcon.con) MsgBox("select … |
| | Hello! I would like to ask for tips on how to handle database concurrency in a client server application in c#. I am using SQL Server 2008 r2 as my server. I have minimum to zero ideas on how to handle such and would really appreciate any help that you … |
| | My .Net Code [code=c] # connDO.Open(); # SqlCommand comm = new SqlCommand("DOrders.dbo.p_Update", connDO); # comm.CommandType = CommandType.StoredProcedure; # daDirectOrders.UpdateCommand = comm; # # comm.Parameters.Add("@UOrderNumber", SqlDbType.Int, 32, uOrderNumber.ColumnName); # comm.Parameters.Add("@ConfirmationCode", SqlDbType.VarChar, 50, confirmationCode.ColumnName); # comm.Parameters["@ConfirmationCode"].SourceVersion = DataRowVersion.Original; # comm.Parameters.Add("@Carrier", SqlDbType.VarChar, 50, doCarrier.ColumnName); # comm.Parameters.Add("@Tracking", SqlDbType.VarChar, 50, doTracking.ColumnName); # comm.Parameters.Add("@OrderID", SqlDbType.Int, 32, … |
| | hi every 1. i am trying to make a search form with 1 label(surname) and textbox. i have 1 gridview on the form aswell. can you plz provide me any code so that when i type in textbox i should c the result in the gridview. wat i have done … |
| | Hi there I am new to .net and I have put at least 4 hours in to figuring out why i cannot view my results when I run a datagrid in my 2010 visual studio WPF application. Also, it looks like it is only filling one record in the datagrid. … |
| | Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this … |
| | Any commands for creating database using oracle command? as well as creating tables? I have this in creating table but did not work. Having invalid table name error. [CODE] Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class dump Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private … |
| | When I add a NEW row to the datagridview, it for some reason freezes the datagridview. That is, it adds the rows pulled from the database to the grid. But you can't add rows to the datagrid by some a click button event. Nor can you select a row in … |
| | In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that … |
| | Environment: Visual Studio 2010, Windows Forms Application, Oracle Database I am trying to use a parameter in a DataSet.xsd DataTable. The query and parameter work fine in Query Builder but gives an error if I try "Preview Data" or use in my application. Error: An unhandled exception of type 'System.Data.OleDb.OleDbException' … |
| | using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data.Common; using System.Data; using System.Data.SqlClient; namespace modalwindow { /// <summary> /// Summary description for WebService1 /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment … |
| | Hi all, I've been using this type of code to pull out a single value from my SQL database but I can't help thinking that there's a simple command I'm not using: [CODE] strSQL = "SELECT MAX(Stage) FROM Visits WHERE ScheduleRef = 22" FinalStage = dl.getPRISMdata(strSQL).Tables(0).Rows(0).Item(0)[/CODE] [CODE]Public Function getPRISMdata(ByVal strSQL … |
| | Hi All, I have 1 combo box and 1 textbox and an excel file. I need to populate the combo box through the data from my excel file which is EMP_ID and I managed to do that via OleDb. This is the content of my excel file: [CODE]EMP_ID SPIDOM Password … |
 | how can I solve this kind of error: "a number, currency amount, boolean, date, time, date-time, or string is expected here" here is my code: [CODE]Dim oDoc As New ReportDocument oDoc.Load("D:\updated 2-21-cla-12-57\WAIS SYSTEM\WAIS SYSTEM\GUIDANCE-dropRpt.rpt") Dim myDS As New DataSet oDoc.SetDataSource(myDS.Tables("drop_student")) Select Case GUIREP_drop.Search.SelectedItem Case "Date" strsql = "{drop_student.date_drop} = '" … |
| | Proper way of doing this? Please disregard some variables. [CODE]Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class Addcage Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private cb As OracleCommandBuilder Private ds As DataSet Dim roomprice As Integer Dim roomtitle As String Dim lubid As String = … |
| | Load from database to datagridview [CODE]Call ConnectAccess() Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT ProductName,Quantity,UnitPrice,Extention, InvNomer,ProductId, InvDetId " _ + " FROM InvoiceDetail where InvNomer ='" & pbInvNomer & "' ", mConn) Dim ds As DataSet = New DataSet() da.Fill(ds, "InvoiceDetail") DGV.DataSource = ds.DefaultViewManager DGV.DataSource = ds.Tables("InvoiceDetail") Me.DGV.Columns(0).HeaderText = "Product … |
| | I have this code in my form (in load event) wherein there is a crystal report viewer: [CODE]Dim oDoc As New ReportDocument oDoc.Load("D:\grading_report\grading_report\teacherLoad.rpt") Dim myDS As New DataSet oDoc.SetDataSource(myDS.Tables("grading_teacherload")) Dim mystr As String mystr = "{grading_teacherload.teacherid} = " & teacherLoadListView.teacherid & "" CrystalReportViewer1.SelectionFormula = mystr CrystalReportViewer1.ReportSource = oDoc[/CODE] there is …  |
 | I am trying to make a simple demo of a DataGridView bound to a database table. I want to add a row, delete a row, and save the table. I used the IDE to do just about everything. It created the BindingSource when I set the datasource of the DataGridView … |
 | I have 7 different bindingsources on a form right now and I have a "cancel" button to allow a user to reject the changes they made and revert back to the original data in the dataset. Instead of having my cancel button click event call something like: [CODE=C#] private void … |
| | i want to get current date records from database in rdlc report.?? how its possible...?? i create a dataset of my billing table then i pass a parameter of datetime in tableadapter but error showed. here my code: private void Reportt_Load(object sender, EventArgs e) { DateTime dt=DateTime.Now; this.BillTableAdapter.Fill(this.DataSet1.Bill, "dt"); } … |
| | I'm hoping someone can help me out with this. I have a datatable populated from an SQL Server 2008 database table. I created a DataAdapter with a commandbuilder to manage the updating, inserting, and deleting of records. The Updating and Inserting work as expected. However, Delete does not. The code … |
| | Hi, I am using a Dynamic SQL to create a stored procedure. The stored procedure is as follows: [CODE]CREATE PROCEDURE spRetrieveBalanceSheet (@Pfcode varchar(5), @period varchar(10)) AS BEGIN DECLARE @tablename varchar(12), @sql varchar(2000) SET @tablename='SALFLDG'+Upper(@Pfcode) SET @sql='SELECT S.ACCNT_CODE As Code, SUM(S.AMOUNT) AS Amount, A.ACCNT_NAME AS Name FROM '+ @tablename + ' … |
| | hi i'm a beguiner in visual basic i have a datagrid view filled with a dataset table thats combined by 2 tables 1-persons 2- actions i want to select a row in the grid view and get the person table where personid is selected in datagridview i assume that it … |
| | I am working at winforms project and i have a datagridview from which i am trying to update a database from it when the user changes something. Here is the code: [CODE] DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["EbosPr.Properties.Settings.Database1ConnectionString1"].ConnectionString); SqlCommand scmd = new SqlCommand("Select * From CustCalls … |
| | Hi All ! I want to save or Export the content(Row And Column Cell) of a DatGridView To a XML file .how can i do it ? there is [B]No DataSet Or DataTable[/B] for DataGridView . thanks in advance for any Help ! |
| | [CODE]#Region "Imports" Imports System.Data.SqlClient #End Region Public Class frmcuti Private m_Cuti As New Entity_Penggajian.Cuti Private m_GetHari As New GlobalValidasi Private m_CutiA As New BussinessComponents.Cuti Private m_DS As New DataSet Private m_dta As SqlDataAdapter Private datagrid As DataView Private check As Boolean = True Private Sub frmcuti_onEdit(ByVal sender As Object, ByVal … |
| | I have searched high and low for an answer to this question and the answers I have found don't generally apply to what I am looking at and was hoping someone might have some suggestions. I have a form that is bound to a dataset that retrieves its data from … |
The End.