- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
45 Posted Topics
 | Good day guys I need help for adding rows in datagrid where the rows to be added are equal to the number of rows copied from excel. I can copy the data but it displays only the first row from excel on the last row of datagrid but if I … |
| | 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'm having a hard time in grouping my data via ReportViewer. My friend told me to use List in grouping but I don't have a clue on how to do it so I'm requesting help from you guys if you can teach me. Thanks  |
| | I noticed that I can't use a field that has an expression ex: Fields!date_due has an expression where if Fields!term.value = 7 it will add 7 days on based on the Fields!date_invoice. I want to get the days overdue based on the interval between Fields!date_due.value and Fields!date_collected. Normally I would … |
| | 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 … |
 | Could you post your work so far? Based on the title of your post may be you didn't put a value in your primary key field. If you can post your codes we can help you. |
| | try using shortdate format in your db and in your datetimepicker |
| | Are you using a join or something similar in pulling your data or using an alias on some of your columns? Crystal report is sensitive on column names try to use alias if you are using join to match the column name in your crystal report. Ex. You have ID … |
| | You can use SQLDataAdapter and SQLCommandBuilder. It will generate Insert, Delete and Update Command cmd = New SQLCommand("Select * From table", con) con.Open() adpt = New SQLDataAdapter(cmd) Dim builder As SQLCommandBuilder = New SQLCommandBuilder(adpt) dtset = New DataSet() adpt.Fill(dtset) DataGridView1.DataSource = dtset.Tables(0).DefaultView con.Close() As for the save button. Try Me.Validate() … |
| | Is your database password protected? Just as OtepTheThird said it's just as logon/logoff problem but then again it can also be a password protected database. |
| | 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, … |
| | Hi guys I'm having problem in crystal report where my inner join is a success but of my 3 fields that are affected dowsn't show up. The values from 2 tables that match is showing on the crystal report but the 3 fields that has a match doesn't. Tried inputting … |
| | Guys I need your help again I use this code to copy values from excel spreadsheet to datagrid. Try 's = Clipboard.GetText() Dim tArr() As String Dim arT() As String Dim i, ii As Integer Dim c, cc, r As Integer tArr = Clipboard.GetText().Split(Environment.NewLine) r = Form1.DataGridView1.SelectedCells(0).RowIndex c = Form1.DataGridView1.SelectedCells(0).ColumnIndex … |
 | Try this. It let's you copy the values from a ceratin cell up to the last cell with value. The copied value will be in clipboard. xlWorkBook = xlApp.Workbooks.Open(location of your spreadsheet) xlWorkSheet = xlWorkBook.Worksheets(1) '1 indicates the first worksheet, 2 indicates second, and so forth Dim last As Excel.Range … |
| | You can use OLEDB Command Builder. It will generate, Update, Delete, and Insert commands for DataAdapter. Note: You should have a Primary Key in your DB for this to work. Private Sub Src_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Src.Click Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & … |
| | What happens when you run your code? Try removing the ds.Tables.Add(dt) in your code. Edit: Sorry for Necroing. |
| | Value5 = Value1 + " " + Value2 + " " + Value3 + " " + Value4 It works on TextBox I don't know if it will work on a variable |
| | 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] … |
| | Hi guys I need your help once again. I can update a record from excel through datagrid but I've encounter a problem where instead updating in number/percentage format(I have columns in number format and in percentage format) it updates in General Format. Example: col1 col2 col3 abc 123.00 100% -------> … |
 | Use Try Catch method Try 'Your Backspace code Catch ex as Exception MsgBox("No Value") 'I use MsgBox to notify that there's no value. 'Feel free to use other methods you see fit End Try |
