- Strength to Increase Rep
- +4
- Strength to Decrease Rep
- -1
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
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 … |
|
i have two tables in access and i want to update datagridview which is made from joining of these two tables, how update this datagridview in vb.net |
|
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 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 … |
|
I have vb.net application with SQL server express. Here is my code to save data to database, but itn not working. Here ID is not the primary key. Imports System.Data.SqlClient Imports System.Data Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim cmd As New SqlCommand Dim … |
|
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 … |
|
Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help. I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's … |
|
I am using vb.net with OleDb database. Following is my code, although i am to search database but not able to save after making changes. It displays following error at Command.ExecuteNonQuery level as OleDbException was unhandled, Data type mismatch in criteria expression. Imports.Sysytem.Data.OleDb Private Sub Form1_Load(ByVal sender As System.Object, ByVal … |
|
Hi..all I'm newbie in VB.net Please Help me.. How to search data by textbox and datetimepicker access 2003 database in VB.net Exp : I want to search for data based on the Part name and two datetimepicker I try with code like this but the results are not in line … |
|
Hi everybody, I''m knew with VB.Net I want to insert different value into one field value. For example: Value1: this Value2: is Value3: a Value4: test I want that Value5 become a string: This is a test. There must be space between the words. How can I achieve this? Regards, … |
|
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% -------> … |
|
I have a backspace key button. Then I have two text boxes. Well, it is working but when the letters in a certain text box are all cleared up then i keep on clicking the button I get this errror. This is the code: desiredTextbox.Text = desiredTextbox.Text.Substring(0, desiredTextbox.Text.Length - 1) … |
|
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 … |
|
I hav two tables sales (sa_no,sa_date,cu_id,total) ladger(ledger_id,cu_id,payment,payment_date) I want to display the transactions of a customer (cu_id) in one crystal report in the order of dates ,such as sa_no sa_date total ledger_id payment payment_date ie one row from sales then one row from ledger for the customer cu_id Please help … |
|
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 = … |
|
str1 = "select distinct [Sched_Code] as [No.], [Course], [Year], [Section], [Batch]," & _ " [Subject],[subject_desc],[units], [Time], [Day], [Room], [Instructor], [Schoolyr] as [S.Y.], [Semester] as [Sem] from tblSchedule, tblcurriculum where tblschedule.subject=tblcurriculum.subjects" Dim dt As New DataTable dt = ConnectDatabase(str1) rpt.SetDataSource(dt) CrystalReportViewer1.ReportSource = rpt help, i cant see content of my data … |
|
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 … |