Ldap authentication on Vista? - C# Discussion Boards

using fileupload control any file will save and retrieve from database

grkrishna21-Mar-09 2:45

21-Mar-09 2:45

this is my code plz help me here is my code.

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, 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;
//cmd.Parameters.Add("@requirement", SqlDbType.VarChar).Value = "application/vnd.ms-word";
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();
}
}
}

the following error will come
Could not find a part of the path 'C:\Documents and Settings\icon\Desktop\researchmind\'.

plz any one help me
any file will save and retrieve from db

Re: using fileupload control any file will save and retrieve from database

Xmen Real 21-Mar-09 4:15

Xmen Real

21-Mar-09 4:15

wrong

string filepath = Server.MapPath(Request.ApplicationPath + "//");
string filename = Path.GetFileName(filepath);
FileStream fs = new FileStream(filepath, FileMode.Open, FileAccess.Read);

correct

string filepath = Server.MapPath(Request.ApplicationPath + "//");
string filename = Path.GetFileName(filepath);
FileStream fs = new FileStream(filepath <code>+ filename</code>, FileMode.Open, FileAccess.Read);

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Re: using fileupload control any file will save and retrieve from database

grkrishna21-Mar-09 20:46

grkrishna

21-Mar-09 20:46

i changed as you given but the same problem will come. i want to any type of file upload into the db,the same will retrieve into the gridview

Could not find a part of the path 'C:\Documents and Settings\icon\Desktop\researchmind\'.

Re: using fileupload control any file will save and retrieve from database

Xmen Real 21-Mar-09 21:26

Xmen Real

21-Mar-09 21:26

no, if you did what I said. You wont get this error anymore. Can you show your code again....?

-----------------------------------------------
128 bit encrypted signature, crack if you can

Re: using fileupload control any file will save and retrieve from database

grkrishna21-Mar-09 23:05

grkrishna

21-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">
CUSTOM RESEARCH:</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</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</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</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 </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</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</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
 
(or) 
<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"></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">
Attach a File With Your Requirements
(Max 20mb) 
Browse</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</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">


*
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>
</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" />  
<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

Re: using fileupload control any file will save and retrieve from database

grkrishna22-Mar-09 0:03

grkrishna

22-Mar-09 0:03

sorry,one point is forgot i took two tables one table for customresearch_t, another table for uploadfile_t is this useful for my requirement.

Re: using fileupload control any file will save and retrieve from database

grkrishna23-Mar-09 2:23

grkrishna

23-Mar-09 2:23

hello plz reply this problem

Ldap authentication on Vista?

Ronni Marker21-Mar-09 2:34

Ronni Marker

21-Mar-09 2:34

Hi Guys,
Have on Windows XP been using the following code to authenticate if username and password are valid up against Active Directory. But found out that my apps are not working on Visa OS as it always return false, even if user + pw is correct - on XP no problems works 110% fine there, but on vista.. urgh!

private bool doAuthenticate(string szController)
{
    string path = "LDAP://" + szController;
    DirectoryEntry de = null;

    if (szUserName == null)
    {
        de = new DirectoryEntry(path);
    }
    else
    {
        de = new DirectoryEntry(path, "\\" + szUserName, szPassword);
    }

    try
    {
        Object native = de.NativeObject;
        return true;
    }
    catch (Exception ez)
    {
        return false;
    }
}

Any who have an idea on what is happening?

Cheers,

Convert PDF to Tiff

Sun Rays21-Mar-09 2:18

Sun Rays

21-Mar-09 2:18

Hi All,
i want to convert PDF file into tiff file using a code.
Do you have any idea how can i achieve this using any 3rd party Dll ?
Thanks.

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: Convert PDF to Tiff

dan!sh 21-Mar-09 2:25

dan!sh

21-Mar-09 2:25

Lots of ways to do this.[^]

जय हिंद

Re: Convert PDF to Tiff

Sun Rays21-Mar-09 2:27

Sun Rays

21-Mar-09 2:27

Thanks Danish,
but nothing is free......
I am looking for code even..

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: Convert PDF to Tiff

