309 Posted Topics
 | Hello Friends, I want to calculate the instance of * in the text file.... but I am not able to do it.... can anyone tell me which file funtion to use for it... I first tried to read the file --- its just one line file then see if the …  |
 | [QUOTE=dilse4sk;1781641]hi i am having problem in deleting a single row from a gridview. i am using binding navigaator to delete the row. i have customer table and booking table. Cust_id is used as foreign key in booking table. when i try to delete a single row from booking table it …  |
| | [QUOTE=waqasaslammmeo;1780452]well bernardz26! there are two simple ways to perform this , one is to declare a global or public variable and just access it at any part of your prog , and second way is to call the form then the call the control , here are both ways to … |
| | Hello Friends, I have one project in Java but the exe file cant show the system.out.println messages. I want to create a jar file in such a way that the error of file e.g. abc.java should be viewed when I click the jar file. is there any possible way.... |
| | Hello friends.... I have to check the folder path in such a way that c:\Pooja\[COLOR="red"]dynamic_folder[/COLOR]\Output.txt From Pooja folder how will I be able to move to the text file since the dynamic folder can be anything and I want to move inside the dynamic folder... is there any way... i … |
| | [QUOTE=easygi;1774667]I build my project then I open the EXE file at the RELEASE FOLDER, when generating in a crystal report a error message pops up "LOAD REPORT FAILED".[/QUOTE] Check the path for the crystal report or paste the crystal report code u have written |
| | Hello Friends.... I have a patient registration form in my project...in which I have to browse the image of the patient save it in the database and when I need the details of the patient again the uploaded image should also be displayed.... Please help me in this... I have … |
| | Hello Friends, I have got confused with one topic Scenario is such that.... I need to browse a file and copy the file from one location to another.... I am done with the file copying but I need to add the list of all files present under that folder in … |
| | Re: help please!! [QUOTE=yumyam09;1766251]example iam the employee and i want to have a vacation leave and i want to have a vacation in 4 days and the vacation leave have 10 days maximum so if i get 4 days my vacation leave will be 6 days automatically then on my another vacation i … |
| | Re: Error Log in [QUOTE=timothy0726;1772997][code]Dim cmd As OleDbCommand = New OleDbCommand("SELECT username,password FROM tblUsers where username=? and password=?", conn) Dim usernameParam As New OleDbParameter("@username", Me.txtUsername.Text) Dim passwordParam As New OleDbParameter("@password", Me.txtPass.Text) cmd.Parameters.Add(usernameParam) cmd.Parameters.Add(passwordParam) Try connectDatabase() Dim read As OleDbDataReader = cmd.ExecuteReader() If read.HasRows Then read.Read() If txtUsername.Text = read.Item("username").ToString And txtPass.Text = read.Item("password").ToString Then … |
| | Hello Friends, I have a patient register form in my project... When the patient details will be saved in the database it should also be saved in the text file... I am dynamically creating a folder with patientid and firstname in that folder I am creating a text file patientreg.txt … |
| | [QUOTE=dilse4sk;1772090]hi every 1 i am trying to make a search criteria based on last name.i have dragged and dropped customer dataset as details view on my form and booking as gridview(customer id is foreign key in bookings table so now when i scroll through customer i could see the relaive … |
| | [QUOTE=Farhan_B;1770592]When Creating a query using the sear Criteria Builder . I keep getting the error : " The schema returned by the new query differs from the base query " I no this means that the error is due to the query attempting to return too little columns i have … |
| | [QUOTE=Alison1;1772376]i had to take someone elses project this year because i failed to complete my project,however im having troubles with the one i picked up.i cant even change it now because ive already submitted synopsis and software engineering journal on that new project.its on gymnassium system. the main form had … |
| | Hello Friends, I have compeleted my project but I just need one help.... I want that when the application exe file is running at that time the database associated with the application shud be closed.... Means...I am using the .mdb file... is there any way that when the application starts, … |
| | [QUOTE=LFCDay123;1766646]I'm new to Visual Basic and I am trying to set up a currency converter. I have converted a currency to UK Sterling on the first form and on the second form I want to have the same label with the same amount of UK Sterling as on the first … |
| | Hello, Can any one provide me with the Crsytal report runtime installer for Visual Studio 2010.. I have the installer of Visual Studio 2008 but its of no use... I need the installer that is the .msi file.... Can anyone provide it to me...coz I have searched a lot.... |
| | [QUOTE=waqasaslammmeo;1768315]hello ! try this may be this will solve your prob [CODE] dim con as new sqlconnection("connectionstring") con.open() dim da as new sqldataadapter("select firstname,lastname,address from table where firstname='" +txtfirstname.text+"' and lastname='"+txtlastname.text +"' and address='"+ txtaddress.text+"'",con) dim dt as new datatable da.fill(dt) if dt.rows.count = 0 then 'means record is not … |
| | [QUOTE=jaimin4829;1767920][CODE] I m trying to make totaly disable mdi child form1 when another data entry form2 opened. Bcz by mistak on clicking frm1 frm2 go to back that i dont want to do. Me.enabled=false and frm1.sendto back. can't solve the problem. [/CODE][/QUOTE] Use this [CODE]Me.Hide() or Me.Visible=False Form2.show()[/CODE] you can … |
| | [QUOTE=vaishnaviS;1767616]Hello , I am doing a project on Resort Website where I have a module of Room Reservation. I want a code for checking the availability of rooms when user selects arrival date and departure date and clicks check button. database room_details table ------------------ roomno type rate_regular rate_delux rate_suite -------------------- … |
| | [QUOTE=Eniekko;1766311]Hello, currently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already. The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column … |
| | [QUOTE=madao;1766921]I would like to retrieve the ID number for that row that was just inserted into the database. [CODE]Dim Enrollment As New Enrollments With Enrollment .Student_ID = CInt(lvwStudents.FocusedItem.Text) .Enrollment_Date = CDate(dtpDate.Text) End With EnrollmentBAL.Save(Enrollment) [/CODE] I have this code to save it from the database, what I want to do …  |
| | I have created a project for clinic in vb.net... So I have one exe file for it.... But I want VBnet installer and Crystalreport runtime installer to be packaged along with it... As to when the user will click the exe file the VB.Net installer shud first install then the … |
| | [QUOTE=tenorjazz;1766916]Amazing.... [Container] fixed the problem ---- THANKS!! Just want to make sure I understand what you are saying... Container is a reserved word that can be used in SQL "UPDATE" statement?[/QUOTE] U have missed the "+" sign in ur update query Try this... [CODE] Try Dim MessageText As String Dim … |
| | [QUOTE=acepeda;1765610]Hey guys! I need a little help with Crystal Reports!The Report keeps repeating the details.I tried to group it by the reference number but it keeps displaying it four times!Also how can I order the report by reference number?Please help me its the last thing for me to finish my … |
| | [QUOTE=networkmancer;1766888][CODE]Select TRANSACTION.TRANSACTION_ID ,CUSTOMER.FNAME ,CUSTOMER.LNAME,PET.PNAME,Employee.Emp_ID,Employee.fname,TRANSACTION.DATESTART,TRANSACTION.DATEEND from(TRANSACTION) INNER JOIN CUSTOMER ON TRANSACTION.CUSTOM_ID = CUSTOMER.CUSTOM_ID INNER JOIN PET ON TRANSACTION.PET_ID = PET.PET_ID INNER JOIN EMPLOYEE ON TRANSACTION.EMP_ID = EMPLOYEE.EMP_ID Where TRANSACTION.STATUS=1 order by TRANSACTION.TRANSACTION_ID [/CODE] Cant edit my code. This is my code. I forgot to remove repeted Transaction.EMP_ID[/QUOTE] Try this code [CODE] … |
 | [QUOTE=PutingPanday;1766897]I want to Have a Fix File path for my Flash Animation Flash Screen.. Is this possible ?coz VB doesnt allow you to upload a Flash File In resources... This is my path: AxShockwaveFlash1.Movie = "C:\Users\Nat\Desktop\Sudoku tactics(Pencil)\finished products\SPLASHscreen.swf" It's not fixed...If you switch PC it wont work anymore...[/QUOTE] Try it … |
| | Hello Friends, I am messed up with the below query [CODE] Try Dim myCommand As OleDbCommand myCommand = New OleDbCommand("select sum(tmt.total) as Total from Appointment appt, TreatmentMaster tmt where appt.patientid='" + txtPatIDBill.Text + "' and [tmt].[treatid]=[appt].[treatmentid] and (Format([appt.ApptDate], 'Short Date')) between '" + dtpFromBill.Value.Date + "' and '" + dtpToBill.Value.Date … |
 | [QUOTE=riahc3;1754385]Yes... [code] DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy - HH:mm:ss"); [/code] But how do I include the miliseconds (and the localized version of the day of the week)?[/QUOTE] Check this [CODE] Dim MyTime As String MyTime = DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss.fff") [/CODE] It gives the output: 09-Feb-2012 18:08:14.403 Sorry its in vb.net |
| | Hello Friends, Please help me in this.... I have created a project in VB.net and its working fine in my machine. But when I provide the exe to my senior to test it shows the initialization error. I came to know the reason that the error is because the microsoft … |
| | [QUOTE=mani-hellboy;1755067]Forgot the one thing to find the length of ID there only easy when you add 10,11...,100,101,....,1000,1001... [CODE] temp_id=string.Empty; for(int i=0;i<(5-id.lenth);i++) { temp_id+="0"; } temp_id+=id; [/CODE][/QUOTE] I have done the following to get the custom ids like DOC1, DOC2, DOC3 and so on.... I have create a table which will …  |
| | [QUOTE=TIM_M_91;1757434]Hi guys well what I'm trying to do is produce a query that only produces the results which will match my director input. I have looked for the correct syntax and cannot seem to find it. Any help would be appreciated Code of my syntax below: [CODE] ResultSet results = …  |
| | [QUOTE=waqasaslammmeo;1753774]hello! in you db , date format is same as you specified in your windows , so change the date format .secondly users have concern with the interface , time showing on there datetime picker , there you can set the format property custom and set your required format of … |
| | Hello Friends, I need an urgent help on the below topic.... I have created a project which takes the database dyanamically.... Means when the application starts it will ask for the database path....the database will already be created in some or the other folder.... The path for database is stored …  |
| | [QUOTE=princenathan;1753892]try this code from sql server - vb.net [CODE] Private Sub loddatagrid() Call main() Con.Open() DataAdapter1 = New SqlDataAdapter("SELECT [ID],[type],[lot],[loc],[meas],[units],[pounds] FROM [dbo].[Inventory] where [rcvandwork]='" & txt1.Text & "'", Con) DataSet1.Clear() DataAdapter1.Fill(DataSet1, "Table1") grid1.DataSource = DataSet1 grid1.DataMember = "Table1" grid1.Refresh() Con.Close() End Sub private sub form.... loddatagrid() txtno.DataBindings.Add("Text", DataSet1, "Table1.ID") xt1.DataBindings.Add("Text", … |
| | [QUOTE=Begginnerdev;1754669]You can create a naming scheme, which you already have. Then generate that name on runtime. I am assuming you are using a database backend? If so, you can use a primary key as a varchar. Generate the key in application, on save, by: [CODE] dim datestr as string = … |
| | [QUOTE=nesnes;1753947]just want to know how will i able to display the info description in my list view but the one that appears in the database is its id(using vb.net)[/QUOTE] The id value must be having some description in ur table right?? if yes then use the below code. I quess … |
| | [QUOTE=Rock_IT;1741866]im a beginner wid vb .net and need to clear the air wid connecting a database file created on sql server 2008r2 wid vb.net 2008 for a project..plz nebody help from scratch regardng retriving,insertng n modifyng data using vb.net code..awaiting....[/QUOTE] u can create a module and call it every time …  |
| | Hello All, Actually I am facing issue in creating an ASP.net application. I have created a project in VB.net but now my seniors are saying that the code should be in ASP.net and it is taking hell lot of time for code conversion, designing and all other stuff. Actually I … |
| | Hello All, Actually I am facing issue in creating an ASP.net application. I have created a project in VB.net but now my seniors are saying that the code should be in ASP.net and it is taking hell lot of time for code conversion, designing and all other stuff. Actually I … |
| | [QUOTE=Ziggy713;1742419]Okay, I implemented the changes that you suggested, and VS 2010 now tells me that it is expecting an end of statement at the [CODE]combobox3.text & "'"[/CODE] I don't understand what it means..... This is the update Query with the changes in it [CODE]Query = "update Prod_DB_Completed_Board set [Stock Level] … |
| | [QUOTE=trisha0906;1738536]ok thank you, i will try this[/QUOTE] U can try this too for a alphanumeric or if u need only numeric increment then delete the red part [CODE] Try Dim myCommand As SqlCommand Dim STid As String myCommand = New SqlCommand("select ISNULL(Max(SUBSTRING(id,4,7)),0) From Studentreg", Connection) Dim reader As SqlDataReader = … |
| | [QUOTE=Begginnerdev;1738691]Have you tried the .ToString() function? Example... [CODE] TxtRate.Text = dt.Rows(0).Item(1).ToString [/CODE][/QUOTE] Try this... [CODE] Dim conn As New SqlConnection(ConnectionString) Dim abc As String abc= cbMenu.Text [COLOR="red"]'the value selected in combo box[/COLOR] Dim strSQL As String = "select Menu_Rate from Menu where Menu_Name='" & abc & "'" Dim da As … |
| | Hello All, I need help in this... I am attaching a zip file which contains my project in Microsoft Visual Studia 2010 along with Crystal reports.... Please help me....its giving a lot of errors...and I dont know from where it is coming and why.... Urgent help.... |
| | [QUOTE=Prasad.weer;1705517]I know to work with VB.net + crystal report + SQL server. But now i want to work with SQL server compact edition instead of SQL server. When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB … |
| | Hello Friends, I need one urgent help on this topic. I have a database in mysql. The column in table is of datatype time(0) Similarly I have a control datetimepicker in vb.net I have assigned format property as [COLOR="red"]custom[/COLOR] to the control and the CustomFormat property as [COLOR="Red"]HH:mm:ss tt [/COLOR]so … |
| | Hello Friends, I need help on the below issue I have two forms -DoctorAppointment -DoctorSchedule the DoctorAppointment form has all the details about the doctor and the patient and one Schedule button which will show the DoctorSchedule form When I click on any value in the DoctorSchedule form like Monday … |
| | Hello All, I have 3 combo boxes on my form 1. Doctor Start Time 2. Doctor End Time 3. Doctor Appointment Duration I want a 4th combo Box that will Start from Doctor's Start Time upto Doctor's End Time with the interval of Appointment Duration eg. Suppose the Start time … |
| | Hello Friends, I need to retrive a part of the value present in combobox. Suppose the ComboBox stores the Time values in it. eg. 00:00 00:30 01:00 01:30 Then how can I retrive only the hours value or the first two values separately from the Combo Box. Is there any … |
 | [QUOTE=bluehangook629;1730642]Im trying to put current system time in YYMMDD format but having problem with day function. is Day() which returned day of month in VB6 not available in VB.Net? If I want to get the current day of month, how would I do that? [CODE] Dim dt As Date Dim … |
The End.