|
Dear All,
I use ASP.net AccessDataSource to retrieve data from a Access file. In this Access file, two tables are updated automatically by a Excel file and MsSQL(ODBC) respectively. The Access file and Excel file are in the same folder, so Access file can retrieve data from the Excel one successfully. However, when ASP.net -> Access -> MsSQL(ODBC connection called "ProyectoCongelados"), I got the following error message:System.Data.OleDb.OleDbException: ODBC--connection to 'ProyectoCongelados' failed.
Anyone can give me some advice?
Thanks in advance.
Regards,
TM
|
|
|
|
|
I am unable to judge where you got problem. Any code? You are using AccessDataSource - OleDB classes and where is code that uses ODBC?
A DATAPOST COMPUTER CENTRE
(K.V Prajapati)
|
|
|
|
|
hi,
i am using following code to download file from application its working fine in local system but when i configure in server a file is opening with sourse of aspx page can any one help me ?
string FilePath = Globals.ApplicationVRoot + "/Downloads/DemoUser.CSV";
string FileName = "DemoUser.CSV";
HttpResponse response = HttpContext.Current.Response;
response.ContentType = "application/octet-stream";
response.AddHeader("Content-Disposition", "attachment; filename=" + FileName);
response.WriteFile(FilePath.ToString());
response.End();
|
|
|
|
|
You should write following code:
string FilePath = Globals.ApplicationVRoot + "/Downloads/DemoUser.CSV";
byte []b=System.IO.File.ReadAllBytes(FilePath);
string FileName = "DemoUser.CSV";
HttpResponse response = HttpContext.Current.Response;
response.ClearHeaders();
response.ClearContent();
response.ContentType = "application/octet-stream";
response.AddHeader("Content-Length",b.Length.ToString());
response.AddHeader("Content-Disposition", "attachment; filename=" + FileName);
response.BinaryWrite(b);
response.Flush();
response.End();
A DATAPOST COMPUTER CENTRE
(K.V Prajapati)
|
|
|
|
|
Dear Sir,
How to extract Text from Candidate Resume word file and save in database.like in name column name will save Email column only Email will save etc. all candidate information will save in databse.
is it possible ?
in ASP.NET C# with SQL SERVER.
Thank you
|
|
|
|
|
yes, it is possible, using parsing you can achieve it... try to google and find the solution...
Padmanabhan
|
|
|
|
|
To read data from word file requires Ms-Office Interop service - DLL. So, add the reference of Ms-Word com component. LINQ is the another way to read a word document.
A DATAPOST COMPUTER CENTRE
(K.V Prajapati)
|
|
|
|
|
Hi all,
For adding the data in database i m using SqlParameter array collection.
In this method i am declering hardcoded array decleration of sqlparameter.
Follwing the the example.
public int Checkadmin(string usernm, string pwd)
{
SqlParameter[] sqlParam = new SqlParameter[2];
SqlDataReader dr;
int count = 0;
sqlParam[0] = new SqlParameter("@Username", SqlDbType.VarChar);
sqlParam[0].Value = usernm;
sqlParam[0].Size = 50;
sqlParam[1] = new SqlParameter("@Password", SqlDbType.VarChar);
sqlParam[1].Value = pwd;
sqlParam[1].Size = 50;
initializeDBConnection();
try
{
dr = execSelectByKeyParams("select.admin_login", sqlParam);
while (dr.Read())
{
count = Convert.ToInt32(dr.GetValue(0));
}
}
catch (SqlException sqlEx)
{
string str;
str = sqlEx.Message + sqlEx.StackTrace;
}
catch (Exception ex)
{
string str;
str = ex.Message + ex.StackTrace;
}
dispose();
return count;
}
Now i want to replace the SqlParameter array by generic arraylist.I dont want
to user hardcoded array decleration. I have created sqlparameter generic arraylist
as follow.
List<SqlParameter[]> sqlParam=new List<SqlParameter[]>();
But can anybody guide me how can i proceed further.
Thanks
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
This [^]should help you.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi All,
Is there a tool or template that someone can suggest which can be used to assess the impact of recent database changes (sql server 2000) on an existing asp.net 1.1 project?
Any guideline will help.
Thanks for the time.
sthambir
|
|
|
|
|
I am stucked in to a problem. I am working on a shopping cart project. When a user selects an category from the menu, it showcases the subcategories related to that category. It is showcased like this:
first the image (in the image button control) then below it the name of the category (in the hyperlink control). Both are clickable. Now if the user further clicks on any of the sub category, the name and the category id is passed to the next page through query string. Suppose the name of the category is "Spirit Dispensers & Measures". When I am retrieving this through request.querystring, the problem arises i.e
ch_name = Request.QueryString["name"];
While debugging by using breaking point I found that the variable ch_name is showing only "Spirit Dispensers" and when I am checking the QueryString by mouseover it is showing like this "Spirit+Dispensers+&+Measures" .
But I want the full name in the variable as "Spirit Dispensers & Measures" . So please help me out. Its really urgent.
Waiting for your earliest response.
Actually I am passing it like this:
so how to do it in inline code.
<asp:ImageButton ID="ImageButton1" runat="server" Height="100px" Width="100px" ImageUrl='<%# Eval("cat_image") %>' PostBackUrl='<%# "SubCategory.aspx?name=" + DataBinder.Eval(Container.DataItem,"category_name")+ "&cat_id=" + DataBinder.Eval(Container.DataItem,"category_id")%>' /><br />
<asp:HyperLink ID="HyperLink1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"category_name") %>' NavigateUrl='<%# "SubCategory.aspx?name=" + DataBinder.Eval(Container.DataItem,"category_name")+ "&cat_id=" + DataBinder.Eval(Container.DataItem,"category_id")%>' Font-Underline="false" Font-Bold="true" Font-Names="verdana" Font-Size="Small" ForeColor="#336699" />
cheers,
sneha
|
|
|
|
|
//encode
string aa = "Spirit Dispensers & Measures";
string url = string.Format("Default1.aspx?name={0}", Server.UrlEncode(aa));
Response.Redirect(url);
//decode
ch_name = Server.UrlDecode(Request.QueryString["name"]);
Padmanabhan
|
|
|
|
|
ya, Padmanabhan is correct and I have tried it. you can use Server.UrlEncode()
|
|
|
|
|
Database
Name Product Target Achieved
AAA A1 5 4
AAA A1 3 1
BBB B1 8 5
BBB B1 2 1
CCC C1 56 4
CCC C1 43 32
Grid View
A1 B1
Name Target Achieved Target Achieved
AAA 5 4 3 1
BBB 8 5 2 1
CCC 56 4 43 32
Total 69 13 48 34
i want result like that any one tell solution
|
|
|
|
|
If you use Oracle there is function rowtocol(), you can use that as follows,
SELECT a.deptno, a.dname, a.loc,
rowtocol('SELECT DISTINCT job FROM emp WHERE deptno = ' ||a.deptno) as jobs
FROM dept a;
Which database are you using ? 
|
|
|
|
|
i am using sql server 2005
|
|
|
|
|
|
Hi all,
I have textboxes with both single line and multiple line entry. I have noticed that the fonts are different between the two types..
i have been used a CSS class..in that Body part i have given the fonts...
body
{
font-family:Century Gothic,"Trebuchet MS", Tahoma, Arial, Verdana, Helvetica;
margin: 0;
font-size: 10px;
overflow: auto;
background: #ffffff;
}
but still the fonts are diffrent for textbox and textarea...
I would like to set them to be the same. Can someone tell me how to fix that?..
thanks in advance...
|
|
|
|
|
//css
.text { font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; }
<asp:textbox id="TextBox1" runat="server" cssclass="text">
<asp:textbox id="TextBox2" runat="server" textmode="MultiLine" cssclass="text">
Padmanabhan
|
|
|
|
|
but am not adding any CSS specifically to any textbox..it should apply the same which i gave in the body part,as what i mentioned...
|
|
|
|
|
this is my code:
<object height="451" width="547" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0">
<param value="/temp/Player.swf" name="movie" />
<param value="high" name="quality" /><param value="false" name="menu"/>
<param value="transparent" name="wmode" />
<param value="true" name="allowFullScreen" />
<param true="" value="FlvPath=Http://localhost/temp/200901161841142187.flv&autoStart=" name="FlashVars" />
<embed height="451" width="547" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" quality="high" menu="false" flashvars="FlvPath=Http://localhost/temp/200901161841142187.flv&autoStart=true" allowfullscreen="true" src="/temp/Player.swf" />
Why it can't play?
Thanks.
|
|
|
|
|
//you can use like this... Preview is my folder name and TRAD.AVI is my video name
<embed src="Preview/TRAD.AVI" style="HEIGHT: 331px; LEFT: 83px; TOP: 171px; WIDTH: 538px" />
Padmanabhan
|
|
|
|
|
still can not play.
only display a Blank region.
|
|
|
|
|
//I am using the same .SWF format file. It plays fine for me.
<embed src="Preview/VISUALISE.SWF" style="HEIGHT: 331px; LEFT: 83px; TOP: 171px; WIDTH: 538px" />
Padmanabhan
|
|
|
|
|
You can use this object.
Here "Images_View/globe.swf" is the complete path of my flash file and set hight and width as per your requirement.
Hope this will helpful for your.
<OBJECT id='hcp' codeBase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000'VIEWASTEXT>
<PARAM NAME='_cx' VALUE='20585'>
<PARAM NAME='_cy' VALUE='5054'>
<PARAM NAME='FlashVars' VALUE='20585'>
<PARAM NAME='Movie' VALUE='Images_View/globe.swf'>
<PARAM NAME='WMode' VALUE='Transparent'>
<PARAM NAME='Play' VALUE='-1'>
<PARAM NAME='Loop' VALUE='-1'>
<PARAM NAME='Quality' VALUE='High'>
<PARAM NAME='SAlign' VALUE=''>
<PARAM NAME='Menu' VALUE='0'>
<PARAM NAME='Base' VALUE=''>
<PARAM NAME='AllowScriptAccess' VALUE='always'>
<PARAM NAME='Scale' VALUE='ShowAll'>
<PARAM NAME='DeviceFont' VALUE='0'>
<PARAM NAME='EmbedMovie' VALUE='0'>
<PARAM NAME='BGColor' VALUE='FFFFFF'>
<PARAM NAME='SWRemote' VALUE=''>
<EMBED src='Images_View/globe.swf' quality='high' height='200' width='450' wmode='transparent' menu='transparent' TYPE='application/x-shockwave-flash' PLUGINSPAGE='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash'> </EMBED>
</OBJECT>
Regards...
Vijay Jain
"One thing you can't recycle is wasted time."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
