Posts
 
Reputation
Joined
Last Seen
Ranked #3K
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
3
Posts with Upvotes
3
Upvoting Members
3
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
0 Endorsements
Ranked #2K
~39.7K People Reached
About Me

guhehehehe

Favorite Forums
Member Avatar for jared.geli

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 …

Member Avatar for richardsonka
0
2K
Member Avatar for jared.geli

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 …

Member Avatar for waterm
0
2K
Member Avatar for jared.geli

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

Member Avatar for Begginnerdev
0
112
Member Avatar for jared.geli

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 …

0
72
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
997
Member Avatar for mkhan.haqpalkhan

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

Member Avatar for jared.geli
0
157
Member Avatar for anuradha71

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 …

Member Avatar for anuradha71
0
2K
Member Avatar for VIPER5646

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 …

Member Avatar for VIPER5646
0
1K
Member Avatar for Satyam_1

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 …

Member Avatar for jared.geli
0
453
Member Avatar for jaejoong
Member Avatar for jared.geli

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, …

Member Avatar for jared.geli
0
233
Member Avatar for jared.geli

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 …

Member Avatar for Julian_1
0
2K
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
207
Member Avatar for Papa_Don

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 …

Member Avatar for jared.geli
0
396
Member Avatar for Satyam_1

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 …

Member Avatar for Sulaiman_1
0
267
Member Avatar for caello

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 …

Member Avatar for jared.geli
0
2K
Member Avatar for striqo

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, …

Member Avatar for t3cho
0
150
Member Avatar for jared.geli

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] …

Member Avatar for jared.geli
0
115
Member Avatar for jared.geli

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% -------> …

Member Avatar for jared.geli
0
191
Member Avatar for Khyxz

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) …

Member Avatar for Khyxz
0
141
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
170
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
423
Member Avatar for jared.geli

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 …

Member Avatar for oussama_1
0
136
Member Avatar for bijoy.balakrishnan.3

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 …

Member Avatar for jared.geli
0
287
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
7K
Member Avatar for jared.geli

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 = …

Member Avatar for jared.geli
0
671
Member Avatar for decoder.mira

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 …

Member Avatar for jared.geli
0
367
Member Avatar for jared.geli

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. …

Member Avatar for jared.geli
0
4K
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
0
223
Member Avatar for jared.geli

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 …

Member Avatar for jared.geli
1
1K