Posts
 
Reputation
Joined
Last Seen
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
74% Quality Score
Upvotes Received
6
Posts with Upvotes
5
Upvoting Members
6
Downvotes Received
2
Posts with Downvotes
2
Downvoting Members
2
1 Commented Post
3 Endorsements
Ranked #496
Ranked #1K
~44.3K People Reached
Interests
Like to try many new things
Member Avatar for Dili1234

this is my first time of creating trigger..I tried to create trigger using mysql to count how many 2007 data in the table when inserting new record but it not working....... My table have more than 50 data... CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright; …

Member Avatar for Kuripaner
0
198
Member Avatar for Lethugs

Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at …

Member Avatar for Lethugs
0
255
Member Avatar for arezz09

hello.. i have problem load two data from different table and column.. for example, each data from product table into product combobox and brand table to brand combobox..i succussfully load data to combobox but got multiple same data into combobox.. Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\mydatabase.mdb;Jet …

Member Avatar for ryanjayson
0
2K
Member Avatar for yagelnnn1

Hey, does anybody know how to read cloumn from MySQL? I mean, like if I have in my MySQL the schema "Bdatabase" and the table "accounts". In that table there are username and password. How can I do in my program that it'll read the username and password?

Member Avatar for ryanjayson
0
185
Member Avatar for pc20912

I am using MS-Access & VB.Net I want to change Database password which use for connection string in Vb.Net forms (DB password change using, Open DB through MS-Access) For the beginning I used My.setting to save password and retrieve it from project load, but it not secure. My.Setting files easily …

Member Avatar for Dili1234
0
592
Member Avatar for Dili1234

I'm doing a project about lighting.I don't know how tp draw beams does anybody know about it?

0
112
Member Avatar for DanielTradeWs

I have this problem, I have a SQL code working perfectly on SQL Query windows... SELECT ID_no, nom_navire, date_mes, date_sav, description, nom_fourn, no_facture, date_facture, accept, decline FROM DB_FACTURE WHERE( ID_no = 39) Answer perfect On my code Is ... SELECT devise FROM FOURNISSEURS WHERE nom_fourn = '" + Nom_FournPass + …

Member Avatar for DanielTradeWs
0
378
Member Avatar for Dili1234
Member Avatar for Dili1234
0
152
Member Avatar for Dili1234

I want to retrive data from table to combobox I used this coding though I didn't get an error the outpiut(data) is not displaing in the combobox Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click MessageBox.Show("Please Insert the Sample note no", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) Try myConnection …

Member Avatar for sharls
1
584
Member Avatar for Iamkenny

I'm completely clueless to this as I have never used crystal reports before. So I want to use a textbox to pass values into my crystal report so basically only those I inputted into my textbox will be read and be outputted into my crystal report. Here is my code …

Member Avatar for Dili1234
0
2K
Member Avatar for Dili1234

When to trying to display data to datagrid view using query i got an error "a column named date already belongs to this datatable in net 2008" Dim dt As New DataTable Try myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim cmd As New SqlClient.SqlCommand With cmd .CommandText = "SELECT [Date],[Totalamount] FROM …

Member Avatar for Dili1234
0
180
Member Avatar for Dili1234

I taking data from 3 tables to crystal report.Tables are 1.Moblization -primary key is Fen_Inovoice_No 2.invovoice details -Primary keys are Fen_Inovoice_No and description 3.Client details-primary key is Contract name I 'm using this query to retrive data Dim cryRpt As New ReportDocument CrystalReportViewer1.SelectionFormula = "{Mobilization.Fen_Inovoice_No}= '" & Varibles.invoice1 & "'" …

Member Avatar for Dili1234
0
174
Member Avatar for Dili1234

