|
Hey tecchies,
For a project I'm working on that moment, we need to create a new database in Sql Server 2005 (to make use of the native xml datatype). One of the things which seems to be plugged a bit in 2005 is the use of managed code stored procedures.
Has anyone had any experience of writing and using these? Can you advise on their advantages and of any difficulties you may have encoutered? I'm no database expert, but I would have thought that they would lack the 'execution plan' which standard stored procedures provides. In fact, I can't see a great deal of point of this new technology.
Any views/experiences would be welcome.
Thanks
Regards,
Rob Philpott.
|
|
|
|
|
Rob Philpott wrote: I'm no database expert, but I would have thought that they would lack the 'execution plan' which standard stored procedures provides. In fact, I can't see a great deal of point of this new technology.
There are many things you can do with C# that you cannot do in SQL, or is very difficult in SQL.
As Microsoft have said on countless occasions, CLR integration in SQL Server does not mean you can ditch SQL and replace everything with C# code. The CLR integration is for doing stuff that is difficult or impossible to do in SQL directly. It can also be used for creating custom types in SQL Server.
For me, I've not yet tried any of this yet. I'm waiting until I hit something that is obviously crying out for CLR integration to make it run great. However, I've not found it yet.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
I have a ListView controls with 10 ListViewItems with checkbox. Now when I list the Items, I need to disable or make read-only the 5th item so that I will not be able to select the that item. How can i do this?
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
HI, I have the same problem. Just wonder if you have got any answer for it?
Thanks
Best Regards
Chibi Maruko S
|
|
|
|
|
|
you can use the selectedcell property of the datagrid to get
the data within a particular cell.
Thanks
Pramod
|
|
|
|
|
myDataGrid[rowIndex, colIndex]
|
|
|
|
|
Ok i was find it this way but thank's for answare.bye
|
|
|
|
|
Hello All,
I just want to know how to license a software written in .Net?
How to implement different licensines? for example a trial version which runs only for a few days like 15-30 days and after that the user have to register it? how to generate the keys?
Any help will be greatly appreciated. Thanks alot
Best Regards,
Rizwan Ahmed.
|
|
|
|
|
Depending on how safe you want your license to be making it yourself can be very complicated.
There are several commercial components which do what you need. One of them is this[^] on.
|
|
|
|
|
I have developed an windows service in C# the working of service is to fetch data from database generate some messages and store those messages in database.
The problem i am faceing is the memory consumption of my service is very it goes upto 2GB and due to this the system hangs.
I have disposed all the objects and also i am invoking garbage collector after
specific amount of time but the memory still increse.
The service is running on Windows-2003 server.
|
|
|
|
|
swapnilk78 wrote: I have disposed all the objects
You're missing something somewhere. You're going to have to profile your code with something like CLRProfiler to get its memory consumption.
swapnilk78 wrote: i am invoking garbage collector after
You just about NEVER have to do this. Did you know that your entire application, ALL of it's threads, come to a complete halt when the garbage collector runs? Still think this is a good idea?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have already profiled my code using .Net Memory profiler, Ants profiler and also CLR profiler
and changed my code according to the results of above profilers.
Is there something another way by which i can come to know which objects are in memory and not getting disposed
|
|
|
|
|
The CLR Profiler will tell you, if you know how to read it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
im using a js function to dynamically fill a dropdown.
im using document.getElementById('dd') for getting the id of the select box.
first it was working properly and now not.
document.getElementById('dd') retuning a null and previosly it was returning a object. so im not getting the binding.
what could be the problem
sathy
|
|
|
|
|
Have you checked the source of the page? What id does the dropdown get?
If you moved the dropdown inside a container, the id can change.
---
b { font-weight: normal; }
|
|
|
|
|
thanx a lot Guffa
Guffa wrote: Have you checked the source of the page? What id does the dropdown get?
the id for the select tag is 'dd' only ...
Guffa wrote: If you moved the dropdown inside a container, the id can change.
i cant get this above point ???
i dunno why im gettin that null ...
sathy
|
|
|
|
|
Well, if the id in the tag is correct, then there has to be something else in your code that causes the problem.
Do you have any other element with the same id?
imsathy wrote: i cant get this above point ???
If you put the dropdown in a user control, for an example, with the id "froglegs", the dropdown would get the id "froglegs_dd". If you put the dropdown in a repeater, each dropdown created would get a unique id, like "Ctrl_42".
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: If you put the dropdown in a user control, for an example, with the id "froglegs", the dropdown would get the id "froglegs_dd". If you put the dropdown in a repeater, each dropdown created would get a unique id, like "Ctrl_42".
thanx for the explanation. but im using the select tag on the same page.
Guffa wrote: Do you have any other element with the same id?
i tried keeping some unique name. but null is wat it returns if check tat wit a alert.
but my previous similar coding in the source gear is workin perfectly
sathy
|
|
|
|
|
Test by giving the element a different id, just to see if that makes the javascript work.
Also check for other errors in the page source. For an example, if the element is placed outside the form, it might be ignored by the browser.
---
b { font-weight: normal; }
|
|
|
|
|
thanx a lot Guffa.....
the error was bcoz i was callin the function inside the script and not on the onload event of the page .....
sathy
|
|
|
|
|
i am inserting data in access database. i actually am inserting data in access DB in following manner
INSERT INTO SPECIALOFFER (Description,ImageS) VALUES ('" + this.txtdesc.Text + " ','" + filename + "')"
but the problem i am facing here is that the value for txtdesc.text is as follows
textdesc.text="\r\n\t\t\r\n\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\tRaheel Iqbal\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\r\n\t\t \r\n"
thisi s inserting data in DB but the field for description is not taking any string its showing empty value..
datatype for description is memory.
can anybody please help me to solve this problem
|
|
|
|
|
raheeli wrote: datatype for description is memory.
I assume that you mean the data type Memo, the text type that can hold more than 255 characters.
Are you really sure that the value is empty? As I can se, the string starts with a line break, that means that you have to heighten the rows in Access to see the other lines in the field.
---
b { font-weight: normal; }
|
|
|
|
|
I have to develop a system which connected with radio device. & i listen radio all the time & differentiate different CTCSS Tones + DTMF Digits + Detect RF Audio & all the thing have to generate.In short it is Soft Phone with radio device for mobile communicaion.
Plz help me.
|
|
|
|
|
Hi all, i have a question, it's possible to fill mydataset with all the table of my database without make a specifically query for all the tables?
I don't know if is possible but i want to do the next things:
a)fill a dataset with all the tables of my database;
b)with the dataset check if i have to update some fields, or adding tables into mydataset;
c)update all the database with my alteration;
Regards
|
|
|
|