Dim reader As SqlDataReader
reader = cmd.ExecuteReader
Dim XML As String = reader("records").ToString
I've executed the command in SQL server and I get a result string with length of 54781But when I execute it via .NET and assign it to the XML variable, the length of XML is always 2033...so now Im thinking that the result column "records" cannot exceed this length for some reason...
How it is possible to assign datatype of an attribute retrieved using sql query to a string? for eg:
SqlCommand cmd = new SqlCommand("select data_type from information_schema.columns where table_schema='dbo' AND table_name=table1 AND column_name=column1, con);
I want to assign this datatype value to a string. How it is possible?
Passing a query string value retrieved to an ImageUrl attribute of an image control using asp.net c#.
I have a page called DisplayImage and within the page_load event i was able to retrieve somevalues from the query stringhcode=Request.Querystring["ccode"].Tostring();
Now,
hcode="6699FD";
i'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 RepliesNow I can upload image/Word document and store it in to our SQL database.
Also I can save image retrieved from our SQL database.
But I am having problem with retrieving Word document.
Right now I am doing this for word document:
[Code]....
This works, but IT ONLY shows in the browser. (I WANT TO SAVE THIS AS .DOC IN ONE OF OUR FOLDER)
For images (*.jpg *.gif) I can save it in our folder. Like this:
[Code]....
This saves as temp.jpg in our Temp folder.
I want to do exactly the same with word document.
But I cannot use Bitmap as image. It gives me error...
i have a web application which which proccesses some request on some data that client selects, when the client selects more than 20 objects and clicks on proceed the client recieves this error, because the server takes a long time to process, however if the records are less and hence a timely response is recieved, no such error comes?
i have increased the sessiontimeout as well as set the
I'm trying to display images retreived from a sql server table in a GridView.
I found that the approach generally accepted was to have a handler that finally writes the image to the HttpContext.
My problem is that I only get a red X in the image column and not the images I want.
I'm using Northwind database, and I'm displaying data from the Employee table.
[Code]....
I have a web app that allows users to update their public facing information (bio, profile pics, etc). Once a user updates a piece of information, it needs to be held "pending" until an authorized admin user "approves" the change. I was thinking that I'd keep a table (called something like PendingHistory) which would hold the "pending" changes, then once approved (which requires TWO admin user to approve), I'll dump this data into the "real" tables that's responsible for displaying information to the public. Is there a way (I'm sure there has to be) to only store those fields that were changed? Some sort of comparison of the original field vs "new" so I don't have to save everything. I was hoping to make it as easy as possible for the admin crew, so that they could just get a view of "pending changes" vs the entire row of data. So basically I need something like this:
September 15, 2010 John Doe requested to change: First Name to Fred; Last Name to Flinstone
[Date Updated] [user] [column name] [column name]
What is the difference between ExecuteDataSet and ExecuteReader.
View 2 RepliesI am trying to complete my function below but got lost in the different methods out there. It will always return 1 row and I need to get the values of the record and ADD into a new row. The function returns a DataTable.
[Code]....
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd;
[code]...
I am getting error that ExecuteReader: Connection property has not been initialized
I'm using data access block [URL] in asp.net 3.5. Back end is sql server 2005. It's working fine and returns result instantly for all DB calls. But, I've a problem with one SP. When I call it, executereader is taking too much time. In few cases, it is executed. And sometimes I get the Time out error. I run the same SP in sql server. It returns 9000 rows in 3 seconds.
View 3 Replieshere my code-
using (SqlDataReader sqlDataReader = ExecuteReader(CommandType.StoredProcedure, StoredProcedures.AuthenticateUser, sqlParameter))
{
isAuthenticated = Convert.ToBoolean(sqlParameter[2].Value);
if (isAuthenticated)
{
if (sqlDataReader.Read())
{
User = new UserEntity();
DbHelper.GetEntity(sqlDataReader, User);
}
}
}
I always get isAuthenticated as false because sqlParameter[2].Value is null all the time but when I execute my query with ExecuteNonQuery it gives me the value but in that case I can not fill the entity.
After trying many solutions listed on the internet I am very confused now. I have a C#/SQL web application for which I am simply trying to bind an ExecuteReader command to a Dropdownlist so the user can select a value. This is a VS2008 project on an XP OS.
How it works is after the user selects a table, I use this selection as an input parameter to a method from my Datamatch.aspx.cs file. Then this Datamatch.aspx.cs file calls a method from my ADONET.cs class file. Finally this method executes a SQL procedure to return the list of columns from that table. (These are all tables in Adventureworks DB). I know that this method returns successfully the list of columns if I execute this SP in SSMS. However, I'm not sure how to tell if it works in VS or not.This should be simple. How can I do this? Here is some of my code. The T-sQL stored proc:
CREATE PROCEDURE [dbo].[getColumnNames]
@TableName VarChar(50) AS
BEGIN
SET NOCOUNT ON;
[code]...
The CreateLabels method above correctly shows me the labels. But the CreateDropDownLists method just shows me one dropdownlist with nothing in it. In other words, it is not selectable. So how can I verify that the datareader is returning all 4 columns and inspect their values? I was able to find from datareader "COLUMN_NAME" but I don't know what properties to search to verify the column names.
I am having problems with the following. On debugging I find that when strKeywords = '', reader = "System.Data.SqlClient.SqlDataReader". However, as soon as strKeywords takes the value of anything else, reader = nothing. But the stored procedure handles the arguments fine, so I am very confused!
[Code]....
Some time i getting error below ,but i am did'nt used excutereader
ExecuteReader requires an open and available Connection. The connection's current state is closed.
This my code,
try { if (con.State != ConnectionState.Open) con.Open(); string result;
string Queryip = "ViewIp"; SqlCommand cmdip = new SqlCommand("ViewTranscation", con);
cmdip.CommandType = CommandType.StoredProcedure; cmdip.Parameters.AddWithValue("@QueryType", Queryip); cmdip.Parameters.AddWithValue("@Input1", "");
[Code] ....
Note: You may not need to read the whole thing to know what's wrong... skip down to the part about the 3 scenarios if you'd like. Only read the begin if you'd like some background info on how I've tried implementing this and where the errors occurred.To begin with, I'm trying to retrieve a list of Clients stored in the CRM_Clients table for a given callerId.I retrieve the clients from my Controller with the SelectLiveClientsForCaller method. The message is then passed on to the DAL through the static Instance method in the DataProvider class:
public List<Client> SelectLiveClientsForCaller(int callerID)
{
List<Client> results = new List<Client>();
[code]...
Is there a way I can limit the width of a textbox to be equal to the MaxLength property? In my case right now, the textbox control is placed in a table cell as in this snippet:
<td class=TDSmallerBold style="width:90%">
<asp:textbox id="txtTitle" runat="server"
CausesValidation="true"
Text="Type a title here..be concise but descriptive. Include price."
ToolTip="Describe the item with a short pithy title (most important keywords first). Include the price. The title you provide here will be the primary text found by search engines that index Zipeee content."
MaxLength="60"
Width="100%">
</asp:textbox>
(I know I should not use HTML tables to control layout..another subject for sure) but is there a way to constrain the actual width to the max number of characters allowed in the typed box?
I am trying to use MaxLength function for the textbox in code behind.
How is it possible for textbox txttabname here, which is created dynamically.
[Code]....
I tried this but for @class and size doesn't work.I want to reduce the size of the textbox but when I specify the width in the css class or use size=25 doesn't change the size.
View 4 RepliesIs it possible for me to set MaxLength for AjaxControlToolkit.HTMLEditor?Or is there a workaround if this control don't have maxLength property
View 1 RepliesHow do I specify size,maxlength,class and other attributes for the
<%= Html.TextBoxFor(model => model.XXX) %>
If I set the maxlength field for a textbox, and have the textmode set to SingleLine, the amount of text is limited to the specified number of characters. If you change TextMode to MultiLine, the number of characters is no longer constrained.
View 2 RepliesI used below code for textbox that users can enter 30character in text box
<asp:TextBox ID="txttopic" runat="server" MaxLength="30"></asp:TextBox>
It worked correctly and now I want use MaxLenght for textbox with TextMode="MultiLine" like below
<asp:TextBox ID="txtmatn" runat="server" TextMode="MultiLine" MaxLength="100"></asp:TextBox>
But it didn't worked for above TextBox... What should I do for this Textbox ?
I have set the MaxLength in the textbox and don't know why I can type more than the max length characters in the textbox. Do you know why? ....
View 9 Replies