How to develop Message Board Application in ASP.net - ASP.NET Discussion Boards

Poblem regarding port the .dbf files into Sqlserver

Aavesh Agarwal9-Dec-07 18:38

9-Dec-07 18:38

Hi all,

I want to port the .dbf files into Sqlserver.
The requirement are as such that

The user should be able to specify the name of Database and login Credential prior to porting the files into the Database.

we are using Visual Studio 2005 as developoemnt platform.
Please suggest us the possible way for that i can achieve my target.

Thanks and Regards
Avesh Agarwal

Find String in string

AnhTin9-Dec-07 17:24

AnhTin

9-Dec-07 17:24

hi all
I have
string strDemo = "abc";
string strDemo1 = "abc def ghjk abcde";

I want check if strDemo1 have character is same strdemo return true else false.
Same query Like N'%%' in sqlserver

how can i do ??

Re: Find String in string

Christian Graus9-Dec-07 18:49

Christian Graus

9-Dec-07 18:49

The Contains method on the string class

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Find String in string

Michael Sync9-Dec-07 18:57

Michael Sync

9-Dec-07 18:57

- Get the length of strDemo
- Cut the string according to the lenght of strDemo from strDemo1
- compare strDemo and strDemo1 (which has been cut)

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Find String in string

Michael Sync9-Dec-07 18:58

Michael Sync

9-Dec-07 18:58

Oh. I didn't see the Christian's reply.
ya. Christian's method might be better for you.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Sitemap Path

Member 46484919-Dec-07 17:00

Member 4648491

9-Dec-07 17:00

How can we use 2 sitemaps in an aspx page?

Re: Sitemap Path

Sam Xavier10-Dec-07 18:37

Sam Xavier

10-Dec-07 18:37

Hello,

Definitely, you may have multiple site map paths for a single website or a page. To configure multiple site maps for a single site, start with a site map in the root of your application. Next, configure the root provider as the default site-map provider in your Web.config file. Then, link to child site maps or providers by referencing them in a SiteMapNode object. Here is a good link which I have used to create one:

http://msdn2.microsoft.com/en-us/library/ms178426.aspx

Do let me know if this works for you or not.

Best Regards,
Sam Xavier
www.componentone.com

How to develop Message Board Application in ASP.net

Rajesh_K_Sharma9-Dec-07 16:59

Rajesh_K_Sharma

9-Dec-07 16:59

Hi,
I want to create an application “Message Board “like code project. When any user can ask question and can view the answer like given in Code project. Please give me idea to develop such type of allocation or send me link.

Regards
Rajesh

rajesh

Re: How to develop Message Board Application in ASP.net

Christian Graus9-Dec-07 17:10

Christian Graus

9-Dec-07 17:10

Buy a book on ASP.NET and work through it. Buy a book on SQL and databases, and work through it. If you want the sort of features CP has, buy a book on javascript and DHTML and work through it.

Vb.net AND C#

AnhTin9-Dec-07 16:09

AnhTin

9-Dec-07 16:09

hi all
I have some code is VB.net but i dont understant it
Dim strdemo as String
strdemo = "demo"

Dim strdemo1 as String
strdemo = "demo1"

If Ucase(strdemo ) Like "*" & Ucase(strdemo1 ) & "*" Then

END IF

If i convert this code to C#. How can i do that??.

Re: Vb.net AND C#

leckey9-Dec-07 16:13

leckey

9-Dec-07 16:13

This needs to be in the VB forum.

Current Rant: "Mormon Mania"
http://craptasticnation.blogspot.com/[^]

Re: Vb.net AND C#

Christian Graus9-Dec-07 16:19

Christian Graus

9-Dec-07 16:19

Basically, the person who wrote this has no idea how to use .NET. Methods like Ucase should never be used.

I think this belongs in the C# forum, it sure doesn't belong here. It has nothing to do with ASP.NET

set login user control to my site from a data base

Knowledgestudent9-Dec-07 15:46

Knowledgestudent

9-Dec-07 15:46

hi there,
I have specified users to my web site designed using ASP.net over VB
But actually number of users needed to be larger than they are be added via normal ASP.net configuration, and I need to take them from my database
example : I have a table containing all employees I want them to access my site authenticated and authorized
How can I make them login with there usernames and passwords saved in that table

note : the database used is SQL

I hope that I explained it right

urgent help is needed Smile | :)

There is always something to learn

Re: set login user control to my site from a data base

Christian Graus9-Dec-07 16:16

Christian Graus

9-Dec-07 16:16

Surely the built in control can do that ? If not, you need to write your own solution.

Re: set login user control to my site from a data base

Knowledgestudent9-Dec-07 16:46

Knowledgestudent

9-Dec-07 16:46

thanks a lot
I am trying it now

There is always something to learn

How to save filename in korea language while exporting gridview to ecxel.

Rajesh_K_Sharma9-Dec-07 13:56

Rajesh_K_Sharma

9-Dec-07 13:56