| | Hi guys can you help me in this one? I can add cell values in Datagrid using their column address or column name but I want to add the columns which contain a specific word for example I want to add all cells with a column name containing "Amount" Dim … |
| | Hi guys. I need help in updating Excel files through Datagrid. I can update it through a fixed update sql statement(Update table_name Set field1=value1, field2=value2 Where ID=unique_no) but I encountered a situation where a spreadsheet can have 3 columns, sometimes 5 and so on. My point is can I update … |
| | Hi guys about my previous post on [Copy Selected rows from Datagrid to another](http://www.daniweb.com/software-development/vbnet/threads/471088/copy-selected-rows-from-datagrid-to-another) that was answered by oussama_1 and Deep Modi, I was wodering if is it possible to detect that there is a similar row between the 2 Datarids to avoid redundancy? Does it require a datatable or …  |
 | Re: Crystal Report First do a SQL statement with Join. I'm going to use Left Join but feel free to try other Joins you see fit in your project Select sales.cu_id as [cu_id], sa_no, sa_date, ledger_id, payment, payment_date, total from sales Left Join ladger on sales.cu_id = ladger.cu_id Drag all the columns you … |
| | Hi guys I need help in deleting rows in Excel. What I want is if I delete a row in DataGridView it will also delete a row with the same value. I tried using the OleDb way and I find out I can't delete a row using that so I … |
| | Hi guys I'm having a problem in opening excel files using the workbook.open for me to save all the changes made by oledbcommands. Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") MyConnection.Open() Dim i = 0 Dim h = Label1.Text Do 'Dim q = … |
| | The alias should match the column name you are about to show in the report. Ex. You want Sched_Code to show inthe report from your query of 2 tables. First put Sched_Code in the Crystal Report then make your query. Your query should be this. Select [ts.Sched_Code] as [Sched_Code] From … |
| | Hi guys. I need help in copying selected row from DataGrid to another. What I want is if I click a row it will be copied to another DataGrid. I set my DataGrid Selection Mode to FullRowSelect. Is it possible for me to update my database using the copied rows. … |
| | Hi guys. I'm having problems in updating records in Excel. Whenever I update a cell the value I input it goes 4 cells above the intended cell and I know the reason. In my Select query: `SELECT * FROM [Sheet1$A5:R1048576] where [ITEM CODE] is not null` Meaning I skipped reading … |
| | Hi again I want to display my table in excel to my datagrid. I want select the 5th row of my spreadsheet as the column header. I have no problems of displaying it in DGV when my column header is at the first row. Now I need to have my … |
| | Hi guys I need help on adding a value from 1 row to other column 1 row below. I know it's kinda confusing so here's what I want to do: Column_A Column_B Column_C 1 25% 25% 2 15% 40% 3 25% 65% 4 35% 100% So far I don't have … |
| | I suggest to use your code from frmUsers. Add it below MessageBox.Show("Users Added Successfull") from btnAdd. One more thing you don't need the ".show" on your MsgBox as it will pop up once the insert is done MsgBox("Users Added Successfull") Dim cnn4 = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Renz\Documents\Visual Studio 2012\FINAL\Database\AuditDB.mdb;") sql2 = … |
| | I was wondering if I can fill up an edited row based on the value in my Label. Here's the scenario: An employee will add and edit rows in the DataGridView1. All rows involved in adding and editing will fill up the last row with the Employee ID of the … |
| | Hi I need help in making an auto complete feature in my datagridview where if I input a certain cell it will automatically have a value or it will have a autocomplete suggestion (like a textbox link to a table) based on my other table. I don't have any clues … |
| | How do you add your records? Is it from TextBox or DataGridView? If you are adding records in TextBox: Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.ace.oledb.12.0;data source=C:\test.accdb") Dim cmd As OleDbCommand = New OleDbCommand("Insert Into Table(Field1, Field2, Field3) Values('" & TextBox1.Text & "', '" & TextBox2.Text & "', '" & … |
| | As the title says I'm having trouble in my Vehicle Maintenance routine where I will have a a monthly maintenance based on the last maintenance date. If the vehicle has reach 1 month since last maintenance it will show in a datagrid. Also it should select those vehicle that reach … |
| | Good day guys. I'm having problems in my crytal report where it doesn'y load any record. Yesterday it was working I can see all my records but now It doesn't. It's not loading any record like it suppose to. I was wondering if it has to do on the CR … |
| | hi I'm having problems in my crystal report where all the selected rows in my datagrid will show up in my crystal report but instead it showing me an exception selectcommand.connection has not been initialized here's my code in my form where the datagrid is: Dim cmd As OleDbCommand = … |
| | I want to know how can I trigger an event or at least display it in a Datagrid from database. Here's the scenario: DateFile Plate Driver EmpID OdometerBefore OdometerAfter 9/25/2013 ABC123 Jared 00369 4000 8000 9/27/2013 DEF456 John 00246 3000 8000 10/9/2013 ABC123 Jared 00369 8000 14000 10/9/2013 DEF456 John … |
| | Try this Dim conn As New SqlClient.SqlConnection ("Your db provider, data source and password") Dim cmdlogin As New SqlClient.SqlCommand("SELECT ID, PASSWORD, LOGINTYPE FROM TblUser WHERE ID = '" & txtUsername.Text & "' And PASSWORD = '" & txtPassword.Text & "'", conn) conn.open() Dim dr As SQLDataReader = cmd.ExecuteReader If dr.read …  |
| | Good day to all I was wondering if it is possible to show all data in a datagridview that doesn't match from 2 tables? Like Inner Join if you have at least 1 match data from the other table it will display it. What i want is to display those … |
| | Hi again............ I'm having problems in saving the data in my datagrid to my Database Imports System.Data.OleDb Public Class Form2 Dim con As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\RMC\Documents\Vehicle.accdb;") Dim cmd As OleDbCommand Dim adpt As OleDbDataAdapter Dim cb As OleDbCommandBuilder Dim sql, lol As String Private Sub Form2_Load(ByVal sender As System.Object, … |
| | Just load the database again after you insert, update or delete records I use this code myCommand = New OleDbDataAdapter _ ("select * from TableName", MyConnection) DtSet = New DataSet myCommand.Fill(DtSet) DataGridView1.DataSource = DtSet.Tables(0) If you made your connection using the wizard thingy you're talking about. I hope this helps … |
| | So far I can compute and update seperately a specific row when type it in a text box. What I want now is to read and update rows automatically up until the last record. Imports System.Data.OleDb Public Class Form1 Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=G:\Raw Data.xlsx; Extended Properties=Excel 12.0;") … |
| | Hi I'm new here. I'm making a barcode calutator and I want to know how can I get the positions of all integer in a string because I need their position for calculations. Thanks in advance |
The End.