Click here to Skip to main content
15,888,610 members
Home / Discussions / C#
   

C#

 
AnswerRe: Borland C DLL in C#.NET Pin
Xmen Real 21-Mar-09 4:11
professional Xmen Real 21-Mar-09 4:11 
GeneralRe: Borland C DLL in C#.NET Pin
dataminers21-Mar-09 5:06
dataminers21-Mar-09 5:06 
GeneralRe: Borland C DLL in C#.NET Pin
Ravadre21-Mar-09 6:23
Ravadre21-Mar-09 6:23 
Questionusing fileupload control any file will save and retrieve from database Pin
grkrishna21-Mar-09 2:45
grkrishna21-Mar-09 2:45 
AnswerRe: using fileupload control any file will save and retrieve from database Pin
Xmen Real 21-Mar-09 4:15
professional Xmen Real 21-Mar-09 4:15 
GeneralRe: using fileupload control any file will save and retrieve from database Pin
grkrishna21-Mar-09 20:46
grkrishna21-Mar-09 20:46 
GeneralRe: using fileupload control any file will save and retrieve from database Pin
Xmen Real 21-Mar-09 21:26
professional Xmen Real 21-Mar-09 21:26 
GeneralRe: using fileupload control any file will save and retrieve from database Pin
grkrishna21-Mar-09 23:05
grkrishna21-Mar-09 23:05 
hi, actually i designed one form. here the fields are name,dob,address,phone,email,his/her requirements,etc.i used fileupload control for requirement field.the enduser will upload any type of file. that file sent to db. this is my requirement using asp.net and c# and sql server 2005

bellow is my design code and programing code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="customresearch.aspx.cs" Inherits="customresearch" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body style="font-size: 12pt; font-family: Times New Roman">
<form id="form1" runat="server">
<div>
<table style="width: 520px; height: 672px">
<tr>
<td colspan="3">
<strong><span style="color: #0000cc">CUSTOM RESEARCH:</span></strong></td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
Title</td>
<td style="width: 136px">
<asp:DropDownList ID="ddlTitle" runat="server" Width="72px">
<asp:ListItem>Mr.</asp:ListItem>
<asp:ListItem>Ms.</asp:ListItem>
<asp:ListItem>Mrs.</asp:ListItem>
<asp:ListItem>Dr.</asp:ListItem>
</asp:DropDownList></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
First Name</td>
<td style="width: 136px">
<asp:TextBox ID="txtFirst" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
Last Name</td>
<td style="width: 136px; ">
<asp:TextBox ID="txtLast" runat="server"></asp:TextBox></td>
<td style="width: 100px; ">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
Job title</td>
<td style="width: 136px">
<asp:TextBox ID="txtJobtitle" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
Company</td>
<td style="width: 136px">
<asp:TextBox ID="txtCompany" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
Address-1</td>
<td style="width: 136px">
<asp:TextBox ID="txtAddress1" runat="server" TextMode="MultiLine" Width="152px"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right; height: 40px;">
Address-2</td>
<td style="width: 136px; height: 40px;">
<asp:TextBox ID="txtAddress2" runat="server" TextMode="MultiLine" Width="152px"></asp:TextBox></td>
<td style="width: 200px; height: 40px;">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
City</td>
<td style="width: 136px">
<asp:TextBox ID="txtCity" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right; height: 26px;">
State/<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Province</span></td>
<td style="width: 136px; height: 26px;">
<asp:TextBox ID="txtState" runat="server"></asp:TextBox></td>
<td style="width: 200px; height: 26px;">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Zip/Postal Code</span></td>
<td style="width: 136px">
<asp:TextBox ID="txtZipcode" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Country</span></td>
<td style="width: 136px">

