ASP.NET Discussion Boards

give the detail information of sql and asp.net

kuldeep patil

See http://www.asp.net/[^]. You can probably find the SQL page.

Veni, vidi, abiit domum

Member 10461572 wrote:
give the detail information of sql and asp.net

Not clear, could you please rephrase your question?

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

try this link, I hope this video clear a lot of confusion about asp .net and Sql. Try this

I have selected an item from a drop-down list from one table (i.e. "Event") using EventName, EventID in the drop-down list, and
used that ID (EventID) to select an item from another table (Payments).

If zero rows are selected, how to you make the DetailView
create a new row? The EmptyData text is displayed, but
I'd like for a new row (insert) to be displayed in the DetailsView.
I am using VB in my project.

Thank you ahead of time!

Will

Hello,

i want to integrate video Conferencing in my web application using asp.net or Jquery.

actually i want to something like user go to my web application URL with specific id means something like private room id and share this URL with other user so both user can do video chat like Google hangout.

i have tried Webrtc sample but in this sample sound i'm facing audio issue(not getting clear audio).

please provide me best solution for the same.

Thanks

Apart from which you have tried u can check this also
YouConf - Your Live Online Conferencing Tool[^]

Hope it will help.. Smile | :)

If i have WCF service and there are three client and i want to show the only 2 method to client 1 and 3 methods to client 2 and 1 method to client 3. What will be the approach?

User roles. But this question belongs in the WCF[^] forum.

David

User based authorization (in ASP.Net) should help you control method accessibility.

Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial

Hi All,

I have developed an application it is working fine in desktop/laptops systems. Now we need to make it to work in Mobile devices. I know little bit of Jquery core. I created a sample page using Jquery Mobile plugin and it is changing the size/width of the page automatically. But when I browse the same page in desktop browser it is not looking good. Means the page width is increased blob blob.....

I want to make the existing site to work in Mobile devices? How can i do that.? I googled but not got proper solution to my problem.

There is no easy way.
If you used latest web technologies (Html5), your site should open up in the mobile browser.
However, there might be layout issues which you will need to address.

Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial

How to get a data from database by using forms and updatepanel

Start by reading a book on asp.net

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

There is a lot of code to do this. You'll want to study ADO.Net or look into other ASP.Net frameworks, MVC, for example.

There are only 10 types of people in the world, those who understand binary and those who don't.

Agree with other guys. Education Needed[^]

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

I assume you mean something like ListView or DetailView, as an UpdatePanel is simply a tool used for partial page updates.
http://msdn.microsoft.com/en-us/library/bb399001.aspx[^]

For ListViews, GridViews and DetailViews...
You can start by adding a a DataSource to your web form. Visual Studio makes this step easy and you can simply drag a template from the Data section of your tool box.
Visual studio will provide a basic walk-through to help you configure your data source and create a new connection string in web.config.
Once you have successfully created your new Data Source, you can choose this as the Data Source for your Object and the the data should populate accordingly.

You could also insert one of the above data tools within an update panel as well.
You can simply place the Gridview (or other data object) within the realms of the UpdatePanel and get a partial page load with the data is resolved.

ASP.NET

        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>
// Data Object Here
// Data Object's Data Source
            </ContentTemplate>
        </asp:UpdatePanel>

SQL

I am using HTML Virtual Keyboard Interface Script - v1.49 in our asp.net c# project for tamil keyboard. It is working perfect, but when I saved the textbox value into sql server 2005 database it is stored as small squares or question marks. I used nvarchar data type for that field. Please help me, I am in very critical position.

Regards

It's normal for non printable chars and unicode to show as squares like CR and CRLF. It doesn't mean that the data is wrong or malformed unless you can prove it.

If you want to see all the data, try blob or something that shows the whole character set.

Or you may have to encode on write and decode the data on read.

Here's something to get you started on what to search for

[^]

Take a look at Thatja's solution[^].

I found this with a simple search query on Google, try doing some research before asking a question.

Never underestimate the power of human stupidity
RAH

Hello,

I have a radio button list control on my ASP.NET web form for selecting the payment method (Credit Card, Cheque or Cash),

