ASP.NET

Re: ASP.NET and BlackBerry

14-Mar-07 23:09

Try this :

http://www.c-sharpcorner.com/UploadFile/ggaganesh/DvelopingMobileWebApplicationwith.NET11182005013704AM/DvelopingMobileWebApplicationwith.NET.aspx

http://www.wirelessdevnet.com/channels/wap/features/mobilesdk.html

Hope this helps u...

Vsree15-Mar-07 1:53

Vsree

15-Mar-07 1:53

Thanks friend

Now am comfortable with designing pages in Mobile Web Application.
The two links are quite useful.

If anyone can help me with more samples,it would be of great help.
Thanks
~VSree

hai can help out

sooreeagt14-Mar-07 21:54

sooreeagt

14-Mar-07 21:54

i need code for upload an xl file which has size 100mb. so how can i approach. using file laoder it si not possible as it is too big. so by FTP it possible i think ...but i don't know the code to use in c#
so plzzzzzzzzz any one can gve me response as early as possible

Suresh.R

Re: hai can help out

N a v a n e e t h14-Mar-07 22:30

Please help me with myn dropdowmlist

14-Mar-07 22:30

Try this

http://www.w3hearts.com/showsnippet.aspx?show=10[^]

string Cheers = "Navaneeth!!"

www.w3hearts.com

Oga M14-Mar-07 21:36

Oga M

14-Mar-07 21:36

Hello

am a beginner in programming asp.net(vb)I really don't understand what might be the problem connected my application to the database,inside the values in the tables to test my applicatuion,bind it,when I try to run it the value in the dropdowmlist doesn't appear....

Please help me

Thank you in Advance

oga m

Re: Please help me with myn dropdowmlist

N a v a n e e t h14-Mar-07 22:29

Re: Please help me with myn dropdowmlist

14-Mar-07 22:29

Show me how u binded dropdown ?

string Cheers = "Navaneeth!!"

www.w3hearts.com

siddisagar15-Mar-07 2:05

siddisagar

15-Mar-07 2:05

Hi Change your Datasource name and Database then it will work

page_load()
----------
If Not Page.IsPostBack Then
bindDrop()
End If

Sub bindDrop()

Try
conObj = New SqlConnection("Data Source=B4B-2F-323-CK26;user id=sa;password=sa;Database=TEST")
conObj.Open()
adpObj = New SqlDataAdapter("SELECT * FROM Login", conObj)
adpObj.Fill(dsObj, "Login")
ddl.DataSource = dsObj.Tables("Login").DefaultView
ddl.DataTextField = "UserName"
ddl.DataValueField = "ContactNo"
ddl.DataBind()

Catch ex As Exception
Console.WriteLine(ex.ToString())
Finally
conObj.Close()
adpObj.Dispose()
End Try
End Sub

if you find any problems then mail me bye
Laugh | :laugh:

How to Write this Query

varshavmane14-Mar-07 21:29

14-Mar-07 21:29

Hi All,

I need to write a query where I have to search Date form DB.
Suppose I have a column name as InvoiceDate and I have to search all the records whose InvoiceDate is Like 02/14 or 02 or 02/14/2007.These are the different searches which I need to do.

Please help me...

Thanks in advance...

N a v a n e e t h14-Mar-07 21:36

14-Mar-07 21:36

How you are storing date values in database ? Varchar or datatime ?

If varchar then

select * from table where InvoiceDate like '02/14'
select * from table where InvoiceDate like '02'
select * from table where InvoiceDate like '02/14/2007'

if datetime use day,month and year functions to search like this

string Cheers = "Navaneeth!!"

www.w3hearts.com

varshavmane14-Mar-07 22:00

14-Mar-07 22:00

Thanks for the reply.I storing it as datetime.Can u please explain me in detail or help me in writting the code.

Thanks ...

N a v a n e e t h14-Mar-07 22:25

14-Mar-07 22:25

It could be something like

--For checking day
select * from table where day( convert(datetime,yourdatetimecolumn) ) = yourday

--For checking day and month
select * from table where month( convert(datetime,yourdatetimecolumn) ) = yourmonth and day( convert(datetime,yourdatetimecolumn) ) = yourday 

select * from table where convert(datetime,yourdatetimecolumn)  = yourdate

I am not sure that this is the best way. But I think it can work according to u r requirement.

string Cheers = "Navaneeth!!"

www.w3hearts.com

varshavmane14-Mar-07 22:37

14-Mar-07 22:37

The input can be anything I mean if user put 2/ then how will I use this...

N a v a n e e t h15-Mar-07 0:55

CrystalReport Design Problem

15-Mar-07 0:55

varshavmane wrote:
The input can be anything I mean if user put 2/ then how will I use this...

You should ensure that the input is valid. If not valid like 2/ change it to the format which we can do checking

string Cheers = "Navaneeth!!"

www.w3hearts.com

siddisagar14-Mar-07 21:21

siddisagar

14-Mar-07 21:21

if i want to design a Report then which one we will choose.
aspx page or CrystalReport(.rpt) if CrystalReport then how will do that?

Suppose, if I enter a Empno and Date in TextBoxes then Report should display task details for that day for the given Empno?

pls tell me ,Can we add any labels and TextBoxes in CrystalReport(.rpt)

Thanks to all Repliers
Laugh | :laugh:

Re: CrystalReport Design Problem

N a v a n e e t h14-Mar-07 21:32

to put data from dropdownlist to list

14-Mar-07 21:32

siddisagar wrote:
f i want to design a Report then which one we will choose.
aspx page or CrystalReport(.rpt) if CrystalReport then how will do that?

