|
I was about to publish my site live until I discovered that a DDL is not displaying the first record from the results set! My code is as follows:
if (objRdr.Read())
{
ddlModelTypes.DataSource = objRdr;
ddlModelTypes.DataValueField = "TypeId";
ddlModelTypes.DataTextField = "ModelType";
ddlModelTypes.DataBind();
}
I thought the following line was replacing the first value:
ddlModelTypes.Items.Insert(0, "Other");
However, I took this out and it's still not displaying the first record value so any help will be much appreciated.
Thanks
Lorna
|
|
|
|
|
You do not need to call objRdr.Read(). Try the following.
connection.open
ddlModelTypes.DataSource = objRdr;
ddlModelTypes.DataValueField = "TypeId";
ddlModelTypes.DataTextField = "ModelType";
ddlModelTypes.DataBind();
connection.dispose();
I didn't get any requirements for the signature
|
|
|
|
|
Thanks but I'm using the if (objRdr.Read()) to check that records have been returned as sometimes there will be no records - is there another way to check this before using DataBind?
|
|
|
|
|
It doesn't matter if there's no records, the binding won't fail. You can always check post binding (i.e. count the items in the list) if you need to do something in that case. Calling dr.Read moves the reader onto the second record...
|
|
|
|
|
Do Like this
Member 3402886 wrote: ddlModelTypes.DataSource = objRdr;
ddlModelTypes.DataValueField = "TypeId";
ddlModelTypes.DataTextField = "ModelType";
ddlModelTypes.DataBind();
No need to Call
Member 3402886 wrote: if (objRdr.Read())
No need to Call , otherwise everything else looks ok , it should work
|
|
|
|
|
Hello friends,
I am using a FileUpload Control inside Customized CreateUserwizard Control. I am accessing textboxes inside the CreateUserWizard as ((TextBox)BusinessDetWizardStep.FindControl("txtfirmsname")).Text.Trim().
I also put a fileupload inside this wizard. But while catching the file in code using this code
if(((FileUpload)BusinessDetWizardStep.FindControl("fileupload1")).HasFile)
{
}
The Fileupload control does not get any file to upload...Why this is happening? What could be the cause and solution for this?
Thanks...
|
|
|
|
|
Are you using the fileupload within an updatepanel by any chance?
|
|
|
|
|
Thanks for the reply..
I am not using fileupload within UpdatePanel. The FileUpload is contained within WizardStep directly..
|
|
|
|
|
i added image datalist view.and i want to show my images by database.
imageurl=<%#&App_Data\Urunler\Banyo"+DataBinder.Eval(Container.DataItem,"resim") %>
where is wrong in that code?
|
|
|
|
|
You don't have any quotation mark at the beginning of the string.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Serverpath + "\\" + Session.SessionID + "1" + "." + fileext + ";Extended
Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
OleDbCommand com = new OleDbCommand("SELECT * FROM [Sheetname$]", con);
In the query sheetname is worksheet name. my sheet name will change frequently. is ther any way to access sheet name using sheet INDEX
its very urgent ......
Thnaks in advance....
|
|
|
|
|
mithun narayanan wrote: its very urgent
Avoid using "urgent".
This[^] article might help you.
Loading signature. Please wait...
|
|
|
|
|
mithun narayanan wrote: its very urgent ......
Isn't it always - but only to you, nobody else cares.
In the time it took you to post the question you could have tried it for yourself, so why don't you just go into debug and try it?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Is there any way to generate secure or cryptographic random numbers without using any third party code/tool(watever...English is not my first language). If not, then is CryptoAPI recommended?
I am using ASP/IIS 5.0.
[Edit]Somehow I feel that Web Developement is the forum for this kind of question. Is it so?[/Edit]
Loading signature. Please wait...
|
|
|
|
|
Hi. I have a desktop application that I want to load on the internet or just its database. I really have a vague understanding on how web service works other than your application being loaded on the web. My goal is to retrieve data from the internet instead of a direct connection in a wifi connection. I was asked to load the data on the internet before being retrieve by the user. Can someone tell me how I can migrate my desktop application to the web? What I would need? What I have to do? Do I have to recreate my application again if I'm going to place it on the web (It would be a hassle)?
In simple terms, the client (PDA phone) retrieves data from the internet, then sends information to the server (desktop app) but must go through the internet. So basically. Instead of a direct wireless connection from wifi, we are required to add the internet as a bridge of communication between the two.
P.S.
- By the way, it doesn't necessarily have to be used by a certain webhost. Using localhost would be just fine with me, as long as it can connect via wifi. I really really need your help for this. Thanks!
modified on Wednesday, November 19, 2008 7:17 AM
|
|
|
|
|
The easiest way to do this would be to build an ASP.Net page for the client. I'm assuming the PDA Phone can view webpages, so you'll have to have a phone to test your pages in the phones the browser. Both the web client and Desktop client should get the data from web services. This is actually very easy to set up.
You can create one webservice method to do all the work for you. Simply create one service with SQLProcName and SQLParameter array for input and DataTable as result. Should be easy.
The trickiest part of web services is securing them. Personally, I don't bother with certificates, just pass a userName and passWord as parameters in your webservice method. If the wrong info is passed, simply don't execute any code.
Good luck.
I didn't get any requirements for the signature
|
|
|
|
|
I see. I'm sorry but I'm very new to ASP.NET, and I can't seem to understand what you meant by a service with SQLProcName and SQLParameter. I have scanned a few tutorials and few ebooks but nothing seems to lighten me up. And also, I tried to create a webservice, added a windows form, and I tried to test run it but I get an error message like this:
"Windows start service failure:
----------------------------
Cannot start service from the command line or debugger.A windows service must first be installed
(using installutil.exe) and then started with the server explorer, Windows services Administrative
tool or the NET START command. "
--------------------------------
|
|
|
|
|
i want to display my images in datalist.
i save my images path in access database(like this Product\hotel\product1.gif)
my images are in a speial folder which under the App_Data.
how can i connect datalist-images directory-image? i connected to database with accessdatasource1.
|
|
|
|
|
U need to use an Image Control in DataList(Edit Template)
and set the Image Control URL in ItemDataBound event of DataList
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
Image I1 = (Image)(e.Item.FindControl("Imagex"));
I1.ImageUrl = dth.Rows[e.Item.ItemIndex]["ImageURL"].ToString();
}
"dth" is the DataTable which I am using as DataSource for DataList
The URL should be "App_Data/product1.gif",to retrieve the image .
As in ur case if URL is stored as eg:Product\hotel\product1.gif
Then you need to convert it to "App_Data/product1.gif",
using string manipulation .
|
|
|
|
|
i Have given image tag inside td in Body but not displaying message. but if i tried for inline attachment with System.Net.Mail.LinkedResource then getting as image embed but while embeding like this mails are getting late to send
follow is the code part i am using
Body = "<div>
Body += "<table cellpadding="0" cellspacing="0" align="center">";
Body += "<tr valign="top">";
Body += "<td align="center">
<div><img src="images/S.JPG" alt="" /></div></td>";
Body += "</tr>";
Body += "</table>";
Body += "";
Body += "";
Body += "</div>";
|
|
|
|
|
I can only see fractions of your code. Use the "Ignore HTML" option when you are posting markup code.
sathimailin1 wrote: i Have given image tag inside td in Body but not displaying message.
Is it the mail message that is not displayed, or the contents of the message that is not displayed? Where is it not displayed?
sathimailin1 wrote: while embeding like this mails are getting late to send
How are you embedding the image? What do you mean by "late to send"?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
<pre>
string Body;
AlternateView htmlIV;
SqlConnection _oSqlconn;
SqlCommand _oSqlCmd;
SqlDataAdapter _oAdapt = new SqlDataAdapter();
DataTable DT;
DT = new DataTable();
string Sqlstr;
_oSqlconn = new SqlConnection(ConfigurationManager.AppSettings["Test"]);
_oSqlconn.Open();
Sqlstr = "select cEmail_id1 from Master_Contacts";
_oSqlCmd = new SqlCommand(Sqlstr, _oSqlconn);
_oSqlCmd.CommandType = CommandType.Text;
_oAdapt.SelectCommand = _oSqlCmd;
_oAdapt.Fill(DT);
_oSqlconn.Close();
Body = "<table cellpadding='0' cellspacing='0' bgcolor='#c1c1c1' align='center' width='100%' border='0'>";
Body += "<td align='center'>";
Body += "<table cellpadding='0' cellspacing='0' align='center' width='600' height='703' border='0'>";
Body += "<tr>";
Body += "<td align='center'><img alt='' hspace=0 src='cid:imageId' align=middle border=0 ></td>";
Body += "</tr>";
Body += "</table>";
Body += "</td>";
Body += "</tr>";
Body += "</table>";
htmlIV = System.Net.Mail.AlternateView.CreateAlternateViewFromString(Body, null, "text/html");
System.Net.Mail.LinkedResource imagelink = new System.Net.Mail.LinkedResource(Server.MapPath(".") + "\\images\\S.jpg", "image/jpeg");
imagelink.ContentId = "imageId";
imagelink.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
htmlIV.LinkedResources.Add(imagelink);
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage("xyc2@yahoo.com", Convert.ToString(DT.Rows[i]["cEmail_id1"]), ConfigurationManager.AppSettings["Subj"], Body);
mail.AlternateViews.Add(htmlIV);
System.Net.NetworkCredential mailAuthentication = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["MailID"], ConfigurationManager.AppSettings["Pass"]);
System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("smtp.gmail.com", 25);
mailClient.EnableSsl = true;
mailClient.UseDefaultCredentials = false;
mailClient.Credentials = mailAuthentication;
mailClient.Send(mail);
</pre>
Above is the way i used to send a mail with embed image and this becomes slow to send mail i.e to send 5 mails for example it takes 3 minutes.
II
i tried to write an image inside td of Body message src=mypath instead of
src='cid:imageId' but result is i am getting mails deliverd but if i open a mail then mail not displayed any images
|
|
|
|
|
specify full path of your image like
http://yoursite.com/images/S.JPG....
|
|
|
|
|
Hi
Thanks image got displayed when i give path as you mentioned but in gmail when opening mail gmail is showing diplay images below i dont want to get message rather it should display image when user open a mail, can u tell me why i am getting error
|
|
|
|
|
No chance at all!!!. It's gmail's property. we can't change it...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