<asp:DropDownList ID="ddlCountry" runat="server" Width="156px">
<asp:ListItem value="0" selected="True">--Country--</asp:ListItem>
<asp:ListItem value="93">Afghanistan-93</asp:ListItem>
<asp:ListItem value="355">Albania-355</asp:ListItem>
<asp:ListItem value="213">Algeria-213</asp:ListItem>
<asp:ListItem value="684">American Samoa-684</asp:ListItem>
<asp:ListItem value="376">Andorra-376</asp:ListItem>
<asp:ListItem value="244">Angola-244</asp:ListItem>
<asp:ListItem value="1">Anguilla-1</asp:ListItem>
<asp:ListItem value="1">Antigua and Barbuda-1</asp:ListItem>
<asp:ListItem value="54">Argentine Republic-54</asp:ListItem>
<asp:ListItem value="374">Armenia-374</asp:ListItem>
<asp:ListItem value="297">Aruba-297</asp:ListItem>
<asp:ListItem value="247">Ascension-247</asp:ListItem>
<asp:ListItem value="61">Australia-61</asp:ListItem>
<asp:ListItem value="672">Australian External Territories-672</asp:ListItem>
<asp:ListItem value="43">Austria-43</asp:ListItem>
<asp:ListItem value="994">Azerbaijani Republic-994</asp:ListItem>
<asp:ListItem value="1">Bahamas-1</asp:ListItem>
<asp:ListItem value="973">Bahrain-973</asp:ListItem>
<asp:ListItem value="880">Bangladesh-880</asp:ListItem>
<asp:ListItem value="1">Barbados-1</asp:ListItem>
<asp:ListItem value="375">Belarus-375</asp:ListItem>
<asp:ListItem value="32">Belgium-32</asp:ListItem>
<asp:ListItem value="501">Belize-501</asp:ListItem>
<asp:ListItem value="229">Benin-229</asp:ListItem>
<asp:ListItem value="1">Bermuda-1</asp:ListItem>
<asp:ListItem value="975">Bhutan-975</asp:ListItem>
<asp:ListItem value="591">Bolivia-591</asp:ListItem>
<asp:ListItem value="387">Bosnia and Herzegovina-387</asp:ListItem>
<asp:ListItem value="267">Botswana-267</asp:ListItem>
<asp:ListItem value="55">Brazil-55</asp:ListItem>
<asp:ListItem value="1">British Virgin Islands-1</asp:ListItem>
<asp:ListItem value="673">Brunei Darussalam-673</asp:ListItem>
<asp:ListItem value="359">Bulgaria-359</asp:ListItem>
<asp:ListItem value="226">Burkina Faso-226</asp:ListItem>
<asp:ListItem value="257">Burundi-257</asp:ListItem>
<asp:ListItem value="855">Cambodia-855</asp:ListItem>
<asp:ListItem value="237">Cameroon-237</asp:ListItem>
<asp:ListItem value="1">Canada-1</asp:ListItem>
<asp:ListItem value="238">Cape Verde-238</asp:ListItem>
<asp:ListItem value="1">Cayman Islands-1</asp:ListItem>
<asp:ListItem value="236">Central African Republic-236</asp:ListItem>
<asp:ListItem value="235">Chad-235</asp:ListItem>
<asp:ListItem value="56">Chile-56</asp:ListItem>
<asp:ListItem value="86">China-86</asp:ListItem>
<asp:ListItem value="57">Colombia-57</asp:ListItem>
<asp:ListItem value="269">Comoros-269</asp:ListItem>
<asp:ListItem value="242">Congo-242</asp:ListItem>
<asp:ListItem value="682">Cook Islands-682</asp:ListItem>
<asp:ListItem value="506">Costa Rica-506</asp:ListItem>
<asp:ListItem value="385">Croatia-385</asp:ListItem>
<asp:ListItem value="53">Cuba-53</asp:ListItem>
<asp:ListItem value="357">Cyprus-357</asp:ListItem>
<asp:ListItem value="420">Czech Republic-420</asp:ListItem>
<asp:ListItem value="243">Democratic Republic of the Congo-243</asp:ListItem>
<asp:ListItem value="45">Denmark-45</asp:ListItem>
<asp:ListItem value="246">Diego Garcia-246</asp:ListItem>
<asp:ListItem value="253">Djibouti-253</asp:ListItem>
<asp:ListItem value="1">Dominica-1</asp:ListItem>
<asp:ListItem value="1">Dominican Republic-1</asp:ListItem>
<asp:ListItem value="670">East Timor-670</asp:ListItem>
<asp:ListItem value="593">Ecuador-593</asp:ListItem>
<asp:ListItem value="20">Egypt-20</asp:ListItem>
<asp:ListItem value="503">El Salvador-503</asp:ListItem>
<asp:ListItem value="240">Equatorial Guinea-240</asp:ListItem>
<asp:ListItem value="291">Eritrea-291</asp:ListItem>
<asp:ListItem value="372">Estonia-372</asp:ListItem>
<asp:ListItem value="251">Ethiopia-251</asp:ListItem>
<asp:ListItem value="687">ew Caledonia-687</asp:ListItem>
<asp:ListItem value="500">Falkland Islands-500</asp:ListItem>
<asp:ListItem value="298">Faroe Islands-298</asp:ListItem>
<asp:ListItem value="679">Fiji-679</asp:ListItem>
<asp:ListItem value="358">Finland-358</asp:ListItem>
<asp:ListItem value="33">France-33</asp:ListItem>
<asp:ListItem value="594">French Guiana-594</asp:ListItem>
<asp:ListItem value="689">French Polynesia-689</asp:ListItem>
<asp:ListItem value="241">Gabonese Republic-241</asp:ListItem>
<asp:ListItem value="220">Gambia-220</asp:ListItem>
<asp:ListItem value="995">Georgia-995</asp:ListItem>
<asp:ListItem value="49">Germany-49</asp:ListItem>
<asp:ListItem value="233">Ghana-233</asp:ListItem>
<asp:ListItem value="350">Gibraltar-350</asp:ListItem>
<asp:ListItem value="30">Greece-30</asp:ListItem>
<asp:ListItem value="299">Greenland-299</asp:ListItem>
<asp:ListItem value="1">Grenada-1</asp:ListItem>
<asp:ListItem value="590">Guadeloupe-590</asp:ListItem>
<asp:ListItem value="1">Guam-1</asp:ListItem>
<asp:ListItem value="502">Guatemala-502</asp:ListItem>
<asp:ListItem value="224">Guinea-224</asp:ListItem>
<asp:ListItem value="245">Guinea-Bissau-245</asp:ListItem>
<asp:ListItem value="592">Guyana-592</asp:ListItem>
<asp:ListItem value="509">Haiti-509</asp:ListItem>
<asp:ListItem value="504">Honduras-504</asp:ListItem>
<asp:ListItem value="852">HONG KONG-852</asp:ListItem>
<asp:ListItem value="36">Hungary-36</asp:ListItem>
<asp:ListItem value="354">Iceland-354</asp:ListItem>
<asp:ListItem value="91">India-91</asp:ListItem>
<asp:ListItem value="62">Indonesia-62</asp:ListItem>
<asp:ListItem value="872">Inmarsat-872</asp:ListItem>
<asp:ListItem value="873">Inmarsat-873</asp:ListItem>
<asp:ListItem value="874">Inmarsat-874</asp:ListItem>
<asp:ListItem value="871">Inmarsat-871</asp:ListItem>
<asp:ListItem value="870">Inmarsat SNAC-870</asp:ListItem>
<asp:ListItem value="800">International Freephone Service-800</asp:ListItem>
<asp:ListItem value="98">Iran-98</asp:ListItem>
<asp:ListItem value="964">Iraq-964</asp:ListItem>
<asp:ListItem value="353">Ireland-353</asp:ListItem>
<asp:ListItem value="972">Israel-972</asp:ListItem>
<asp:ListItem value="39">Italy-39</asp:ListItem>
<asp:ListItem value="1">Jamaica-1</asp:ListItem>
<asp:ListItem value="81">Japan-81</asp:ListItem>
<asp:ListItem value="962">Jordan-962</asp:ListItem>
<asp:ListItem value="7">Kazakstan-7</asp:ListItem>
<asp:ListItem value="254">Kenya-254</asp:ListItem>
<asp:ListItem value="686">Kiribati-686</asp:ListItem>
<asp:ListItem value="82">Korea-82</asp:ListItem>
<asp:ListItem value="965">Kuwait-965</asp:ListItem>
<asp:ListItem value="996">Kyrgyz Republic-996</asp:ListItem>
<asp:ListItem value="371">Latvia (Republic of)-371</asp:ListItem>
<asp:ListItem value="961">Lebanon-961</asp:ListItem>
<asp:ListItem value="266">Lesotho-266</asp:ListItem>
<asp:ListItem value="231">Liberia-231</asp:ListItem>
<asp:ListItem value="218">Libya-218</asp:ListItem>
<asp:ListItem value="423">Liechtenstein-423</asp:ListItem>
<asp:ListItem value="370">Lithuania-370</asp:ListItem>
<asp:ListItem value="352">Luxembourg-352</asp:ListItem>
<asp:ListItem value="853">Macau-853</asp:ListItem>
<asp:ListItem value="261">Madagascar-261</asp:ListItem>
<asp:ListItem value="265">Malawi-265</asp:ListItem>
<asp:ListItem value="60">Malaysia-60</asp:ListItem>
<asp:ListItem value="960">Maldives-960</asp:ListItem>
<asp:ListItem value="223">Mali-223</asp:ListItem>
<asp:ListItem value="356">Malta-356</asp:ListItem>
<asp:ListItem value="692">Marshall Islands-692</asp:ListItem>
<asp:ListItem value="596">Martinique-596</asp:ListItem>
<asp:ListItem value="222">Mauritania-222</asp:ListItem>
<asp:ListItem value="230">Mauritius-230</asp:ListItem>
<asp:ListItem value="269">Mayotte-269</asp:ListItem>
<asp:ListItem value="52">Mexico-52</asp:ListItem>
<asp:ListItem value="691">Micronesia-691</asp:ListItem>
<asp:ListItem value="373">Moldova-373</asp:ListItem>
<asp:ListItem value="377">Monaco-377</asp:ListItem>
<asp:ListItem value="976">Mongolia-976</asp:ListItem>
<asp:ListItem value="1">Montserrat-1</asp:ListItem>
<asp:ListItem value="212">Morocco-212</asp:ListItem>
<asp:ListItem value="258">Mozambique-258</asp:ListItem>
<asp:ListItem value="95">Myanmar-95</asp:ListItem>
<asp:ListItem value="264">Namibia-264</asp:ListItem>
<asp:ListItem value="674">Nauru-674</asp:ListItem>
<asp:ListItem value="977">Nepal-977</asp:ListItem>
<asp:ListItem value="31">Netherlands-31</asp:ListItem>
<asp:ListItem value="599">Netherlands Antilles-599</asp:ListItem>
<asp:ListItem value="64">New Zealand-64</asp:ListItem>
<asp:ListItem value="505">Nicaragua-505</asp:ListItem>
<asp:ListItem value="227">Niger-227</asp:ListItem>
<asp:ListItem value="234">Nigeria-234</asp:ListItem>
<asp:ListItem value="683">Niue-683</asp:ListItem>
<asp:ListItem value="1">Northern Mariana Islands-1</asp:ListItem>
<asp:ListItem value="47">Norway-47</asp:ListItem>
<asp:ListItem value="968">Oman-968</asp:ListItem>
<asp:ListItem value="92">Pakistan-92</asp:ListItem>
<asp:ListItem value="680">Palau-680</asp:ListItem>
<asp:ListItem value="507">Panama-507</asp:ListItem>
<asp:ListItem value="675">Papua New Guinea-675</asp:ListItem>
<asp:ListItem value="595">Paraguay-595</asp:ListItem>
<asp:ListItem value="51">Peru-51</asp:ListItem>
<asp:ListItem value="63">Philippines-63</asp:ListItem>
<asp:ListItem value="48">Poland-48</asp:ListItem>
<asp:ListItem value="351">Portugal-351</asp:ListItem>
<asp:ListItem value="1">Puerto Rico-1</asp:ListItem>
<asp:ListItem value="974">Qatar-974</asp:ListItem>
<asp:ListItem value="262">Reunion-262</asp:ListItem>
<asp:ListItem value="40">Romania-40</asp:ListItem>
<asp:ListItem value="7">Russian Federation-7</asp:ListItem>
<asp:ListItem value="250">Rwandese Republic-250</asp:ListItem>
<asp:ListItem value="290">Saint Helena-290</asp:ListItem>
<asp:ListItem value="1">Saint Kitts and Nevis-1</asp:ListItem>
<asp:ListItem value="1">Saint Lucia-1</asp:ListItem>
<asp:ListItem value="508">Saint Pierre and Miquelon-508</asp:ListItem>
<asp:ListItem value="1">Saint Vincent and the Grenadines-1</asp:ListItem>
<asp:ListItem value="685">Samoa-685</asp:ListItem>
<asp:ListItem value="378">San Marino-378</asp:ListItem>
<asp:ListItem value="239">Sao Tome and Principe-239</asp:ListItem>
<asp:ListItem value="966">Saudi Arabia-966</asp:ListItem>
<asp:ListItem value="221">Senegal-221</asp:ListItem>
<asp:ListItem value="248">Seychelles-248</asp:ListItem>
<asp:ListItem value="232">Sierra Leone-232</asp:ListItem>
<asp:ListItem value="65">Singapore-65</asp:ListItem>
<asp:ListItem value="421">Slovak Republic-421</asp:ListItem>
<asp:ListItem value="386">Slovenia-386</asp:ListItem>
<asp:ListItem value="677">Solomon Islands-677</asp:ListItem>
<asp:ListItem value="252">Somali Democratic Republic-252</asp:ListItem>
<asp:ListItem value="27">South Africa-27</asp:ListItem>
<asp:ListItem value="34">Spain-34</asp:ListItem>
<asp:ListItem value="94">Sri Lanka-94</asp:ListItem>
<asp:ListItem value="249">Sudan-249</asp:ListItem>
<asp:ListItem value="597">Suriname-597</asp:ListItem>
<asp:ListItem value="268">Swaziland-268</asp:ListItem>
<asp:ListItem value="46">Sweden-46</asp:ListItem>
<asp:ListItem value="41">Switzerland-41</asp:ListItem>
<asp:ListItem value="963">Syrian Arab Republic-963</asp:ListItem>
<asp:ListItem value="992">Tajikistan-992</asp:ListItem>
<asp:ListItem value="255">Tanzania-255</asp:ListItem>
<asp:ListItem value="66">Thailand-66</asp:ListItem>
<asp:ListItem value="389">The Former Yugoslav Republic of Macedonia-389</asp:ListItem>
<asp:ListItem value="228">Togolese Republic-228</asp:ListItem>
<asp:ListItem value="690">Tokelau-690</asp:ListItem>
<asp:ListItem value="676">Tonga-676</asp:ListItem>
<asp:ListItem value="1">Trinidad and Tobago-1</asp:ListItem>
<asp:ListItem value="216">Tunisia-216</asp:ListItem>
<asp:ListItem value="90">Turkey-90</asp:ListItem>
<asp:ListItem value="993">Turkmenistan-993</asp:ListItem>
<asp:ListItem value="1">Turks and Caicos Islands-1</asp:ListItem>
<asp:ListItem value="688">Tuvalu-688</asp:ListItem>
<asp:ListItem value="256">Uganda-256</asp:ListItem>
<asp:ListItem value="380">Ukraine-380</asp:ListItem>
<asp:ListItem value="971">United Arab Emirates-971</asp:ListItem>
<asp:ListItem value="44">United Kingdom of Great Britain and Northern Ireland-44</asp:ListItem>
<asp:ListItem value="1">United States of America-1</asp:ListItem>
<asp:ListItem value="1">United States Virgin Islands-1</asp:ListItem>
<asp:ListItem value="598">Uruguay-598</asp:ListItem>
<asp:ListItem value="998">Uzbekistan-998</asp:ListItem>
<asp:ListItem value="678">Vanuatu-678</asp:ListItem>
<asp:ListItem value="379">Vatican City State-379</asp:ListItem>
<asp:ListItem value="39">Vatican City State-39</asp:ListItem>
<asp:ListItem value="58">Venezuela-58</asp:ListItem>
<asp:ListItem value="84">Viet Nam-84</asp:ListItem>
<asp:ListItem value="681">Wallis and Futuna-681</asp:ListItem>
<asp:ListItem value="967">Yemen-967</asp:ListItem>
<asp:ListItem value="381">Yugoslavia-381</asp:ListItem>
<asp:ListItem value="260">Zambia-260</asp:ListItem>
<asp:ListItem value="263">Zimbabwe-263</asp:ListItem>
</asp:DropDownList>
</td>
<td style="width: 200px">
</td>
</tr>
<tr>
<td style="width: 246px; text-align: right">
<span style="font-size: 11pt; line-height: 115%; font-family: 'Perpetua','serif';
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">E-Mail&nbsp;</span></td>
<td style="width: 136px; font-size: 12pt; font-family: Times New Roman;">
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox></td>
<td style="width: 200px; font-size: 12pt; font-family: Times New Roman;">
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtEmail"
ErrorMessage="Enter Your email-id"></asp:RequiredFieldValidator></td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Phone</span></td>
<td style="width: 136px">
<asp:TextBox ID="txtphone" runat="server"></asp:TextBox></td>
<td style="width: 200px">
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtphone"
ErrorMessage="Enter Your phoneno"></asp:RequiredFieldValidator></td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Fax</span></td>
<td style="width: 136px">
<asp:TextBox ID="txtFax" runat="server"></asp:TextBox></td>
<td style="width: 200px">
</td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Brief Description of Your
Custom Research
<br />
(or)<br />
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA"></span></span></td>
<td style="width: 136px; font-size: 12pt; font-family: Times New Roman;">
<asp:TextBox ID="txtDesc" runat="server" Height="96px" TextMode="MultiLine" Width="152px"></asp:TextBox></td>
<td style="width: 200px; font-size: 12pt; font-family: Times New Roman;">
</td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px; text-align: right">
<span>Attach a File With Your Requirements
(Max 20mb)<br />
Browse</span></td>
<td style="width: 136px">
<asp:FileUpload ID="FileUpload1" runat="server" Height="32px" Width="160px" /></td>
<td style="width: 200px">
</td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px; text-align: right">
<span style="line-height: 115%;
mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast;
mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US;
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">How Did you Find Us</span></td>
<td style="width: 136px">
<asp:DropDownList ID="ddlFind" runat="server" Width="152px">
<asp:ListItem>Google</asp:ListItem>
<asp:ListItem>Yahoo</asp:ListItem>
<asp:ListItem>Excite</asp:ListItem>
<asp:ListItem>Microsoft</asp:ListItem>
<asp:ListItem>Other searchengine</asp:ListItem>
<asp:ListItem>Link from Oher site</asp:ListItem>
<asp:ListItem>Referred by Others</asp:ListItem>
<asp:ListItem>Others</asp:ListItem>
</asp:DropDownList></td>
<td style="width: 200px">
</td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td colspan="3">
<p class="MsoNormal" style="margin: 0in 0in 10pt; tab-stops: right 110.6pt">
<b style="mso-bidi-font-weight: normal"><span style="font-family: 'Perpetua','serif'">
<span style="font-size: 11pt">*<span style="font-family: Times New Roman"><span style="font-size: 12pt">
If Possible Please Provide Your Company E-Mail Address
While Ordering<?xml namespace="" ns="urn:schemas-microsoft-com:office:office" prefix="o" ?><o:p></o:p></span></span></span></span></b></p>
</td>
</tr>
<tr style="font-size: 12pt; font-family: Times New Roman">
<td style="width: 246px">
</td>
<td style="width: 136px">
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" ForeColor="Blue" Font-Bold="True" />&nbsp;&nbsp;
<asp:Button ID="btnClear" runat="server" Text="Clear" OnClick="btnClear_Click" ForeColor="Blue" Font-Bold="True" /></td>
<td style="width: 200px">
</td>
</tr>
</table>

