Re: Borland C DLL in C#.NET - C# Discussion Boards

21-Mar-09 3:28

How can I use DLL file in C#.NET ? I create dll in Borland C++ Compiler 5.5.1 and using C language.

Following code is not work.

My C Code;
-----------------------------------------------------
//hello.dll
#include <windows.h>

extern "C"
{
void __declspec (dllexport) function1()
{

MessageBox (NULL, "test message","test title",0);
}
}

BOOL WINAPI DllMain (HINSTANCE, DWORD, LPVOID)
{
return TRUE;
}

My C# Code;
-----------------------------------------------------

[DllImport("C:\hello.dll")]
public static extern void function1();

private void button1_Click(object sender, EventArgs e)
{
function1();
}

harold aptroot21-Mar-09 3:43

harold aptroot

21-Mar-09 3:43

Does it give an exception (if so, what kind?) or does it just silently fail?

dataminers21-Mar-09 3:48

21-Mar-09 3:48

Ok, I try this; But I get this error: Entry Point Not Found

C DLL CODE
-----------------------------------------------

#include <windows.h>

BOOL __stdcall DllMain(HINSTANCE hInst, DWORD dwReason, LPVOID lpReserved) {
return TRUE;
}

__declspec(dllexport) void __stdcall Message(char* p_szMessage) {
MessageBox(NULL, p_szMessage, "Message from DLL", MB_OK);
}

C# DLL CODE
-----------------------------------------------

[DllImport("filename.dll")]
static extern void Message(string msg);

private void button1_Click(object sender, EventArgs e)
{
Message("Hello world");
}

Ravi Mori21-Mar-09 3:46

Ravi Mori

21-Mar-09 3:46

Just put hello.dll in C:\WINDOWS\system32
and replace [DllImport("C:\hello.dll")] with [DllImport("hello.dll")]
IS that give any error or exception??

dataminers21-Mar-09 3:51

21-Mar-09 3:51

I get this error: Entry Point Not Found

Ravi Mori21-Mar-09 4:13

Ravi Mori

21-Mar-09 4:13

Sorry I am not sure about it, but try out following:
[DllImport(@“Hello.dll”, EntryPoint = "Your Function Name")].

And checkout following link:
http://blog.rednael.com/2008/08/29/MarshallingUsingNativeDLLsInNET.aspx[^]

Xmen Real 21-Mar-09 4:11

Xmen Real

21-Mar-09 4:11

following article may help
http://www.codeproject.com/KB/cs/dyninvok.aspx[^]

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

dataminers21-Mar-09 5:06

21-Mar-09 5:06

No, this article not related about my question.

I use Borland Compiler. Is it occour problem?

using fileupload control any file will save and retrieve from database

Ravadre21-Mar-09 6:23

Ravadre

21-Mar-09 6:23

Article XMen has linked will tell you how to check if library that you have compiled exports symbol (function) you are referring to. So try that one, this can give you some hint.

grkrishna21-Mar-09 2:45

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

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

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);

-----------------------------------------------
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

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

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\'.

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

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

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

grkrishna22-Mar-09 0:03

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

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.

grkrishna23-Mar-09 2:23