|
Does anyone know of any good free controls for creating pie charts?
|
|
|
|
|
Try the MSChart Control which comes with VB 6.0
|
|
|
|
|
I have an empty table I set up as a Master table template. How can I copy this table and give it a new name using SQL? I have to create a new table each day so I just want to copy this template table I have.
|
|
|
|
|
select * into new_table from old_table where 1 = 0
This will copy the basic structure, but it will not create indexes, PK, constraints, etc.
Kant wrote:
Actually she replied back to me "You shouldn't fix the bug. You should kill it"
|
|
|
|
|
Is there no way to do a SQL command like CREATE TABLE or something to copy this table?
|
|
|
|
|
Something like a "COPY TABLE STRUCTURE"?
No, probably because it's not a good practice to spread your data through several small physical tables. Your physical database design should be decoupled from the logical design.
Kant wrote:
Actually she replied back to me "You shouldn't fix the bug. You should kill it"
|
|
|
|
|
Oh boy... Your DB admin will love that
Just use one table and add a date of entry column. Its soooooo much simpler.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
Do you know where I can get modules to print bar codes ?
|
|
|
|
|
Look on SourceForge[^]. I saw a barcode thing there recently ("BarCode .NET" or something like that).
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
How can i use concurrency control using vb.net.I have used sqlcommand,sqlconnection and sqldatareader(No Dataset) to access data from database in my project.And multiple user can access and modify data ,so how can i use lock and cursor to maintain consistency in database.
|
|
|
|
|
|
I will be glad to have a VB.NET code snippet to implement Concurency control when data inserted or updated on the database through command/datareader objects of VB.NET.
|
|
|
|
|
I apologize for the brevity of my response -- you can achieve concurrency control using transactions in ADO.NET with the SqlTransaction class (see MSDN[^] for more details).
However, the following two examples might be more specific to the issue you are attempting to resolve:
MSDN Data Concurrency[^]
Data Concurrency Exception Handling[^]
|
|
|
|
|
how to access active directory in windows 2000 using vb.net ?
i want to get the list of active dir in windows 2000,
can anybody help me please? thx very much
|
|
|
|
|
This is in C#:
http://www.codeproject.com/useritems/ActiveDirQuery.asp[^]
But it should give you a starting point...
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
Hi,
I am a diabetic and new at programming. I record my sugar levels at a regular basis on a ACCU-CHEK. It has a infrared port. How do I transfer the data from it to my PC?
Please help!
Thanks Bloodhound1
|
|
|
|
|
I was wondering where I could find information on automating VB with Excel, outputting data to a spreadsheet. I'm trying to make a punch in and punch out type setup that keeps track of punches on an Excel spread sheet. Any info would be helpful.
Thank you
The Jazz Master 6000
DJ Badknees
Parma Grind Crew - www.geocities.com/parmagrindcrew
|
|
|
|
|
Read the VBA help in Office..
Automating Excel in VB6 is very similar to it.
|
|
|
|
|
Plz help!
how can I make my application to do certain tasks in other application repetitely so that I can monitor the performance of that application.
For eg., I open a particular menu and select a sub menu and hence the procedure assosiated is executed(Help window in notepad). Then I close that task(help window). My application should perform this whole task certan number of times.
How can i do this in vb .
|
|
|
|
|
You can try using the SendKeys function (Lookup MSDN)
You can send a specific key sequence using SendKeys (Eg Alt+H or Alt+F4)
|
|
|
|
|
Hi
I am using a datagrid to indicate employes that are on leave iver a certain period. The code works well for employees that take leave more then one day. The problem arises when the employee only takes one day leave, the datagrid shows the day of leave and every other day up until the end of the array. Please help
<br />
For i = 0 To oDS.Tables("Dept_History").Rows.Count - 1<br />
<br />
dr = dt.NewRow()<br />
dr(0) = oDS.Tables("Dept_History").Rows(i).Item("Name").ToString()<br />
<br />
iCol = 1<br />
For m = Month(NewStartD) To Month(NewEndD)<br />
If m = Month(NewEndD) Then<br />
lastday = Day(NewEndD)<br />
Else<br />
lastday = Darray(m)<br />
End If<br />
If m = Month(NewStartD) Then<br />
startday = Day(NewStartD)<br />
Else<br />
startday = 1<br />
End If<br />
<br />
For d = startday To lastday<br />
Dim CheckDate As Date<br />
Dim SD As String<br />
Dim ED As String<br />
Dim ld As Long<br />
Dim FDate As New Date(Year(NewEndD).ToString(), m.ToString(), d.ToString())<br />
<br />
'FDate = m.ToString() & "/" & d.ToString() & "/" & Year(NewEndD).ToString()<br />
ED = oDS.Tables("Dept_History").Rows(i).Item("EDate").ToString()<br />
SD = oDS.Tables("Dept_History").Rows(i).Item("SDate").ToString()<br />
ld = DateDiff(DateInterval.Day, CDate(ED), CDate(SD))<br />
<br />
If DateDiff(DateInterval.Day, CDate(FDate), CDate(SD)) = 0 Then<br />
dr(iCol) = d.ToString()<br />
ElseIf DateDiff(DateInterval.Day, CDate(FDate), CDate(ED)) = 0 Then<br />
dr(iCol) = d.ToString()<br />
Else<br />
dr(iCol) = "0"<br />
End If<br />
iCol = iCol + 1<br />
Next d<br />
Next m<br />
<br />
dt.Rows.Add(dr)<br />
Next i<br />
<br />
Dim dv As New DataView(dt)<br />
<br />
laDatagrid.DataSource = dv<br />
laDatagrid.DataBind()<br />
<br />
|
|
|
|
|
I created my first web service and accessing it from IE on the local machine works great. But when I try to access from another computer on the network I can see the definitions but cannot execute any of the functions? It says they are only avaiable to the local machine. How do I make it available for any machine?
|
|
|
|
|
Here Is The Answer:
Your problem lies in your machine.config file which will most likely
be in the following directory:
C:\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG
The problem is that .NET 1.1 ships with HttpPost and HttpGet turned
off. look for the following tags:
<webservices>
<protocols>
<add name="HttpSoap1.2">
<add name="HttpSoap">
<add name="HttpPostLocalhost">
<add name="Documentation">
You will notice that HttpPost and HttpGet are commented out. Uncomment
them and it should fix your problem.
Thanks,
Kenton Smeltzer
|
|
|
|
|
You found that on Google too hugh?
I just had the same issue.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
How to write macro which will be set AssemblyVersion,when program is compiled like this:
1.1.X.Y
where x- is current Month & Day and Y - is current Time
Somebody can Help me?
S_W
|
|
|
|