|
I vote for option 2. SQL server got good support for XML. You can supply a XMLReader which contains your XML and a transact SQL statement can loop through it and if the "id" does not exist in database, put it in a temporary table. Once you finish the loop, return the temporary table as XML (FOR XML AUTO).
|
|
|
|
|
Option 2 works much faster for long run when you create CLR function in sqlserver.
Processing of compliled procedures and functions for multiple database read/write commands make it faster. If anybody goes for Option 1, then he may be good Desktop programmer without any knowledge of database and strength of PL/SQL
|
|
|
|
|
Option 3.
Return two result sets from SQL server.
Write a query to put all records in a table variable.
Write a second query with the id column via a join.
Return both sets to a dataset.
Use ADO.Net (such a datatable select method or rowfilter) to check for the id.
Then as you loop through your 100-200 records you don't need to hit sql server for each record, just search your datatable.
I didn't get any requirements for the signature
|
|
|
|
|
hi..
i have a problem in asp.net as follows..
question1
radiobutton1 radiobutton2
i.e.
if (Mydatareader.Read())
{
Label1.Text = rd[1].ToString();
RadioButton1.Text = rd[2].ToString();
RadioButton2.Text = rd[3].ToString();
}
now i want this code to be genrated 10 times in a .aspx.cs page. and after that how can i identify all those radiobuttons and question (displayed in label).as if i create thease contols in run time it is not differentiated by me.and if i create it desigen view i have to reapete all code (feathing from database ) for every set of controls(for every datarow).
Values of question and radiobutton fetchs from database.i want to check it on a button click from database .i want all this for a online paper..
can anyone send the code for it in c#..
thanks in advance
|
|
|
|
|
You should look into the asp:repeater control. Or try a gridview with a template column.
Each of these have an itemdatabound event where you can add code.
I didn't get any requirements for the signature
|
|
|
|
|
|
|
You will get a message board just down to that article. Please use that for discussions related to the article.
|
|
|
|
|
This Article is based on C# and Win Application, Then why are you putting it in ASP.Net forum.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi,
I have created a web service and i have created the msi file. I deployed the Web service in the IIS by running the msi file. If any exceptions occur during the WS call i want log the exceptions in to a file. I have given the file path in the web.config file. Until or unless i create a directory with write permission, its not creating the file in the mentioned path.
for ex: path : c:\Inetpub\wwwroot\webservice\ErrorLog\ErrorLog.txt
If the dont create the ErrorLog folder with write permission its showing the c:\Inetpub\wwwroot\webservice\ErrorLog\ErrorLog.txt denied message.
Is there any way to create directory with write permission through the c# code itself or the above is the only way to log the message.
Please help me.
With Regards,
Anand
|
|
|
|
|
anandhakrishnan wrote:
If the dont create the ErrorLog folder with write permission its showing the c:\Inetpub\wwwroot\webservice\ErrorLog\ErrorLog.txt denied message.
There are Two Solution for that.
1. If you are using IIS 6.0 or above, Create a separate Application Pool, Change the identity of Application to "Local System", By default it is "Network Service", which is having minimum privilege on your system and that will not allow you to write on server. Change the Identity of Application Pool to "Local System", Assign the Application Pool to you virtual Directory.
Then Try. It will work
2. Give the Right Permission to All th user to that file.
I will suggest you to go for application pool.
Let me know if any other issue.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
hi
i have deployed on web site on local machine
but i am getting error because dll is not in gac how do i install that
|
|
|
|
|
nikhil1234 wrote: but i am getting error because dll is not in gac how do i install that
how to put assembly in gac
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hello Everybody
I need some suggestion about HTTP and HTTPS
I have bought some HTTPS space, so I can send customer to https for payments, login and register. For examples: When customer clicks Payments Button then it should be redirect to https://secure/mydomain/payment.aspx
As I know I have to send payments amount (£10.00)
Q1: What else I do need to send on https://secure/mydomain/payment.aspx from my http://mydomain.co.uk
Q2: After payment confirmation how do I know which customer make payment?
As I bought the package of PayPal Web Payments Pro so customer will make payments from my website.
So far what I have done is:
1.When customer click login then it goes to https
2.After login successful I have kept customer on https not redirect to http (I know its not a good idea)
I am waiting for your wise suggestion
Thnaks in Advance
Sarfarj Ahmed
|
|
|
|
|
I have Downloaded a source code for this proble but when i run this application on my PC it is giving an error that
"Element ModalUpdateProgress is not a known Element. This can occur if there is a compilation error in the website"
So, I am not able to understand why it is giving such a problem?
Does anybody know the solution for this?????????
Please help me...
|
|
|
|
|
Niungareamit wrote: Element ModalUpdateProgress is not a known Element. This can occur if there is a compilation error in the website"
Which Framework Version do you have? Do you have AJAX/AJAX Toolkit installed in you system?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
sir,I have Ajax Toolkit installed in my system..
|
|
|
|
|
I am a beginner and i want to learn asp.net using c# language.i am working in a IT dept.plz guide me step by step process to be proficient in c#.
|
|
|
|
|
M ZOHAIB KHAN wrote: plz guide me step by step process
1 - Goto amazon.com and search for C# books.
2 - Read the book reviews and choose a good one.
3 - Order it via the site or goto a book shop and purchase it.
4 - Read and workout with the exercises provided.
Seriously, How are you expecting step by step help for learning C# from a discussion board? You need to take books and learn from that and come back with specific questions.
|
|
|
|
|
Thankyou for your reply .By ''step by step'' word i mean the tips and the tricks that can help me to understand c# thoroughly
|
|
|
|
|
There's not really any tips to offer until you've bought a book and learned some basics. Learn C# first, then learn to use it with ASP.NET ( so, work through an ASP.NET book after the C# one )
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
M ZOHAIB KHAN wrote: I am a beginner and i want to learn asp.net using c# language.i am working in a IT dept.plz guide me step by step process to be proficient in c#.
1.Buy Some Beginner's Book
2.Install Visual Studio in your system
3.Read books and practice them .
4. Do lots of googling
5. Read lots of beginners Article.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Besides getting some good books.
As with almost anything else. Practice, Practice, Practice.
Nothing beats real world experience. The more you code the more you will learn.
I didn't get any requirements for the signature
|
|
|
|
|
Hello,
1)Initially join course in any institute.
2)Asp.net for dummies(This is book available in the book shop).
Go thru,
Wishes
Balaji
|
|
|
|
|
hi every1,
i m beginner in asp.net I have watched tutorials on Role base security and trying to implement it.In aspnet database (same database uses for default web sercuty) i added a simple student table with two cols (UserId, UserName) then made a one to one relation between aspnet_User and Student. when i created a user through Asp.net configuration. I found that UserId has been added into both aspnet_users and aspnet_membership tables but not in Student table. please could u explain me how i can add same userid in student table as it has been added in users and membership table. if i cant save UserId in any other table at all then pleas tell me how i can add student data like(CourseId,startdate) wit same user Id. I ll really appriciate ur help.
regards
learner
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
