2,634 Topics
 | |
| | Hi, I am working on querying a specific value from my xml file. Below is what I have so far. When running the entire script I get the error "Incorrect syntax near 'varchar'". Thanks -- Declarations needed to run sp_xml_preparedocument. This will create XML image. Declare @idoc int Declare @doc … |
| | There are tons of posts in many forums about this, and I'm sure it can be done easily with custom code for each button, but if Visual Studio has any merits, this should be much easier. What I'm trying to do is update some fields in gridview, then next time … |
| | Hi.. i have imported a excel in to datatable which contains 5 columns and some thousand rows. I have to do two level validation. First i have to check whether the column belongs to specific datatype. If so, then i need to check each and every cell in that column … |
| | Hi.... I have a datepicker that contains an alternate key of an Access Table with a autokey primary key. [code] Private Sub DateTimePicker1_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles DateTimePicker1.Validating Dim d As Date = DateTimePicker1.Value If d < Today Then MsgBox("Gelieve een datum in de toekomst te … |
| | Hello, Please help! I"ve created a form with three comboboxes and a datagrid. I've connect the comboboxes to the database and they all work but when i try and fill the datagrid based on the final selection from the last commbobox but it will not populate the datagridview..Help! [CODE] cmbVendor_MouseClick … |
| | Hi, I have an aspx form that is meant to add a new prescription for a doctor system. I've created the database and dataset needed, but the problem is that the doctorID and patientID has to be able to select from the database, not entered in as a plain text. … |
| | Hi all, 1) I am trying to use Ajax and Jquery on master page. In my existing project i have used the Ajaxpro.dll it's working fine. but when i am trying to use jquery then it throws error "Object doesn't support this property or method." 2)I have taken a fresh … |
| | Hi Guys, I just want some one to look over this for me really, and possibly can some one tell me how to call the function! as you can see below (VB.Net Code) this is running of a button and it will connect to SQL obtain the relevant information and … |
| | Hello folks, I am new to VB 2008 and right now I have been struggling a lot for updating access 2003 database from a VB 2008 desktop application. My problem is that I am unable to update the 'Status of the USER' to 'ACTIVE'. The problem is in the "setUsersOnline() … |
| | I am developing a Windows application using VB.NET. I have a datagrid control bound to a dataset which is populated from an Access database. When a user using my application clicks on a row in the grid, a triangle appears in a column on the left of the grid indicating …  |
| | Hi, I am working on tree View in taht i want to do two thinks i.e 1. add new node at run time 2. what data is stored in a database is shown in the tree view as parent node and its child for second i have do some coding … |
| | Hello my friends I have a txt file with the follow layout [QUOTE] error1 255 error2 34 error5 111 error3 23 [/QUOTE] and what i'm trying to achieve is, from this text file plot a trend chart with the errors and respective quantity! this is the code that i'm using.... …  |
| | how to add gridview data to dataTable and display at crystal report? for example,my gridview show 10 data and i wan show these 10 data to crystal report! when i add the gridview data to dataset,there occur sum error![CODE] 'add column to that table For i As Integer = 0 … |
| | I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc. One table will have data representing 47k reps that currently have credit for a transaction. …  |
| | Help!How to generate a crystal report from gridview data! i ady can get data in gridview through the code below! How can i generate a crystal report from this??? [CODE] Dim sColList, sTableName As String Dim DT_Data As New RS_UtilityService.dsSDFSystem.sp_DynamicSQLDataTable Dim ds As New DataSet Dim table1 As New DataTable … |
| | I want to import data from a xml file into a dataset this is my xml file [iCODE] <?xml version="1.0" encoding="UTF-8" standalone="no"?> <Persons> <Person Personid="10"> <firstname>Hi</firstname> <lastname>bye</lastname> <Birthday>1360 </Birthday> <Phones> <Fax>04</Fax> <Other>05</Other> <Home>01</Home> </Phones> <Emails> <Email>Email@site.com</Email> </Emails> <Webs> <Web>web.com</Web> </Webs> </Person> </Persons> [/iCODE] when I use this code [CODE]dataset1.readxml(FilePath); [/CODE] … |
| | Hi All, I am developing an windows application in .Net 2005 with C# coding. One part of my work, the functionality is 1. Use USB barcode scanner. 2. When something is scanned, it records the item number and automatically pulls the item price from the database. 3. After an item … |
| | i get an error when i try and do this. [code=c] private void button2_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DBconnect db = new DBconnect(); Global.GlobalVar = textBox1.Text; string Co = new Password('J', textBox1.Text).SetSql(); ds = db.GetDataSet(Co); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 0) { if …  |
 | This seems to be the appropriate thread to post my problem in: I'm also trying to bind to a ReportViewer object, however I'm not binding a stored procedure but dynamic sql that selects <dynamic columns> from <dynamic views or tables> nice huh? My boss has fallen in love with the … |
| | hi.. i'm using the database on live .. i may do hosting on different system and ip is changed.. please help me the below code runs well when i remove the ispostback condition.. but when i keep that when page is loaded it works well but when i give print … |
| | I have a combo box that needs to be autoupdatable. I know you can set the AutoCompleteMode to SuggestAppend and have the combobox suggest as you type values that are in a combobox's items list. My question is this, Is there a way to have this same functionality happen with … |
| | My main idea is to link the three combo boxes I had taken appSet, app, package comboboxes Now when I select one iten in appSet then the remaining two comboboxes should show the data related to the selected item in the appSet and when I select one item in the … |
| | Hi all, I am getting the following error when I am loading the data into the ComboBox and the ComboBoxes are linked to each other I am getting the errors as below Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at client.cpm.dailyT20.CBRCPMDailyT20View.appComboBox_actionPerformed(CBRCPMDailyT20View.java:235) at client.cpm.dailyT20.CBRCPMDailyT20View.access$1(CBRCPMDailyT20View.java:234) at client.cpm.dailyT20.CBRCPMDailyT20View$2.actionPerformed(CBRCPMDailyT20View.java:227) at javax.swing.JComboBox.fireActionEvent(Unknown Source) at javax.swing.JComboBox.contentsChanged(Unknown Source) at … |
| | hi... i've 50 crystal reports which is connected to the database directly without using any dataset.. and the connection string is vsspl-002\\sqlexpress.. now my problem is i've shifted the database to another location.. and my connection string is vsspl-008\\sqlexpress.. now i dont want to change the connection string for each … |
| | Hi all, I got this Error Message while I try to preview the records in Dataset Designer: "The connection string could not be found or Data provider associated with the connection string could not be loaded" Here is my dataset.xsd code [CODE] <Connections> <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)" … |
 | Hi guys, I am using Visual Studio 2008 and have connected a database correctly as I have done a login that works fine, although when I try to insert information submitted in the text boxes a different table, it doesn't enter after I end program to check it still has … |
