2,634 Topics
 | |
| | I have vb.net application with MS access database. I use following code to autocomplete textbox from database. the problem is that, although its working but more frequently it gives an error "AccessViolationException was unhandled----Attempted to read or write protected memory. This is often an indication that other memory is corrupt." … |
| | I want to export the excel data and show it in gridview. And I want to update the existing table i sql using Gridview data Below is my code for exporting from Excel protected void btnUpload_Click(object sender, EventArgs e) { //Coneection String by default empty string ConStr = ""; //Extantion …  |
| | Hi, I have a DataGridView with a table loaded onto it. I have nine textboxes which will serve as a search feature for the DataGridView. What I want is that once text is entered, it goes through the relevant column filtering data as per what is inputed. This works perfectly … |
| | Hi! I am using Data Grid View to display the data from my database. This code works properly. It displays the data. This code is inserted in the Form_Load of the form. Dim cmdCount, cmdGet As New iDB2Command Dim daGet As New iDB2DataAdapter Dim dsGet As New DataSet Dim sqlCount, …  |
| | Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it does not seem to work :( I am initializing the connection using form_load and not in the Properties Window. Imports … |
| | i have a form which asks the user to enter a username , once the user enters the username, the program will check if the username entered by the user is a new username or an old one from the database 'testdb' and table 'test'. if it is a new …  |
| | Hi guys I have this problem where a certain cell will select a value from a table based on another cell (like an id or something). First I select some values to be put in Datagrid (a typical OleDBCommand) then add some more columns using Datagridview.Columns.Add. Here's the scenario I … |
| | Hello, I am currently completing a side project. The biggest ideal of it all has to do with a dynamic drop down box. I have heard and seen of the 'auto complete textbox' feature by using ajax/jquery toolkits. That is what I'm looking for, but I was wondering if there …  |
| | THIS IS MY CODE.... bUt i am not getting the data between the given dates IN THE DATAGRID VIEW Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= C:\Users\Anand\Documents\db.accdb" Dim dfrom As DateTime = DateTimePicker2.Value Dim dto …  |
| | But i am not getting the selected data displayed on the datagridview... pl do help me.. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dfrom As DateTime = DateTimePicker2.Value Dim dto As DateTime = DateTimePicker1.Value Dim SQLString As String = "SELECT * FROM cc WHERE … |
| | Hi guys i need your help, i am trying to read an xmlfile which is on the listbox, after reading it i want to bind the data to GridView, i can read directly from the location where i have saved the XMLfiles but now i want to select it from …  |
| | hi.,:cool: I need to create a grid view in asp.net which should have the database connectivity nor sqldatasource. hence i should use the dataset,datatable,datarow and some how i tried and create the dataset and displayed in grid view. i wrote this code in page load event: dataset ds = new …  |
| | 0 down vote favorite I have a problem, what i want is when the user enters data in the textbox, it needs to compare the entered textbox value like ,,name, with value ,,name,, in dataset. If name exists, It should enter the value in textbox. If not, it should pop …  |
 | i am using asp.net datalist to retrieve text from database field, when i put an integer value like 10 in where clause of select statement then it retrieves data from databse on next page but when i used variable (which is used to store value sent via query string) then … |
| | Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report … |
 | hello everyone, i have a datagridview filled with a dataset and i want to store all the records it has to new table in database. i added a new column,("pos") to a dataset that fills the datagridview through a query so that it ranks records based on a field (total).my … |
| | Hi guys I tried to to use inner join on 5 tables it worked but the problem is instead of getting the exact sum values it got doubled. Here's my code cmd = New OleDbCommand("SELECT om_list.invoice_no as invoice_no, om_list.internal_id as internal_id, om_list.customer_id as customer_id, om_list.account_name as account_name, om_list.seller_name as seller_name, … |
| | I have this database in stored inside my Visual Studio Express 2013 for web. How can I use XSLT to turn into: <?xml version="1.0" encoding="utf-8" ?> <graph caption='Cashflow' subcaption='(Drag to zoom out)' hovercapbg='FFECAA' hovercapborder='F47E00' formatNumberScale='0' decimalPrecision='0' showvalues='0' numdivlines='15' numVdivlines='15' yaxisminvalue='1000' yaxismaxvalue='1800' showVLineLabelBorder='1' numVisibleLabels='500' legendPosition='RIGHT' SCROLLBAR='Glow' btnSwitchToPinModeTitle='Compare Graphs'> <categories> <category name='1/1/2014' …  |
| | Hi guys, I'm new to ASP.Net. I'm building a page which consists of a dropdownlist, a gridview and a save button below the gridview. I want to populate the gridview based on the values selected from the dropdownlist. My first problem is that the gridview does not display when the … |
 | I have been able to limit the number of data to send to the application however I need help setting up the application to show the fetch next button. data retrieval code - I am using show only 2 rows because I have a small amount of data in the … |
| | Hello, I do the simple project using VB.net 2008 to link with MS Access 2007. I have two textbox which is data for ID and Fullname. txtID.Text = ID txtFullname.Text = Fullname Button1 = Search In MS Access My data for ID : 1,2 & 3 and My data for … |
 | I need to add the URL property to webbrowser1 (located on my form) from a dataset containing the URL, but am getting the error "Invalid cast from 'System.String' to 'System.Uri'. The column in datagridview1 is called link. I need the web browser URL to change with a corresponding textbox and … |
| | Hello, I am new to C# and i am stuck when i try to fetch the data from SQL Server to Visual studio. I am writing the code as a n-tier application - Data Access, Business logic and the front end. I am fetching data in a disconnected env. I … |
| | hello .. i just need a lil guideline... m making a program where i have to apply counting sort on the data which is comma seperated and it is written in a text file like this 59,54,40,79,38 28,98,77,71,74 24,91,56,82,51 74,36,98,29,41 39,10,52,3,24 30,5,4,70,15 29,55,40,56,23 8,94,69,13,37 79,96,54,53,29 12,29,30,99,35 63,87,64,6,6 65,56,80,37,89 total no. …  |
| | Hi All, I have a form with 4 listboxes on it connected up to a "books' database.The four boxes are: 1)Authors (this one is a list of authors names) 2)Publishers (A list of the publishers who have published the authors books) 3)YearPublished(A list of the years in which the book … |
| | Hi I'm new to programming but have learned pretty fast and have most of my small application figured out. But the part that I'm working on now has got me. I have a form with some text boxes that after they are filled out get added as a new row … |
| | hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins …  |
| | I don't know what i doing wrong. I have been on several forums trying to figure out how to sort a table in visual basic. I have treid with and with out a dataview, but noting seams to work. I have a logg that the user can do new inserts … |
| | Hi guys, I'm using a very simple database and dataset and it appears to be working, except I can't actually save any data. Here's what I did: I created an empty database with a corresponding empty dataset. I filled it in with 4 rows of dummy data (ID, name, address, … |
 | i have a repeater in one page to which me load the data from database now i want to click a button and i get the value of a repeater specific row data and kept data in session and access that data an another page.plz help me any one have … |
 | I have created three tables used dataset to generate fields when i enter data it does get stored but when i close application and then reopen data doesn't show. |
| | i have four columns in a gridview .Every field is a template field with checkboxes.I have a button. when i check the check boxes and store it in database the checkbox value is storing. but after clicking the button the checkboxes unchecked. how to make the checkboxes checked . public … |
| | I am trying to make a form in vb and connect that to database .First of all i created a databse and then opened new project and tried to connect that database to form. file new--->try____>project--->add new item---->Service based databse--dataset---->finish step2----->in databse explored right clicked on table and Add table … |
| | Can you guys please help me understand when to use const? For example, if I have the following functions: viod add (int* array) { int total = array[1] + array[2]; } viod subtract (int* array); viod times (int* array); viod divide (int* array); viod printArray(int* array); and I only intend … |
| | Hi, I am new to VB programming. I am using Aceess 2010 database with VB 2010. I have one main table which stores information of company details. The details are broken down in seven different tables with codes to avoid data duplication and keep the main table less bulky. e.g. … |
| | I have two functions declared in my program, and i want to use the variables in another function to display the matched images. My code is: def messageWindow(): win = Toplevel() path = 'C:\Users\HP\Desktop\dataset' COLUMNS = 12 image_count = 0 for infile in glob.glob(os.path.join(path, '*.jpg')): image_count += 1 r, c … |
 | Undefined index: id line 7 help me please email me asap at asmafayaz@hotmail.co.uk <?php // Connect to database server $conn = mysqli_connect("mysql5", "fet12014211", "Milkshake12","fet12014211"); // Show a particular value. $id = $_GET['id']; // SQL query $strSQL = "SELECT * FROM countries where iso_alpha3='" . $id . "'"; // Execute the … |
| | I made an online application to store employees information in MS SQL,I used Disconnected model and I made my class for "DataSet configuration" and call method in it in The "Form_Load" event. This is the class public static string constr = ConfigurationManager.ConnectionStrings["cnn1"].ConnectionString; public static DataSet GetDataSet(string stored_name, string table_name, params … |
| | Hi Guys, Hope you can help. (Bit of a N00b still).. I've written an Functioning Program (Good start!) However, I was wondering if there is a way for the data that is being shown currently in the Grid view to be shown with 'Decimal Places? The Data is Being pulled …  |
| | Imports DemoExcelFileHandling.DataSet1 Imports DemoExcelFileHandling.DataSet1TableAdapters Public Class ReadFromExcel Private dt As New dtMonthDataTable Private ta As New taMonth Private bs As New BindingSource Private Sub BindUI() dgvExcelData.AutoGenerateColumns = False colYear.DataPropertyName = "Year1" colMonth.DataPropertyName = "Month1" colFacility.DataPropertyName = "Facility" colProductCode.DataPropertyName = "ProductCode" colProductDesc.DataPropertyName = "ProductDesc" colUnit.DataPropertyName = "UnitOfIssue" colBegBalance.DataPropertyName = "Beginning_Balance" colQtyReceived.DataPropertyName … |
| | There are many examples of reading an xml file and populating a datagridview. I would like to pull the xml from a string instead. Dim myXMLfile As String = "C:\tmp\accountlist.xml" Dim ds As New DataSet() ds.ReadXml(myXMLfile) DataGrid1.DataSource = ds DataGrid1.DataMember = "account" The above code works when the xml data … |
| | Hi guys I need your help on selecting data from 4 different worksheet. Here's my code Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") Dim cmd As OleDbCommand = New OleDbCommand("Select [MAM$].[Seller Name], [MAM$].[Final Computation], [MAM$].Designantion From [MAM$] Left Join [DSS$] on [MAM$].[Seller Name] … |
 | i am told t use old traditional way of SQL in MVC so created login register page but now problem is that i can't return data to VIEW from dataset. Model public ConnectionStatus Login_db(String email, String pwd, String conStr) { String hashedpwd_login = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "SHA1"); using (SqlConnection sqlCon = new … |
| | I want access data randomly and i have write the code when i click the button then data is displayed but i want when i again click the button then the next row data is displayed. could you please tell i am stuck here past 15 days.please And when click … |
| | I'm using: Windows 7 Word 2010 Visual Studio 2013 Express for Desktop An Access database with one table As this project is for proof of concept I'm keeping things very simple until I can get the VB working correctly. The project consists of one form (Audit.vb) which contains one textbox … |
| | im creating a voting system that add votes to the database but it seems that my update/submit button don't add numbers(INT) in my database. what could be the problem here?help my database schema: | cid | cpos | cfname | cmname | clname | cyr | cparty | votes | …  |
| | HOW COULD I UPDATE DATASET WITHOUT USING FOR LOOP IN ONE COMMAND............/////////////////  |
| | I have here my code; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from Personaldata", connParam); OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter); DataTable dataTable = new DataTable(); DataSet ds = new DataSet(); dAdapter.Fill(dataTable); dataGridView1.DataSource = dataTable; for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][3], dataTable.Rows[i][4], …  |
| | i really have a problem to this code. can anyone help me? Try Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName …  |
| | I have created link button dynamically and attach event to this. but when I invoke this event from page_load or page_init this works. but when i invoke this event from any simple button this is not working. could anybody help me. My code is following :- protected void test2() { … |
The End.