I am making a basic application, which is collecting information of visitors by entering their info in text boxes, then how can I store those information in DB? what will be the connection code to DB? and the method to store in DB?
View 7 RepliesIts related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 RepliesMy SQL stored procedure returns 3 different datasets as follows:
team_id name
1 Team1
2 Team2
...and more
location_id name
1 Dallas
2 New York
...and more
branch_id name
1 Austin
2 New Jersey
...and more
How do I put this data into one Dataset so that I can loop through the data and manipulate it?
hey folks I got a general question that maybe some of you can just weigh in. I developed an online store for a client and people place orders online for a food ordering place however I am trying to find the best way to have the orders show up for them at the store. Currently I am sending an email and an autoprint software prints it out which works most of the time but not good enough sometimes it doesn't print. Anyone had similar issues or have other alternative solutions you may have heard off? Like I said the site sends an email to the customer and the store's email account.
View 7 RepliesIs it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 RepliesWeb service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
View 1 Repliesi am using a datalist in usercontrol.. i need to select data from datalist using jquery and store it in session?
View 2 RepliesI need to create a asp .net web application which should have several forms to get the survey data, When the user is out of the wifi or don't have internet access to connect to the server even though the user should have access to the forms or any other tools to input data and store them locally and sync to the database later. What are the options available to do this kind of tasks in asp.net / C# / Sql Server
View 2 RepliesI have a user control with data of person. iN this user control is subroutine which storing data to database of person.On my ASPX page I've implemented this control and another form with data which ii'm storing.On button click on ASPX page, i want to store all my data including data from my user control or subroutine in that user control which storing data of person.I want to make sqltransaction, so only one connection for aspx page and user control.ASPX.vb
[code]...
The point of my question is how to interact between my class where i have methods and user conttorl on aspx page.
I have a Stored Procedure
Create procedure selectdata
as
begin
select * from Employee
end
In my front End I Created a Button in default.aspx page
<asp:Button id="btnsave" runat="server" Text="Send to Excel" onclick="btnsave_Click"/> <asp:GridView id="gv" runat="server" > </asp:GridView>
In default.aspx.cs
protected void btnsave_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection();
conn.ConnectionString="User id=aa; password=123; Initial Catalog=abc;Integrated Security=xxxx";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
[Code].....
Output: It Displays the Data in Grid View but is it possible to store the Data directly in Excel file in my PC
Below is the code I use to store file into database but there are a few problems.
1. couldn't store file larger than 4mb
2. couldn't store doc,docx,xlsx but only .txt
my table column are:
[code]....
i have store data in the session and i want to insert that data to the database using sql server 2008.can i do this or not? if can, how can i?
View 1 RepliesHow much data store in Session and query string? means what is the limit of Session and query string.
View 1 RepliesI have one parent gridview where each record will link to its details page (another child gridview in modal popup). May I know how do I store the values of the child gridview temporary (maybe in session) and repopulate the data into the parent gridview? Current problem is: once I click save in the child modalpop gridview, it binds the parent gridview before the child gridview data is stored in session. I want to store the data temporary until user click save in the parent gridview.
View 4 RepliesI had displayed data in a gridview..Now I want to store all the data in a database table..How can I do that?..For eg: I have 2 columns named col1 and col2 and have 10 rows of data..I want to store the data in a table which has 2 columns to store col1 and col2 data..How can I store all the 10 rows of data in a single button click event?
View 1 RepliesI am developin application using WPF. I am using Backend XML File. I have a class StockQuoteSoapClient.
StockQuoteSoapClient obj = new StockQuoteSoapClient();
string s = "IBM";
Gridview1.DataContext=obj.GetQuote(s);
obj.GetQuote(s) returns xml format data
I have two pages
1. Register and
2. Preview.
Database Table columns are, ID, Name, Photo..During registration user can preview his/her information before submit their data to thek database. I can store ID and Name data to session state and retrive them easily from preview page but I do not know how to store data to session state. That means, I want to preview all data with Image without store data into database. Is it possible, Is possible, how?
I am developing a application which is social related, and medical also, where there are lots of offline data which we have to show per user, insted of asking database for all the data, to reduce the preassure on the db server, i have thought of using xml for the offline data source.
When a user logs in, the old data will be loaded from the xml file from his folder which approx of ( less than 1 mb) each file). the updated info will be fetched from the db with the index of that table.
Can we use xml in getting data using writer and reader in vs 2012.
I have OrderFilm.aspx that bind films information from database and I want use cookie in this page and users can order their film with different quality:
this is table:
Id Name 720P 1080P 720Price 1080Price
1 Spectre.2015 1 1 200$ 300$
2 Water Fall 1 1 150$ 200$
Orderfilm.aspx
<asp:DataList ID="DataList1" runat="server" RepeatColumns="2" RepeatDirection="Horizontal">
<ItemTemplate>
<div>
<asp:Label ID="lbldes" runat="server" Text='<%# Eval("name") %>'></asp:Label>
<asp:HyperLink ID="HyperLink3" runat="server" CssClass="LBP3In" NavigateUrl='<%#"film.aspx?ID="+Eval("ID")%>'
[Code] ....
In orderfilm.aspx users click on Film name and after that they go to film.aspx page that bind other film information from database :
film.aspx:
<div>
<asp:Label ID="lblMessage" runat="server" />
<div>
<asp:Label ID="Lblname" runat="server" />
</br>
<asp:CheckBox ID="cb720P" runat="server" Text="720P " />
[Code] ....
here users can select their intendend quality from checkbox:
film.aspx.cs:
string Film720p = string.Empty;
string FilmName = string.Empty;
string Film1080p = string.Empty;
protected void Page_Load(object sender, EventArgs e) {
viewproduct();
lblMessage.Text = GetCookies();
[Code] ...
Here I save cookie like this:
FilmName=Request.Cookies["orderFilm"]["FilmName"];
Film720p = Request.Cookies["orderFilm"]["Film720p"];
Film1080p = Request.Cookies["orderFilm"]["Film1080p"];
I want if users click on film name from orderfim.aspx ( i.e:Spectre.2015 )and go to film.aspx and select 720P checkbox it save in cookie that users select 720P for Spectre.2015 ...
here I wrote:
HttpCookie cookie = new HttpCookie("orderFilm");
if (cb720P.Checked) {
cookie["Film720p"] = cb720P.Text;
} if (cb1080P.Checked) {
cookie["Film1080P"] = cb1080P.Text;
} cookie["FilmName"] = Lblname.Text;
Response.Cookies.Add(cookie);
lblMessage.Text = GetCookies();
but problem is that in orderfilm.aspx page if users click in other film name(i.e:WaterFalll) and go to Film.aspx page and checked 720p checkbox It delete their last selected cookie and just set their new cookie:
and attention that here I use querystring in orderfilm.aspx:
<asp:HyperLink ID="HyperLink3" runat="server" CssClass="LBP3In" NavigateUrl='<%#"film.aspx?ID="+Eval("ID")%>'
Target="_blank">click to order</asp:HyperLink>
I'm creating a website using ASP.NET MVC 2 and I'm thinking of using the default AccountController and Views to take care of the Users.The only problem is that, for all the rest, I'm using a Postgres database.Is there a way to link The account controller to a User class defined by me?I'm using Nhibernate to connect to the database, so I'll have a User class with whatever fields necessary.
View 3 RepliesDoes someone have the code to write/store data from asp.net c# to a sql database?
View 5 RepliesCan i store Image data in Array list.
View 4 RepliesI am Developing a mobile Application by using .Net the Application having forms which are having different options like textfields and radio buttons.date,...etc Now, After filling the data into those forms then, I want to Store that data into Mobile internal or external Memory Later when the GPRS connection is available then, I want to retrive that data and want to send it to a server by using http connection or something else
View 3 RepliesI need to read and store data from tableOne, then insert those data to tableTwo.
View 5 RepliesI recently switched computers and now when I attempt to run my web project on my local machine I am receiving:[PolicyException: Required permissions cannot be acquired.]But if I publish it to my website everything seems to work correctly. I have done some research on this and it appears to be a security issue with one of the assemblies but I'm unsure which and how to go about figuring out which it is.Also, when I get on the Web Site Administration Tool and under the security tab I am seeing:"There is a problem with your selected data store. This can be cauesd by an invalid server name or credentials, or by insufficient permission. IT can also be caused by the role manager feature not being enabled.
View 4 Replies