Please I'm using SQL server 2014 and all of a sudden the server stops working and I have to go to the configuration manager to start it. Though the start mode i
s set to automatic, this still happens and I just don't know why. Please help.
Benniit
Last Activity: Aug 11 '16, 10:04 PM
Joined: May 20 '08
Location:
-
Sql Server stops, though network type set to automatic.
-
Export Vb.net Datagridview to Microsoft Excel 2013
Please I'm using vb.net 2013 and Microsoft office 2013. The below code is able to display the datagridview
into excel 2007. But the code does not display onto excel 2013 and no error gets reported. I suspect the
excel 2013 format could be the cause but i do not know how to go about it. Please help me out. Thanks, Ben
...Code:Dim ExcelApp As Object, ExcelBook As Object Dim ExcelSheet -
Populate DataGridVieComboBox with adaptable
Please I have DatagridView bound to a DataTable
that pulls records and displays the DataGridView
correctly. Now, I have ColumnType as
DataGridViewCom boBoxColumn of the forth
column named "Username". When I click the
combo box of the DataGridview, nothing gets
displayed at all. I just don't understand it.
Below is the code.
...Code:'Objects already initialized Dim QueryU
-
Thanks for your urgent reply and explanation. -
TextBox Validation
Please I'm using vb.net 2013 and I have a textbox named txtRecipients
Now i want to check for the following:
1. The phone no. should always start with 233 followed by any digit other than zero like: 233201245685
2. Multiple phone numbers should be separated by a comma, like 233201245685, and the comma replaced automatically before the start of another phone number in the same format. So if two phone numbers... -
Remove double spaces in a textbox
I have this
textbox that users enter their names, but
I realized that they enter their names by entering
so many spaces. I used the
replace function but it does not work well. Is
there anyway to replace the double spaces . Thank you,
all. -
Save and Retrieve word document in Sql Database
Good day, gurus of this well-known site. I am using vb.net 2013 Ultimate and SQL 2012 and can some show/link me how to save and retrieve a word document from SQL database? Thanks -
BindingSource with ComboBox
'Nothing gets populated and the autocomplete feature does not work as well. Please review the code for me. Thanks
...Code:'Connection established already SQLCon.ConnectionString = DataL1 SqlQuery = "Select * from Users order by UserName asc" ds = New DataSet da = New SqlDataAdapter(SqlQuery, SQLCon) Try da.Fill(ds, "Users") Dim bs = new BindingSource() -
BindingSource with comboboxes using Autocomplete feature
Please, I'm using vb.net ultimate 2013 and I have about 15 comboboxes being populated with data at runtime.
Now, I used a "for loop"to add autocomplete feature to the comboboxes and it takes a longer time to load the form as a result of the "for loop", looping through each combo box to add the autocomplete feature. I thought of a binding source but how to implement it becomes a problem. Is there any quick way to to add... -
please I'm using vb.net ultimateLeave a comment:
-
Detach Process in vb.net 2012
I'm using visual studio 2012 (vb.net) and when I created the project, there was this start button on the tool bar which looks like an arrow.
Some weeks later, I realized the start button had changed to "Attach".
When I run the application, "Attach to Process" form appears instead of my startUp form.
I looked through the tools and Debug menus thinking that I would locate "Detach Process"...Last edited by Frinavale; Mar 19 '14, 03:53 PM. Reason: Removed code tags surrounding the non-code explanation of the problem. -
Using Background worker
I am using vb.net 2008 which is connected to sql 2008. I have a timer control and a tooltip. The timer always keeps on ticking and when a condition is met the tooltip displays a message. My problem now is the timer hangs or freezes the program.
I thought of a Background worker that works on a separate thread, but how to go about it.
How can I put the IterateMovement procedure below in a background worker so that every 5 seconds it will... -
Sql database schemer
Please, I'm using sequel server 2012 and I have so many tables in it .
How can I create a database schemer that will show a graphical representation of the tables? Thanks and I wish u all a prosperous New years.Last edited by Niheel; Dec 31 '13, 03:59 PM. -
Convert Crystal Report in vb.net 2008 to vb.net 2012
Code:Please I was using vb.net 2008 with its crystal report and when I migrated to vb.net 2012, the crystal report displays junk characters. And the packaged files that I used to have in 2008 version have mysteriously vanished in the 2012 project. Please help me solve the problems. Thanks
-
Timer Control / Threading
The code below loops through all the records and checks if Allocation_Due_ Date is equal to the current date. If a match is found, the tooltip displays it on a button on the form. My problem is a time will come and the records will be many which will cause the machine to hang. So if someone can help me place the below code in a thread to free the machine from hanging. Thank you
...Code:' The sub procedure 'AllocationExpiryDate' is called to
-
Check records continuously from sql database if a condition is met
Please, how can check a record continuously from sql database using vb.net 2008 if a condition is met?
Assuming connection has been established and the display of the in records has also been done. The moment the program is launched, the checking starts...
I know about threading but how to implement it. Please help. Thank u in advance.
Ben -
vb.net 2008 crystal report connection to sql database
Please, I'm using Vb.net 2008 and sql 2008 and I have a crystal report to print, but the connection to the sql 2008 programmaticall y becomes a problem. Can some show me the connection code through the crystal report to the sql database. Thanks. Ben -
Synchronize two sql servers
Please, I'm using two sql database servers (2008) on a network. Data is updated every minute and would like to synchronize the two servers so that backup can be taken from Sever1 to Server 2. Could some one show me the steps? Thanks.
Ben -
Hi Mikkeee, since I wasn't getting the required result, I decided to step into the code and that was when I realized there was something wrong even if I displayed it using a msgbox. What surprises me is that when I detached it from the mdi form and run it, it worked fine. Just that it failed to work with the mdi form.Leave a comment:
-
TextBox Problem
I'm using Vb.net 2008 with an MDI form with a child named frmQueryDatabas e having a textbox (txtQuery).
I have noticed that when I added the child to the MDI form and run the program, the content of the text box in debug mode was always empty, though you could see a text in it.
...Code:'When the frmQueryDatabase was a child to the MDI form Dim frm As New frmQueryDatabase frm.MdiParent = Me frm.Show()
No activity results to display
Leave a comment: