2,634 Topics
 | |
| | data not save on the strGno, is there is another way to do this? Dim connetionString As String Dim strSQL As String Dim conn As SqlConnection Dim ds As New DataSet Dim strGNo As New TextBox strSQL = " Select * From DocNos Where DocId='" & Trim(Doctype) & "' " … |
| | Hi all, I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go: I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know … |
| | Hi.. I have 3 DropDownList:- DropdownList1 has status,DropDownlist2 has date and DropDownList3 has duedate and based on these values selected i want to populate the Gridview following is my code.. protected void Button1_Click(object sender, EventArgs e) { string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataAdapter sda = new SqlDataAdapter("Select * from DropDownFilter where … |
| | Hi Guys I need some urgent help I have Created a C# windows application to implement a form with • a ListBox, • a TextBox, • an Edit button, • an Insert button, • a Delete button, • a Update button and • an Exit button. [ I have also … |
| | I am using a JFreeChart from this link [ICODE]http://www.java2s.com/Code/Java/Chart/JFreeChartCategoryStepChartDemo.htm[/ICODE] the format of the datasetUtilities.createCategoryDataset is (new String[]{..,..,},new String[]{..,..,},data).Is there any way that i can pass an already filled arrays for countries and years? [CODE] public Chart(String tablenm,final double[][] data,String[] countries,String[] years) { super(); final CategoryDataset dataset = DatasetUtilities.createCategoryDataset( countries,years, data … |
| | [CODE] <%@ Page Language="C#" MasterPageFile="~/Admin.master" AutoEventWireup="true" CodeFile="last_try.aspx.cs" Inherits="last_try" Title="Untitled Page" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </asp:ToolkitScriptManager> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AllowPaging="True" DataSourceID="SqlDataSource1" onselectedindexchanged="GridView1_SelectedIndexChanged" onrowcommand="GridView1_RowCommand" > <Columns> <asp:BoundField DataField="l_no" HeaderText="l_no" SortExpression="l_no" /> <asp:BoundField DataField="nam_dep" HeaderText="nam_dep" SortExpression="nam_dep" /> <asp:BoundField … |
| | I'm using a JFreeChart which I found in this link [ICODE]http://www.java2s.com/Code/Java/Chart/JFreeChartCategoryStepChartDemo.htm[/ICODE] I have modified the code as given below.My problem is how i can change the values in the x-axis so that they don't start from the zero. [CODE]public class Chart1 extends JPanel { /** * */ private static final … |
| | i am trying to insert value using dataset but its giving me an error of null point exception(object was not created) at run time 'my code is [CODE]Dim cnCustomers As OleDbConnection cnCustomers = New OleDbConnection Try With cnCustomers ' If .State = ConnectionState.Open Then .Close() .ConnectionString = cnString .Open() End … |
 | Sir, I am currently doing a project on "Pharmacy Management System". My question is "Can I used DataGridView to show the items that i have searched and the rest won't be visible??" If yes then can anyone give me the code for search button?? I have used the following code …  |
| | Dear all, I am busy implementing a small program and I'd like to work with threads. First of all, I'd like to specify that I am certainly not an expert user of C++ (I often use Perl -ouch- but in this case, Perl was far too slow for the program … |
| | Here's a sample of the excel data: column A: partnumber AL-01-BLT AL-01-ATV AL-01-BRS AL-01-BAR column B: price 20 21 40 45 When the user selects the partnumber in combobox1 and combobox2, it should add the total price and output it in label1.. For some reason I'm getting an error now … |
| | Hi, I cannot seem to figure out how to search through a created/filled dataset for a certain value which exists in column(1), returning Column(0)'s value into a textbox. My code looks like this: Dim connStringdg44 As String = "server=(local);database=Cricket;trusted_connection=yes" Dim conndg44 As New SqlConnection(connStringdg44) Dim strSQLdg44 As String = "select … |
| | hi all! i have here a code [CODE] Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged mycommand = New MySqlCommand Dim daMyName As New MySqlDataAdapter Dim dsMyName As New DataSet Try connection() mycon.Open() With mycommand .Connection = mycon .CommandText = "Select * from finaltickettable where work_group … |
| | Hi All I am creating a program which will (in the end) help me quickly transfer products from one category into another within a MySQL Database. I have a database with TWO separate tables which are connected using INNER JOIN where the products have a categoryID as do the categories …  |
| | hi, i have a project in my last year and have 2 queries i am using vb.net and sql server 2005 as backend first problem is, i have a search form in which a field called billno is searched and all details are displayed in datagridview but the problem is … |
| | hi.. i'm new in using vb... can anybody help me to check the problem inside my code? [CODE]Imports System.Data.OleDb Imports System.IO Public Class editMovies Private Sub editMovies_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim con As OleDbConnection = New OleDbConnection(conString) Dim cmd As OleDbCommand = New OleDbCommand("SELECT … |
| | Hi daniweb first of all, sry my english. I have a problem with at update code, I was hoping that U can help me, im new to this. i have a code where i get an id from another page, from update.aspx?id=1 up to 6 ATM. my code works fine …  |
| | [B]Read a CSV file into a DataGridView[/B] [CODE]'12/4/2011 'Code to read CSV file with headers using 'ACE.OLEDB.12.0 Connection 'The following is a Sampling of <EXTENSION.csv> 'The CSV file contains all the Extension on my Desktop Computer 'The full file has 923 Rows with Headers: 'EXTENSION,DESCRIPTION,EXECUTABLE_PATH '.mde,Microsoft Office Access MDE Database,C:\Program … |
| | Hello masters! I have a project and need a bit of your help. I would like to access/get values from certain fields from a database and assing that value to a variable. Database is included into my project along with DataSet. Is there any simple way to access certain field? …  |
 | [B]HI Friends..i want to import an excel file to DataGridView .In My code its working Fine For all excel sheet that have less number of columns...but its showing error(External table is not in the expected format.) for excel sheet having more number of columns...please help me...my code is below [/B] … |
| | Hi All, Finally getting somewhere with this project and can see the light at the end of a very long tunnel.. I have one more hurdle to overcome so any help in pointing me in the right direction would be greatly appreciated. I have a bound datagrid which I fill … |
 | HI i am trying to convert a doc file to a pdf file. please see my conversion code below [CODE] private string m_SourceFilePath; private string m_DestFilePath; public bool DoConversion() { bool returnValue; Word.WdExportFormat exportFormat = Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF; object paramMissing = Type.Missing; Word.ApplicationClass wordApplication = new Word.ApplicationClass(); Word.Document wordDocument = null; try … |
| | Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone … |
| | I have an assignment on recursion that calls for me to use recursion to find the largest element in an array. I have a general understanding on how recursion works but this problem throws me off because I can't figure out how to correctly implement the getMaximum() function which is … |
| | this is the code... I am trying to update a element from login table but it not showing any error massage or any thing execution is error free but finally whenever i check the database its not updated.. i'm using access2007 database with vb 2008.. PLEASE Help me.. [CODE] dbprovider …  |
| | Hi EveryOne, I have some problem in validating duplicate values while saving & updating my records to SQL database. I have following codes: [B]1. Decalaration Code[/B] [CODE] #Region "Declarations" 'Declaration for Navigation Dim inc As Integer Dim maxRows As Integer Dim ds As DataSet = New DataSet Dim dvEmpDesignation As … |
| | hi sir i m kunal raj want to share my problem pls help me my application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some … |
| | Hello! how to view report particular Customer Name.............in this code when i m type from date or To date report is showing all customer information but i need single customer info with name or Date this is my code........ plz help me sorry my english is not good [CODE]Imports System.Data … |
| | Hi guys i'm trying to just do a simple email/password validation on two text boxes. This code runs but when i type in a correct email address it throws an error "Object reference not set to an instance of an object." on [CODE]AdAcc.InsertCommand.Connection = OleAcc;[/CODE] I'm thinking i may need … |
| | Hello, I would like to get message, or true result when DataSet get new record (new row). But, I always get message as "no". Button1 is add new record [CODE]Me.Table1BindingSource.AddNew() [/CODE] Button2 is save a record [CODE] Me.Validate() Me.Table1BindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(Me.TestDataSet) [/CODE] Button3 should return "Yes" as new record has been … |
| | I would like to give me your help please.. I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where … |
 | I'm writing a program has access to a database (a database where an other software stores data that users type). This database has several colums, but in my code, i need to use the two columns that describes where the data is from, and the the date when the data … |
| | Hi guys ok guys this is my problem my DataGridView1 does not show the data on my testdb.mdb i need to fix this first before i continue on adding records on my db i very much appreciate any one who can help me with this. [CODE]Imports System.Data.OleDb Public Class Customer …  |
| | I am writing program that should allow the user to hit a browse button and be able to browse in their local directory to select a folder that they will later on save a file to. I know you can do this in windows forms but since I am using … |
| | Hello all! I am getting errors when I try to use this adodb.connection and command in my code. The error I am getting is saying that the connection and command are not defined. I read online that depending on your version of vb that you might use the "OLE" connection …  |
| | Hi guyz cn any1 help me i connected a vb program(vb 2008 express edition) with Ms access database(MS Access 2007) using a vb wizard which allows me to drag the labels of the dataset which appears on the left pane in vb,which automatically add a toolbox with the navigation buttons,add … |
| | I want to export my database selected information into word 2003/2007. If i use below code then it takes more time [10 minutes] for 20000 records to display. Is there any other way to display 20000 records into word 2003 /2007 within 10/15 seconds [CODE]Dim ds As New DataSet dscmd.Fill(ds) … |
| | Hi Is there any way to do nested mail merge in vb.net . i can do only simple mail merge. but not nested mail merge. My Code gives: [code] <District1> <District2> <District3> [/code] What i want [code] <District1> <Code ID><Code Name> 1 pcs 2 pcs <District2> <Code ID><Code Name> 14 … |
| | Hello, I have done a PHP project and on my localhost it is working perfectly but when I uploaded it on my webspace the CMS part of my website did not work as it is supposed to. The strange thing is that the client side of the website is working …  |
| | I am developing a point of sale program for a project subject. The trouble im having is when i press on the button to add the item from a textbox to a listview i receive an error: See attached Screenshot. my code is: [CODE]Private Sub SalesScreen_Load(ByVal sender As Object, ByVal …  |
| | Hey. I am fairly new to VB.NET so I research alot when I run into bugs. Problem is I cannot find a solution to this, or anything remotely dealing with it. I am developing software to connect to a remote mysql server, run a query, and come back with a … |
| | Hi Everyone. I am totally new here and this is my first post.. I have tried many place, since i could get any solution. I have no choice then posting here. basically, i have one delete form, where i will load the firstname from a table in access(hardcode) to listbox. … |
| | I wrote a code for a user to enter in their username and authorization, database and datasets and some other information all to be verified within the code. The code works fine but the problem I am having is basic formatting making it run cleaner and checking for all user … |
| | I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: [ICODE] using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using MySql.Data.MySqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) … |
| | Hi All, I am trying to do a search on a index/row number taken from a dataview i.e. I enter 379437 in the input box which I know has a index/row number of 6. Now when I replace the Rows(index) with a Rows(6) I get the results that I want. … |
| | Hi everybody, Actually I'm trying to learn C# by myself, and I was thinking to create a small program, I was thinking to build 4 buttons, First, Next, Previous, Last. I'm using Oracle express database. I tried my best before posting here, and this is my code for next and … |
| | what is the code to validate my upload pic.. this is the first form [CODE]Imports System Imports System.IO Imports System.Data Public Class ApplicantsInfo1 Private path As Bitmap Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click Me.Close() ApplicantsInfo2.Close() ApplicantsInfo3.Close() ApplicantsView.Show() ApplicantsView.pageInit() End Sub Private Sub Button1_Click(ByVal sender … |
| | Hello, im working on a project that works with an access database but i dont know how to edit an existing record... here is the code that i use for reading the database: [CODE]Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) con.Open() Dim da … |
| | I have code for a browse button and I wanted to know how to write the code to output a sucess message if it saves correctly. Also how to output the file path to a textbox... here is the code I have so far... [CODE] protected void Browse_Click(object sender, EventArgs …  |
| | I want to perform calculation in gridview :NetAmount=(ServiceAmount*Quantity)*Discount I had written code in rowdatabound but it is not working,i amnew to programming help me solve this proble i would appreciate if some one share ther knowledge my Axpx code is: <asp:GridView ID="GridView1" runat="server" Height="156px" Width="618px" AutoGenerateColumns="False" BorderWidth="1px" HorizontalAlign="Justify" onrowdatabound="GridView1_RowDataBound" BackColor="LightGoldenrodYellow" … |
The End.