2,634 Topics
 | |
| | Hello, I am trying to learn c# and sql server and I am not sure how should I proceed in the following situation: I have a database with 2 tables: Clients and OrdersFromClients I am trying to make a form with a listbox in which I will display all the …  |
| | Hi! Basically I am trying to add the graph inside the Jpanel which already exists. I am getting the erorr "adding a window to a container" Here is my code public void displayGraph(){ try{ String sql = "Select pressure, ventilage from statstbl"; DBCon conn = new DBCon(); JDBCCategoryDataset dataset = …  |
| | Hi guys I make program to select data every day automatically by timer every second in c# In sql server 2005 i write the following query ALTER proc [dbo].[JeddahSalesAll] as SELECT ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [S.N], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'OrderNo', dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live$Sales …  |
| | hi guys, i had an account on Daniweb but forgot password and recovery was a bit hectic so decided to crreate a new account. the previous username was emma etigu. i have a problem and need some help. below i have two tables from my dataset, i would like to … |
| | I am working on an application that will let a user make a graph using the number of hours that the user has slept. Currently the attached code will take the input and make a graph expecting an integer values from the user. I want to be able to instead, … |
 | Hi all :) I'm using VB 2008 and VB.NET I have a database data. Each column namely as name, age and hobby. For 1 person have more than one hobby. Each time user key in the name, it will directly display their age and hobby. So, I need to loop …  |
 | private void btnSearch_Click(object sender, EventArgs e) { if (searchtext.Text == "") { MessageBox.Show("Plese Inter Employee's ID you are searching for"); searchtext.Focus(); } else { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Employees.mdb"); OleDbDataAdapter ad = new OleDbDataAdapter("select * from Employee where EmpID=@EmpID", con); ad.SelectCommand.Parameters.Add("@EmpID", OleDbType.Integer); ad.SelectCommand.Parameters["@EmpID"].Value = int.Parse(searchtext.Text); DataSet ds = new … |
| | I have a chart that is being populated from a query in the vb code but when the chart is displayed there is an extra x-axis grid tick. How do i get the x-axis grid to only display the number of items being returned? **VB code: ** Public Function CLGenerateRevenueHistoryChart() … |
| | Hi guys i have problem this code send email based on timer every 5 minutes it working ok but my problem i need to determine first rcord updated not inserted and send email this is starting work this is my code Sales.SalesClass SalesClass1 = new Sales.SalesClass(); DataTable dt = SalesClass1.ShowSalesData("Data … |
| | Hi guys, I am a new member to the group. I am trying to build an inventory management application using VB.net 2008 express edtion and MS access 2007. I have managed to load the Combo box (cmID) on form(frmSales) with product Ids from tblProducts. I have two textboxes on the … |
| | Hi, so I have a dataset which I am using to create a CSV. When I run the code in debug mode and use the datatable visualiser all the data is shown, however when it opens in excel the last two cells of the last row are missing. I can't … |
| | Imports System.Data Imports System.Data.OleDb Public Class Chemical_Details Dim MyConnection As OleDbConnection Dim MyDataAdapter As OleDbDataAdapter Dim MyCommandBuilder As OleDbCommandBuilder Dim MyDataTableChemical As DataTable Dim MyDataSet As DataSet Private Sub Chemical_Details_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MyConnection = New OleDbConnection 'Creates OleDB connection MyConnection.ConnectionString = "Provider= Microsoft.ace.oledb.12.0;Data … |
| | i am new in VB.net (about 3 weeks now) and i am using visual studio 2008 to make a reservation and billing program project. i want to change the background color of the row having the entry which time (Day Swimming 8am-5pm, night swimming 4pm-11pm and overnight swimming 9pm-11pm) will … |
| | hi guys, i have start working with C#, i m making a simple application for my office, i m using mysql database. my question is i want to make a record navigation button like: Next, Previous ..... kindly guide me how to make this. i m using mysql database with … |
| | Hi All, I am trying to create a new report in VS2010 using reportviewer. The report must use data from two dufferent databases, I would rather not have to create a temporary database and then populate it with the data and then create a new dataset. I also can't get …  |
| | Form1.cs public partial class Form1 : Form { DataSet ds = new DataSet(); DataTable table = new DataTable(); //List<Pessoa> p = new List<Pessoa>(); public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { //Add Columns to DataTable (table) table.Columns.Add("Nome", typeof(string)); table.Columns.Add("Idade", typeof(string)); table.Columns.Add("Profissão", typeof(string)); table.Columns.Add("Signo", typeof(string)); table.Columns.Add("Morada", typeof(string)); … |
 | so i need to download free dataset UKM06-1.slt... i have tried this link [Click Here](http://www.ftsm.ukm.my/jabatan/tk/masri/Exam/) but it wasn't found. need help from you.. thx  |
 | I have problems for loading data from draft in my project. On the homepage (Default.aspx) under the tab "Drafted", when I want to edit the drafted data on another page (DraftRegister.aspx), it didn't show up the drafted data, just only empty and default values.  Can help me check … |
| | Hi ! I am working in a project using vb.net 2010 with SAP Crystal Reports. Regarding the Reports everything is fine but i had an unusual problem. Actually i have to make a report using sub report technique but when i call the main report that calls another sub report … |
| | I have a gridview that is being populated from a dataset which is a table returned from a stored procedure. However now the stored procedure has changed and it returns 2 tables, the first returns the column headers as well as labels and other info, the second is the table …  |
| | Let's say i have a table with the column names : 'One' , 'Two' , 'Three' ... Column 'One' has values 'A' , 'B' and 'C' Column 'Two' has values 'D' , 'E' and 'F' Column 'Three' has values 'G' , 'H' and 'I' In my code(im not sure if … |
| | I have an excel sheet with 2 tables both wit 6 columns an each starts at columnB Table1 with headers starts at B16:G16 AND ENDS AT B62:G62. Table2 with headers starts at B91:G91 AND ENDS AT B118:G118. I want to load table1 to Datagridview1 and table2 to Datagridview2 Please help …  |
 | A look at [Dataset](http://dataset.readthedocs.org/en/latest/) and easy and Pythonic way to create a database. Other candidates in this categorie,i will mention [pyDAL](https://github.com/web2py/pydal) and [Peewee](https://peewee.readthedocs.org/en/latest/). I did some test of Dataset in this [post](https://www.daniweb.com/software-development/python/threads/490219/how-can-i-creat-e-text-file-to-use-as-a-database-in-python) to look at. So here a common task some web-scraping of food recipes(just a task i did help … |
| | When user click on the button "back",it should go back to "HomeStudent.aspx",but unfortunately its not working and no error shown.Do help me. <%@ Page Title="Advertisement" Language="C#" MasterPageFile="~/AccommodationStudent.master" AutoEventWireup="true" CodeFile="Advertisement.aspx.cs" Inherits="Advertisement" %> <%@ Register TagPrefix="ajax" Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> <style type="text/css"> .style1 { width: 224px; } </style> </asp:Content> … |
| | Dear fellow programmers, I have tweaked this code for some time, and again failed. I want the user to select a client in the combobox and its text, with date range (two datetimepickers) the results will show in a click of a button. CODE for DataGridView search results: Dim ConnectionString … |
| | Hello, I have a problem with my connection to the emulator mySql when I log on to my games and I run a command me his crash, is when I see her in my my emulator me this error: Error Message - Connection must Be valid and open (System.InvalidOperationException), its … |
| | Dear fellow programmers, I am trying to build a form that has two datetimepickers (for date range) and one button. When a user clicks the button the datagridview will show results according on the date range (by the two datetimepickers). This is my code so far: Dim dbconnection As New … |
| | If I have a datagridview that is bound to a dataset which comes from a MSSQL database, how can I have the datagridview display only one row of data from the dataset rather than all of the rows? Specifically, the first column is a combobox which is bound to the …  |
 | Imports System.Data.OleDb Imports System.Data Imports System.Web Imports System.Web.UI Partial Class _TakeSurvey Inherits System.Web.UI.Page Dim sid, query1, query2, query3, query4, query5, query6, qnos, currentQ, q_type, filledby, qid, status1 As String Dim dbcon As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _ "Data Source=|DataDirectory|SurveyDatabase.mdb" Dim con, conn, conn1, conn2 As OleDbConnection Dim da, da1, da2, …  |
| | Hi Guys I have a GridView inside a tabcontainer with some bound data fields , i have set Autogeneratecolumns=false; ShowHeaderwnenempty=true; But i can't see header or grid anymore when run but it is visible on design mode, but if i manualy bind it gridview.datasource=dataset; gridview.databind(); it is showing header and … |
| | I can post a single line of row I selected from datagridview but I want to select specific multiple rows then display it in my crystal report. BTW I'm using VB2010. Dim cmd As New OleDbCommand("Select * From Data1 Where ID = " & Form4.DataGridView1.SelectedRows(0).Cells(0).Value.ToString() & "", Form4.con) Dim adpt … |
 | i have a datagridview and a combobox. the combobox is auto populated by values from a database. i need to filter the datagridview using combobox. this is the code that i've done. it shows a error : Cannot find column [year]. can you help me??? Imports MySql.Data.MySqlClient Public Class ReportGradeLevel … |
 | I'm trying to compare a date obtained from maskedTextBox accepting short date, with a date from an excel sheet. I need to select those rows from excel file that are equal with the date from the maskedTextBox and display them in datagridview. The problem is that i don't get any …  |
| | Hi I am creating a report and I am filtering the columns of my table through a parameter. But I then add a few textboxes but I can not find a way to filter the values to show in these based on the parameter. Anyone who knows if this is … |
 | <item> <HaberKodu </HaberKodu> <Kategori</Kategori> <Sehir</Sehir> <title</title> <description></description> <pubDate></pubDate> <images> <image> 1 </image> <image> >2 </image> <image> 3 </image> <image> 4 </image> <image> 5 </image> <image> 6 </image> </images> <small_images> <small_image>1 </small_image> <small_image> 2 </small_image> <small_image> 2 </small_image> </small_images> <Aciklamalar> <Aciklamala>1 </Aciklamala> <Aciklamala> 2 </Aciklamala> <Aciklamala> 3 </Aciklamala> </Aciklamalar> <link> </link> …  |
| | Hello, I'm trying to import xlsx to datagrid using oledb. but i'm geting this: Syntax error (missing operator) in query expression.I've read other related posts but didn't helped this is the code: private void button1_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\alm1.xlsx" + @";Extended … |
| | This is a SMS DLR application from http://www.smsgatewaycenter.com which is sent by them to my client's url and I need to configure for my client the same from my client's url to his reseller's url. This script uses every 1 hour to post data to my client's reseller/customer. So, it … |
| | Hi fellow members of Daniweb. I've been working on project for the past few days now, and have come across a bump, that i am unable to pass. The project, when finished, will do the following: 1. Select DBF file from computer location (Default C:) 2. Import the database file … |
| | Hello All we want to print datagrid view's 20 records per page, but it seems LIMIT Command is not working and shows error plz can any one help or suggests alternet. this is our coding. ANPSql = "Select * from Table1 limit 0,20" MsgBox(ANPSql) Pth = My.Application.Info.DirectoryPath ANPConn.ConnectionString = "Provider=Microsoft.ace.oledb.12.0; … |
| | hello friends I am trying to convert a vb.net datagridview code into asp.net. I want to display last three rows of table column from database table in gridview column1. Dim dt As New DataTable ' Create columns dt.Columns.Add("column1", Type.GetType("System.String")) dt.Columns.Add("column2", Type.GetType("System.String")) dt.Columns.Add("column3", Type.GetType("System.String")) dt.Columns("column3").Expression = "[column1]+[column2]" dt.Rows.Add("", "") dt.Rows.Add("", "") … |
| | I have currently written a way to rank fixed length DataSets however I am looking for additional methods which can be used to improve the ranking and results. See the dataset below with the test data: [Fixed Length Column 1] This is a test subject This is test subject01 Ideally … |
 | I am trying to show data on datagridview but error occurs Form1.vb code is as below Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.String Imports System.Configuration Imports System.ComponentModel Public Class Form1 Dim con As SqlConnection Dim cmd As SqlCommand Dim dr As SqlDataReader Dim da As SqlDataAdapter Public … |
| | Hi to all, I have to preview dataset data using printdoc and my code is below. Upon clicking the Preview button the preview dialog displays fine with data. when I close the preview dialog then click the preview button the data is not diplayed. weird behavior to me. what should … |
| | I have a problem updating table from datagridview in vb.net to sql server. I have posted the code below. I am importing connectionstring from connection module. It used to be working but I dont know what went wrong and now it isnt. Imports System.Data.SqlClient Public Class frmreportsp Dim cn As … |
| | I have a app, that requires login with SQL server as backend. I have users who are on laptops and not always connected to the network. I want a way to check for the SQL server, and if it does not exist then roll over to local auth for local … |
| | Hello, i try to develop some application for inventory and transaction using VB.Net with database access i have a problem with query result, it looks like not using newest database when application already run. for example : i have MS access table like this ID CustomerName 1 John 2 Doe … |
| | Hi guys when i search record between two dates it works ok success but you must enter date from and dateto first to to make search i will show what i need from this example I need to search dynamic by 4 textbox 1-datefrom 2-dateto 3-EmployeeNo 4-EmployeeName but search i …  |
| | I want use Inner Join link 2 table and display in a datagridview. For example, PDC_FG Table contain PONO,Customer Customer Table contain Customer, Zone 2 table has same field is Customer. [CODE]ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["MyDBConnectionString"]; string name = conSettings.ProviderName; string providerName = conSettings.ProviderName; string ConnectionString = conSettings.ConnectionString; string sql = … |
| | Hi Guys, I hope you can help me out... I have a slight issue in where the 'Search Box' Code I currently have seems to sift through the Populated Data Grid View fine. However, when selecting an Account that has been filtered by the use off the 'Search Box' it … |
| | I am exporting data from excel and show it in gridview and when I click submit, it needs to be updated in existing table. Below is my excel data S.No. RequestID Subdivision No Parcel No CUID Status Remarks 1 5 42 55 55 Open Pending I have successfully exported and … |
The End.