|
in Managed code GC control all of these de-allocations automatically
,actually GC check them periodically and collect everyone of them that
ain't used.
.Net Developer
|
|
|
|
|
Hi everybody I hope somebody can find a suggestion for this problem
I wrote store proc that work correctly in QueryAnalyzer but when I
call it from my project it make error "system error"
look at it:
CREATE PROCEDURE spSer_contact
@contactGroupID uniqueidentifier,
@countryID uniqueidentifier,
@contactName varchar(100),
@city varchar(50),
@phoneNumber varchar(100)
AS
declare @SqlString varchar(2000)
set @SqlString = 'SELECT contact.contactName,
contactgroup.contactGroupName,
country.countryName, contact.city,
contact.street, contact.zipCode,
contact.phoneNumber, contact.faxNumber,
contact.telex, contact.email,
contact.webSite, contact.comments,
contact.attachment,contact.contactID,
contact.contactGroupID, contact.countryID
FROM contact INNER JOIN contactgroup
ON contact.contactGroupID = contactgroup.contactGroupID
INNER JOIN country
ON contact.countryID = country.countryID
WHERE'
if (len(cast(@contactGroupID as varchar(38))) != 0)
set @SqlString=@SqlString+' contact.contactGroupID='''+cast (@contactGroupID as varchar(38))+''''
if (len(cast(@countryID as varchar(38))) != 0)
if (SubString(@SqlString, len(@SqlString) - 4, 5) = 'where')
set @SqlString = @SqlString + ' contact.countryID = '''+cast(@countryID as varchar(38))+''''
else
set @SqlString = @SqlString + ' and contact.countryID = '''+cast(@countryID as varchar(38))+''''
if (len(@contactName) != 0)
if (SubString(@SqlString, len(@SqlString) - 4, 5) = 'where')
set @SqlString=@SqlString+' dbo.contact.contactName='''+ @contactName+''''
else
set @SqlString=@SqlString+' and dbo.contact.countryID= '''+ @contactName+''''
if (len(@city) != 0)
if (SubString(@SqlString, len(@SqlString) - 4, 5) = 'where')
set @SqlString = @SqlString + ' dbo.contact.city = '''+@city+''''
else
set @SqlString = @SqlString + ' and dbo.contact.city = '''+@city+''''
if (len(@phoneNumber) != 0)
if (SubString(@SqlString, len(@SqlString) - 4, 5) = 'where')
set @SqlString=@SqlString+' dbo.contact.phoneNumber= '''+ @phoneNumber+''''
else
set @SqlString=@SqlString+' and dbo.contact.phoneNumber= '''+ @phoneNumber+''''
exec (@SqlString)
GO
====================
//sample code for retriving data by store proc
SqlConnection cn = new SqlConnection(connectionString);
SqlCommand cm = new SqlCommand("[spSer_contact]",cn);
cm.CommandType = CommandType.StoredProcedure;
SqlParameter pm = new SqlParameter("@contactGroupID",SqlDbType.UniqueIdentifier,16,"contactGroupID");
pm.Value = listBox1.SelectedValue;
cm.Parameters.Add(pm);
SqlDataAdapter da = new SqlDataAdapter(cm);
DataSet ds = new DataSet();
da.Fill(ds,"contact");//this have problem error message is (system error)
dataGrid1.DataSource = ds.Tables["contact"];
if somebody find a solution for this problem please send it
thanx
|
|
|
|
|
how can i export .Net Native data types such as for e.g [string]
to a calling C# program ?
|
|
|
|
|
4 of the (essentially) same questions all in a row...was it really necessary?
|
|
|
|
|
how can i export .Net Native data types such as for e.g <string>
to a calling C# program ?
|
|
|
|
|
|
Is there any proper way of returning string from a function in a DLL ,
written in VC++.Net to the calling C# program.
plz i need this solution urgently....................
|
|
|
|
|
C# strings are unicode, so perhaps you need to return a BSTR ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
What is the proper way of calling code written in VC.Net from C#
|
|
|
|
|
As You know in vc.net you can write managed and unmanaged code
Unmanage Code:
if you want to use unmanaged code use platform invoke
P/Invoke to call function you have in dll
Managed Code:
you can compile your code and reference this assembly from your project
MCAD
|
|
|
|
|
Don't know if this is right to chip into your current topic or should I start a new one BUT....
There are functions in C++ like
"CVideoModes:CurrentVideoMode(CurrentMode)" that do not exist ( or I can't find them!)in C# in the .NET framework.
Where can I read more about imbedding C++ code in a C# program?
Wej Parry
|
|
|
|
|
|
Thank you Mohamad. Spot on answer. I obviously have a lot to read and understand.
Wej Parry
Wej Parry
|
|
|
|
|
Ok guys, i not even know if it's a problem but i've seen many c# tutorials that explain assembly compilation by command line and i've seen they usually use "csc (my arguments...)".
That "csc" is a bit strange for me because they only use csc directly("c:\>csc myarguments..." for example) but i have to type all the path to the csc.exe file (C:\Windows\Microsoft.NET...csc.exe Myarguments...).
How can i create a link to csc?
Thanks in advance
|
|
|
|
|
Create a .txt file, open it and paste %comspec% /k "C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\vsvars32.bat" (or something else, go to Start->All Programs->Microsoft Visual Studio .Net 200X->Visual Studio Tools->Right-Click Command Prompt->Properties->Target->Paste that line)
Save the text file, and rename it to .bat, Now you can doubleclick and you have a shortcut to all Visual Studio programs, you can just type csc and the command prompt knows what you mean.
Mazzelz!
"..Commit yourself to quality from day one..it's better to do nothing at all than to do something badly.."
-- Mark McCormick
|
|
|
|
|
Hi All,
I have a custom datagrid with two checkbox controls in it.
When checkboxA is checked then if checkboxB is checked, it is unchecked and vice versa. (not like a radio button since if checkboxA is unchecked then nothing happens to checkboxB).
But I would like to implement this in client side...any help would be GREATLY appreciated!
schoudhr@hotmail.com
|
|
|
|
|
I am looking for some type of package that offers a task management system to allow us to track tasks, create reports.. within our portal? Is there anything out there that is any good?
|
|
|
|
|
Take a look at www.axosoft.com.
|
|
|
|
|
I am looking for something that will not only support software teams but also teams outside of software development.
|
|
|
|
|
I am Programming for a Desktop File Search Software in Pocket 2003.
I use .NET CF.
How Can I Get Text from A Pocket Office File?
Please Help Me,Thank !
zzzzzzz
|
|
|
|
|
Hello, I'm getting stucked at this point :
I've created a new class called ListViewItemEn that inherits from ListViewItem, I need to add a String into this new class called FullPath, since this point is all ok, my problem is that I'm not able to override the constructor
public ListViewItemEn(String[] text, String path)<br />
{<br />
}
I should add all the string of text into subitems, but it starts adding in the 2° column
Here's my code
public ListViewItemEn(String[] text, String percorso)<br />
{<br />
this.FullPath = percorso;<br />
<br />
for (int i=0; i< text.Length;i++)<br />
{<br />
this.SubItems.Add(text[i]);<br />
}<br />
<br />
}
How can I solve that? thanks in advance
Paolo
|
|
|
|
|
There already is a method that takes an array of items to initialize the LVI with.
In any case, it's behaving correctly. You need to set the Text property of the base class, and the SubItems are columns 1..n
Marc
My website
Latest Articles:
Object Comparer
String Helpers
|
|
|
|
|
excuse me, what u mean for base class? System.Windows.Forms???
thanks in advance
Paolo
|
|
|
|
|
Hello,
I'm trying to develop a simple Explorer, just to kill time, I've got a problem for what concern context menu and listview's item.
I try to explain at my best.
I tryied to use
this.listView1.ItemActivate += new System.EventHandler(this.item_Selected); to catch ItemActivate event and here's the function's code
private void item_Selected(object sender, System.EventArgs e)<br />
{<br />
try<br />
{<br />
ListViewItem currentItem = this.listView1.FocusedItem;<br />
---> currentItem.ListView.ContextMenu = itemMenu;<br />
<br />
FileInfo f = new FileInfo(currentItem.Text);<br />
if(f.Attributes == System.IO.FileAttributes.Directory)
how do I reset the context to default one when no item are selected? and why I've difficulties to unselect the line I checked?? is a problem of itemactivate event??
Thanks
Paolo
|
|
|
|
|
I write a store proc for search that work correctly in QueryAnalizer
but wen I call from c# by SqlCommand.ExecuteReader there is error and its
message is "System Error"
I checked all parameter values before execute ExecuteReader method and
all of them was correct
have u any suggestion for this problem
thanx
Programming is differed world
|
|
|
|