It depends on your requirement. If you want only showing the output to user then better go for aspx page. Or if u wan to convert the output to PDF then crystal reports will be good solution.

siddisagar wrote:
Can we add any labels and TextBoxes in CrystalReport(.rpt)

Labels you can. Textboxes I am not sure

string Cheers = "Navaneeth!!"

www.w3hearts.com

manugrg14-Mar-07 21:04

manugrg

14-Mar-07 21:04

I need to populate a listbox named "subcategory" once the user clicks his desired selection in dropdownlist named "category" e.g. c++ has subcategories polymorphism,inheritance etc.

please help me thru code

Re: to put data from dropdownlist to list

N a v a n e e t h14-Mar-07 21:19

Re: to put data from dropdownlist to list

14-Mar-07 21:19

manugrg wrote:
I need to populate a listbox named "subcategory" once the user clicks his desired selection in dropdownlist named "category"

In server side you can do like this

1. Make autopostback to true for category dropdown
2. On selected index changed event of category write the following code

if( category.SelectedItem.Text == "c++" )
{
       subcategory.items.add("polymorphism");
       subcategory.items.add("overloading");
       subcategory.items.add("something");
}

But this method will make a postback each time when you change category. For avoiding postback use javascript

string Cheers = "Navaneeth!!"

www.w3hearts.com

varshavmane14-Mar-07 21:24

Gridview +array + asp.net 2.0 + c#

14-Mar-07 21:24

Try this:
strSql = "SELECT ID , Name FROM sysTable"
objDT = objDB.ExecuteDatatable(strSql)
If objDT.Rows.Count > 0 Then
With cmb
.DataSource = objDT
.DataTextField = objDT.Columns(1).ToString
.DataValueField = objDT.Columns(0).ToString
.DataBind()
If IsDefaultValueNeeded Then
.Items.Insert(0, New ListItem("Select", -1))
End If
End With
End If

On SelectedIndexChanged of combo Fill the listbox
strSql = "Ur Query"
objDT = objDB.ExecuteDatatable(strSql)
If objDT.Rows.Count > 0 Then
'Fill ListBox With Column Display Name
With lstsource
.DataSource = objDT
.DataTextField = objDT.Columns(3).ToString
.DataValueField = objDT.Columns(0).ToString
.DataBind()
End With
Endif

hope this helps u...

ritu432114-Mar-07 20:51

ritu4321

14-Mar-07 20:51

how to connect a string array fileList in the gridview .i am doing it as

DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("title", typeof(String));
DataRow newRow;
foreach (DataRow row in fileList)//???<u>i am not getting how to do this </u> {
newRow = dt.NewRow();
newRow["title"] = Title;

dt.Rows.Add(newRow);
}
GridView1.DataSource =dt.DefaultView ;
GridView1.DataBind();

}
GridView1.AutoGenerateColumns = false;

GridView1.DataBind();

on aspx page
<asp:GridView ID="GridView1" AutoGenerateColumns="true" runat="server" ShowHeader="False" GridLines="None" OnRowCommand="GridView1_OnRowCommand" >
<Columns>

<asp:TemplateField>
<ItemTemplate>

<asp:LinkButton ID="Hyperlinkpolicy" runat="server" Text='<%#Eval("fileList") %>' CommandArgument='<%#Eval("fileList") %>' CommandName="button" />
</ItemTemplate>
</asp:TemplateField>

</Columns>
</asp:GridView>
pls help me out .

thanks in advance

-- modified at 2:24 Thursday 15th March, 2007

thanks in advance .

refresh modal dialoug box

yesu prakash14-Mar-07 20:27

yesu prakash

14-Mar-07 20:27

i have parent.aspx and child.aspx pages,child.aspx ia a modal dialoug box.when i click a link on parent.aspx page child.aspx will open. if i close child.aspx ,parent.aspx will refresh..upto this it working well..
if i again click on the same link the child.aspx page show the old data..the page load is not working.
if i click another unclicked link..the page load work..
so for a link in parent.aspx only one time the page load work in child.aspx

how can i solv it?

thks
yesu

Re: refresh modal dialoug box

N a v a n e e t h14-Mar-07 21:23

how to print report in local mode that is repotr.rdlc

14-Mar-07 21:23

ypki wrote:
if i again click on the same link the child.aspx page show the old data

Browsers cache is making problem. Next time it is showing from browsers cache. To avoid set the browsers cachebality to none in child.aspx

string Cheers = "Navaneeth!!"

www.w3hearts.com

mohd imran abdul aziz14-Mar-07 20:24

mohd imran abdul aziz

14-Mar-07 20:24

Dear all,

i am making web application using asp.net2.0,C#,sql2000

i generated report in local mode that say report.rdlc.

my question is can i print this report. if yes please give some usefull link or example

thanks

regards
imran khan

Re: how to print report in local mode that is repotr.rdlc

N a v a n e e t h14-Mar-07 21:24

14-Mar-07 21:24

Do you want to print the contents in the browser ? Then use document.print() in javascript

string Cheers = "Navaneeth!!"

www.w3hearts.com

Encrypting

samerh14-Mar-07 20:20

samerh

14-Mar-07 20:20

Hi All,
My question is that if any one has a module or function that encrypts and then decrypts specific data of any type. I have a case where i want to save data encrypted in sql 2005 and then show it decrypted for specific users only. I am using asp.net 2.0 and sql 2005
Any help is really appreciated and thanks in advance.

Re: Encrypting

N a v a n e e t h14-Mar-07 21:28