20,899 Topics
 | |
| | Hi! How should I get date, month & year in ascending order there in Crystal report? I have written following code there in my form to show report. Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Income_Sheet_Report Private Sub Income_Sheet_Report_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cmbisrbdt.Items.Clear() … |
| | I have a loop to look for the key i.d. "veh2." The loop is there because even though the next line in the text file is where it should be, it is not there in all cases. The problem I'm having as far as wording or a way to go … |
| | hi all, i am not able to redirect/login to my owa page. when i run my code below commandd windoe comes and disappears nothing happens. please seemy code below: Sub main() Dim strServerName As String = "12.345.56.789" ' my owa ip Dim strPassword As String = "password" 'my password Dim … |
| | i am trying to get crystal report of my Marks_master Records From Table . I tried Following Code But It is Giving Me Exception As : System.IO.FileNotFoundException was unhandled Message=Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one … |
 | Hi, How can i change the bar chart color after I click a button? Here is the senario. I have a bar chart to show line progress. Here is the 3 condition for the bar chart: 1) Before the bar chart reach maximum limit, the color will set to blue. … |
| | If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then Try TempImage = Image.FromFile(ofd.FileName) imagename = ofd.FileName System.Diagnostics.Process.Start("filetest.exe", imagename) System.Diagnostics.Process.Start("sobel2.exe", ofd.FileName) PictureBox1.Image = TempImage this is my code. sobel2.exe works file with the argument. but filetest.exe hangs and gives win32 unhandles exception if i give a proper filename within codes to imagename filetest.exe works fine.. … |
| | Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class books Inherits System.Web.UI.Page Dim con As New SqlConnection Dim cmd As New SqlCommand Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load If Not IsPostBack Then BindRatingControl() End If End Sub Protected Sub RatingControlChanged(ByVal sender As Object, ByVal e … |
| | How can I change the color of bar chart based on value in database column? For example, in table "STATUS" in my database, I have 3 type of value. What I want is: 1) If the value = 0, then color will change to blue. 2) If the value = … |
| | Sub empno() ComboBox2.Items.Clear() sql = "select empno from tbl_empinfo" If rs.State = 1 Then rs.Close() rs.Open(sql, conn) Do While rs.EOF = False ComboBox2.Items.Add(rs(0).Value) rs.MoveNext() Loop End Sub how do i write this for an access connection???  |
 | Need help while working with timer.... I am trying to do the database restoring part.... When the user clicks on the restore database button the progress bar shud be shown and as soon as the restoring is completed the progress bar shud stop and display success msg... Right now I …  |
| | Actually I'm doing a project to maintain the company info, here i wanted to write a code to check whether the company id already exists or not. that is if the id 123 is already present in the access database then it shuld show the msg that it already exist. … |
| | How do you display an image in a dgv..i can display all the other info in the table, just need to know how to display an image. |
| | i have here a code that add timeintextbox and timeouttextbox to calculate for the total hours work. my problem is that i want to subtract 1hour in the total hours work for the break time..please any idea on how should i do this? Dim TimeA As Date Dim TimeB As … |
| | so i am using visual basic express edition 2010 i am now able to select an image and displaying it in the picture box. now i need to run a c code (its exe file) by clicking a button in the vb form. i was able to this too by … |
| | Hi all, I want to create a crystal report. Before print the document I want to see the output first, and then give the print command. On print button, But the problem is I have dot-matrix printer and I the page size is fix. So how can I overcome this … |
| | hi while resetting text box value to blank it gives error txt_cash_acc.text='' Error : conversion from type 'DBNull' to type 'String' is not valid.// thank you in advance |
| | I have to use a basic ByRef and ByVal in a program and its not showing up in the labels when I hit the calculate button. The program I am creating is very basic and it calculates your age, nextyear age, month born, astrological sign, days old and seconds old. … |
| | I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to … |
| | i have a database table and it has some column with duplicate values , and i want to get that column value of the table in a combobox, but i want every value single time not repeatedly ... i tried but it is still giving me all values in the … |
 | Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click … |
| | When I try debugging this, it comes up with an error on the line "If txtUsername.Text = ds.Tables("AddressBook").Rows(inc).Item(1) Then". It says NullReferenceException was unhandled. Object reference not set to an instance of an object. Public Class MainLogin Dim MaxRows As Integer Dim inc As Integer = 0 Dim con As …  |
| | Hello everyone. Please I am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, … |
 | # vb.net 2008 # Hi there! I am a college student of **Southern Leyte State University - Tomas Oppus** from **Philippines** taking Bachelor of Science in Information Technology. Can you help me on how to code the timer in **vb.net 2008**? We are using this in our research as completion … |
| | Hi all! I think I need some help moving data from one table to another. Here is the scenario: I have two tables, tblDetails (studentID,Name, Class.....) and tblPhysics (StudentID.....). Now, I want to SELECT StudentID from tblDetails WHERE Class = 1 (SELECT tblDetails.StudentID FROM tblDetails WHERE tblDetails.Class = '1') So … |
| | Hi guyz, My problem is when i am saving a record in MySQL Database there is an error occured "Incorrect datatime value 3/20/2011 for COLUMN DATE at ROW 1" I used Date as my DataType in MySQL server? Can anyone fix my error ?? |
| | Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security … |
| | Hello everyone Anybody to help me with this please How can make an app that will check the server/URL if it's Online/offline using visual basic 2010 I know that i can just ping it using the CMD but i want something that will be in the app i'm aiming to … |
 | Not sure what I am doing wrong but let me try to explain my issue. I have a single combobox on my form that I use to load external settings. If I load, lets say, 100 settings in to this combobox then I clear the combobox via Combobox1.items.clear(), then try … |