| | Can anyone tell me what is wrong with the following Code. I am trying to launch a form on a different thread because the form takes 10+ seconds to load. The code I am using follows: [CODE] Public Class frmAdjustments Inherits System.Windows.Forms.Form Dim gVariant As Guid Dim gsUID As Guid … |
| | I've got a vb.net 2005 form that calls a stored proc to load a combobox with eligible sales reps. There are approximately 40k sales reps available...I know that's a lot, but that's what I'm dealing with. I'm trying to figure out why it's taking this form 15 seconds to load. …  |
| | I'm having trouble trying to update or delete records from my database. Basically, I have a datagridview(DGV) in my form and the following is what I wanna do. The user could directly change/edit the values in the DGV and just click the update button to update the database. And the … |
| | My gridview is being generated at runtime by a dataset. My first column is a template field with checkbox, how to delete a selected row? C# please. |
| | I'm trying to call a base class specifically; Release class into a Page_load method.The release class is linked to a baseclass which contains a method Dataset Getresult. How do i call from the release class into the page load.I'm using Repeater I'm trying to do something like this [code] protected … |
| | Hello Everyone, Could you please tell me why my dropdown not firing selectindexchange event. I have dynamic load that dropdown box using dataset. My problem this I have two dropdown boxes now I have load Brand Information in first one and when I select the brand all printers info load … |
| | I have checkedlistbox that is being populated at runtime by a dataset. Whenever I tried checking multiple items, only one is being stored in my database. Here to explain more clearly. [B]SQL[/B] I have two tables, book table and author table which has its own id. My book table has … |
 | Hey Just wanted to ask a quick question. i am using a MS access database. i have done my selecting and filling of the dataset. What i was wanting to know is there a way to look at the name of the Column where the data is in. I was … |