And a credit card detail submission area for entering the credit card details if the user chose Credit Card as the payment method.
The credit card detail entering area has a radio button list control for selecting Credit Card type (AMEX, Master or VISA), a text box for entering the credit card number and a drop down list for selecting the credit card expiry month as shown below

ASP.NET

<!-- Radio button list control for selecting the payment method -->

<asp:RadioButtonList ID="rdPaymentMethod" runat="server">
     <asp:ListItem Value="CC"> Credit Card</asp:ListItem>
     <asp:ListItem Value="Cheque"> Cheque</asp:ListItem>
     <asp:ListItem Value="Cash"> Cash / Other</asp:ListItem>
</asp:RadioButtonList>


<!-- Credit card details entering area -->

<asp:RadioButtonList ID="rdCCType" runat="server">
     <asp:ListItem Value="AMEX"> American Express</asp:ListItem>
     <asp:ListItem Value="Master"> Master Card</asp:ListItem>
     <asp:ListItem Value="VISA"> VISA</asp:ListItem>
</asp:RadioButtonList>


<asp:TextBox ID="txtCCNumber" runat="server"></asp:TextBox>


<asp:DropDownList ID="ddlCCExpiryMonth" runat="server">
     <asp:ListItem Selected="True">Month</asp:ListItem>
     <asp:ListItem Value="01">01</asp:ListItem>
     <asp:ListItem Value="02">02</asp:ListItem>
     <asp:ListItem Value="03">03</asp:ListItem>
     <asp:ListItem Value="04">04</asp:ListItem>
     <asp:ListItem Value="05">05</asp:ListItem>
     <asp:ListItem Value="06">06</asp:ListItem>
     <asp:ListItem Value="07">07</asp:ListItem>
     <asp:ListItem Value="08">08</asp:ListItem>
     <asp:ListItem Value="09">09</asp:ListItem>
     <asp:ListItem Value="10">10</asp:ListItem>
     <asp:ListItem Value="11">11</asp:ListItem>
     <asp:ListItem Value="12">12</asp:ListItem>
</asp:DropDownList>

I am trying to validate my webform so that,

IF and ONLY IF the user select the first option (Credit Card) for payment type,

Then the user must ALSO select the credit card type (rdCCType), then enter credit card number (txtCCNumber) and also select credit card expiry month (ddlCCExpiryMonth)

I have absolutely no idea how to accomplish this and where to start.

Please show me how to do this using ASP.NET validation controls.

Thank you.

You make validation groups, and assign the controls in the credit card code to use the validation group for it. Then assign the submit button that triggers the validation group with the same group.

Example:
http://www.aspsnippets.com/Articles/Validate-Multiple-Validation-Groups-with-one-Button-in-ASPNet.aspx[^]

modified 8-Dec-13 18:50pm.

you can make the validation group in every radio button and also with in Drop down list.
IF you when submit button click check the every validation group, if any validation throw false your button not working.
I hope Validation Group help solve your problem.

Hello friends! Please I need your help over this issue. I have asp.net application using sql as backend. In my database, I have two fields(authorName and txtbkTitle) In this application, authors can insert as many textbooks as they want into the database provided the authors name remains unchanged (i.e if John Kyle is an author, all the textbooks he will save, will have John Kyle as their author's name). I know how to search the database for a specific textbook but this is not the way I want it. What I want is that, when the author enter his/her name, all textbooks written by that author should be displayed and bind to datalist control leaving the other authors textbooks behind. Sample codes, links will be welcome. Thanks in advance!!!

You need to decide when you are going to start looking for the books, after the first character, after 2 or 3 characters or when the user presses the search button.

The search requires a round trip to the database and the volume returned will cause a delay, depends on your database size.

Your query would probably look something like

SQL

Select ID,Title,FirstName, Surname from vwBookAuthor where Surname like 'K%' or FirstName like 'K%'

Once you have that from the database you simply filter it in your codebehind or pass the list to the client and filter it based on further input. If the latency on 1 character is too big then wait for 2 or 3 characters to begin the search.

Never underestimate the power of human stupidity
RAH