| Stored Procedures and check for recordcount |
|
 |
Index ‹ DotNet ‹ Visual C#.Net
|
- Previous
- 1
- 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.
- 2
- 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.
- 3
- 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 !
- 4
- 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
- 5
- ADO >> Stored Proc results in DataGridViewI'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
- 6
- 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
- 7
- 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?
- 8
- 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?
- 9
- 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
- 10
- 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
- 11
- 12
- 13
- 14
- 15
- 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
|
| Author |
Message |
tomoseki
|
 Posted: Tue Jan 09 21:55:08 CST 2007 |
Top |
Visual C#.Net >> Stored Procedures and check for recordcount
I 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
DotNet126
|
| |
|
| |
|
Karthik
|
| Posted: Tue Jan 09 21:55:08 CST 2007 |
Top |
Visual C#.Net >> Stored Procedures and check for recordcount
EMail@HideDomain.com wrote:
> I 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
Hi,
This is how you can do i feel... I have given some code snippet.
SqlConnection conn =3D new SqlConnection();
conn.ConnectionString =3D "Put Connection string here";
SqlCommand cmd =3D new SqlCommand();
cmd.CommandText =3D "Stores Procedure name";
cmd.CommandType =3D CommandType.StoredProcedure;
SqlParameter param =3D new SqlParameter("ParamName",
SqlDbType.Int);
param.Direction =3D ParameterDirection.Input;
//Add some more parameterd , if needed.
// Assign the return paramter.
SqlParameter retValue =3D new SqlParameter("@RETUTRN_VALUE",
SqlDbType.Int);
retValue.Direction =3D ParameterDirection.ReturnValue;
cmd.ExecuteScalar();
// Get the return value here.
int returnValue =3D Convert.ToInt32(retValue.Value);
//Another way of getting return value.
returnValue =3D cmd.ExecuteNonQuery(); //This will return
only in case of insert, delete , update command.
|
| |
|
| |
|
XOR
|
| Posted: Tue Jan 09 22:38:00 CST 2007 |
Top |
Visual C#.Net >> Stored Procedures and check for recordcount
you could use an output parameter in the sql.
|
| |
|
| |
|
| |
|
Index ‹ DotNet ‹ Visual C#.Net |
- Next
- 1
- 2
- Dotnet >> How can I share code between projects w/o creating a class library?Using VS2003, I can't add an existing class to a project w/o the IDE
creating a copy of it.
I want multiple projects to be able to share a central copy of a class.
I can't compile the shared class into a library because one of the
executables that uses the class needs to be a self contained executable
that will be downloaded and immediately executed on a PDA.
I can't GAC the shared library so that both applications can use it
because my deployment model is limited to "OTA" - simple downloads of
cab files and I don't think I can GAC something using the standard
cabwiz cab file builder.
I tried to use AL.exe to link my shared library to the executable that
needs to be self contained but I can't even begin to figure out how to
use that tool (I think I have to create "modules" - don't even know what
they are).
The simplest way is if I could just share the code without VS forcing me
to make local copies......
- 3
- Dotnet >> The device, \Device\Harddisk0\D, has a bad block.I have for months now had my computer hanging ocassionally with the error
"The device, \Device\Harddisk0\D, has a bad block. I thought the problem
would go away after I removed my "D" drive from the system, could be going
bad. I still get 26 of these errors in a row, while the computer freezes for
about 6 minutes. But I have no "D" drive. Any ideas?
ASUS P5WD2-E Premium Motherboard
Intel 845 D 775 3.0 Processor
Windows XP Pro, v 5.1 SP2 OS
C: SATA 500GB Maxtor, NTFS, 1 Basic Partition 34% free
D: SATA 500GB Maxtor, NTFS, 1 Basic Partition 98% free (removed)
ATI Radeon X1800XT PCIE
--
Best Regards, Any help appreciated
- 4
- Dotnet >> Urgent Help : What is the best control ???Dear all,
I have an application which is collecting dynamic incoming data and store
them in a list.
I need to dispaly this incoming list with 2 important recommandation :
1- if the incoming item is already present in the control list, I should
not display it
2- if an item is not anymore present i shoulds eb able to remove opnly that
item
For the time beeing I have used a Lisview control. The easiest way to handle
this is to clear all the time the content of the list when new range of data
need to be filled up. This works well but the problem with this si that if
the incoming frenquency data is high, then my list will blink all the time
due to the refresh.
I was wondering which control should I used to handle the addition of only
non existing data and remove of only non existing data without having this
refreshing stuff.
I was thinkinbg also by using a dataset object and datagrid, but this will
not avoid me this problem, if dataset content change, I will need to make a
refresh of the datgrid to show the new values.
To summarize the whole thing what is the best way to collect a frequency
incoming data (like TCP chanel data) and disply them to user by beeing able
to update only data that have change and not doing continuous refreshing
which ia bad for the eyes after a while
thanks for your help
regards
serge
Any idea?
- 5
- Visual C#.Net >> Run time error when subscribing to an eventHello!
Below I have two easy classes that are relevant for my question. These are
called Clock and Ticker.
In class Clock I subscribe to the event tick which is of type Tick that
exist in the Ticker class in this way
pulsed.tick += new Ticker.Tick(RefreshTime);
When I use this construction of subscribing to the event I get a run time
error that say the following
"Cross-thread operation not valid: Control 'digital' accessed from a thread
other than the thread it was created on."
I have read in different books that you can subscribe to event by using
these two statement which I call statement 1 and 2 below
Statement 1 : pulsed.tick += new Ticker.Tick(RefreshTime); // This gives run
time error
Statement 2 : pulsed.tick += RefreshTime; //
this works fine
If I use the second statement "pulsed.tick += RefreshTime; " to subscribe to
the event it works fine.
So my question is can somebody explain to me why I can't subscribe to the
event by using
statement 1 "pulsed.tick += new Ticker.Tick(RefreshTime);"
when this statement 1 "pulsed.tick += new Ticker.Tick(RefreshTime);"
should be the same as statement 2 "pulsed.tick += RefreshTime;"
class Clock
{
private Ticker pulsed = new Ticker();
private TextBox display;
public void Start()
{
//pulsed.tick += RefreshTime;
pulsed.tick += new Ticker.Tick(RefreshTime);
}
public void Stop()
{
pulsed.tick -= new Ticker.Tick(RefreshTime);
//pulsed.tick -= RefreshTime;
}
private void RefreshTime(int hh, int mm, int ss)
{
display.Text = string.Format("{0:D2}:{1:D2}:{2:D2}", hh, mm, ss);
}
}
class Ticker
{
public delegate void Tick(int hh, int mm, int ss);
public event Tick tick;
private Timer ticking = new Timer();
public Ticker()
{
ticking.Elapsed += new ElapsedEventHandler(OnTimedElapsed);
ticking.Interval = 1000;
ticking.Enabled = true;
}
private void Notify(int hours, int minutes, int seconds)
{
if (tick != null)
tick(hours, minutes, seconds); //call delegate
}
private void OnTimedElapsed(object source, ElapsedEventArgs args)
{
int hh = args.SignalTime.Hour;
int mm = args.SignalTime.Minute;
int ss = args.SignalTime.Second;
Notify(hh, mm, ss); // call notify
}
}
//Tony
- 6
- 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
- 7
- 8
- 9
- Visual C#.Net >> Serializing propertiesHi Folks!
Here's a strange behaviour:
Without a properties SET accessor (see code below), the property will not
serialize.
public class myObject
{
private string _myAttribute;
[XmlAttribute("MyAttrib")]
public string myAttribute
{
get { return _myAttribute; }
set { _myAttribute = value; } //this accessor must be present to
serialize
}
public myObject()
{
_myAttribute="set during construction...";
}
}
I would prefer the property (myAttribute) be accessible only by GET but if I
want it to serialize I must allow the SET. Is there any way around this?
Rein
- 10
- Microsoft Project >> Macros are missingI wanted to use a macro that allows me to "Rollup Formatting" In the Macros
window, I no longer have a list of macros to choose from. Can anyone tell me
what might have happened to my macros?
--
Thank you.
- 11
- Visual C#.Net >> Old Windows helpDoes anyone know where I can find the old help that came, say, with visual
studio 6? the one that gave a good overview of windows and win32 api?
- 12
- 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.
- 13
- 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
- 14
- ADO >> DataRow Performance BottleneckOur ADO.Net application was spending almost all its time
in the following line of code:
object dataColumn = row.ItemArray[column];
where row is a DataRow and column is an int.
We changed the line to the following:
object dataColumn = row[column];
This increased the performance by more than a factor of
25. Why did this happen? Is the performance hit in using
ItemArray documented anywhere?
- 15
- Dotnet >> [Question] Crystal / VB ASP .net / Stored ProcedureHi,
I have a Crystal Report that I want to have use as its datasource a
SQLServer 2000 stored procedure, basically the sp would do several selects
to insert data from several tables into 1 temp table (first letter of temp
table name = #) then the last thing I do is select * from #temptable.
However Crystal can not see in the VB .net IDE any fields just the SP. If
all I do is create the temp table and then do select * from #temptable I can
see the fields in the SP when I add the SP to Crystal within the VB IDE.
Obviously doing the latter is no good as I need to do several selects prior
to the last one to populate my temp table.
Anyone got any ideas?
Thanks
Paul
|
|
|