| | Hello Everyone, I just write a web service in which function return a dataset. Now I have load that dataset in asp:dropdownlist in a web page. Please let me know bow would I do this. Thanks Farooq |
| | Hi all, I use managed dlls in my application to read dicom data (.NET wrapper for visualisation tool kit if any one know) , the problem is that when trying to increase the DICOM series the system crashed , the reader uses 32 bit index pointers. on suggest using LARGEADDRESSAWARE … |
| | I'm using Visual Basic Express 2008 to create an interface with a order database in MS Access 2007 (.accdb file). Everything is fully functional except updating the "Inventory" table is very slow. Updating around 2200 items takes almost 2 minutes and the window will appear as "not responding" for the … |
| | hi to all. i've created one aspx page in that i've added a new item called dataset. i've taken the employee table.. form the database. i've added a new item crystal reports to it.. i've dragged some of the field from the dataset.. now i want to write the code … |
 | I've been trying to figure this one out. I was under the impression that when a class method contains any resources, once the method has reached the end of the code and returns it's result (or nothing in the case of void), that all of those resources are gobbled up … |
| | I am having a small problem with dataset problem defination is: _____________________________________________________________ System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217843 Message="Not a valid password." Source="Microsoft JET Database Engine" ________________________________________________________________ and My connecting string is: _______________________________________________________________________________ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\Shop Inventory\database\DATABASE.mdb";Persist Security Info=True;Jet OLEDB:Database Password=123456789" ________________________________________________________________________________ WHERE the password I added is right but whenever I try … |
| | hi i am trying to convert data from excel sheet to dataset\datatable using sqlserver2005 as backend, so anybody can help me . Thanx in advance. |
| | here's my code [CODE] Dim suppQuery As String = "SELECT [Supplier ID],[Company],[Last Name],[First Name],[Email Address],[Mobile Phone],[Office Phone],[Address],[City],[ZIP/Postal Code],[Notes] FROM [Suppliers]" Dim dsSupp As New DataSet Dim daSupp As New OleDbDataAdapter(suppQuery, cnPharma) Dim cbSupp As New OleDbCommandBuilder(daSupp) Try daSupp.Fill(dsSupp, "Suppliers") Dim rownum As Integer rownum = listSupplier.SelectedIndex With dsSupp.Tables("Suppliers") .Rows(rownum).Item("Company") = … |
| | Hi. I'm building an app (in VS2005) in which I have a datagridview with a combobox column that needs to be databounded. I use the dataSet designer to add a dataset and then add to the combobox column datasource the dataset I just added (make a reference) and then I … |
 | Hi, I'm having trouble getting the Ajax Toolkit autocomplete extender to work. I have the web service set up as its own file in the same project and calling that alone works - the correct list of results is output as xml. But when entering text into the textbox nothing … |
| | Good day everyone! I'm still a noob with C#.NET so patience pls! :) I'm making a Windows Forms Application with a database from MS SQL 2005 Express. I want to transfer this projects with the database to another pc. What should I do? Should I transfer the database (.mdf and … |
| | Hi, I'm trying to setup a DataGridView with ComboBox, but I can't manage to setup the selected value of the combobox. The ComboBox value & display members are from table[1] of a Dataset object, and the rest of the datagrid columns are from Table[0] of the dataset. "noseID" (the primary …  |
| | Hey all, I am currently fiddling around with SQL/Access statements in C# and created a very simple dictionary program that will search for the words depending on the length of each text entered in one text box. So when the user presses the search button it the program will search … |
| | Hello all Experts, I have following Code to get Image from dataBase and Show it in the Gridview Control on my web page but I am succeded to get data but when I bound the DataSet with GridView it doesnot show me Image. You can View error on Attached Image. … |
| | I have a vb .NET 2005 form that needs to load data based on a selected month by the user. Because there is a large amount of data in the table (60k+ records per month) it is taking the query a long time to pull the dataset back and populate … |
| | i have looked around the forum and on the web but couldnt find anything that seemed to be what i was looking for. or i couldnt follow how they where doing it. What i need is to fill a treeview from a dataset. the dataset has been filled from a … |
The End.