|
Hello,
I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer. So, I am posting it here.
I have one ObjectDataSource which has a Select query that requires Parameter @CompanyId. CompanyId is Guid and I want to compare it with a bunch of GUID. Can i pass those Guid programatically???
my Query is like..
select a.companyId, b.startdate, b.....
from a,b
where a.companyId IN (@CompanyID)
|
|
|
|
|
DotNetDominator wrote: I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer.
There are many reasons you may not have received an answer. The bottom line is that this is a community site. People take their own time to answer questions. If you require an answer urgently then Microsoft Support can help for a small payment.
DotNetDominator wrote: So, I am posting it here.
Your question has nothing to do with ASP.NET so it is inappropriate for this forum.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Hi there,
You can define a select parameter for the ObjectDataSource control, then create a handler for the Selecting event of the datasource control. In the handler, you can pass a list of the CompanyID values to the input parameter collection.
Using Parameters with the ObjectDataSource Control [^]
|
|
|
|
|
Hi,
Mr.Mackay,
I Do appreciate the help provided by people by taking time for it from their busy schedule. But, I did mean to blaim any one for not getting reply. It's just that I was desperate to have answer because I've to finish this project in 10 days. I'll surely consider your suggestion of joining Microsoft support for urgent answer. But, As long as I am a student, I can not afford it. I joined this forum because, I found it very authentic and rich with knowledge. Anyway...I'll take care in selection of forum before i post. Thank you.
Hi minhpc_bk,
I am very very thankful for the reply.. Just what i wanted... It is running fine now... earlier i was thinking to pass parameter as http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
but it requires stored procedure.. Thank you very much for solution.
|
|
|
|
|
If i am having 10 tables in my dataset.xsd,is it is necessary to have 10 different Data Adapter in my project or single Data Adapter is enough.
|
|
|
|
|
Hi there,
Actually, you can also use a single DataAdapter object to fill one or more datatables in the dataset.
|
|
|
|
|
I have made some web parts in vs2005 and now on run time i make some changes by using drag drop operation. Can anyone tell me how and where those changes made at runtime are saved in DB of SQLExpress. I got that those are saved in APP_DATA folder of application in personalization tables. but there those were in form of image dat so i could not get them. So any views about that?
Its urgent so please reply fast.
|
|
|
|
|
Hi there,
By default, the ASP.NET uses the the SQL Express database file in the App_Data to store the personalization data. If this file is not available, the ASP.NET will automatically add it to the application. As you may already know that the central class in the Web Parts is the WebPartManager which responsible for persisting the personalization data. The WebPartManager serializes and persists the properties of the web part control which are marked with the Personalizable attribute. In the AspnetDb, there 3 tables which are used for the personalization, they are aspnet_Paths, aspnet_PersonalizationAllUser, aspnet_PersonalizationPerUser. You also see that the personalizable property is saved as binary data because the property is serialized with the ObjectStateFormatter object. You can read more about this in MSDN:
Web Parts Personalization Overview [^]
|
|
|
|
|
Hi!
There is a website that contains free online tutorials. I used the search criteria: "web part" and I found a tutorial that walks through a process that might be the answer of your question.
Why don't you go ahead and try it: http://www.KYNOU.com
|
|
|
|
|
Hi,
I read the artical
http://www.codeproject.com/useritems/Excel_Connectivity.asp
Its nice and i need some change.
I want to read an excel stream from the Web Page and
has to capture rows and column data from that stream
without saving the stream as a file in the physical
disk.
In this artical, we have specified a file name in the
connection string.
Anybody can clarify this ?
Thanks,
Murthy.
|
|
|
|
|
If you have comments or questions about a specific article, you should post them on the article's forum. Scroll to the bottom of any article and you'll find its forum.
|
|
|
|
|
Hello,
I am running an ASP.NET application that works perfectly on the localhost but when I try to load on the browser from the server, I have the following error:
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customerrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customerrors> tag should then have its "mode" attribute set to "Off".
I did all mentioned in the details section but am still getting same error.. can some one help? I have worked on this for days...
|
|
|
|
|
|
Hello,
I will check this documentation...
Thanks for you reply though....
Commickey
|
|
|
|
|
Sir/Madam
My problem is that I have to check a textbox that it may contain some text or not on clicking a button if it not contain any text then i have to display a message box that you nave not entered any value or you have entered null. it may be done by using javascript or asp.net
Balwan Singh
|
|
|
|
|
For ASP.NET, look at the RequiredFieldValidator[^] control.
-- modified at 8:52 Monday 1st May, 2006
I hadn't noticed that you had already asked this question earlier. Did you not like the responses you got? They looked pretty good to me.
|
|
|
|
|
for javascript on the click of button call a function in javascript there check for value of text box if it is empty then display a alert box with message and return false else pass true without displaying the alert box.
|
|
|
|
|
Hi!
I created a class called HelperClass where I have a lot of methods that help me with situations like this one. Here goes the code of the method to provide an alert window:
public static void MsgBox(System.Web.UI.Page page,string msg)
{
msg = msg.Replace("'","\\'");
page.RegisterStartupScript("msg","alert('" + msg + "');");
}
I also have other methods, if you need them let me know. I also found some free online tutorials at www.KYNOU.com
I hope I helped.
sfdsfsdf
|
|
|
|
|
hi all,
Thanks in advance to you all.i have a html textbox in my asp.net form and i have email id's on that for validation.after finishing the validations i have to send the mails to the id's given in the text box.i want to know way to get the value of textbox to the c# code behind as the mail to send address of my application.please help me.
like
mail.To="value of the HTML textbox should come here"
with regards,
susa
-- modified at 7:11 Monday 1st May, 2006
|
|
|
|
|
All server controls have properties. You access a property's value using the syntax:
ServerControl.Property
The TextBox control has a Text property for retrieving or setting the text in the box. If your TextBox is named "MyTextBox", you would retrieve its value in C# this way:
string myText = MyTextBox.Text;
You might benifit from a look at the QuickStart tutorials on http://www.asp.net[^].
|
|
|
|
|
To get the value of a HtmlTextBox control from C# code behind, you have to convert the Control to a server control, not a web server control. just click on the control and select "Run as server control". set the ID propety in the preorties window.
or you can add 'id="UName" runat="server"' this snippet in the textbox tag in the HTML view.
example
initially your control looks like the below,
<input type="TextBox">
alter it to
<input type="TextBox" id="UName" runat="server">
know at the code behinde
you can use the below code to get the value
System.Web.UI.HtmlInputText txtName = new System.Web.UI.HtmlInputText();<br />
txtName = (System.Web.UI.HtmlInputText)this.FindConrol("UName");
now txtName.Value will give you the textbox value
hope this helps you
Cheer.
Ramesh.Kanjinghat
|
|
|
|
|
hi,
thank you ramesh for ur help by sparin ur time ,now i will try it out.i know it will work.
sudharson.g
with regards,
susa
|
|
|
|
|
I have a windows app project that I need to create an installer for distribution. How do I do that? Do I need a third party software?
|
|
|
|
|
Your question doesn't seem to refer to ASP.NET. You may want to post questions like these instead to a language-specific board in the future.
That being said, you could use the VS.NET's Setup project type to create a windows installation application.
|
|
|
|
|
I have to check a textbox text and if it is null while clicking the button then i have to show a message on alert box.
Balwan Singh
|
|
|
|