2,634 Topics
 | |
| | hello all I am trying to update a table through a dataset.Shortly I place content of a table in a DataSet ,display it on screen with datagridview ,and then do some changes. finally I do a button click with will do sqlda.Update(ds, "tbl"); //where ds= DataSet, tbl1= the Table I … |
| | I have 3 tables in my Db Supplier with started Supplier-id=C001 up to C999,Each supplier have many Contacts.On some condition i want to assign one table values to second table only those values which are related to that condition let suppose Supplier S010 marge his Business With Supplier S090 then … |
| | How do you insert label values to database? here is my code.. [CODE]Imports System.Data.OleDb Public Class frmemp Dim con As New OleDbConnection Dim dbAddNew As New OleDbCommand() Private Sub frmemp_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ds As New DataSet Dim dt As New DataTable Dim …  |
| | Dear Sir/Madam/Friends, Sir, i have written code for first step of euclidean distance . now i need to merge the smallest distance points as single point. The class which i have written is using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Collections; /// <summary> /// Summary description … |
| | [CODE]Imports System.Data.OleDb Public Class frmlog Dim con As New OleDbConnection Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click If ask() = True Then MessageBox.Show("Success") Me.Hide() Form1.Show() Else MessageBox.Show("Invalid") End If End Sub Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) …  |
| | I hve created one procedure in oracle which is used as a dataset 1 in SSRS in oracle procedure we created one table which is used in sql server query as a dataset 2. but after click on refresh button it gives proper resultset. can we get proper data without … |
 | If Server A and Client B are chatting through sockets, and Client B requests a dataset of all accounts on the server it has access to, the server provides that data set to the client (through serialization and sending it over the socket) and the client modifys the data, say … |
