ASP.NET Discussion Boards

how to refresh access 2003 database

sathyan_829417-Jul-08 23:47

17-Jul-08 23:47

i am using .net 2005.i do my project in asp.net.
how to refresh access 2003 database when insert new record and delete a record during runtime.
my problem is when i insert new record then concurrently not saved in database but if i close and open the database means new inserted data is there.
so i want to store datas when database is concurrently opened.

Re: how to refresh access 2003 database

Ashfield18-Jul-08 1:23

Ashfield

18-Jul-08 1:23

sathyan_8294 wrote:
when i insert new record then concurrently not saved in database

I think you will find the record is in the database. You will not see it on the screen until you refresh your data.

Bob
Ashfield Consultants Ltd

Validation control

Tauseef A17-Jul-08 23:45

Tauseef A

17-Jul-08 23:45

hi guys

i have four text boxes and four custom validation controls ,
upon failure of a validation i am showing the erros on a summary validator control, but each of my
custom validator also shows the error message , why ?
i want just summary validator control to show the message , how to do that ?
thanks in advance

hello

Re: Validation control

windhopper17-Jul-08 23:50

windhopper

17-Jul-08 23:50

In the design view of your page you can adjust the validation controls to show nothing or just leave the error message section blank.

"Sex is not the answer, it's the question and the answer is yes"

Re: Validation control

J4amieC18-Jul-08 0:39

J4amieC

18-Jul-08 0:39

Display="None" on the Validation Control

WebService : Request failed with HTTP status 401: Unauthorized

AS@1317-Jul-08 23:39

AS@13

17-Jul-08 23:39

Hell EveryBody,

I have a webservice in a server.And in another server I have a webApplication. When i use the webmethod of the webservice in my webApplication I got the following error.

I had already used this code, but no result.

webservLeave.PreAuthenticate = false;
webservLeave.Credentials = System.Net.CredentialCache.DefaultCredentials;
or
webservLeave.Credentials = System.Net.CredentialCache.DefaultCredentials;

The request failed with HTTP status 401: Unauthorized

plz help me out.

A key to every Solution

report generation

n.sa.vivek17-Jul-08 23:16

n.sa.vivek

17-Jul-08 23:16

Is it possible to generate reports in asp.net

Re: report generation

N a v a n e e t h17-Jul-08 23:36

N a v a n e e t h

17-Jul-08 23:36

n.sa.vivek wrote:
Is it possible to generate reports in asp.net

Yes

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: report generation

Sherin Iranimose17-Jul-08 23:59

Sherin Iranimose

17-Jul-08 23:59

Perfect answer. You got my 5.

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

How to post a question

Re: report generation

eyeseetee17-Jul-08 23:39

eyeseetee

17-Jul-08 23:39

http://msdn.microsoft.com/en-us/library/aa479018.aspx

Re: report generation

n.sa.vivek21-Jul-08 2:25

n.sa.vivek

21-Jul-08 2:25

hi,thank you

Re: report generation

metallica_rock1018-Jul-08 0:10

metallica_rock10

18-Jul-08 0:10

Yes u can better way is to use Crystal reports.

http://aspdotnetnstuff.blogspot.com

Instead of grid and directory files any other solution for console application?

Member 387988117-Jul-08 23:08

Member 3879881

17-Jul-08 23:08

Hi guys, actually in my aspx page, i created runtime excel files using dynamic grid control...,

The code looks like this......,

