20,285 Topics
![]() | |
Hi! This is my Gridview1 and I wanted to get the value of the recid column using the GridView1_RowEditing method <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="RECID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"> <Columns> <asp:CommandField ShowSelectButton="True" /> <asp:BoundField DataField="RECID" HeaderText="RECID" InsertVisible="False" SortExpression="RECID" /> <asp:BoundField DataField="DOCUMENT_NUMBER" HeaderText="DOCUMENT_NUMBER" SortExpression="DOCUMENT_NUMBER" /> </Columns> </asp:GridView> Please help me, I … | |
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, … | |
I'm trying to make a integer to string and also string to integer. Integer to string is what I want because if I finish integer to string I think I can reverse it. Here is I have a wrong output. I likely created a number system in string like how … | |
I came across a program [SelfNote](http://selfnote.pen.io/) which stores all the text we write and the password in itself.No other file is created (the EXE changes its size as we change it's contents) . It is a standalone exe with all the content within it. How can an exe modify itself … | |
Am developing a two screen application where first screen resides in the user system and other screen in extended mode is directed towards a projector or another monitor. They all are working perfectly. Now my client asked me if I can preview the secondary screen onto the primary screen. I … | |
hi I wnat to make **only third line** i.e "Wenisday" bold in richtextbox. how can i do this Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click RichTextBox1.Text = RichTextBox1.Text & vbCrLf & "Monday" RichTextBox1.Text = RichTextBox1.Text & vbCrLf & "Tuesday" RichTextBox1.Text = RichTextBox1.Text & vbCrLf & … | |
Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i … | |
Hello I have a vb.net application with MS access database. I want to run LAN in 3 pc by this application. So it possible or which SQL method shuold I adopt for LAN connectivity. I started to convert my database in SLQ express but I am not succeed . | |
Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb … | |
Program runs without errors, unfortunately it will not calculate the days overdue. Any Suggestions? I have attached the code as a pdf, i have also done this as an IF, THEN, ELSE statement with the exact same results, but it will not let me upload it. Help! Private Sub calculateFees … | |
I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another … | |
namespace gridStudent { public partial class Form2 : Form { public Form2(DataGridView dgvFromFom1) { foreach (DataGridViewColumn dc in dgvFromFom1.Columns) { dataGridView1.Columns.Add(dc.Name, dc.HeaderText); } foreach (DataGridViewRow dr in dgvFromFom1.Rows) { Object[] newRow = new object[dr.Cells.Count]; for (int i = 0; i < newRow.Length; i++) { newRow[i] = dr.Cells[i].Value; } dataGridView1.Rows.Add(newRow); } … | |
Imports System Imports System.IO Imports System.Text Imports System.Collections.Generic Class Program Public Shared Sub Main(ByVal args As String()) ' Set a variable to the My Documents path. Dim mydocpath As String = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) Dim sb As New StringBuilder() ' Enumerate the files in teh My Documents path, filtering for text files … | |
I need help in fixing this bug (Data type mismatch).Im using a datagrid to insert data to access database but get this error. I can update and delete during runtime but I cant insert data to database. Following is my code: Try conn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Video Store\Video Store\DvDSystem.mdb") conn.Open() … | |
I am having the most horrendous time searching for this. I swear I have trawled the web 10 times over. All I need is to get the URL of the link that has been clicked on, and open it in a new form window that is maximised with a web … | |
Hy guys, . Please assist in advicing whch toolbox conncetion controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to … | |
Hi guys pls help, Im trying to connect to access 2007 database in vb.net 2005 woth no luck.....im using a login form with two text boxes and two buttons, Im tring to log into the database using the below connection string....... (i only get the catch message box error)... Plz … | |
Hy guys, Please assist in advcicing which toolbox connection controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to allow … | |
how to resize a image thtz lager than picturebox?? | |
Dim total As Integer For Each row As DataGridViewRow In DataGridView1.Rows total += row.Cells("Total").Value Next TextBox2.Text = total // the above was the code i used and it worked good,bt if i do it for another column it is showing an error (which is given below)// Private Sub Button1_Click(ByVal sender … | |
i want to insert text in textbox at specific location(i.e row 2 column 3).how can i do that ? i tried this but its not working `Me.RichTextBox1.Text = Me.RichTextBox1.Text.Insert(i, CChar(cb.Text))` | |
Ok here is the required feature: To send data gathered from a database inside a UserControl to the main form which houses the UserControl. Hierarchy at present: Mainform --FlowLayoutPanel ----UserControl The UserControls are generated on the fly by a client list in a database. This all works fine. When you … | |
Hello, am on a project and I want the user to search for a word in datagridview. Am using vb.net 8 with access 2010 I want where the text is to be highlighted | |
HI, This code is to draw a circle in the form with one button in vb.net. [code] Dim g as system.drawing.graphics g=me.creategraphics dim p as new system.drawing.pent(system.drawing.color.Blueviolet) g.drawellipse(p,150,100,30,60) end sub [/code] this is not working it is showing the error in the declaration of p any one can help me … | |
Sometimes you want to add a little functionality to an existing class but you don't want to go to the trouble of sub-classing. A technique that you can use is known as **Extending**. For example, I frequently use regular expressions when working with strings. Wouldn't it be nice if strings … | |
Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … | |
good evening everyone... could anyone help me on this? With a "time value", eg. 08:00:00... i want to find the range that this value falls in using case statement... i am not good in using the time format... anyone can help? This is just an example: (the code is not … | |
Good Morning Everyone, i have a question.... i have 2 text boxes... for text box 1, i want user to enter integer in "hour hour" (24 hours format) for text box 2, i want user to enter integer in "mm" (24 hours format) there is also a label in between … | |
Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn … |
The End.