Idatareaders Not Returning Values From Database
May 25, 2010In my codebehind I have this vb:
[Code]....
No Errors are being presented yet nothing is being returned by the reader. Is there an error in my code?
In my codebehind I have this vb:
[Code]....
No Errors are being presented yet nothing is being returned by the reader. Is there an error in my code?
Is there a way of selecting returned values from a call to an sql database in the code behind? For example assume that I used the following to select values from a table called Products;
SELECT Price, Qty, Numbersold FROM Products
How can I now get the returned values e.g. Price in the c# codebehind and display it in a textbox? I know that in the asp markup that I can use EVAL and Bind statements to do this for example I can do Eval("Price") but is there a way of getting any of the selected values (Price, Qty or Numbersold) in the codebehind?
I know that I can use three separate select statements and make three separate calls to return each value and then do something like the following
Price = Convert.ToInt32(myCommand.ExecuteScalar());
I am developing an application with WCF services. The basic functionaloty of a screen is to provide an entry screen to add particular entity. Once save even fired It will save the data to the database and call the bind method to bind into the grid by refreshing the latest data.
When I am running the site from my source (Visual Studio) , it works perfectly. When the client calls method to fetch the data the WCF service, it returns latest (added) data. But the issue comes in the server when it works with IIS. I deployed the code in the server, once the data added I am getting the old data only. But after two refresh I am getting the latest data.
what required to be done to get the latest record.
I have jquery using ajax/json to grab an elements ID and then hits:
[System.Web.Services.WebMethod]
public static string EditPage(string nodeID)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(Global.conString))
using (SqlCommand cmd = new SqlCommand("contentPageGetDetail", con))
{
cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = Global.SafeSqlLiteral(nodeID, 1);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
}
if (dt.Count > 0)
{
string pageTitle = dt.Rows[0]["Title"].toString();
string contentID = dt.Rows[0]["ContentID"].toString();
return pageTitle, contentID, nodeID;
}
else
{
return "Failed";
}
}
When it's time to return I want to grab all content returned from the stored procedure back to the jquery method in the success section and set a hiddenfield, dropdown value, and a title in a textfield. In the jQuery I tried using "pageTitle" but it came up undefined. What do I need to do jQuery side to grab whats being returned and populate fields in my Web Form before showing the form?
In Login page, i make use of the following procedure:
ALTER PROCEDURE dbo.logincheck
I'm trying to communicate with a Windows-hosted SOAP web service using PHP's SoapClient.The Web Service is intended to insert a new record for a member into a database.I can verify that my code using PHP's SOAPClient can successfully transfer the data via the Web Service to the database,but I am not getting the expected return value.
The Web Service description for what I should be getting as a return is described below.On successful execution of the Web Service code,I am getting nothing back despite calling LastResponse function and LastResponseHeaders.It seems no XML is getting returned at all.I am using other API calls within this Web Service and they all seem to work fine with the expected XML returned whenever I invoke a method.but for this one,which involves sending data,I'm not getting a return
I created a custom membership provider in my ASP.NET 4.0 web site, stored in App_Code, and referenced in my web.config.
However, it doesn't appear to be pulling values out of web.config during initialization.
The code was taken from [URL] , and the only modifications were changing "connectionStringName" here to the name of my connection string:
[Code]....
The connection string always comes back as nothing in this line:
[Code]....
No matter what I change the password format to in web.config, the default value here is always used:
[Code]....
So to me it's pretty clear it's not pulling out values for some reason. Here is the reference to the membership provider in web.config.
[Code]....
I have 2 two listitems. Each list returns different rows. I want to combine both the list rows and disaply it in single grid.
List<somedata> grid1=new List<somedata>
List<somedata> grid2=new List<somedata>
I am getting values in grid1 and grid2. Each list values i am binding to 2 different grids
I want to bind both grid1 and grid2 to the same grid
For example: something like this : grd.datasource=grid1+grid2;
grd.databind();
I'm trying to retreive values entered by users in the textboxes in the footer of the gridview and insert these values into another sql table.My code is as follows :-
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("addnew"))
{
TextBox t1 = (TextBox)GridView2.FooterRow.FindControl("tfrm");
string frm = t1.Text;
TextBox t2 = (TextBox)GridView2.FooterRow.FindControl("tsub");
string sub = t2.Text;
string cmd = "insert into suggestions values('" + frm + "','" + sub + "','c','c')";
con.Open();
SqlCommand com = new SqlCommand(cmd,con);
int a = com.ExecuteNonQuery();
GridView2.DataBind();
con.Close();
}
}
But the strings 'frm' and 'sub' returns null values.
In my application, users fill out a form to submit a "Job Request" - once they submit the form it is stored as a new row in a table in the Sql database. Each "Job Request" that is submitted is given a "JobID" which is a number and also the primary key of the new row in the database (the number is generated by the database). Once the users hit the "submit" button, I'd like to return the value of the "JobID" (the primary key) so that the user can know what it is. How would I achieve this? In the future, I will have to expand the application so that the users would be able to edit an older "Job Request" and get a similar JobID number (so if before it was 1234, the new one would be 1234-1 or something like that), so this is not simply a matter of searching for the highest number in the primary key field in the table and returning that. I'm using Sql for my database and writing in VB.
View 1 RepliesI have a function:
public List<Car> GetFourWheelDrives()
{
return dataContext.Cars.Where(c => c.IsFourWheelDrive == true).ToList();
}
Firstly it's kind of obvious what I'm trying to do here. Any suggestions on how I'm doing this? Any improvements?
So now I want to unit test this. Well is it a unit test? A unit test isn't suppose to touch the database right? So this is a functional test?
So say I write a test
[Test]
public void GetFourWheelDrives_NoParameters_ReturnAListOfOnlyCarsThatAreFourWheelDrives
{
Assert.Greater(dataContext.Cars.Where(c => c.IsFourWheelDrive == false).ToList().Count, 0);
var cars = GetFourWheelDrives();
Assert.Greater(cars.Count, 0);
Assert.AreEqual(cars.Count, cars.Where(c => c.IsFourWheelDrive == true).ToList().Count);
}
So first Assert I'm making sure cars that aren't 4WD exist in the database otherwise it wouldn't be a valid test.
Second Assert I'm making sure at least one was returned.
Third Assert I'm making sure that all the cars returned were in fact 4WD.
I know this isn't a good test because I'm using the same logic in the test as the function I'm testing. However this is the only way I can currently think of to do this.
I am trying to create a search page, this allows the admin to search through the entries in the database by certain criteria, such as province (like state but diff country)
Here is the code I have so far. The problem is that I am not getting any errors. But I am also not getting any results. The page just posts back and returns to the blank search page. The GridView does not display any results.
here is my code as it stands:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial Class administration_Search
Inherits System.Web.UI.Page
Protected Sub ProvinceButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ProvinceButton.Click
'get the search string from text box
Dim Search As String
Search = ("%" & ProvinceButton.Text & "%")
'if the string has value then continue with search
If Len(Trim(Search)) > 0 Then
Dim con As String = WebConfigurationManager.ConnectionStrings("fubar").ToString()
'build sql string
Dim s As String
s = ("SELECT id, surname, name FROM orders WHERE province like @strSearch")
'declar connection
Dim c As SqlConnection = New SqlConnection(con)
'add command
Dim x As New SqlCommand(s, c)
'add parameter
x.Parameters.AddWithValue("@strSearch", strSearch)
c.Open()
Dim r As SqlDataReader = x.ExecuteReader
GV.DataSource = r
GV.DataBind()
c.Close()
Else
Province.Text = ("Please enter search terms")
End If
End Sub
End Class
On the .aspx page I have a textbox (id: province) and a button (id:submit)
I have an entry from a database that has 500 characters. But when i display it i only want to return 200 charcters. How do I do that. I use Sql Server.
View 3 RepliesWe have a web project that contain its business methods in a class library project called "Bll.dll"
some methods of Bll.dll return List<> ... from a source - that i don't remember now - told that returning Collection<> is better than returning List<> Is it a valid ? Note that i don't make any process on values returned from BLL methods .. just view it in a web page
When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined.I mean assuming I have a view like this
CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.
var foos = myDB.FilteredFoos.Include("Bar").ToList();
foreach (Foo foo in foos) { ...
I have a clear button and a textbox in an aspx page. I set the session variable in this page as
String str = Textbox1.Text;
Session["TypeIds"] = str;
and I clear the sessions in a clear button event as
Session["TypeIds"]=null;.
Then when the user types some value in the textbox ,on Response.Redirect on another aspx page, the session variable returns null values.It does not retain its session state. The session state has to be maintained in the next page. Is it because this clear button event and setting explicitly to null creates this problem?
i showed two column (Electronics,Photoshop) but i have six. i want to update their checked or unchecked condition in database (0,1) how do i do?
<asp:CheckBox ID="CheckBox1" runat="server" Text="Electronics" />
<asp:CheckBox ID="CheckBox2" runat="server" Text="Photoshop" />
<asp:CheckBox ID="CheckBox3" runat="server" Text="VideoEditing" />
<asp:CheckBox ID="CheckBox4" runat="server" Text="Gaming" />
<asp:CheckBox ID="CheckBox5" runat="server" Text="Coding" />
<asp:CheckBox ID="CheckBox6" runat="server" Text="Miscellaneous" />
I'm trying to implement this tag cloud:
[URL]
...and I need the replace the hard-coded values below with those coming from my database?
[code]....
I've created the following sql string which returns the data in the format expected string/int or value/key
SELECT Tag, COUNT(Tag) AS Counter
FROM dbo.CtagCloud
GROUP BY Tag
HAVING (COUNT(Tag) > 3)
ORDER BY Counter DESC
I've done a bit of development with C# applications but not much with ASP.Net so if this is a trivial issue. I have a webform that has textboxes for password, phone number and a listbox for a provider. When I load up the webpage, I populate with the textboxes and listbox with selections from my SQL database. This works correctly. Then I allow the user to change data in any of controls. In the event that is triggered by the Save button, the values in the textboxes and listbox are the data values that were populated during the loading of the page, not what the user has typed in.
What am I doing wrong? I've attached my 2 pages of code.
Here is the .aspx
[Code]....
Here is the .aspx.cs code
[Code]....
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
iam using asp.net2.0 with c#, with backend sql server2000
in my client system i have to create dynamically procedure and return the result
but when iam using in my local system the code is working fine but at client system it it not working
[Code]....
I am quite new to MVC.
I have code like
string guid = Guid.NewGuid().ToString();
i want to store "guid" to the field named guid_data in table named "Detais" in aspnetdb database.
i have ado.net entity model which i have generated from "detais" table. how do i query to database so that the valu in guid will be stored in table?
I hope I can explain myself properly. What i'd like to do is be able to add a Search form where users can search various criteria based on my Orders table. I was hoping to add the capability to click on one of the OrderID's to display the fields from the Orders in the various text boxes on my form. This would allow the users to search, and update all in the same page. I have the data retrieval portion down pat, but am not really sure how to give them useful links. Is this possible? Or is there a better approach that I could take?
View 6 Replieshow to bind values in combobox from database in that combobox my first value should be display as <----select----->, but i have no such values in my database.
View 5 RepliesI want to retrieve the values from two columns in a database, but I get an error. Here is my code:
[code]....