|
thank you for your reply, and if I want to show the result of choice in the dropdownlist in a html table creates at run time of this application
here is the code of creating a htmltable to display data from DB SQL by selecting a dropdownlist:
string chaineCnx = ConfigurationManager.ConnectionStrings["ConnectionString_operateur"].ToString();
HtmlTable tbTableName = new HtmlTable();
HtmlTableRow tbRow = null;
HtmlTableCell tbCelle = null;
tbTableName.ID = "TableName";
tbTableName.Border = 1;
tbTableName.CellSpacing = 1;
using (SqlConnection cnx = new SqlConnection(chaineCnx))
{
cnx.Open();
SqlCommand cmTable = new SqlCommand("select * from operateur, cnx);
SqlDataReader drTable = cmTable.ExecuteReader();
while (drTable.Read())
{
tbRow = new HtmlTableRow();
for (int i = 0; i < drTable.FieldCount; i++)
{
tbCelle = new HtmlTableCell();
tbCelle.Width = "80";
if (drTable[i] != DBNull.Value)
tbCelle.InnerText = drTable[i].ToString();
tbRow.Cells.Add(tbCelle);
}
tbTableName.Rows.Add(tbRow);
}
this.form1.Controls.Add(tbTableName);
}
|
|
|
|
|
Hi All
I Have a problem.I want to search record from database and fill in a grid simultaneously when a user typing in TextBox
means when i type 'A' in TextBox it fill gridview from database like 'Adam', 'Ashmit' ,'Anirudh' ,'Adnan'
bt when he type another letter like 'Ad' then only 'Adam','Adnan' will remain in grid.
this is the result without click over any button
Thanks in Advance
|
|
|
|
|
|
Tell me without use of AJAX i Think it can be possible by adding one more attribute i.e. onTextChange event bt i dont know how i do this.
Guide me if u know the solution
|
|
|
|
|
if you wont use AJAX on every textchanged a postback will happen which at all not good
|
|
|
|
|
Use Ajax and in Sql Query use Like stmt 
|
|
|
|
|
Could u tell me how mean in form of Code
|
|
|
|
|
gautamamit8 wrote: Could u tell me how mean in form of Code
Try out! You have been given head start...use Google with key words if needed... people here won't provde you direct code. Put some effort and if you get stuck, all will help.
|
|
|
|
|
Yeah, the way out is to use the ajax AutoCompleteExtender alongside a web method to get the data
|
|
|
|
|
Hey guys,
In my ASP.NET(.aspx) pages am referencing an external css file,
When I run my pages in a website, firefox 'cannot' interpret
anything in my css file but Internet Explorer can...
Does anyone know what i can do to help firefox read my css?
Please help 
Thanks,
Morg
|
|
|
|
|
How are you referencing the css file?
Wout Louwers
|
|
|
|
|
I tried both of this type, both work for IE and none work for firefox,
but when i paste the second line in the firefox address bar, the file can
open and show my css coding but the 1st line will not show in firefox:
1. <link href="C:/Documents and Settings/Morgan/Desktop/Morgan Documents/PlanetFitness/App_Themes/StyleSheet.css" type="text/css" rel="stylesheet" />
2.<link href="file:///C:/Documents and Settings/Morgan/Desktop/Morgan Documents/PlanetFitness/App_Themes/StyleSheet.css" type="text/css" rel="stylesheet" />
Don't worry with my full file path coz thats what Visual studio wants
|
|
|
|
|
I don't know if you are plannimg to use your webpage on a webserver in the future, but I would worry about the full path.Don't mind what Visual studio want, try to fix it.
Wout Louwers
|
|
|
|
|
How can a clever guy like me struggle like this?
You know what? I just changed the whole full path to:
<link href="App_Themes/jtip.css" type="text/css" rel="stylesheet" />
and both firefox and IE can read my css code...
mistakes...
And thanks for being helpful man
|
|
|
|
|
I seem to remember that Firefox has a security feature, on by default, to prevent it from reading local files referenced by the link tag. If you avoid calling something a local file you avoid the roadblock, as you found out.
|
|
|
|
|
Hi All
I have a problem.I am using a datalist on which 2 controls are there. 1st is Label which have date 2nd is buttonshow. when buttonshow is pressing the popup panel will come n all details of that particular date(label) filled in Popup Panel's text Box.I am unable to cougt that label value on the panel.
Thanks in Advance
|
|
|
|
|
Did you get any error or exception ? Can you post some of your code snippet here?
Thanks,
Arindam D Tewary
|
|
|
|
|
aspx page Code-
<td rowspan="11" valign="top" width:"590px">
<asp:DataList ID="DataList1" runat="server" RepeatColumns="2" RepeatDirection="Horizontal"
Width="476px" Height="200px" onitemcommand="DataList1_ItemCommand"
onitemdatabound="DataList1_ItemDataBound" >
<ItemTemplate>
<asp:Panel ID="Panel1" runat="server" Height="110px" Width="230px"
BorderStyle="Solid" BorderWidth="2px">
<table style="height: 100px; font-family: 'Times New Roman'; font-size: small;"
width="230px">
<tr>
<td colspan="3" height="10px" width="100px">
<asp:Label ID="lblBookingDate" runat="server" Font-Size="8pt"
Text='<%# Bind("BokingDate") %>' ToolTip='<%# Bind("BookingDate") %>'></asp:Label></td>
<td style="text-align: right"><asp:ImageButton ID="ibNotes"
runat="server" ImageUrl="~/Images/edit24.gif" Height="15px" CommandName="CommandNotes" />
<cc1:PopupControlExtender ID="ibNotes_PopupControlExtender" runat="server"
DynamicServicePath="" Enabled="True" ExtenderControlID="" PopupControlID="pnlBookingNotes"
TargetControlID="ibNotes">
</cc1:PopupControlExtender>
</td>
</tr>
<tr>
<td rowspan="2" valign="top" width="10px">
<asp:ImageButton ID="ibBreakfast" runat="server" Height="10px"
Width="10px" CommandName="CommandBreakfast"
ImageUrl="~/Images/Delete.jpg" /></td>
<td rowspan="2" valign="top" style="width: 10px">
<asp:ImageButton ID="ibLunch" runat="server" Height="10px" Width="10px" CommandName="Commandlunch"
/></td>
<td rowspan="2" valign="top" height="10px" width="10px">
<asp:ImageButton ID="ibDinner" runat="server" BackColor="White"
CommandName="CommandDinner" Height="10px" Width="10px" />
</td>
<td style="width: 96px; height: 16px;" valign="top">
<span style="font-size: 8pt">Restaurant</span></td>
</tr>
<tr>
<td style="width: 96px; height: 129px" valign="top">
<asp:Panel ID="pnlNotes" runat="server" Height="59px"
Width="130px">
<asp:TextBox ID="tbDiaryNotes" runat="server" BackColor="#FFFF80" Height="62px" TextMode="MultiLine"
Width="130px" Visible="False"></asp:TextBox></asp:Panel>
</td>
</tr>
</table>
</asp:Panel>
</ItemTemplate>
</asp:DataList></td>
<td valign="top" width:"590px" colspan="2">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
</td>
</tr>
There is no error actually that Popup panal not get the Date from Label ID="lblBookingDate"
this is the panel which is on Popup extender
<asp:panel id="pnlBookingNotes" runat="server" width="250px"
="" bordercolor="Black" >
="" <table="" style="width: 250px" bgcolor="#0099FF" <tr>
="" <td="" day="" note<="" td>
="" <asp:label="" ><="" asp:label>
="" <="" <asp:imagebutton="" height="15px" imageurl="~/Images/Cross.jpg" <td>
="" onclick="ibSaveDiaryNotes_Click" tr>
="" colspan="4" <asp:textbox="" textmode="MultiLine" asp:textbox>
="" table>
="" asp:panel><pre="">
i want to show the detail over it
|
|
|
|
|
Hi,
I have trouble to write binary data stored in sql server databse to word
document.when i run the program it write garbage value to document.
how can i do it
plz help
My code is given below
byte[] MyData = new byte[0];
da.Fill(ds, "myinages");
DataRow myRow;
myRow = ds.Tables["myinages"].Rows[0];
MyData = (byte[])myRow["imgField"];
int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);
string fileName=@"C:\Documents and Settings\Anurag_2\Desktop\anurag.doc";
Response.AppendHeader("Content-Type", "application/msword");
Response.AppendHeader("Content-disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(MyData);
Response.Flush();
no knowledge in .net
|
|
|
|
|
Hi,
i'm assuming now that the byte[] you provide is valid.
This is how i implemented "download-from-database" functionality, maybe it works for you, too.
Response.ClearHeaders();
Response.ClearContent();
Response.ContentType = "Application/pdf";
Response.AppendHeader("content-disposition", "attachment; filename=" +
HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
Response.AppendHeader("content-length", fileData.Length.ToString());
Response.OutputStream.Write(fileData, 0, fileData.Length);
Response.End();
|
|
|
|
|
Hi michaelschmitt,
thanks for replying.
I am still getting same error.i have define datatype of image in my table.while opening word file ,i recieve error that word can not start the converter mswrd632.
plz provide me solution.
thanks in advance.
no knowledge in .net
|
|
|
|
|
Hi,
i must admit, i'm a bit confused concerning your problem.
You get binary data from your sql-server, which is actually an image?
You want to write that to a doc file???
You use Response.[SomeWriteMethod] for that?
There is some mixup, i'm sure.
What your code basically does, is , it writes the binary data you retrieved from your sql-server (on server-side) to your responsestream (so someone can download it using the browser).
There is no interaction with any file on your client-harddrive. You cannot directly write to a client file from your server-page.
Maybe i'm just not understanding you correctly. Maybe someone else can help or you can describe a little bit more what youre trying to archive.
|
|
|
|
|
Hi,
I want to convert the total price in my crystal report to word. I have write the following formula:
formula1 : TruncateValueStr
towords(truncate(sum({@TotalStylePrice}),0))
formula2 : num2word
{@TruncateValueStr} + " and " + ToWords ((Round({@TotalStylePrice},2) - Int({@TotalStylePrice})) * 100, 0)
the output of the formula2 is:
forty-four thousand five hundred eight and xx / 100 and eight
The output containing xx/100 for fraction number. what is the solution to avoid xx/100.
I have googleed but there is no perfect solution. Please Help me. Its Very Argent.
Bye
Take Care
|
|
|
|
|
Hi
You can use following code to convert amt into words. Use it in your formula field,
numbervar RmVal:=0;
numbervar Amt:=0;
numbervar pAmt:=0;
stringvar InWords :="Rupees ";
Amt := 25,12,000 ;
if Amt > 10000000 then RmVal := truncate(Amt/10000000);
if Amt = 10000000 then RmVal := 1;
if RmVal = 1 then
InWords := InWords + " " + towords(RmVal,0) + " crore"
else
if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores";
Amt := Amt - Rmval * 10000000;
if Amt > 100000 then RmVal := truncate(Amt/100000);
if Amt = 100000 then RmVal := 1;
if RmVal = 1 then
InWords := InWords + " " + towords(RmVal,0) + " lakhs"
Else
If RmVal > 1 then InWords := InWords + " " + ToWords(RmVal,0)+ "Lakhs";
Amt := Amt - Rmval * 100000;
if Amt > 0 then InWords := InWords + " " + towords(truncate(Amt),0);
pAmt := (Amt - truncate(Amt)) * 100;
if pAmt > 0 then
InWords := InWords + " and " + towords(pAmt,0) + "paisa only"
else
InWords := InWords + " only";
UPPERCASE(InWords)
|
|
|
|
|
Hi. I have a situation where I need to use Page Methods instead of posts backs on an ASCX control. But I cant find a way that doesnt involve putting code in the main aspx page(which I cannot do due to specifics of the project).
I also cannot create a web service. Basically each ascx control needs to be self containing and not call anything else.
P.S. Update panels work for what I need, but are SLOW SLOW SLOW.
Thanks
Strive to be humble enough to take advice, and confident enough to do something about it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
