Hi there, i'm really in need of a convertor to convert unicode character map to iran system charachter map Please Help!

hi there! i have a big problem with memory releasing in c#, let me explain u my case: i have a sql class (sqlconnection+ sqlDataAdapter )which fill a DataTable that contains about 34000 rows, now the memory consumtion goes up about twice than before query executed! but the problem is when user closes the host form, memory would not be released compeletly! so after 3 or 4 time execution, application stopped working and out of memory exception! I tried this solutions: Disposing Table- GC.Finalize- GC.Collect and so but they wont return whole of memory... plz HELPPPPP

djj55 wrote:

You would need to calculate the maximum average in this query.

how i could do this?

row #5 expected to be updated to 233, not 500

hi everybody, I have a big problem with update statement, let me mention the situation by exact script and results! first create trans table=>

create table trans(
id bigint identity(1,1) not null,
price decimal(18,0) null,
relatedid bigint null)

Then fill it by this script

Insert into trans (price,relatedid)values(100,NULL)
Insert into trans (price,relatedid)values(100,NULL)
Insert into trans (price,relatedid)values(500,NULL)
Insert into trans (price,relatedid)values(1,NULL)
Insert into trans (price,relatedid)values(1,3)

Now run this query!

Update trans
set price=(case when relatedid is null then (select avg(price) from trans where id<=t.id)
else (select top(1) price from trans where id=t.relatedid) end)
from trans t

After execution of query I expect this result: id-----price-----relatedid 1 100 NULL 2 300 NULL 3 200 NULL 4 200 3 <======== realy expected!!!! But this is the result!!! id-----price-----relatedid 1 100 NULL 2 300 NULL 3 200 NULL <======= #3 row 4 1 3 <===== wrong value, i mean this is the value before update row with id 3 has been updated before but update doesnt know this!!!!! WHAT I NEED i need to get expected result from this execution!!!! plzzzzzzzzzzz

modified on Wednesday, April 13, 2011 7:53 AM

plz take look at edited message...

hi everybody, I have a big problem with update statement, let me mention the situation by exact script and results! first create trans table=>

create table trans(
id bigint identity(1,1) not null,
price decimal(18,0) null,
relatedid bigint null)

Then fill it by this script

Insert into trans (price,relatedid)values(100,NULL)
Insert into trans (price,relatedid)values(100,NULL)
Insert into trans (price,relatedid)values(500,NULL)
Insert into trans (price,relatedid)values(1,NULL)
Insert into trans (price,relatedid)values(1,3)

Now run this query!

Update trans
set price=(case when relatedid is null then (select avg(price) from trans where id=
After execution of query I expect this result:
id-----price-----relatedid
1 100 NULL
2 300 NULL
3 200 NULL
4 200 3 <======== realy expected!!!!

But this is the result!!!
id-----price-----relatedid
1 100 NULL
2 300 NULL
3 200 NULL <======= #3 row
4 1 3 <===== wrong value, i mean this is the value before update

row with id 3 has been updated before but update doesnt know this!!!!!

WHAT I NEED i need to get expected result from this execution!!!! plzzzzzzzzzzz

modified on Tuesday, April 12, 2011 10:34 AM

hi there, Im really confused! i need to connect sql server from my pocket pc ... i made a wireless network and connect them to each other. now with this code i try to connect ...

SqlConnection con = new SqlConnection(@"Data Source=mohsen-pc\sqlexpress;Initial Catalog=ManagerCo;Persist Security Info=True;User ID=sa;Password=123456");
SqlCommand cmd = con.CreateCommand();
try
{
con.Open();
}
catch (Exception f)
{
MessageBox.Show(f.Message);
}

sqlexception is result! note that firewall is switched off, sql express accepts remote and configured correctly plz help!!!!!!!!!1

Hi there, as i titled im going to connect sql server over wifi, i use windows mobile 6.5 on my device, i installed sql server ... its ready for remote connection, now how i could make network between device and my pc? please answer me in details!!!!

it wasnt what i need, I need a condition varaible for windows installer, to do a custom action in two way depends on 64bit os or else... like

memmory>=4000

i need something to check 64bit like

64bit=1

hi there, im going to run a custom action in a setup proj... its a driver installer which depends on windows platform now i have two version of this driver x64 and x86 ... i know there is a condition properties for detecting platform... but what should i write in it for this reason?

http://www.sql-articles.com/scripts/enabling-remote-connections-via-dos-or-t-sql[^] the actual link! THANK YOU :laugh:

Thank you, but the link does not work! this is the link for sp of enable remote: http://www.sql-articles.com/index.php?page=Scripts/remoteconn_dos.php[^] which opens no downloadable text page!

Hi, look im going to configure sql express 2008 for accepting remote connection, BUT, automically ... I mean the enduser will not set anything, after installing sql express it whould be configured for network connections and etc. actually i need sql scripts for this...

i meaned condition compilation symbols! there is no info about condition compilation symbols in that link

please answer with sample... i googled but i mixed up!

MS build cant build vdproj, test it!!!!!! devenv could do this! :)

Hi, as i titled i really need to compile a vdproj in command line or in c# classes! i googled and i found nothing really related! THANK YOU

Hi, Specially parameters used to pass data to ur query , as inset update delete even select

select *
from t1
where id = 12

this query always returns a fixed result, now going to make it gloabal, i mean change the 12 value to needed value, so u use parameters as:

select *
from t1
where id=@id

now in command line, u must set the parameter, look at this method as a sample:

    private DataTable SelectParameter(int idvalue, bool useWithvalue)
    {
        string constr = "";
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand("select \* from t1 where id=@id", con);

        if (useWithvalue)
        {
            cmd.Parameters.AddWithValue("@id", idvalue);
           
        }
        else
        {
           
            SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
            p.Value = idvalue;
            cmd.Parameters.Add(p);
        }

        con.Open();
        DataTable dt = new DataTable();
        dt.Load(cmd.ExecuteReader());
        return dt;

    }

in cases that u are going to set the value type of parameter u should use add else u could use both of them.

look for example my application uses lpl.ocx ... well now I want to be sure that this lpl.ocx is the true one like this

assemblycheck c=new assemblycheck;
//lpl.ocx is assembly name and 193718378378937937732 is crc number or digitally sign
if(!c.check("lpl.ocx","193718378378937937732"))
///cracked assmbly

actually i need a way to check current assembly used in my application that could check assembly in c# code with digital signed number as I mentioned. thank you