| | I would like to know how to open any file by using the codes!!! |
| | hello! i have one button . i want when i click it it will print preview a microsoft document from my desktop. is it possible? how to do it? thank you~ |
| | Hi, I am stuck on this two sqldatadapater and sqldatareader,we can display records in listview by using this sqldatadapter and sqldatareader.my question which is more effecient and secured to use?does this two matters in populating data in database?  |
| | SYTAX ERROR ON UPDATE STATEMENT, PLZ HELP, I CNT FIGURE IT OUT GUYZ Private Sub SubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubmitButton.Click Try conn.Open() mystring = "UPDATE ClientLogIn SET Password = '" & PasswordTextBox.Text & "' WHERE ClientID = '" & ClientIDTextBox.Text & "' AND Username = … |
| | Hi, Is it possible to send an email from SMTP server, for example from do_not_reply@xxxx.xxx.com, without have the server credential (username and password) inside my code? I tried one code, it works, but it send from my email account. Not from SMTP server. I also tested several code but I … |
| | i need help with changing a text box for a calculator ex: 1. if (textbox3.text = 0) then (textbox.text = 1) 'i need help with that thx |
 | Please help me I got a error:Incorrect syntax near ')'. It pointed to the update_product.ExecuteNonQuery() Dim update_product As SqlCommand = New SqlCommand("Update sell Set Mode_Of_Payement(Cash)='" & TextBox9.Text & "',Payement='" & TextBox6.Text & "',Balance='" & TextBox8.Text & "', Mode_Of_Payement(Cheque)='" & TextBox9.Text & "',Cheque_No='" & TextBox4.Text & "' where Bill_No='" & txtbillno.Text … |
| | Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e … |
| | Public Class txtSurname Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As OleDb.OleDbConnection 'Dim con As OleDb.OleDbConnection Dim dbProvider As String Dim dbSource As String Dim DS As New DataSet Dim DA As OleDb.OleDbDataAdapter Dim sql As String dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data … |
| | Hi, can you help me please how can i populate data from my listview using sqldatareader. by the way can you please explain me why is it that listview in first column we call item but the other column we call it subitems.can you please enligthen my mind on this.I … |
| | create a project that generates 5 random integers from 100-999. store them into an array. Re-display the numbers in a list box. calculate the sum and product of the 5 numbers and display them in label. use procedures and functions. |
| | Hi, is it possible to code column header in listview during run time? can you please give me some idea on this.Thank you in advance. |
| | Hello again. Generating item codes for my inventory system became complex when the panel said that this must be the format of the generated ID number: "CATEGORY-ITEMNAME-ITEMINDEX" For example: School Supplies - Coupon Bond short- Second Item in the database would result to an item ID : SCS-CBS-002. Advanced thank … |
| | Thank all you for last replies here i hve a problem in my project . I have 2 form . In frm1 i have a datagridview which contain all information of student i.e ID, NAME , CLASS No. , ADDRESS , Department and course . In this form i hve … |
| | Hi, I have a bar chart to display information. I also have a vertical line indicate the limit of Y-value. For example, I set the limit to 25. So now I want the color of column bar to change to red color if the column exceed the limit. I tried … |
| | When reading from an access database, my code is like this: Private Sub PaidNavigateRecords() If ds.Tables("Paid").Rows(inc).Item(1) <> "" Then txtRanch.Text = ds.Tables("Paid").Rows(inc).Item(1) Else txtRanch.Text = "" End If If IsDate(ds.Tables("Paid").Rows(inc).Item(2)) = True Then txtDate.Text = ds.Tables("Paid").Rows(inc).Item(2) Else txtDate.Text = "" End If If ds.Tables("Paid").Rows(inc).Item(3) <> 0 Then txtInvoice.Text = ds.Tables("Paid").Rows(inc).Item(3) … |
 | i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 … |
| | Hello , I'm making tetris in vb.net and i'm working with an image in a picture box that falls and with classes , my whole program works but hen my image falls it actually copies itself , does anyone know an eraser function or something or a method how to …  |
| | I want to filter the datagridview on Search button click,i am using 3-tier architecture,the grid should be updated with the search result |
| | Hello everyone I'm creating an application in visual basic 2010, "I'm very new to this" What i want to do now is to make a monitor to check the status of the website server (If it's up or down) I know that i can just ping it using CMD"command" But … |
| | Hello, I have a PDA which is working properly but now i need to use it in other application like if my active window is Microsoft Word and I want to read a barcode and to get it value where the cursor is placed in the document , how can … |
 | Hello Community, I need help with this script, i can't seem to use this to switch beteen dll files that contain a form eg. if i use it to open a form from the dll file called "Dll One" then when i click the button again it still opens the … |
The End.