| Stored Proc results in DataGridView |
|
 |
Index ‹ DotNet ‹ ADO
|
- Previous
- 1
- 2
- 3
- Net Framework >> Getting 3.0 Facts StraightOk.
If anybody has a url , that'd be great.
My IT Department is asking for the exact lowdown on 3.0, from a machine/OS
perspective.
3.0 projects can be
developed on
a. XP SP2
b. Vista
c. ( I guess 2003Server, but how uses that as their personal OS)
and deployed on
2003Server
(some future version of Vista)
Oh man. I know I screwed that up somehow.
I found a few blogs, but would like group help with the concrete facts with
this one.
- 4
- Net Framework >> Getting Client's Browser information.Hello
Are there some namespace in the framework which one I can take information of the client's Browser? (developing with ASP.NET
Example
If the client has my URL in his Restricted Site, in his security's Internet Options, Are there some manner for knowing it?
Some online article
Thanks in advance!
l-touched
- 5
- ADO >> generate xml from sample xmlhi,
i need to generate an xml files of some data in my database ...
i've an xml sample of the result xml nad i've to create a xml
with the same structure ...
which it is the better and faster way?
Can i retrieve a schema from the sample.xml and then write an
xml based on this schema ?
Might i use Dataset.readxmlschema , Dataset.readxml and
Dataset.writexmlschema , Dataset.writexml ???
tnx in advance
andrew
- 6
- Dotnet >> How can I see what's in a collection during debugging?<I also posted this on microsoft.public.vsnet.debugging 'cuz I didn't know
which was more appropriate or would get quickest response>
Hello,
Can someone tell me how I can view the contents of a collection when in
debug mode?
For example, I working with a dataset and when the app stops at a breakpoint
I'd like to see what is actually in the Tables collection of the dataset. I
add a watch on my dataset variable and expand the Tables object. It just
keeps showing me the following: Count, IsReadOnly, Is Synchronized, Item and
SyncRoot. Expand SyncRoot and you're at the beginning of a big old
recursion.
So if I want to see what's in row x of table y for example, I have to create
a variable in my code representing that row in that table and add a watch
for THAT variable. I have to believe that there is an easier, more dynamic,
way for me to inspect the content of this during debugging.
Any help would be greatly appreciated.
David.
- 7
- Visual C#.Net >> OpenFileDialoghi,
i have a form with a webbrowser control and an openfiledialog. how do i open
an HTML document in the webbrowser?
help me please!
--
Alvo von Cossel I of Germany
- 8
- Microsoft Project >> Gantt chart bar displays wrong timeI am using Project 2007. We are mapping out an industrial process in seconds
by manually scaling hours as minutes and minutes as seconds. I have the
timescale set as minutes with a 10 count and 1,2,3,4 label. When I put a
number over 240 mins in for duration, the gantt chart bar adds 60 to the
number. I can duplicate the problem on a new project. Does anyone have any
ideas?
--
Jason Reese
Microsoft Certified Professional
Microsoft Small Business Specialist
SBA Computers, Inc.
- 9
- 10
- Net Framework >> err.raise inside catch?I would like to use err.raise(x) within a catch block to send an exception
back to the calling function or cain of functions. Is this ok to do? I know
if i dont use try catch fail in the child function that it will send an
exception to the calling function but i want to have error handling in all
chain functions.
any MSDN documentation on this?
- 11
- Microsoft Project >> MS ProjectHi
I have a MS Project 2000 and I have two questions (may be for beginners :-)
- How to enter a recurrent task that happens regularly?
- On the Gantt chart , can we see the summary recurrent task as a line that
includes milestones showed inside it (meaning the repeated tasks showed as
milestones inside the line that represents the recurrent summary task) ?
Thanks in advance
Fayez
- 12
- Winforms >> Emptying the Controls collection prevents form from closing.Why does disposing all of the controls and emptying the controls collection
in a form prevent it from closing?
At the minute we have the lovely choice of not destroying our controls and
having a major memory leak, or we destroy the controls, and find ourselves
unable to close the form.
Any advice appreciated.
Cheers,
4Space
- 13
- Dotnet >> Converting dates with CultureAndRegionInfoBuilder ?Hi,
the built-in CultureInfo in .NET 2.0 can convert calendar dates
between cultures
for instance this code shows current time in hijri calendar
(arabic culture) :
CultureInfo pcul = new CultureInfo("ar-SA");
MessageBox.Show(DateTime.Now.ToString("F", pcul));
it seems that MIcrosoft has not developed this feature for all
CultureInfos
for example :
CultureInfo pcul = new CultureInfo("fa-IR");
MessageBox.Show(DateTime.Now.ToString("F", pcul));
must return the current date in persian calendar (jalali date) but
it retrurns the
Georgian calendar date time.
is there anyway to override this routines in .NET 2.0 ? (it was
possible in .NET 1.1)
I found CultureAndRegionInfoBuilder class to build new cultures but
I found nothing
about date conversion routines.
Thanks,
Mehdy Mohajery
mehdy[@]zworg.com
- 14
- Visual C#.Net >> Dependency Injection - Can It Be This Simple?Does the following accurately summarize the notion of "dependency
injection?"
Class A needs to cause "Some Activity" to happen (in addition to other
things that Class A does).
Class A may or may not have a default implementation of Some Activity.
Class B is able to do Some Activity.
At runtime, a reference to an instance of Class B is passed to Class A
(perhaps via Setter, or to the constructor of Class A).
Class A causes Some Activity to happen by calling a method of its Class B
reference.
In the future (or even immediately), we need for an alternative
implementation of Some Activity, so we create Class C.
We can then pass a reference [to a Class C instance] to Class A, which then
initiates Some Activity on the Class C instance.
In the above account, Class B and Class C both implement an interface or
derive from a common abstract base class -- and Class A knows only about
that interface, and initiates Some Activity as a method of that interface or
base class.
The most important benefit of the above arrangement (dependency injection)
is that we can extend the application specifically to perform alternative
implementations of Some Activity by adding a new class and updating the
application configuration (so that Class A can be passed a reference to the
new class), without modifying Class A in any way. In other words, Class A is
open for extension, but closed for modification, and dependency injection is
one way to achieve that objective.
Your comments are appreciated, as I'm wanting some verification or
clarification of my understanding of dependency injection.
Thanks.
- 15
- Visual C#.Net >> Isolated Storage bug at design timeHello,
We use several user controls and derived custom controls. Some of
which actually hit the database at design time to show data (such as
filling a list box, etc...)
Our c# client server app uses the .NET Isolated storage libraries for
storing connection string and other info about the application. The
problem is that the Isolated storage bombs at design time (when you
try and view a control that hits the database at design time).
The workaround we have in place is the Isolated storage check is in a
try / catch. If it fails, we load a hard-coded xml file with the same
settings at a specified path that never changes... which defeats the
whole purpose of Isolated Storage.
This isn't a huge issue cuz it only happens at design time and we have
a (hackish) workaround, but I was wondering if anyone has had this
problem and/or knows why it would be happening?
Thanks,
Dave
|
| Author |
Message |
Richard>
|
 Posted: Wed Jan 31 16:59:18 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