I have to tables 1.[Mobilization]-Primary key is [Fen_Inovoice_No] it is the forgien key is of [invovoice details] 2.[invovoice details] the primary keys are [Fen_Inovoice_No],[Item] when I tried to view the data , the all data are not loading to listview why is that? Dim intResponse As Integer intResponse = MsgBox("Please …

Member Avatar for Koelald
0
269
Member Avatar for GeekPlease
Member Avatar for Dili1234
0
90
Member Avatar for Dili1234

When tried to update the data I got this error "incorrect syntax near '4' Unclosed quotation mark after the character string" Can someone fixed this error Public Sub Save() Dim indate As Date = DateTimePicker1.Value.Date If String.IsNullOrEmpty(TextBox1.Text) Or String.IsNullOrEmpty(TextBox2.Text) Then 'Show your message here MsgBox("Please fill all Data") Else 'Show …

Member Avatar for Dili1234
0
210
Member Avatar for Dili1234

Dim startdate1 As String = DateTimePicker1.Value.Date Dim enddate As String = DateTimePicker2.Value.Date myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim insert As SqlCommand = New SqlCommand(" INSERT INTO Client_Details (Contract_Name ,Client_Name ,VAT_No ,Cilent_Address,Start_Date,End_Date ,Contract_Value,Telephone_No) VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & …

Member Avatar for khair.ullah
0
155
Member Avatar for Dili1234

When I used the code though there ara no I won't get anwser.I couldn't whatis the error I did. cvowel([],0). vowel([a],Counter):-Counter is 1. vowel([e],Counter):-Counter is 1. vowel([i],Counter):-Counter is 1. vowel([o],Counter):-Counter is 1. vowel([u],Counter):-Counter is 1. vowel([_];[],Counter):-Counter is 0. cvowel([H|T],Counter1):-cvowel(T,Count),vowel(H,Counter),Count is Count +Counter,Counter1 is Counter1+Count. answer I got "Faulse"

Member Avatar for TrustyTony
0
2K
Member Avatar for bryann

I've built an application that displays the contents of an access database in a datagrid and also a form which allows a user to add a new record to the database. When I tried to run the exe in the bin folder on another computer it displays an error when …

Member Avatar for bryann
0
447
Member Avatar for Dili1234

When I used this coding I didn't any output though is no errors. palli([H]). palli([]). palli([H|T])-append(T,H,[T|H]). I got the output as [4] 6 ?- palli([m,a,m]),append(K,L,J). K = [], L = J .

0
72
Member Avatar for Dili1234

I write count the letters in a list, > ERROR: countvowels/2: Arguments are not sufficiently instantiated I got this error" why is that? this is the coding I used countvowels([],0). countvowels([H|T],Count1):-Count is Count1 + 1,countvowels(T,Count),Count1>1.

Member Avatar for Dili1234
0
2K
Member Avatar for Dili1234

I want to transate no to Letters ,and letters to no,as a Example when germantoenglish([e,t,th],Y).Y shoul be like below Y=[1,2,3] but I get answer as false............ trans(e,1). trans(t,2). trans(th,3). germantoenglish([S|H],[G|Ta]):-trans(H,Ta). englishtogerman([J|Ta],[L|H]):-trans(H,Ta). `

Member Avatar for Dili1234
0
170
Member Avatar for Dili1234

Can anybody explain why this is not working.Can someone help me. fib(0, 0). fib(1, 1). fib(N, NF) :- N>=0, fib(N-1, AF), fib(N-2, BF), NF is AF + BF. .

Member Avatar for Dili1234
0
217
Member Avatar for ear92

Hello, who can help me to get the source code (VB.NET) from this application (http://www.4shared.com/file/fch3Wylw/InheritedForm2.html)

Member Avatar for GeekPlease
0
86
Member Avatar for selwyne

Hi there, I have created a vb.net application. Every time i open any of the reports for the first time on only some of the computers then it says Logon Failed. Please try again. When i then open the report again it opens fine! The report however opens first time …

Member Avatar for Dili1234
0
216
Member Avatar for zbzHenry

hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon …

Member Avatar for Dili1234
0
592
Member Avatar for Ariah17

Hey all, Sorry if this is really simple but I couldn't think how to phrase what I'm looking for on google. I've designed a piece of software for a friend for their business. When I learned VB we were always taught how to use it with Access Databases. I've decided …

Member Avatar for Dili1234
0
138
Member Avatar for blivori

Hi, Can anyone tell me why datareader is no reading user_id from this code? I debugged and the user_id_select remains 0 and I am getting no errors. Protected Sub btnAddUser_Click(sender As Object, e As EventArgs) Handles btnAddUser.Click Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True") Dim searchComm As String = …

Member Avatar for Dili1234
0
1K
Member Avatar for dusto

Ok, so this will be longwinded, but I'll try and explain what I'm trying to accomplish. Our form has 3 buttons. 1. Clear Database (Working) 2. Load database from Text File 3. Load listbox from database (I have this working) Our project has 2 forms, one being the form which …

Member Avatar for dusto
0
189
Member Avatar for mnorton

Hi - I am a pretty remedial visual studio express user. I recently understood how to do cascading comboboxes using the binding sources of the related tables, eg tbl 1 Make, Table 2 model, so as eg only ford models displayed in cbo2 if Ford selected in cbo1 - thanks …

Member Avatar for mnorton
0
1K
Member Avatar for dinesh012

hi i have problem with my VB.net program I have a form and 3 GroupBox in the same form. i want go next 2 GroupBoxes afther Clicking the Next Button.. Can you Help me ? plz.. GroupBoxes1 to next GroupBoxes2 next GroupBoxes3 using same Next button

Member Avatar for Dili1234
0
97