|
Elsewhere.
Do While dr.Read()
lblfacility.Text = dr.GetString(1)
Loop
You keep overwriting the same value, so it will always be left holding the last. What did you intend to get?
And I have no idea why you have the outer loop:
Do While dr.HasRows
|
|
|
|
|
Even with this:
Do While dr.Read()
lblfacility.Text = dr.GetString(1)
Loop
dr.NextResult()
I am still getting the last value.
As stated in my original post, each category has atleast two sub category values.
In one instance, one categoryId has five (5) values.
I am hoping that the loop will list all five values or however many values from subcategory that are associated with a chosen category.
|
|
|
|
|
Maybe you want to concatenate those values together and then display the result? (If so, use a StringBuilder.)
|
|
|
|
|
Do While dr.Read()
lblfacility.Text = lblfacility.Text & " " & dr.GetString(1)
Loop
|
|
|
|
|
Hello,
I am developing a Web application using asp.net where am adding multiple window popup . Using button group, but problem is that once I write code for second link then the code for first link doesn't work.
|
|
|
|
|
We can not help you without the relevant code...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
For window based authentication
<add name="dbserver" connectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=databasename;Integrated Security =true;" />
For username and password authentication
<add name="connectionstringname" connectionString="data source=SERVERNAME;initial catalog=databasename;user id=username;password=123"/>
|
|
|
|
|
Thanks guys I got the problem and it's solved .I'll post solution soon.
|
|
|
|
|
I have the following regular expression. I need to add to allow
[] and '' ?
ValidationExpression="^[a-zA-Z0-9+'.#$&'%,“:;=/\(\),\-\s]{1,8000}$"
|
|
|
|
|
Special characters can be used with escape char before...like \[ or \'...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
How to make Connection string in visual studio 2012 ?
|
|
|
|
|
|
here is a good reference site for writing connections strings
http://www.connectionstrings.com[^]
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
in web. confg file..
you just write in <configuration> element before closing tag
write this
<connectionstring>
<add name="mycon" connectionstring="Data Source=<Your server name>; Initial Catalog=<Your Data Base Name>; User ID=sa; Password=<Your RDBMS Password>" providername="System.Data.SqlClient">
|
|
|
|
|
For window based authentication
<add name="dbserver" connectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=databasename;Integrated Security =true;" />
For username and password authentication
<add name="connectionstringname" connectionString="data source=SERVERNAME;initial catalog=databasename;user id=username;password=123"/>
write above code in connection string tag in web config like
<connectionStrings>
<add name="dbserver" connectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=databasename;Integrated Security =true;" />
</connectionStrings>
-- modified 28-Jan-15 7:22am.
|
|
|
|
|
i got an asp.net codes for a website whenever i tried to run the codes on my visual studio 2012 it keeps showing me the following error on the browser
Server Error in '/LovelyWebsiteLearn' Application.
This operation requires IIS integrated pipeline mode.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.PlatformNotSupportedException: This operation requires IIS integrated pipeline mode.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[PlatformNotSupportedException: This operation requires IIS integrated pipeline mode.]
System.Web.HttpResponse.get_Headers() +9681914
System.Web.HttpResponseWrapper.get_Headers() +9
Microsoft.Owin.Host.SystemWeb.OwinCallContext.CreateEnvironment() +309
Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContext.GetInitialEnvironment(HttpApplication application) +246
Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContext.PrepareInitialContext(HttpApplication application) +15
Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContextStage.BeginEvent(Object sender, EventArgs e, AsyncCallback cb, Object extradata) +288
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +285
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929
how can u help me pls?
|
|
|
|
|
|
i want to retrieve date from SQL database using c# [Stored Procedure] and show all the value of Database in a grid.i don't know how to call this procedure in view. this is my Controller code :-
namespace sp_insert.Controllers
{
public class EmployeDetailController : Controller
{
//
// GET: /EmployeDetail/
public ActionResult Index()
{
Employee Employee = new Employee();
return View("DisplayEmployee",Employee);
}
public ActionResult DisplayEmployee(Employee Employee)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString.ToString());
con.Open();
SqlCommand cmd = new SqlCommand("spEmpSelect",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteReader();
return View("DisplayEmployee",Employee);
}
}
}
|
|
|
|
|
I would suggest you to Google and learn MVC and Ado.Net first because the code simply reveals that the way you are trying to do is fundamentally wrong.
So, even if we answer your question, it won't help you.
|
|
|
|
|
actully i am very much clear about mvc and ado.net...but how practically implemented that i am not able to understand that's why i am asking you....
|
|
|
|
|
please any 1 provide me an Example of:"Insert , Display ,Update ,and Delete on Database in asp.net with MVC using Stored Procedure Example".i want to learn how actually application is working with database.
|
|
|
|
|
|
i want to retrieve date from SQL database using c# and show the value as a text property of a label. this is my code  
string calidd = "select calid from calib where Tulname Like @myse";
cmd2 = new SqlCommand(calidd, con);
cmd2.Parameters.AddWithValue("@myse", se);
DateTime dt;
dar2 = cmd2.ExecuteReader();
while (dar2.Read())
{
dt = Convert.ToDateTime((dar[0].ToString()));
xxcd = dt.ToString("dd/MM/yyyy");
}
calibdlab.Text = xxcd;
There is No problem anywhere!.. you only lack Insight on How to provide the Solution.... Knowledge is Power..
|
|
|
|
|
|
I need to add a grid to a web page and implement auto scrolling for the grid. The grid should display a maximum of 15 rows and auto scroll showing each loaded row (0 - 100) at a configurable speed. The number of rows loaded to the grid will vary each time data is pulled from a database. Does anyone know how to automate scrolling for a grid using ASP.Net with VB.Net. Any advice would be greatly appreciated.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
