View Complete Post
Hi dear coders
though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.
i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net
i will be highly thankful for any kind help from you geniuses.
I have a web form, in that i'll enter daily expense details.
After i press save button, the data i entered are saved into an excel sheet.
I don't have idea how to save the data to excel sheet, so your help for this greatly welcome.
I added refernece MySql.Data to my project. My web.config looks like that:
<?xml version="1.0"?><configuration> <connectionStrings> </connectionStrings> <system.web> <compilation> <assemblies> <add assembly="MySql.Data, Version=220.127.116.11, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/> </assemblies> </compilation></system.web></configuration>
But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?
What the problem can be?
A vendor is providing content which needs to be inserted into the db. The content is basically questions with options and explanations. An example is below.
hello all i have a gridview and textbox i want to insert the data that typed in the textbox into the gridview i can do this but in other culomn i just can insert number
and when i type some world the error say:Invalid column name'every thing '
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="soal.aspx.vb" Inherits="soal" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"