Hi,
When I export grid view to excel in asp.net 2.0. It successfully exported but I did localization.
I want to save exported excel file name save in Korean language. When I put file name in Korean language like
protected void ExportGridView(Control grdView, string strFileName)
{

string attachment = "attachment; filename="??".xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

grdView.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

The out put comes like “ë¦¬í´.xls” but I want to save like “??.Xls”
How can I do this to save file name as korean language .

Regards
Rajesh

rajesh

GridView on MultiView / View with MenuItems to change Views - the problem

Member 47002259-Dec-07 12:28

Member 4700225

9-Dec-07 12:28

Thanks to Abisodun and Mike for answering my previous post. Both of the answers was directed to the 2nd part of my question. On the first part, I still need help. So - here's it again:

I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features.

The problem is: when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView).

Any ideas?

Thanks.

Ekjon

Re: GridView on MultiView / View with MenuItems to change Views - the problem

Michael Sync9-Dec-07 15:15

Michael Sync

9-Dec-07 15:15

As I said in previous post, you might miss to bind the dataset in your pageload after postback...

Can you show us what you wrote in PageLoad and Edit event?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: GridView on MultiView / View with MenuItems to change Views - the problem

Member 47002259-Dec-07 18:33

Member 4700225

9-Dec-07 18:33

Hi Michael,

Here's what I'm doing: for the common part of the page, I am using dataset to populate some textbox controls, then for the details part - I'm using GridViews with a SqlDataSources. Each of the GridViews are placed on a View control being changed by MenuItem clicks. Here are some code:
protected void Page_Init(object sender, EventArgs e)
{
projectId = Convert.ToInt32(Session["ClickedId"]);
string [] dataKeys = {"MethodSID"};
conn = new SqlConnection();
// Get the ConnectionString dynamically
conn.ConnectionString = ConfigurationManager.ConnectionStrings["EEM-NEWConnectionString1"].ConnectionString;
dsrcMethods.ConnectionString = conn.ConnectionString;
Parameter param;
dsrcMethods.UpdateCommand = "update tblMethod set MethodName=@MethodName, MethodDesc=@MethodDesc,"
+ "TaxonomicalKeys=@TaxonomicalKeys, TaxonomicalDesc=@TaxonomicalDesc"
+ " where MethodSID=@MethodSID and ProjectID=" + projectId;
dsrcMethods.InsertCommand = "insert into tblMethod (ProjectID, MethodName, MethodDesc, TaxonomicalKeys,"
+ " TaxonomicalDesc) values (" + projectId + ",@MethodName,@MethodDesc,"
+ " @TaxonomicalKeys,@TaxonomicalDesc)";
param = new Parameter("MethodSID", TypeCode.Int32);
dsrcMethods.UpdateParameters.Add(param);
param = new Parameter("MethodName", TypeCode.String);
dsrcMethods.UpdateParameters.Add(param);
dsrcMethods.InsertParameters.Add(param);
param = new Parameter("MethodDesc", TypeCode.String);
dsrcMethods.UpdateParameters.Add(param);
dsrcMethods.InsertParameters.Add(param);
param = new Parameter("TaxonomicalKeys", TypeCode.String);
dsrcMethods.UpdateParameters.Add(param);
dsrcMethods.InsertParameters.Add(param);
param = new Parameter("TaxonomicalDesc", TypeCode.String);
dsrcMethods.UpdateParameters.Add(param);
dsrcMethods.InsertParameters.Add(param);
gvMethods.DataKeyNames = dataKeys;
gvMethods.DataSourceID = dsrcMethods.ID;
}
protected void Page_Load(object sender, EventArgs e)
{
txtID.Focus();
txtID.Enabled = false;
txtTitle.Enabled = false;
txtAbstract.Enabled = false;
txtJust.Enabled = false;
txtSponsor.Enabled = false;
txtStartDate.Enabled = false;
txtStatus.Enabled = false;
txtEndDate.Enabled = false;
txtProgress.Enabled = false;
txtAck.Enabled = false;
if (!Page.IsPostBack)
{
conn.Open();
try
{
txtID.Text = projectId.ToString();
// Create SqlCommand and Parameter to select ProjectID
cmd = new SqlCommand("Select * from tblProject where ProjectSID=@ProjectID", conn);
cmd.Parameters.Add("@ProjectID", SqlDbType.Int);
cmd.Parameters["@ProjectID"].Value = projectId;

dsProject = new DataSet();
da = new SqlDataAdapter(cmd);
da.Fill(dsProject);
cmd.ExecuteReader();
// If there are no records for the user
if (dsProject.Tables[0].Rows.Count == 0)
{
lbl = new Label();
lbl.Text = "<p>You do not have any data for this Project</p>";
Controls.Add(lbl);
}
else
{
txtTitle.Text = dsProject.Tables[0].Rows[0].ItemArray[1].ToString();
txtAbstract.Text = dsProject.Tables[0].Rows[0].ItemArray[2].ToString();
txtJust.Text = dsProject.Tables[0].Rows[0].ItemArray[3].ToString();
txtSponsor.Text = dsProject.Tables[0].Rows[0].ItemArray[4].ToString();
txtStartDate.Text = dsProject.Tables[0].Rows[0].ItemArray[5].ToString();
txtStatus.Text = dsProject.Tables[0].Rows[0].ItemArray[6].ToString();
if (dsProject.Tables[0].Rows[0].ItemArray[7].ToString() == null ||
dsProject.Tables[0].Rows[0].ItemArray[7].ToString() == "")
txtEndDate.Text = "Not Applicable";
else
txtEndDate.Text = dsProject.Tables[0].Rows[0].ItemArray[7].ToString();
txtProgress.Text = dsProject.Tables[0].Rows[0].ItemArray[8].ToString();
txtAck.Text = dsProject.Tables[0].Rows[0].ItemArray[9].ToString();
}
// Cleanup command and connection objects.
dsProject.Dispose();
da.Dispose();
cmd.Dispose();
conn.Close();
}
catch (Exception ex)
{
// Add error handling here for debugging.
Response.Write(ex.Message);
//System.Diagnostics.Trace.WriteLine("[ValidateUser] Exception " + ex.Message);
}
}
}
protected void mnuProjectDetails_MenuItemClick(Object sender, MenuEventArgs e)
{
gvMethods.Focus();

// Get the MenuItem Clicked
int item = Int32.Parse(e.Item.Value);

if (item == 0)
{
conn.Open();
dsrcMethods.SelectCommand = "select * from tblMethod where ProjectID=" + projectId;
conn.Close();
}
else if (item == 1)
{
conn.Open();
dsrcTools.ConnectionString = conn.ConnectionString;
dsrcTools.SelectCommand = "select * from tblTool t, tblMethod m where m.MethodSID=t.MethodID and"
+ " m.ProjectID=" + projectId;
gvTools.DataSourceID = dsrcTools.ID;
conn.Close();
}
MultiView1.ActiveViewIndex = Int32.Parse(e.Item.Value);
}