dan!sh 21-Mar-09 3:09

dan!sh

21-Mar-09 3:09

Here[^] and here[^]

You should have googled this yourself.

जय हिंद

performing button click automatically without performing it

sashidhar21-Mar-09 2:04

sashidhar

21-Mar-09 2:04

hi friends
i have a doubt in c#
i have two forms one is windows form and the other user control form i have a button on each control .i added a user control on windows form at run time by this.controls.add(usrctrl1).Is it possible to run the user control button automatically on clicking windows form button .if it is possible how can it be plz reply it sir
waiting for Your reply Sir

Re: performing button click automatically without performing it

Ravi Mori21-Mar-09 3:36

Ravi Mori

21-Mar-09 3:36

Hi Sashidhar..
Please Checkout following link:
http://www.akadia.com/services/dotnet_user_controls.html[^]

I think this will help you...
Thanks..

Re: performing button click automatically without performing it

DaveyM6921-Mar-09 9:33

DaveyM69

21-Mar-09 9:33

Create a public method in the user control that you call from the form's button_Click handler. In that method (in the user control) call the PerformClick method of the user control's button.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Conversion from ascii to unicode

tauras8121-Mar-09 1:15

tauras81

21-Mar-09 1:15

Hi,
I am having an application in region laguage i want to convert ascii code to unicode can anybody tell how can i do it.

Re: Conversion from ascii to unicode

dan!sh 21-Mar-09 1:25

dan!sh

21-Mar-09 1:25

System.Text.Encoding.Convert

जय हिंद

Re: Conversion from ascii to unicode

PIEBALDconsult21-Mar-09 4:39

PIEBALDconsult

21-Mar-09 4:39

Because Unicode includes ASCII, ASCII is Unicode, no conversion is necessary.

runtime error for oledb

Mangesh Tomar21-Mar-09 1:13

Mangesh Tomar

21-Mar-09 1:13

HI here is my code i take 1 txt,1datagride,2 button,1 file dialog box .
on 1 button i open filedialog box select 1 excel file and fetch string in to txt box,and try to open this excel file in datagride view

WHEN I RUN MY PROGRAM A RUN TIME EXCEPTION THROWEN BY OLEDB IE,
Cannot update. Database or object is read-only.
PLZ HELP

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.OleDb;

namespace filedialog
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

}

private void button2_Click(object sender, EventArgs e)
{

string filename = @"textBox1.Text";
String connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
//String connectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename +";"+"Extended Properties=Excel 8.0;";
OleDbCommand selectCommand = new OleDbCommand("SELECT * FROM [sheet1$]", connection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = selectCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);

// double sum = 0.0;
// We'll make some assumptions for brevity of the code.
System.Data.DataTable dataTable = dataSet.Tables[0];
dataGridView1.DataSource = dataSet.Tables[0];
MessageBox.Show(dataGridView1.RowCount.ToString());

connection.Close();
//openFileDialog1.ShowDialog();
//openFileDialog1.ShowDialog();

// return sum;
// directorySearcher1.FindAll();

}

private void button3_Click(object sender, EventArgs e)
{
OpenFileDialog FD = new OpenFileDialog();

FD .Filter="Excel|*.xls";

if (FD.ShowDialog() == DialogResult.OK)
{
textBox1.Text = " " + FD.FileName;
}

}

}

}

Re: runtime error for oledb

dan!sh 21-Mar-09 1:32

dan!sh

21-Mar-09 1:32

Mangesh Tomar wrote:
string filename = @"textBox1.Text";

Is this what you intend to do?

Which line throws this exception?

जय हिंद

Re: runtime error for oledb

Eddy Vluggen21-Mar-09 2:25

Eddy Vluggen

21-Mar-09 2:25

Two questions, related to the error "Cannot update. Database or object is read-only.";
- Are you "viewing" the sheet in Excel whilst running this code? If yes, then close it.
- Have you checked the properties of the file itself? Ie, it shouldn't be blocked etc.

I are troll Smile | :)