</div>
</form>
</body>
</html>


the programing code is

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;

public partial class customresearch : System.Web.UI.Page
{
SqlConnection cn = new SqlConnection("database=researchmind;Data Source=NEWSOFT;User id=sa;Password=abc123");
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();

protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter();

da = new SqlDataAdapter("insert into customresearch_t(title,firstname,lastname,jobtitle,company,address1,address2,"
+ "city,state,zipcode,country,email,phone,fax,description,find) values('" + ddlTitle.SelectedValue.ToString() + "','"
+ txtFirst.Text + "','" + txtLast.Text + "','" + txtJobtitle.Text + "','" + txtCompany.Text + "','" + txtAddress1.Text + "','"
+ txtAddress2.Text + "','" + txtCity.Text + "','" + txtState.Text + "','" + txtZipcode.Text + "', '" + ddlCountry.SelectedItem.ToString() + "','"
+ txtEmail.Text + "','" + txtphone.Text + "','" + txtFax.Text + "','" + txtDesc.Text + "','" + ddlFind.SelectedValue.ToString()+ "' )", cn);
da.Fill(ds);
string filepath = Server.MapPath(Request.ApplicationPath + "//");
string filename = Path.GetFileName(filepath);
FileStream fs = new FileStream(filepath + filename, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
br.Close();
fs.Close();
string query = "insert into uploadfile_t(Name,ContentType,Data) values (@Name,@ContentType,@Data)";
SqlCommand cmd = new SqlCommand(query);
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = filename;
cmd.Parameters.Add("@ContentType", SqlDbType.VarChar).Value = "ContentType";
cmd.Parameters.Add("@Data", SqlDbType.Binary).Value = bytes;

InsertUpdateData(cmd);

}
private Boolean InsertUpdateData(SqlCommand cmd)
{
cmd.CommandType=CommandType.Text;
cmd.Connection=cn;
try
{
cn.Open();
cmd.ExecuteNonQuery();
return true;
}
catch(Exception ex)
{
Response.Write(ex.Message);
return false;
}
finally
{
cn.Close();
cn.Dispose();
}
}

protected void btnClear_Click(object sender, EventArgs e)
{
ddlTitle.SelectedIndex = 0; ddlCountry.SelectedIndex = 0;
txtFirst.Text = ""; txtLast.Text = ""; txtJobtitle.Text = ""; txtEmail.Text = ""; txtCompany.Text = "";
txtAddress1.Text = ""; txtAddress2.Text = ""; txtCity.Text = ""; txtState.Text = ""; txtZipcode.Text = "";
txtphone.Text = ""; txtFax.Text = ""; ddlFind.SelectedIndex = 0; txtDesc.Text = ""; //FileUpload1.FileName = "";

}

}


