Comments by arminamini (Top 29 by date)

Thanks for ur answer.
with what command i can update gridview, from my usercontrol?

How can i do it from UserControl, after deleting? Coz i dont have access to GridView from my UC!

Thank u very much. it works!

I mean file size, bytes.

Thanks, but i need to change 2 field of all records and insert them again.
how about it?

Yes my solution is that if there is any way that I add this method :
public string DecoAndGetServerName(string Servername)
{
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder strDecoder = encoder.GetDecoder();
byte[] to_DecodeByte = Convert.FromBase64String(Servername);
int charCount = strDecoder.GetCharCount(to_DecodeByte, 0, to_DecodeByte.Length);
char[] decoded_char = new char[charCount];
strDecoder.GetChars(to_DecodeByte, 0, to_DecodeByte.Length, decoded_char,0);
string Name = new string(decoded_char);

return Name;
}

And call it one time, not all times that I get this table by linq.
Once in linq class or somewhere like this that help me use it once.
coz I use this table more than 100 times in many pages and gridviews and ...
its so hard to add this method to all these pages.

Something like trigger in sql. For example you can add a function in sql query, and add something to fields while insert,update,select and Delete.
I need add something to my linq class, that if I Select this spcial table, get me decoded fields.
I mean I need add my decode function somewhere like get events if exists, that help me apply it in one place.

aah Thanks. I hoped if exists some thing like trigger in linq!

Something like this :
<pre>
private string EncodeServerName(string ServerName)
{
byte[] NameEncodein = new byte[ServerName.Length];
NameEncodein = System.Text.Encoding.UTF8.GetBytes(ServerName);
string EcodedName = Convert.ToBase64String(NameEncodein);
return EcodedName;
}
</pre>

And I need something like triggers but in linq in c# not in sql side. That I run it before all gets methods in all project parts.
Thanks.

Many Thanks.

Thanks, But i need queryStrings of the url that user goes, and that page made 404 error

Thanks, Let me check it.

No. How can i do this ?
Plz let me know about this log.
Thanks

Thank u, it was very useful.
And plz do u know any web page for translate all Reg exp words. and how making this regs ?

Thank u. Good idea, lets rely on the browser zoom feature.

Great!

Hi. its good idea. but it can be great if i have these Times in One Select and many Rows. because i need to make this select as a gridview datasource. is it possible?

Great!
Thank you very much. it worked.

Thank u.

Great, thanks.

Yes, i know it's not a normal table, but i dont know if i can change it. i just wondering if there is a way to select those fields.
anyway, thanks for ur answer, i think i should change it.

Thanks for ur notice.
For example i have a row in this table with these values for these fields :
ProdactCatalog : True
ProdactCatalogCount : 3

SeminarDVD : False
SeminarDVDCount : 0

,....

I want to write a query that dont show false fields,and their count fields too.
just Select true fields and their count in a select query.
Thanks in Advance.

Thanks for ur notice.
For example i have a row in this table with these values for these fields :
ProdactCatalog : True
ProdactCatalogCount : 3

SeminarDVD : False
SeminarDVDCount : 0

,....

I want to write a query that dont show false fields,and their count fields too.
just Select true fields and their count in a select query.
Thanks in Advance.

USP_INS_Pic ,is an example for one store procedure that insert a pic as varbinar into database,and it means u should a table that has a varbinary field for image, and write insert query(as procedure o inside ur code behind).

and CS is the ky of ur connectionstring/appsettig. u can set ur appsettings like this in app.config :

<appsettings>
<add key="CS" value="server=local;data source=.;database=yourdbName;Integrated Security=True">