.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

entering data through forms and retriving data from sql

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :ASP.Net
 
Hello,       This is varghese, i need to make a web form in asp.net and i need to collect the filled data in a table created in sql. Given below is the format  when the save button clicks i need to save the entered data in to the corresponding table which is created in sql.      name       (text box) gender        female male mixed (radio button list)country       (test box)  state           "district        " e-mail          "phone       " photo        (upload)   Save (button)   after saving the data ,when clicking another  button for example view i need to show the complete record in one line including photo(size of the photo 120X120) please help me to build a sample code which is working perfectly


View Complete Post


More Related Resource Links

Using Session to pass data between forms

  

In my app, I am displaying an Rss Feed, I have a button that takes the user to another form where they can select a them.  Upon selecting the theme, they are taken back to the original form. 


If the user has selected which theme they want to view then they click on the button to change theme, I need to pass the information about what rss feed they were viewing through session so that once they select the theme they want they are redirected back to the main page and the rss feed they were viewing should still be displayed.


Since I've already bound the data to the xmlDataSource and DataList I am trying the following:


Session.Add("CurrentRssFeed", XmlDataSource1.DataFile);

Session.Add("CurrentDataList", DataList1);


I'm not sure I am passing the data over correctly and I'm not sure how to specify it in the page_preinit.


Any ideas???




Writing Data to database with jQuery Forms, ASMX Webservice, & JSON - help!

  

Hi, 

Can someone point me in the right direction on how to submit data from a jQuery form to a ASMX webservice? I have gotten everything on the form ready to be submitted to the database and now I am stuck on how to send it over using $.ajax(). Everything I have read tells me how to get data from a webservice and display it with jQuery, but not the other direction nor how to access the json data within the within the webservice service(similar to a Request.Form approach with ASP.NET forms).

In other words: 

1. What do I need to do to my webservice to make sure it can receive data from the jQuery form. 

2. What do I need to do in jQuery to receive an acknowledgement the save on the server side was successful. 

I can explain more if need be, but if there is a comprehensive tutorial on not only reading, but also WRITING data with jQuery, JSON, etc. I would love to get pointed in that direction. 


Enable Go Button after entering data in all fields using javascript funtion

  

Hi friends,

My page is having one gridview with check boxes,two textboxes and one button just like this see this link now i want to enable go button whenever user has select checkbox in gridview and he needs to enter text in two textboxes. i have written onkeyup event for two textboxes to test whether user enter text in textboxes or not but i am unable to write javascript function to check whether user has selected checkbox in gridview or not to enable go button .My requiremnet is user need to enter three inputs select atleast one checkbox in gridview and he needs to enter text in two textboxes.please friends pls tell me how to write javascript function to find whether user has selected the checkbox in gridview or not


Writing the windows forms data to an HTML file

  
I have a windows forms application ready now i need to transfer data from the windows forms to the web and to do this i need to write an HTML file that contains the form data, i mean the data contained in the form should be written to an HTML file to be submitted and this HTML file should be generated on the local PC. I have the code for the HTML file but how can i write this HTML file with the data values contained in my windows forms. Please give your suggestions. Best Regards, Syed

External Lists and Infopath forms issue with Secondary Data Sources

  
I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

import data from infopath xml forms to SharePoint list

  
Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Retriving data from CheckBoxList and passing it to a Session

  

Hy


I wondering how can I retrive data from a CheckBoxList in c#. and once I get the data I would like to store the data in a session so I can use the data from a session on a another page


Thank you in advance


WCF Data Service as Forms Auth ASP Auth Source

  

Hi,

I was wondering if it is possible to use a WCF Dataservice as the MemberShipProvider for a forms auth application. I have written code for a provider (below), but I do not know what to do as far as a connection string, or any other web.config properties. Please Help!!! Here is the code for my provider, anytime it says Odbc that is because I based this off of the custom Odbc provider on the msdn site. The only ACTUAL references to any odbc connection are in the comments:

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Collections.Specialized;
using System.Web.Security;
using System.Configuration.Provider;
using System.Configuration;
using System.Data.Odbc;
using System.Text;
using System.Diagnostics;
using System.Security.Cryptography;
using System.Data;
using nGreekApplication.Web.nGreekService;

namespace nGreekApplication.Web.Services
{
    public class nGreekProvider: MembershipProvider
    {
          

    //
    // 

How can I avoid entering Output columns manually (with their data types) in the Script Transformatio

  
I created a wrapper to a WCF web service that is returning many datasets with hundreds of columns.  The destination database schema matches the source schema exactly.  When i make the connection on a ADO.NET destination object to my database it auto-generates my list of columns.  I understand that the script component could output anything so it can't autogenerate at this point, but is there any way to copy and paste the Column definitions from somwhere else and paste them in?  I'd like to avoid spending hours entering all these manually.

InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the s

  

Hi All,

I am getting following error message in my SharePoint Logs,

InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the server. This may indicate the SESSION_STATE_PASCAL_CASED is not configured properly on a multiple front end farm or that a malicious user is trying to tamper with client data.

Any idea how to solve this issue ?

Regards..


Muhammad Tariq khan

Retaining Data on Partially Filled Out Forms

  

Hi All,

I have a question.  Is there a way for a user to partially fill out a form and not commit it to the database, leave the page and come back to it and the information that the user filled out is still there?  Any help or comments will be appreciated.

 

CalvinC

 


How can I read data from the Forms Authentication Cookie

  
Hello,

I am using Forms Authentication to secure a site. I am using the "user defined data area" to store an account number. I am then encrypting the ticket.

eg/

string hash = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash);



How can I read the "user data" in the cookie? Thanks for the help!

Testing InfoPath Forms with Rules using GetCommonMemberships Data Connection

  

I have my first InfoPath form coming up for testing. This uses a GetCommonMemberships data connection as a condition for various rules (for example, form load rules that switch views when the user is a member of a Packaging AD group). I’m not a member of any of the AD groups being used for these conditions and neither are the company’s QAs.

Because I’m not a member of any of the groups, I tend to set my rule up in reverse to check it. For example, if I have a rule where the DisplayName is equal to “domain\Packaging” (of which I am not a member), the control is not disabled for me. This assumes that the opposite is also true if I change the rule to is not equal to “domain\Packaging”. In other words, the control should not be disabled for members of that group but it should be for me.

How do you guys allow your QAs to impersonate different team members to properly test this without compromising the integrity of the form?


Using Drop down menu in a grid view control for entering new data

  

I wish to use drop down menu(based on a table of my database) to update/insert data in a web form. The data is then fetch in to SQL table (Express).

How to do it ? 


How do you pass data between forms in Visual C++?

  

Basically, I have this problem. I need to pass a name from textBox1 in Form 1 to label1 in Form2. How exactly would I go about doing this?

Im using C++ so its much harder....


How to Improve the query Performence in Retriving the data from the tables

  

Hi

I am working on the T-Sql i am writing the the Queries to retrive the data from Multiple tables using Joins,Sub Queries....etc and it is giving the result fine but my worry is the performence is too low, can any any body help me to increase the performance of the Query please provide any link or Example so that i can increase my Query performance  please help me  my team is complaining about my query performance  please help Thanks in advance

Regards

Sunil Yoganna


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend