Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~4K People Reached
Favorite Tags
Member Avatar for GilbertB

Hi, I have this list : CompanyID CompanyName Involved Party Involvement C 10001 GRAF LIMITED GRETA PACE BONELLO Director C 10001 GRAF LIMITED GORDON PACE BONELLO Director C 10001 GRAF LIMITED DAVID PACE BONELLO Director C 10024 J.P.F. TRADING COMPANY LIMITED PATRICIA FERRIGGI Director C 10024 J.P.F. TRADING COMPANY LIMITED …

Member Avatar for Reverend Jim
0
217
Member Avatar for GilbertB

Hi all, I have two tables in a database. Both have columns named "Company Name". I want to compare between these columns for any similarities in their names. For Example : Table1.CompanyName = 2i Ltd /// Table2.CompanyName = 2i Limitied. Thanks Gilbert

Member Avatar for rch1231
0
144
Member Avatar for GilbertB

Hi , I am working on a list : Name Town Street House ID_Number Marco Valletta Triq l-Ajkla 10, Fl 1 53290M Mary Valletta Triq l-Ajkla 10, Fl 1 4748M Victor Valletta Triq l-Ajkla 10, Fl 4 37867M Krystle Valletta Triq l-Ajkla 14, Fl 1 52467M Mariella Valletta Triq l-Ajkla …

Member Avatar for GilbertB
0
152
Member Avatar for GilbertB

Hi I have this list: 532790M 47448M 378267M 467981M 53661M 583783M 524687M 390963M 493436M 185366M 150370M 497092M 3660G 568961M 152693M 254278M 353173M I am running an Access Query and I am trying to figure out what criteria do I need to insert for just showing only two digits before "M" …

Member Avatar for urtrivedi
0
89
Member Avatar for GilbertB

Hi all , I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month. I have tried the Data Add …

Member Avatar for almostbob
0
81
Member Avatar for GilbertB

I have a webstie template and I want to preview it something like this : http://breeze.pcollab.com/moby2/# How can I combine my html to a mobile phone layout ? Thanks

Member Avatar for code739
0
79
Member Avatar for GilbertB

I want to learn how you can do or is there any tool to do a search field in a website which basically you enter a domain name and it search if the domain is available or not. Basically this you can find it in web hosing websites - when …

Member Avatar for rotten69
0
107
Member Avatar for GilbertB

I have this form connected with SQL server : http://img171.imageshack.us/img171/7423/692012101827pm.png is there any way that when I enter a new company and press save icon, the combobox will update automatically ? Thanks

Member Avatar for ious
0
188
Member Avatar for GilbertB

I am doing a sample program where it involves inserting data from textboxes and a Combox to SQL Server databse ... private void btnAdd_Click(object sender, EventArgs e) { da.InsertCommand = new SqlCommand("INSERT INTO Member VALUES (@MemberID, @Name, @Surname, @IDNo, @Address, @Town, @TelNo, @MobNo, @Email)", c); da.InsertCommand.Parameters.Add("@MemberID", SqlDbType.VarChar).Value = textBox50.Text; da.InsertCommand.Parameters.Add("@Name", …

Member Avatar for Mitja Bonca
0
239
Member Avatar for GilbertB

I am building a program which generates a random number in a textbox everytime the form loads. I have this code : public partial class Form1 : Form { SqlConnection c = new SqlConnection(@"Data Source=GILBERTB-PC\SQLEXPRESS;Initial Catalog=DVDandGameBooking;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); public Form1() { InitializeComponent(); random(); } //private void …

Member Avatar for bharat_4g
0
805
Member Avatar for GilbertB

As the title tell, i want to delete a row from a data grid view and also it updates in the sql table. I have this code so far : DialogResult dr; dr = MessageBox.Show("Are you sure ?" , "Rent Returned", MessageBoxButtons.YesNoCancel); if (dr == DialogResult.Yes) { if (this.dgvRent.SelectedRows.Count > …

Member Avatar for Mitja Bonca
0
171
Member Avatar for GilbertB

AM I doing the right syntax for this parameter? da.SelectCommand = new SqlCommand("SELECT Member.MemberID, Member.Name , Member.Surname, Rentals.RentalID FROM Member,Rentals WHERE Member.MemberID = (@MemberID) Rentals.MemberID", c); da.SelectCommand.Parameters.Add("MemberID", SqlDbType.VarChar).Value = txtID.Text; ds.Clear(); da.Fill(ds); dtgv1.DataSource = ds; It is giving me an error "Incorrect syntax near 'Rentals'." Thanks

Member Avatar for Mitja Bonca
0
118
Member Avatar for GilbertB

I am building this database : http://imageshack.us/photo/my-images/217/diagramg.png/ I have a difficilty Regarding Renting. Because in this system one can order either DVD Or Game. Therefore how am i going to link the Game or/and the Dvd to the Rent table ? Currently it does not work due to the fact …

0
91
Member Avatar for GilbertB

Hi all, I have two tables in SQL Server : Rent and Member . And they are in a relationship. Member ID (from Memner table) is in the table of Rent. I would like to know if there is a way that when I view a new Rent in the …

Member Avatar for GilbertB
0
330
Member Avatar for GilbertB

Currently I am working on a project regarding C# and SQL and I have a problem regarding the SELECT function and I cannot find any solutions on-line. The scenario is regard searching query from C# through SQL server and display the results in a Data Grid View at C#. I'm …

Member Avatar for Mitja Bonca
0
976