System.Web.UI.WebControls.DataGrid grid = new System.Web.UI.WebControls.DataGrid();
grid.DataSource = DS.Tables[i];
grid.DataBind();
foreach (DataRow dr1 in DS.Tables[i].Rows)
{
foreach (DataRow dr2 in DS.Tables[i+1].Rows)
{
if (dr1["MID"].ToString() == dr2["MID"].ToString())
{
if (!Directory.Exists(_path + "\\" + dr1["MID"].ToString() + @"\"))
{
Directory.CreateDirectory(_path + "\\" + dr1["MID"].ToString() + @"\");
string _XLSPATH = _path + "\\" + dr1["MID"].ToString() + "\\" + DS.Tables[i].TableName + ".xls";
using (StreamWriter sw = new StreamWriter(_XLSPATH))
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
grid.RenderControl(hw);
}
}
}
for this i have implemented, using web.ui,htmlcontrols and webcontrols...,

Now same functions i am trying to do in console application........,

Here UI interface i wont get...,

So how i can create grid and directory files for console application?

To solve this probs Any other way is there?

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Instead of grid and directory files any other solution for console application?

Sherin Iranimose17-Jul-08 23:57

Sherin Iranimose

17-Jul-08 23:57

http://nishantpant.wordpress.com/2006/11/02/exporting-data-to-excel-from-a-windows-forms-net-application/[^]

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

How to post a question

how to insert image at page 1 and retrive at page 3 using database

gaurav mangal17-Jul-08 22:04

gaurav mangal

17-Jul-08 22:04

actually i want to insert two pictues at page 1 .using two seperate file upload control.images should be inserted at one click when i click submit button .and save the path at database and at page3 want to retrive the images by using the path of the images which comes from the data base .
i want only save path at database .

if anybody knows plz send me the code

thanks .....gaurav

Re: how to insert image at page 1 and retrive at page 3 using database

sumit703417-Jul-08 23:09

sumit7034

17-Jul-08 23:09

try this code........

Dim filename As String = //name of ur file

If filename <> "" Then

Dim path As String = //path of file from database

Dim file As FileInfo = New System.IO.FileInfo(Path)

If (File.Exists) Then

Response.Clear()

Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name)

Response.AddHeader("Content-Length", file.Length.ToString())

Response.ContentType = "application/octet-stream"

Response.WriteFile(file.FullName)

Response.End()

End If

End If

Retrieve Datagrid Control value

Agweet17-Jul-08 21:39

Agweet

17-Jul-08 21:39

Hi all...can anyone help me...im trying to retrieve a controls value from a datagrid in asp.net...can anyone assist me with this issue?

living life on the flip side

Re: Retrieve Datagrid Control value

Herman<T>.Instance17-Jul-08 23:08

Herman<T>.Instance

17-Jul-08 23:08

In which event you need to know this?

In RowDataBound?

In that case you have e.Row has help

foreach (DataCell cell in e.Row.Cells)
{
   foreach (Control ctrl in cell.Controls)
   {
   }
}

In the second control you can check each control used in a cell of the gridview row

Is it after pressing Update or Delete in the gridview? You need something likt this

protected void Grid_OnCommand(Object sender, EventArgs e)
{
    Button btn = (Button)sender; // to know which button was clicked
    (GridViewRow) row = (GridViewRow)btn.NamingContainer; //to get the complete datarow found via it's container
// followed bij
foreach (DataCell cell in row.Cells)
{
   foreach (Control ctrl in cell.Controls)
   {
   }
}
  
}

Good Luck

Re: Retrieve Datagrid Control value

Agweet17-Jul-08 23:20

Agweet

17-Jul-08 23:20

Hi Digimanus...im actually looking to do this in html...if there is a way?

living life on the flip side

Re: Retrieve Datagrid Control value

Herman<T>.Instance18-Jul-08 0:03

Herman<T>.Instance

18-Jul-08 0:03

in html?

I do not understand this.

Re: Retrieve Datagrid Control value

Agweet18-Jul-08 0:10

Agweet

18-Jul-08 0:10

im trying to get a click event in html to call a javascript function that accesses the value of the control inthe datagrid...

living life on the flip side

Problem with Asp.net2.0 Menu Control's javascript.

amit.jha17-Jul-08 20:46

amit.jha

17-Jul-08 20:46

When we r accessing our website after single NATing in the network,the Asp.net2.0 menu control is working fine but when we do double NATing the menu control is not working at all(like it's arrow icon is not coming and no hover effect is there)....in my view it happens only when Webresource.axd file is not accessible/present from the IIS.

Regex for URL

Brij17-Jul-08 20:39

Brij

17-Jul-08 20:39

Hi
Can anyone please tell me the regex for URL in javascript.Actully from Googling the regex i got,doesn't solve my problem,because
if i write
http://www.google.com
or
http://www.google

both is passed

i want if user enters www the it should check at least two'.' else one will be enough.

Thanks in advance

Re: Regex for URL

Imran Khan Pathan17-Jul-08 20:51

Imran Khan Pathan

17-Jul-08 20:51

Brij wrote:
i want if user enters www the it should check at least two'.' else one will be enough.

try this
/(ftp|http|https):\/\/(\w+:{0,1}\w*@)?(\S+)(:[0-9]+)?(\/|\/([\w#!:.?+=&%@!\-\/]))?/

or Regular Express String

http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?

please don't forget to vote on the post that helped you.

Re: Regex for URL

Brij17-Jul-08 21:06

Brij

17-Jul-08 21:06

Hi
It doesn't solve my solve.it pass "http://www.home".My issue is,can we make "www" as optional,means

http://www.google.com and http://google.com shold pass

but

http://www.google or http://www.gooogle. should not.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.