please verify and what is problem is here ?reply me
thanks in advance
i want any file format will store in database and retrieve.
here only application for stored code is given
GeneralRe: using fileupload control any file will save and retrieve from database Pin
grkrishna22-Mar-09 0:03
grkrishna22-Mar-09 0:03 
GeneralRe: using fileupload control any file will save and retrieve from database Pin
grkrishna23-Mar-09 2:23
grkrishna23-Mar-09 2:23 
QuestionLdap authentication on Vista? Pin
Ronni Marker21-Mar-09 2:34
Ronni Marker21-Mar-09 2:34 
QuestionConvert PDF to Tiff Pin
Sun Rays21-Mar-09 2:18
Sun Rays21-Mar-09 2:18 
AnswerRe: Convert PDF to Tiff Pin
dan!sh 21-Mar-09 2:25
professional dan!sh 21-Mar-09 2:25 
GeneralRe: Convert PDF to Tiff Pin
Sun Rays21-Mar-09 2:27
Sun Rays21-Mar-09 2:27 
GeneralRe: Convert PDF to Tiff Pin
dan!sh 21-Mar-09 3:09
professional dan!sh 21-Mar-09 3:09 
Questionperforming button click automatically without performing it Pin
sashidhar21-Mar-09 2:04
sashidhar21-Mar-09 2:04 
AnswerRe: performing button click automatically without performing it Pin
Ravi Mori21-Mar-09 3:36
Ravi Mori21-Mar-09 3:36 
AnswerRe: performing button click automatically without performing it Pin
DaveyM6921-Mar-09 9:33
professionalDaveyM6921-Mar-09 9:33 
QuestionConversion from ascii to unicode Pin
tauras8121-Mar-09 1:15
tauras8121-Mar-09 1:15 
AnswerRe: Conversion from ascii to unicode Pin
dan!sh 21-Mar-09 1:25
professional dan!sh 21-Mar-09 1:25 
AnswerRe: Conversion from ascii to unicode Pin
PIEBALDconsult21-Mar-09 4:39
mvePIEBALDconsult21-Mar-09 4:39 
Questionruntime error for oledb Pin
Mangesh Tomar21-Mar-09 1:13
Mangesh Tomar21-Mar-09 1:13 
AnswerRe: runtime error for oledb Pin
dan!sh 21-Mar-09 1:32
professional dan!sh 21-Mar-09 1:32 
AnswerRe: runtime error for oledb Pin
Eddy Vluggen21-Mar-09 2:25
professionalEddy Vluggen21-Mar-09 2:25 
QuestionRegular Expressions Pin
yadlaprasad20-Mar-09 23:49
yadlaprasad20-Mar-09 23:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.