I'm trying to get the results of a stored proc (with no input parameters)
into a datagridview. I'm able to get the results into a messagebox but i'm
nor sure how to get them into a DataGridView
Using cn As New SqlConnection(strConn)
Try
cn.Open()
Catch ex As Exception
MessageBox.Show("Connect Attempt Failed")
MessageBox.Show(ex.Message.ToString)
End Try
Dim cmd As New SqlCommand("sp_TestBilly", cn)
cmd.CommandType = CommandType.StoredProcedure
Dim rdr As SqlDataReader
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
'Do While rdr.Read()
' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & " "
& rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
'Loop
'rdr.Close()
datagridview1.DataSource=***here's where I can't get the code
right****
cn.Close()
End Using
End Sub
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003
DotNet305
|
| |
|
| |
|
RobinS
|
| Posted: Wed Jan 31 16:59:18 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
Using cn As New SqlConnection(strConn)
Try
cn.Open()
Catch ex As Exception
MessageBox.Show("Connect Attempt Failed")
MessageBox.Show(ex.Message.ToString)
End Try
Dim cmd As New SqlCommand("sp_TestBilly", cn)
cmd.CommandType = CommandType.StoredProcedure
Dim da as SqlDataAdapter = New SqlDataAdapter(cmd)
dt = New DataTable()
da.Fill(dt)
myDataGridView.DataSource = dt
cn.Close()
End Using
You can't use a DataReader; it reads the data one row at a time, it doesn't
keep the whole set of data in memory. You have to use a DataSet, DataTable,
List(Of T), Collection, Arraylist, or something like that.
Robin S.
-------------------------------------------------------------
"BillyRogers" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> I'm trying to get the results of a stored proc (with no input parameters)
> into a datagridview. I'm able to get the results into a messagebox but
> i'm
> nor sure how to get them into a DataGridView
>
> Using cn As New SqlConnection(strConn)
> Try
> cn.Open()
> Catch ex As Exception
> MessageBox.Show("Connect Attempt Failed")
> MessageBox.Show(ex.Message.ToString)
> End Try
>
> Dim cmd As New SqlCommand("sp_TestBilly", cn)
> cmd.CommandType = CommandType.StoredProcedure
>
> Dim rdr As SqlDataReader
> rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
>
> 'Do While rdr.Read()
> ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & "
> "
> & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
> 'Loop
> 'rdr.Close()
>
>
>
>
> datagridview1.DataSource=***here's where I can't get the code
> right****
>
>
>
> cn.Close()
> End Using
> End Sub
>
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003
|
| |
|
| |
|
William
|
| Posted: Wed Jan 31 17:13:40 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
Add
Dim dt as new DataTable
dt.Load rdr
before binding dt to the DataSource.
This is explained in detail in my book...
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"BillyRogers" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> I'm trying to get the results of a stored proc (with no input parameters)
> into a datagridview. I'm able to get the results into a messagebox but
> i'm
> nor sure how to get them into a DataGridView
>
> Using cn As New SqlConnection(strConn)
> Try
> cn.Open()
> Catch ex As Exception
> MessageBox.Show("Connect Attempt Failed")
> MessageBox.Show(ex.Message.ToString)
> End Try
>
> Dim cmd As New SqlCommand("sp_TestBilly", cn)
> cmd.CommandType = CommandType.StoredProcedure
>
> Dim rdr As SqlDataReader
> rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
>
> 'Do While rdr.Read()
> ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & " "
> & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
> 'Loop
> 'rdr.Close()
>
>
>
>
> datagridview1.DataSource=***here's where I can't get the code
> right****
>
>
>
> cn.Close()
> End Using
> End Sub
>
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003
|
| |
|
| |
|
RobinS
|
| Posted: Wed Jan 31 17:43:38 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
As usual, Bill is right. Sigh. I don't use DataReaders very much. I guess I
should buy his book and read it. ;-)
Robin S.
----------------------
"William (Bill) Vaughn" <EMail@HideDomain.com> wrote in message
news:%EMail@HideDomain.com...
> Add
> Dim dt as new DataTable
> dt.Load rdr
>
> before binding dt to the DataSource.
>
> This is explained in detail in my book...
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "BillyRogers" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
>> I'm trying to get the results of a stored proc (with no input
>> parameters)
>> into a datagridview. I'm able to get the results into a messagebox but
>> i'm
>> nor sure how to get them into a DataGridView
>>
>> Using cn As New SqlConnection(strConn)
>> Try
>> cn.Open()
>> Catch ex As Exception
>> MessageBox.Show("Connect Attempt Failed")
>> MessageBox.Show(ex.Message.ToString)
>> End Try
>>
>> Dim cmd As New SqlCommand("sp_TestBilly", cn)
>> cmd.CommandType = CommandType.StoredProcedure
>>
>> Dim rdr As SqlDataReader
>> rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
>>
>> 'Do While rdr.Read()
>> ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & "
>> "
>> & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
>> 'Loop
>> 'rdr.Close()
>>
>>
>>
>>
>> datagridview1.DataSource=***here's where I can't get the code
>> right****
>>
>>
>>
>> cn.Close()
>> End Using
>> End Sub
>>
>> --
>> Billy Rogers
>>
>> Dallas,TX
>>
>> Currently Using SQL Server 2000, Office 2000 and Office 2003
>
>
|
| |
|
| |
|
BillyRogers
|
| Posted: Thu Feb 01 07:16:01 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
Thanks that was perfect. I'll have to take a look at your book.
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003
"William (Bill) Vaughn" wrote:
> Add
> Dim dt as new DataTable
> dt.Load rdr
>
> before binding dt to the DataSource.
>
> This is explained in detail in my book...
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "BillyRogers" <EMail@HideDomain.com> wrote in message
> news:EMail@HideDomain.com...
> > I'm trying to get the results of a stored proc (with no input parameters)
> > into a datagridview. I'm able to get the results into a messagebox but
> > i'm
> > nor sure how to get them into a DataGridView
> >
> > Using cn As New SqlConnection(strConn)
> > Try
> > cn.Open()
> > Catch ex As Exception
> > MessageBox.Show("Connect Attempt Failed")
> > MessageBox.Show(ex.Message.ToString)
> > End Try
> >
> > Dim cmd As New SqlCommand("sp_TestBilly", cn)
> > cmd.CommandType = CommandType.StoredProcedure
> >
> > Dim rdr As SqlDataReader
> > rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
> >
> > 'Do While rdr.Read()
> > ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & " "
> > & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
> > 'Loop
> > 'rdr.Close()
> >
> >
> >
> >
> > datagridview1.DataSource=***here's where I can't get the code
> > right****
> >
> >
> >
> > cn.Close()
> > End Using
> > End Sub
> >
> > --
> > Billy Rogers
> >
> > Dallas,TX
> >
> > Currently Using SQL Server 2000, Office 2000 and Office 2003
>
>
>
|
| |
|
| |
|
BillyRogers
|
| Posted: Thu Feb 01 07:58:00 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
Is there someway to put the data into excel. I know how how to open an
instance of excel but can't seem to figure out how to past the data without
cycling through each cell.
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
oXL = CreateObject("excel.application")
oWB = oXL.Workbooks.Add
oSheet = oWB.ActiveSheet
oSheet.Cells(11, 1) = myDataGridView.DataSource **this doesn't work**
oXL.Visible = True
oXL.UserControl = True
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003
"BillyRogers" wrote:
> Thanks that was perfect. I'll have to take a look at your book.
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003
>
>
> "William (Bill) Vaughn" wrote:
>
> > Add
> > Dim dt as new DataTable
> > dt.Load rdr
> >
> > before binding dt to the DataSource.
> >
> > This is explained in detail in my book...
> >
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > INETA Speaker
> > www.betav.com/blog/billva
> > www.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > __________________________________
> > Visit www.hitchhikerguides.net to get more information on my latest book:
> > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> > -----------------------------------------------------------------------------------------------------------------------
> >
> > "BillyRogers" <EMail@HideDomain.com> wrote in message
> > news:EMail@HideDomain.com...
> > > I'm trying to get the results of a stored proc (with no input parameters)
> > > into a datagridview. I'm able to get the results into a messagebox but
> > > i'm
> > > nor sure how to get them into a DataGridView
> > >
> > > Using cn As New SqlConnection(strConn)
> > > Try
> > > cn.Open()
> > > Catch ex As Exception
> > > MessageBox.Show("Connect Attempt Failed")
> > > MessageBox.Show(ex.Message.ToString)
> > > End Try
> > >
> > > Dim cmd As New SqlCommand("sp_TestBilly", cn)
> > > cmd.CommandType = CommandType.StoredProcedure
> > >
> > > Dim rdr As SqlDataReader
> > > rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
> > >
> > > 'Do While rdr.Read()
> > > ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2) & " "
> > > & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6), "sp_BillyTest")
> > > 'Loop
> > > 'rdr.Close()
> > >
> > >
> > >
> > >
> > > datagridview1.DataSource=***here's where I can't get the code
> > > right****
> > >
> > >
> > >
> > > cn.Close()
> > > End Using
> > > End Sub
> > >
> > > --
> > > Billy Rogers
> > >
> > > Dallas,TX
> > >
> > > Currently Using SQL Server 2000, Office 2000 and Office 2003
> >
> >
> >
|
| |
|
| |
|
RobinS
|
| Posted: Thu Feb 01 11:40:01 CST 2007 |
Top |
ADO >> Stored Proc results in DataGridView
You can do that with ADO.Net, I believe, without automating Excel. I
haven't done it personally, but if you google this newsgroup and
microsoft.public.dotnet.languages.vb, you'll find it's been asked and
answered multiple times.
Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
----------------------------------------
"BillyRogers" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> Is there someway to put the data into excel. I know how how to open an
> instance of excel but can't seem to figure out how to past the data
> without
> cycling through each cell.
>
>
> Dim oXL As Excel.Application
> Dim oWB As Excel.Workbook
> Dim oSheet As Excel.Worksheet
>
> oXL = CreateObject("excel.application")
>
> oWB = oXL.Workbooks.Add
> oSheet = oWB.ActiveSheet
>
>
> oSheet.Cells(11, 1) = myDataGridView.DataSource **this doesn't
> work**
>
> oXL.Visible = True
> oXL.UserControl = True
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003
>
>
> "BillyRogers" wrote:
>
>> Thanks that was perfect. I'll have to take a look at your book.
>> --
>> Billy Rogers
>>
>> Dallas,TX
>>
>> Currently Using SQL Server 2000, Office 2000 and Office 2003
>>
>>
>> "William (Bill) Vaughn" wrote:
>>
>> > Add
>> > Dim dt as new DataTable
>> > dt.Load rdr
>> >
>> > before binding dt to the DataSource.
>> >
>> > This is explained in detail in my book...
>> >
>> > --
>> > ____________________________________
>> > William (Bill) Vaughn
>> > Author, Mentor, Consultant
>> > Microsoft MVP
>> > INETA Speaker
>> > www.betav.com/blog/billva
>> > www.betav.com
>> > Please reply only to the newsgroup so that others can benefit.
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > __________________________________
>> > Visit www.hitchhikerguides.net to get more information on my latest
>> > book:
>> > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> > -----------------------------------------------------------------------------------------------------------------------
>> >
>> > "BillyRogers" <EMail@HideDomain.com> wrote in message
>> > news:EMail@HideDomain.com...
>> > > I'm trying to get the results of a stored proc (with no input
>> > > parameters)
>> > > into a datagridview. I'm able to get the results into a messagebox
>> > > but
>> > > i'm
>> > > nor sure how to get them into a DataGridView
>> > >
>> > > Using cn As New SqlConnection(strConn)
>> > > Try
>> > > cn.Open()
>> > > Catch ex As Exception
>> > > MessageBox.Show("Connect Attempt Failed")
>> > > MessageBox.Show(ex.Message.ToString)
>> > > End Try
>> > >
>> > > Dim cmd As New SqlCommand("sp_TestBilly", cn)
>> > > cmd.CommandType = CommandType.StoredProcedure
>> > >
>> > > Dim rdr As SqlDataReader
>> > > rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
>> > >
>> > > 'Do While rdr.Read()
>> > > ' MessageBox.Show(rdr(0) & " " & rdr(1) & " " & rdr(2)
>> > > & " "
>> > > & rdr(3) & " " & rdr(4) & " " & rdr(5) & " " & rdr(6),
>> > > "sp_BillyTest")
>> > > 'Loop
>> > > 'rdr.Close()
>> > >
>> > >
>> > >
>> > >
>> > > datagridview1.DataSource=***here's where I can't get the
>> > > code
>> > > right****
>> > >
>> > >
>> > >
>> > > cn.Close()
>> > > End Using
>> > > End Sub
>> > >
>> > > --
>> > > Billy Rogers
>> > >
>> > > Dallas,TX
>> > >
>> > > Currently Using SQL Server 2000, Office 2000 and Office 2003
>> >
>> >
>> >
|
| |
|
| |
|
| |
|
Index ‹ DotNet ‹ ADO |
- Next
- 1
- Microsoft Project >> Resource allocated to ongoing taskHi
Project Pro 2002
Project server 2002
PWA
Please can you tell me how I can add a resource to an existing task
without it showing them as overallocated for the time before they
joined the company.
I have a chap just started, I've allocated him to a task which started
in April and so for that month my resource usage chart shows him as
overallocated.
Is it just a case of deleting the hours manually from the resource
usage view?
Many thanks
lynne
- 2
- Visual C#.Net >> 'dynamic' classHello,
I have a variable containing a classname and want to use that variable to
create an instance of the class. Is that possible? How?
string classvar = "xyz"
object class = new classvar --> creates an instance of class xyz
Thanks in advance
Frank
- 3
- Microsoft Project >> Printing a specific phaseHi all,
I have a MS Project 2003 document which is comprised of several phases with
subtasks under each phase. Is there a way that I can print out a specific
phase and its subtasks? I know I can do a task range filter and print that
but I wasn't sure if there was a better way. I would appreciate any helpful
hints on this.
Thank you in advance!
LaurenM
- 4
- Visual C#.Net >> Question on threading and using P/Invoke...If a DLL has been created to be thread-safe, and you create a wrapper
class around it in C# that is non-static (i.e. you must instantiate
objects from it), what are the implications of creating multiple objects
from said wrapper class? There's only one DLL, so is it creating
multiple instances of its functions when each object is making calls to
it? Does anyone know of any resources that explain this? Thanks, gilad
- 5
- Microsoft Project >> 24 Hour/Day ScheduleI'm trying to develop a schedule for a 24 hr/day project, including all
resources. There will be two crews on this project working from 6:00 AM to
6:00 PM for the first shift. The 2nd shift will work from 6:00 PM to 6:00
AM. I can only assume that I would develop a day shift resource and a night
shift resource and assign the work hours accordingly? Also, the Gant chart
does not appear to depict the correct start time of 6:00, it defaults to
8:00. I would like to have the works hours accurately shown on the Gant
chart for both shifts. This is most likely a simple question for those more
experienced - regardless I am hopeful to receive some help. Thanks in
advance.
- 6
- Visual C#.Net >> Stored Procedures and check for recordcountI have this Stored Procedure that is passed the following parameter
protected void btnNext_Click(object sender, EventArgs e)
{
Session["Locations"] =3D Locations.Text;
Server.Transfer("AudioVisual.aspx");
/* Calling on Stored Procedure */
string connectionStr =3D
@"server=3Dlocalhost;uid=3D"";pwd=3D"";trusted_connection=3Dtrue;database=
=3DPMAEvents=AD";
SqlConnection connectObj =3D new SqlConnection(connectionStr);
SqlCommand commandObj =3D new SqlCommand("eventtest",
connectionStr);
commandObj.CommandType.StoredProcedure;
commandObj.Parameters.Add(new SqlParameter("@Locations",
SqlDbType.VarChar)).Value =3D Session["Locations"];
}
but I'm running into problems when I go to test to see if any values
were returned
if( recordreturned =3D=3D 0 )
{
Server.Transfer("nextpage.aspx");
}
else{
//Stay on the same page!!!!
}
i'm a little stuck on the syntax to test if the sp returned any
records!
thanks
- 7
- 8
- Net Framework >> Unhandled exception in class libraryHello,
I am creating one class library in .net. I need to save the
unhandled exception in a text file. So how to catch the unhandled
exception from class library.
Unhandled exception means, i am having try.. Catch block in my
class library. Even though, if i got the error in any place of my
code.
How to catch these type of unhandled exception from my class
library.
Regards,
Raj.
- 9
- Winforms >> Getting Text from a RichEdit20aI am primarily a web developer, but I am branching out for this project into
the world of Windows Forms.
I am looking for any help, examples, samples to show me how to retrieve text
from a RichEdit20a (or RichEdit20w) that exists in another application
running on the same box.
This is the only part of a large project that I am running that is new to
me, so I want to get this sorted as soon as possible. Then I can relax and
concentrate on actually writing the code.
Any help would be appreciated.
Thanks very much.
Matt. Davies
P.S. My apologies for a cross group post, but I wasn't sure which would be
the most appropriate group...inexperience again !
- 10
- Net Framework >> Install a Service Programmatically ?Hi there,
I'm designing an application in C#. One of the files in my application
is "server.exe". This assembly listens for inbound connections and handles
various incoming requests. I want to give the user of my application the
option to allow server.exe to execute and handle requests even after the
user has logged off.
My plan is to ask the user "Would you like this service to continue
running after you log off?". If the user answers yes, I want to install
"server.exe" as a service. I've done this successfully in a manual way using
the 'installutil' .NET helper application, but my application will need to
do this in an automated way.
How can I accomplish this? Shall I shell out to a command prompt and
execute installutil against server.exe? Does the user need to be an
administrator of his machine? Can I be 100% certain that if the user has the
.NET framework installed that 'installutil' will be installed as well? If
so, how do I find it? Is there some sort of macro (i.e. %DOTNET_FOLDER% for
example) that will allow me to easily determine the dotnet folder where
'installutil' resides?
Is there any way to get server.exe to execute after a user has logged
off *other* than using a service? I'd appreciate any suggestions.
--
Sincerely,
David Sworder
http://www.CodeFanatic.com
- 11
- Microsoft Project >> Predesessor link not workingI am surprised to see that the task start date is not changing according to
it's predesessor end dates...I don't know what happned to my project plan. I
checked all settings. They look ok. I also notice that the duration
calculation is not proper..for example it is coming to be 3.05 days if the
there is 1 week difference between schedule START and FINISH dates. Can you
help?
- 12
- Dotnet >> Microsoft .Net Security Information messageIs there a way to get rid of the "microsoft .net security information"
balloon from No Touch Deploy forms?
The application is running under the Internet Zone and we will not be able
to change the security permissions on the client's machines. Can this
message be removed through digital signing or some other convension? Or is
this something that we cannot work around?
Thanks,
Jody
- 13
- 14
- Microsoft Project >> How do I filter for Overallocated Tasks in Project?Hi,
I'm beginning to level my resources, but I first want to know which tasks
have overallocated resources assigned to them so I can decide what priority
level to give them before leveling the project.
I first tried to set a filter for task overallocations, but that doesn't
help since only overallocations for the individual task show up (in my case
none, because, although during any given day there may be three tasks
assigned to Bob totalling 24 hours-- a definite overallocation-- each
individual task is not overallocated at 8 hours).
I also tried to filter for resource overallocations but that didn't help
since 1) it only works on resource views and, 2) it simply highlights the
resources which are overallocated without giving you a list of the tasks
which are creating the overallocations.
Finally I tried messing around with a custom filter but wasn't able to find
the right combination of fields and values to give the desired results.
If anyone has any suggestions I would really appreciate it.
Thanks,
Carlos
- 15
|
|
|