2,634 Topics
 | |
| | Hello. My VB.Net project is connected with MS Access. Whenever input in VB, it will save in Access. I don't have any problem with textbox but I don't know what to do with checkbox and radiobutton. I want, when checkbox or radiobutton is checked in VB, it will checked also … |
| | hii frnd i need your help i am work on vb.net window application my qus is IN COMBO BOX I SET THE VALUE FORM THE DATABASE AND IT'S SHOW IN COMBO BOX LIKE NAME BUT NOW IF I SELECT NAME THEN OTHER INFOMATION LIKE EMAIL ID OR ETC ARE ALSO …  |
| | I am trying to get data from the SQL database with stored procedure using dataset and populate that data in combobox. It gives error as cannot find table 0. SqlConnection conn = new SqlConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; SqlCommand cmd2 = new SqlCommand("GetBatch", conn); cmd2.CommandType = CommandType.StoredProcedure; cmd2.CommandText = "usp_CAMR_GetBatch_Status"; cmd2.Connection …  |
| | Good day guys! I just want a little help on how to reference a repeater control in a function. Im using c#.net. My code below: private void Load_Childrean_byTypeID(int TypeID, **repeatername reference here**) { SqlDataAdapter mycommand = new SqlDataAdapter("Select Id, FoamType_ChildName, ChildIcon_ClassName, ParentTypeID From tbl_ProductType_Children Where ParentTypeID = " + TypeID, …  |
| | this is my code for loading the data in my database going to my datagrid Private Sub Records_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=Microsoft.Ace.Oledb.12.0; Data Source=" & My.Application.Info.DirectoryPath.ToString() & "\BackUp\Database3.Accdb;" Dim MyConn As OleDbConnection Dim da As OleDbDataAdapter Dim ds As … |
| | Is it possible that when writing this: Dim ds As New DataSet Dim dt As New DataTable ds.Tables.Add(dt) Dim da As New OleDbDataAdapter da = New OleDbDataAdapter("SELECT * FROM [Football Questions]", con) da.Fill(dt) lblQuestion.Text = dt.Rows(0).Item(1) lblAnswer1.Text = dt.Rows(0).Item(2) lblAnswer2.Text = dt.Rows(0).Item(3) lblAnswer3.Text = dt.Rows(0).Item(4) lblAnswer4.Text = dt.Rows(0).Item(5) lblCorrectAnswer.Tag = … |
| | Step-by-step 1) I’ll continue from the previous post. You can download a project file from the previous post at here – SampleMySQL (zip format). The project was created on Microsoft Visual Studio 2005. 2) Open the Design view of Form1. 3)Drag DataGridView tool from the Toolbox window to empty area … |
| | I am making a multiple choice quiz in vb with the questions and answers stored in an access database. When trying to display the question and answers on my labels, they don't change. Here is my code: Imports System.Data.OleDb Public Class Football_Questions Dim con As New OleDbConnection Private Sub Football_Questions_Load(sender …  |
 | Forgive me, but I've only really used WinForms in the past, and MVVM and WPF are new to me. For those who use MVVM with WPF, do you actually make separate directories (namespaces) for your Models, Views and ViewModels files or is it more of an abstract idea? I fundamentally … |
 | Hi. I have a MVC project with a form and a submit button. The values are passed to the controller. One method will fetch data from the dataset according to the parameters passed. Then some VB functions will work with the data retrieved. Currently I have the whole dataset being …  |
| | I'm updating my database using this code. only id and attendance date is updated but the time(AM_TIME_IN etc...) is not updating. What could be wrong? I'm using access and time(AM_TIME_IN etc...) datatype is shorttext Dim a As String = Now.ToShortTimeString If a.Contains("AM") Then a = "AM" Else a = "PM" …  |
| | Dear all, I have created project database in msaccessdatabase. It contail  form layout as shown in image & i have attached code for reference Imports System Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the … |
| | Hello. I have a SQL database called bd with a table called dados. I want to get one row from it. Web.config <add connectionString="Data Source=(local);Initial Catalog=bd;Integrated Security=True" name="bd" providerName="System.Data.SqlClient"/> variable declarations Dim DS As New bd Dim a1row As bd.dadosRow this code in the method won't return anything. In fact … |
 | Although it took eBay itself an absolute age to disclose that a serious breach had taken place, and then [completely screwed up the process of ensuring users change their passwords](http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/news/479152/more-ebay-security-stupidity-exposed), this should come as no real surprise. Happygeeks' Law states: the larger the corporate, the longer it takes to admit … |