Thanks for taking your time and I'm positive that you can find something for me.

Re: GridView on MultiView / View with MenuItems to change Views - the problem

Michael Sync9-Dec-07 19:06

Michael Sync

9-Dec-07 19:06

Try like that..

In Page_load

<br />
if (!Page.IsPostBack){<br />
  //Getting the data from database<br />
  //Bind the data to Gridview<br />
  // Add this datasource to cache or session (e.g. Cache["mydata"]= dsProject.Table[0]; )<br />
}<br />
else{<br />
  //Re-bind the gridview with datasource from cache. (e.g. GridView1.DataSource = (DataTable)Cache["mydata"];)<br />
}<br />

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Navigation??

Muammar©

9-Dec-07 7:54

I know it is embarrassing to ask such a question but how do you navigate in your page?? ie. backward, forward or load a specific url in the same page "I'm using Process.Start("www.url.com");" but I dont want a new page/tab, I want to load it in the same page..

Thank you guys Rose | [Rose]

Smile: A curve that can set a lot of things straight!

(\ /)
(O.o)
(><)

Re: Navigation??

Christian Graus9-Dec-07 9:25

Christian Graus

9-Dec-07 9:25

If you're using Process.Start, it's not going to work when you deploy your site, as it's launching on the server, not the client. Server.Transfer and Response.Redirect are how it's done. The difference is that Server.Transfer doesn't do another round trip and therefore the URL in the users browser does not change.

Re: Navigation??

Paul Conrad9-Dec-07 12:45

Paul Conrad

9-Dec-07 12:45

Use Server.Transfer as Christian has suggested.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Problem in Validation Control

Parameswar Mal9-Dec-07 2:16

Parameswar Mal

9-Dec-07 2:16

Hello Friends,

I am using Asp.net 2.0 with C#.
I have Three textbox ..,txtname,txtAddress,txtphno,and each textbox has Requiredfield Validator.I am inserting Record and show record throuh 2 button ie. Save and ShowRecord button
My problem is when i want show record through Textname textbox putting name(bind through DataReader)
and click on show record then the message comes that other two textbox means txtaddress,txtphon can not blank which i have given in error message.

When i remove validation control then record will be shown in textboxes.

Plz give me some Idea.

parameswar mal

Re: Problem in Validation Control

Michael Sync9-Dec-07 2:49

Michael Sync

9-Dec-07 2:49

1. I think, you can group the validators in ASP.NET 2.0. I haven't tried using it but read somewhere that it does. so, you probably can try..

OR

2. You can use the custom validators with client-side validation

OR

3. Use Javascript-validation or Server-side validation..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Last Visit: 31-Dec-99 18:00 Last Update: 10-May-24 13:53

Refresh

ᐊ Prev 1...3841 3842 3843 384438453846 3847 3848 3849 3850 Next ᐅ

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