| | I have to divide dataset into training dataset(80%) and test dataset (20%) using random sampling.I have to implement it in c#.If anyone knows,please help me..... |
| | [B]ERROR RECEIVED:[/B] [B][COLOR="Red"]NullReferenceException was unhandled [/COLOR][/B] Object reference not set to an instance of an object. And it points on the particular line: [B][I]dsNewRow = ds.Tables("Employees").NewRow()[/I][/B] [CODE]Imports System.Data.OleDb Public Class Register Public cn As New OleDbConnection Public rd As OleDbDataReader Public da As New OleDbDataAdapter Public ds As New DataSet …  |
| | Hi I want to populate a text box from a stored table I have this for the data With DropDownList1 .DataSource = ds.Tables("property") .DisplayMember = "propRef" .ValueMember = "propRef" .SelectedIndex = 0 End With "property" holds all the info from the db when the user changes the dropdown list I …  |
| | Dear Sir/Madam/Friends, Sir, i have written code for first step of euclidean distance . now i need to merge the smallest distance points as single point. The class which i have written is using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Collections; /// <summary> /// Summary description … |
| | I am having problem deleting my data on click event [QUOTE]Private Sub btnDel_Click[/QUOTE]. Here is my code: [CODE]Dim inc As Integer Dim cs As New SqlConnection("Data Source=Connect\SQLEXPRESS;Initial Catalog=ForumCrawl;Integrated Security=True") Dim dbSource As String Dim da As SqlDataAdapter '("SELECT * FROM search_result", cs) Dim ds As New DataSet Dim sql As … |
| | I am trying to read through a table and for each row execute a few lines of code. (The lines of code are taking an data type integer column which contains a time HHMM and a data type datetime column which contains a date. The code combines the time into … |
| | Hi Guys need a bit of help! Basically I have a parent table called users which stores all the user info with a prime key field called ID. Now in the child table which has a seperate foreign key associated with the ID field in the parent table. What I … |
| | I'm trying to format a DataGridView, with style color, etc. The DGV loads (via buildGrid method) at the startup of the form, as you can see in the constructor's code: [CODE]public Report1(DataSet dsReport1, string sDateRep) { InitializeComponent(); sDate = sDateRep; dsReportGrid = dsReport1; orgDataset(); buildGrid(); } [/CODE] Here's the code …  |
| | hello i ve 2 forms form1 & form2. form1 has primary key(parent table) & form2 has the foreign key(child table) [code] me.mytableadapter.update(me.dataset.mytable) [/code] is working f9 but in form2 when i try to use [code] me.secondTableadapter.update [/code] here problem comes the update function is not coming neither recognized by form2 … |
| | 'ttudy the following code' [CODE]Public Function my_account() As Integer Dim accountNumber As Integer Try objconnection.Close() objconnection.Open() sql = "select min(accountNo) as ac from Invoices where dateDue='" & Today.Date & "'" objcommand = New Odbc.OdbcCommand(sql, objconnection) objdataReader = objcommand.ExecuteReader objdataReader.Read() accountNumber = objdataReader("ac") Catch ex As Exception MsgBox(ex.Message) Exit Function End … |
| | I am trying to populate a dataset with data from a dynamic SQL dataset created by a code generator (PDSA). If I want the first row of data, or I use a specific "Where" clause to retrieve 1 row, I have no problem. But, when I loop through the dataset … |
| | Dear All, I am having a problem with reports in a web application with C#. The reportviewers are old style (the application is old, was written with the framework 2.0) and I actually had to hack the reports to make them work. Now, the reports work fine except for two … |
| | I want compare 2 datagridview table for calculation purpose. This is because this 2 table is come from different database. 1 is access and 1 is sql server. therefore I cannot join table.So I have 3 datagridview table to display data. I'm want datagridview3 ItemPerPack Column * datagridview1 Qty when … |
| | I retrieved data from access in vb10 between two dates and here is the code for dat: [CODE]Imports System.Data.OleDb Public Class Form4 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try con = New … |
| | Hello I'm currently using GridView.Sort("Column", ASC") It works perfectly and sorts my gridview, however once I get to 10 or higher the sort order stops working and it goes. 1,10,2,3,4,5,6,7,9. Here is my code would anyone care to explain why it does this? [CODE] DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath(@"xml\" … |
| | Hello I'm currently trying to get my GridView to update all rows at the same time. The gridview takes data from an .XML file - I can use the 'onRowEditing' to update a single row at a time - however I want it to be able to update all rows … |
| | Hello everybody, I am Saurav Saha from India. I am not aware of python but just because i am working on a tool that is on python i got struck. I have many directories in which two files are kept 1. *.txt and 2. *.pdbqt I wanted a program that …  |
| | Hi! I need to convert bindiangsource.datasource (which is a list) to dataset or datatable. Can anyone please give me a sample code? Thanks Obsy |
| | Hey,i am working on a module in vb 10..i have to retrive data from the database between two dates...i have used the following code but not able to get ny output,,nt even an error [code] Imports System.Data.OleDb Public Class Form4 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr … |
 | Like the title says, I have about 10-15 rows in a local dataset. I need to take any one row, and make it the "default" (on a button click), meaning to take that row and stick it right at the top so it comes up first. I've been up and … |
| | i have a XML file that temporary stored data from the DB. i have DataSet that reads from the XML file and fill the DataSet. i want to set this Dataset as data source to ReportViewer in runtime |
| | dear all, I'm trying to find out how to pass a parameter to a predefined parameter in a dataset. I've found everywhere a solution if you build the sqldata adapter and the dataset in the code. Then you can pass the parameter like: da.SelectCommand.Parameters.Add("@param1", SqlDbType.Char).Value = param1_variable (as example) But … |
 | I have a foreach loop, within which I would like to create x number of unique variables. E.g. Upon each iteration I'd like to create a new variable like: $strDisk1 = ... $strDisk2 = ... $strDisk3 = ... I have tried the following but this does not work: [CODE] <?php …  |
| | Hello I'm trying to take Data from my GridView at the moment. My gridview has a column called 'DataField' what I want to do is take those values from Datafield to calculate the highest value. The 'Datafield' are as follows: A10, A11, A12 etc. How can I take those values … |
| | I have a working code that exports the datagrid into XLS. However, the datagrid results does not show on my aspx (html) page. It only shows on the page when I comment out the part that exports it to xls. I am not sure whether it should show by default … |
| | Hello I'm trying to sort my gridview by a particular colum. My gridview has a column which is 'Sort Order' and they are numbered 1,2,3 etc. Now I want to be able to default sort that column in ascending order. Would anyone possibly be able to help? Here is my … |
 | Hi guys, I've recently developed a gridview with edit,delete and update panel..... All is working fine except the Update button.....the error shown is...... [CODE] [B]Object reference not set to an instance of an object.[/B] Source Error: Line 48: GridView1.EditIndex = -1; Line 49: conn.Open(); Line 50: SqlCommand cmd = new … |
 | Hello everyone! Am trying to retrieve data from sql server based on two columns. Its a web application being developed using VS2010 (vb.net) but i keep getting the error: incorrect syntax near '=' Here's my code below: [CODE]Sub GetBasicMidwives() ' Set the SelectCommand properties... With objDataAdapter .SelectCommand = New SqlCommand() … |
 | Hi Some background: I'm trying to create a Server/Client Sync scenario for my application using Sync Services for ADO.NET specifically the LocalCache custom tool which sets the whole thing up for me. My server DB has 5 Tables, all of which are being synchronized to the client application, which now … |
| | using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Shapes; using Business; Guys, I want to populate the DataGridview with a dataset I have created but I am having problem and I would be thankful if … |
| | Hi, I am create one web application in which i have to create dyanamically panel and table,tr,td,labels and textboxes. but when i split the string and create tr but more tr created i want 4 tds in 1 tr but they create 4 tr dynamically.. how to solve this problem..[CODE] … |
| | Hello I currently have a Datagridview which takes data from an XML file. I want to display the array of numbers. Here is the code for my GridView: <asp:GridView ID="rd" runat="Server" OnRowEditing="Editdata" OnPageIndexChanging="pageddata" OnRowDeleting="Deletedata" OnRowUpdating="Updatedata" OnRowCancelingEdit="Canceldata" AllowPaging="True" AutoGenerateColumns="False" PageSize="30" CellPadding="4" ForeColor="#333333" GridLines="None"> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#EFF3FB" /> … |
| | Hi, How to write into excel sheet using oledb connection or how to export dataset into excel sheet using oledb connection. Iam using console application in vb.net. If there are any alternate ways to write into the excel files from dataset. |
| | Hi, I am trying to create comm dll. In which i am reading the contents of the excel and have to return it either as dataset or dictionary object or 2-dimensional array strings. The same dll we are using in javascripts. Here, When i return dataset or dictionary object in … |
| | I'm new to VB.net and am looking for some advice. To start with I need to develop something that I can import 3 different csv files into and then once I've created a query then return my results in a datagrid view. I'm not sure where to start with how … |
| | I am Importing a Excelsheet(xls) in to my Application, but the date and Number column showing blank in dataset when comes to application. the values are there in Excel. what must be the problem Any other way to import the excel sheet to application, so that i should get all … |
| | Function to Convert Dataset to Excel. It will export all the table of the given dataset to the given excel. Example: [CODE]ExportDatasetToExcel(dsFinal, "d:\\my.xls") [/CODE] where dsFinal is my Datase and second parameter is the excel file location. Make sure the excel file exist. |
| | Good day, I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the … |
| | i have this dataset: [CODE]String[][] trainData= { //featIdx////////classInfo {"s", "y", "r"},//0 {"s", "n", "r"},//1 {"w", "y", "r"},//0 {"r", "y", "p"},//0 {"r", "n", "r"},//2 {"r", "y", "p"},//0 {"w", "n", "p"},//0 {"w", "n", "r"},//3 {"w", "y", "r"},//0 {"s", "n", "r"}};//1 int[] trainClassInfo = {0, 1, 0, 0, 2, 0, 0, 3, 0, … |
| | I work as a console technician for an audio company in the north eastern United States. My job is to prep and manage all of our audio console before they go out on tour. I would like to build an application to assist in our testing process. Basically all is … |
| | I am using crystal report of VS 2008. I want to open a crystal report in PDF even when it is loaded with out showing the crystal report . I also not want to show the save dialog box while opening in PDF. With code below the report is opening … |
| | Hi i am trying to write dataset into excel using oledb connection. I get an error "The microsoft access database engine could not find the object 'testTable' Make sure that name and path is correct". I understand that dataset is not in the excel thats y i get an error … |
| | Hi, I am doing a window servise application using VB.net. I have faced problems with sql suery, as below: [CODE] Dim dt As New DataTable() SQLStr = "SELECT FautyScanTbl.Model, FautyScanTbl.Version, FautyScanTbl.WIP, FautyScanTbl.ScanNo, FautyScanTbl.LotSize, FautyScanTbl.SerialNo, FautyScanTbl.PIC," & _ "SerialNoTbl.SetWeight, SerialNoTbl.AccesWeight, SerialNoTbl.pdmid, ScannedPartNoTbl.ScannedTime " & _ "FROM FautyScanTbl LEFT OUTER JOIN " … |
The End.