| | Good afternoon fine DaniWeb folks! I am about to pull my hair out on this one and I'd like to know if someone knows of a simple or obvious "gotcha!" for this problem. I've got a form with some detail fields on it (below)  When a user attempts … |
| | Hi, I'm trying to create cascading comboboxes, and my code isn't working. I've looked at other threads and I don't know why it isn't working properly. The first combo box displays System Names and the second combobox should populate the all Locations of that specific system chosen. When I run … |
 | Dear sir, I have basic knowledge of VB .net I want to sum records (integer) of a column in a table if I give a specific value (text) in a field. Dim ds As New DataSet Dim AccessConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=p:\inquiries.mdb;") Dim sql As String = "Select SUM(orders_amount) FROM … |
| | Dear all, I have created database like this. I have 2 manufacture . I would like to create 2 combobox. COmbox 1 -> Manufacture list combox 2 contain -> model no Can some one share example code where it explained. if particular manufacture selected display only his model in combobox … |
| | Dear all, Here i have attached form window.I wanted to update form with relative data How to refresh the single form. When New project detail is clicked from loaded with project data , when panel button clicked form loaded with panel data. 1)I tried this method. I created a group … |
| | Hello: this is my first window app in .net and have been assigned to create a form that contains a datagridview. I decided to leave it unbound, because I need it to populate in a slightly unconventional way. I also created each column and set them as drop-downs in the … |
| | Hi All Masters, According to advice from master shark 1 and read [Tutorial about BackgroundWorker](https://www.daniweb.com/software-development/vbnet/tutorials/477520/how-to-use-backgroundworker-to-create-threads) created by Rev.Jim I'm trying to use BackGroundWorker for querying database an set new labels...here's my code: Private Sub FormMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load BgWorker.RunWorkerAsync() End Sub Private Sub BgWorker_DoWork(ByVal … |
| | Hi All Masters This is my Second question and problem ...i have some code here Sub SetLabels() Call MySqlConnect() Dim str As String str = " Select * from room " da = New MySqlDataAdapter(str, conn) ds = New DataSet da.Fill(ds, "room") For i = 0 To ds.Tables("room").Rows.Count - 1 … |
| | Thank you in advance. I believe the items below should give a whole view. .Net 4.5.1 / x86 When using a SqlAdapter with new SqlParameter() { SqlDbType = SqlDbType.DateTime, ParameterName = "@FromDate", Value = "09/01/2008" }, I get the error "Conversion failed when converting date and/or time from character string" … |
| | Hi All Masters I'm trying to create a form with multiple labels from mysql database, im confused to add newlabel text from records here's my code Dim str As String str = " Select koderoom from room " da = New MySqlDataAdapter(str, conn) ds = New DataSet da.Fill(ds, "room") For … |
| | Hi, I have recently started working with SQL databases of which I have 0 previous experience. I have added the datasource to my project using the Visual Studio wizard and the DataSet appears in my solution explorer. Everything that I have read thus far has shown connecting to the SQL …  |
| | Hello everyone, I've a little problem with updating my Access DB. I use this code to update my db in vb.net. Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click Try oledbCmdBuilder = New OleDbCommandBuilder(adapter) changes = ds.GetChanges() If changes IsNot Nothing Then adapter.Update(ds.Tables(0)) End If ds.AcceptChanges() … |
| | I have added form1 and on it 2 text boxes. text box1 to accept fromdate and textbox2 to accept todate. After this,I added Crystal report from Add new Item. Then in Crystal report I added table and its columns. After that I wrote code behind form1. The code is not … |
| | Dear brother Sorry for my bad english Please help me in this case I import with big data to Datagridview It's take long time, and i want to using progessbar for wait I try to do this But it's seem not good Please help me Thank you so much! `Inline … |
| | Hi there, I have have a challenge with my application. I am developing it using VB.Net and SQL server 2014. My database contains 2k plus records. I used to search and return the results very fast when the database was still small. The problem now is that whenever i try … |
| | Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As …  |
| | Hi guys! I'm getting frustrated with my code because my filter in my query is not working. All of the item_model in my receiving_details table were being suggested in auto complete but as you can see in my query that I'm filtering item model with a certain form_no. Please help … |
| | I have a 3 character fkLookup field sat_site in a table. I'm using TAdsTable table component. When I filter out records in my grid on a field sat_site, grid does not show any records. With ShowMessage() I check the value of field sat_site which shows blanks or boxes in the … |
| | Hi to everyone, i am trying to display certain data onto some labels depending on the selection the user does from a combobox. The database consists of two tables, RegisterShipment and Shipments, where the RegisterShipmentID is linked to the Shipment Table by a Foreign Key. On the form i have … |
 | I really tried with the title! I could not find what I was looking for through google or here. Seemed like something that could be common enough that I'd find it online already but perhaps it's so simple that no one had a problem doing it so they did not … |
| | I do have a dataset with id date code 1 02/02/2012 A 1 02/07/2012 B 1 02/21/2012 A 2 02/02/2012 C 2 02/09/2012 A and I have to create a grid with the days in february and insert the code in the coresponding days id 1 2 3 4 5 … |
| | Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & … |
| | dear members, i need help, i have one datagrid and two dataset with two diff. tables, what i want is to insert data into datagrid and save grid data to other tabel in sql server. |
| | I know to save records from database into listview, but how to save listview to database instead.. this is the code for showing record into list view..but can any help me how to change the code to save listview into database? Imports System.Data.OleDb Public Class Form1 Dim con As New … |
 | Can anyone check my search code? What seems to be the problem? **ERROR: **Object variable or with block variable not set. Dim con As New SqlConnection(connectionString:="Data Source=APBIPHAP06; Initial Catalog=PMT; Integrated Security=SSPI") Dim ds As New DataSet() Dim da As New SqlDataAdapter() Dim query As String = "SELECT * FROM tblPM … |
| | Hi There, here is a form from my VS2013C Project  As you can see, there are 9 labels that need filling. My Question is, can I load the dataset with 9 different select statements from the same Table, and then fill the 9 labels with the correct data.? … |
| | Can you help me to add Next and Previous Buttons to this code please: Imports System.Data.SqlClient Public Class Form1 Dim id As Integer = 0 Dim idindex = 0 Dim command As SqlCommand Dim adapter As SqlDataAdapter Dim builder As SqlCommandBuilder Dim ds As DataSet Dim table As DataTable Dim … |
| | Dearl all, Is there any way or codes for export dataset or datatabe to excel file. Whenever I use click event in the button, it will save my report in an excel file. My information inside in datatable (dataset) from database and I want to save it in excel file. …  |
| | I've been sitting here staring at this code for a day now, and am quite ready to light my computer on fire and throw it into oncoming traffic. The error I recieve is: System.Data.OleDbException Syntax error in INSERT INTO statement. I think everything is spelled correctly. I'm expanding on a … |
| | i have following code @model EMS1.Models.UsersViewModel @{ ViewBag.Title = "List of users"; var grid = new WebGrid(source: Model.users, canPage: true, rowsPerPage: 10); grid.Pager(WebGridPagerModes.All); } @{ ViewBag.Title = "IndexViewModel"; } <script src="@Url.Content("~/Scripts/jquery-1.6.1.min.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/jquery.validate.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.js")" type="text/javascript"></script> <h2>Grid</h2> <style type="text/css"> .table { margin: 4px; border-collapse: collapse; width: 300px; } … |
| | This is an R script which I used for plotting. Can anyone please give me a python code for this. Thanks in Advance !! setwd("/pipeline/deff") source('http://www.bioconductor.org/biocLite.R') biocLite('cummeRbund') library(cummeRbund) cuff_data <- readCufflinks('deff') pdf("allplots.pdf") #"distbtn of expression levels for each dataset" plot(csDensity(genes(cuff_data))) #"compare the exp of each gene in all the conditions …  |
| | **BUTTON SAVE** Private Sub Button12_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button12.Click get_kon() Dim simpan As SqlClient.SqlTransaction = kon.BeginTransaction Dim command As SqlClient.SqlCommand = kon.CreateCommand bersih() Try With command .CommandText = "InputAnalis5C" .CommandType = CommandType.StoredProcedure .Connection = kon .Transaction = simpan .Parameters.Add("@NONAS", SqlDbType.NVarChar, 12).Value = TextBox1.Text .Parameters.Add("@NAMA", SqlDbType.NVarChar, …  |
 | Hi Guys I am coding as very simple database in VB.net. I have decided to manually code my buttons but for some reason my save button returns with an error. Below is my code for my entire program (I know its not perfect). This is the error i Get: An … |
| | I am calling function (i don't know, if this code is really called function.. so please correct me if i'm wrong) to disable the fields except for buttons and other necessary information needed during form load. But my problem is, some fields are not disabled. My application goes like this: … |
| | In my windows form, I have a combo box which is populated with (part code)values from my database and I'm finding it hard to set each equivalent (part name)value to a text box which is in the same table. I was able to populate combo box values using the code … |
| | need some assistance. I am currently learning vb.net with sql. I have two textboxes (txtValue and txtText) , a dropdownlist (ddl1) and save button (btnAdd). I insert value to txtValue and txtText (eg: txtValue: A and txtText: Apple). when i click button Add, The value will display in dropdownlist (like … |
The End.