C# - Data Reader Trimming The Leading Zeros?
Jan 13, 2011
I have a string coming from a stored procedure looks like '001234567'.
sqlCommand = new SqlCommand("csp_Bbp_OBN_GetBasePageList", BBConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.Connection.Open();
// Run the SQL statement, and then get the returned rows to the DataReader.
accReader = sqlCommand.ExecuteReader();............
In my case, from the stored procedure I am returning the varchar, after executing and reading it I am getting the value to basePage.GrouNum which is a string. So, I don't see where it is trimming the leading zeros.
Example: GroupNumber in the table is : "001234567"
BasePage.GroupNum after reading from DataReader : "1234567"
But, I do not want the leading zeros being trimmed.
View 3 Replies
Similar Messages:
May 7, 2015
My datatable has 0123 when I export it becomes 123, Datatable can be numeric or alphanumeric, after searching I got this link [URL] ....
I didnt managed to use your code in DataTable.
My Code.
dtExport is my DataTable
DataGrid dGrid = new DataGrid();
dGrid.DataSource = dtExport;
dGrid.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
dGrid.RenderControl(hw);
[Code]....
View 1 Replies
Jan 6, 2011
I realized this has been asked multiple times before, but I still haven't been able to get it to work. I'm trying to export a Gridview to Excel without losing leading zeros. Here is my code. Add added the STYLE lines to try to fix the problem.
Dim attachment
As
String =
"attachment; filename=Awards.xls"
System.Web.HttpContext.Current.Response.ClearContent()
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", attachment)
System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"
Dim sw
As
New StringWriter()
Dim htw
As
New HtmlTextWriter(sw)
gv.RenderControl(htw)
System.Web.HttpContext.Current.Response.Write(sw.ToString())
Dim STYLE
As
String =
"<style> .text { mso-number-format: ; } </style> "
System.Web.HttpContext.Current.Response.Write(STYLE)
System.Web.HttpContext.Current.Response.[End]()
View 4 Replies
Jan 13, 2011
I have understood there is no way to keep leading zeros in a OleDbDataAdapter?
Im trying to read some data from a text file with:
MyCommand = New System.Data.OleDb.OleDbDataAdapter("SELECT F7, F5, F9, F1 FROM " & System.IO.Path.GetFileName(bonnerfil.PostedFile.FileName), MyConnection)
I have managed to keep leading zeros if I add a Schema.ini file into the directory with column set to Char.
But, when having a Shema.ini the select statement reads from start to end of the file. As you see in my select statement I prefer/must have the coulumn 7 first being read and so on. This do work and I will have get the result I want. But for now it´s either - get the order of columns correct or have leading zeros.
how can I either have a Schema.ini that reads the file in the order I want, or keep leading zeros and not have the order I want.
Code:
[Code]....
View 1 Replies
Mar 25, 2010
The GridView in ASP.NET 2.0 is trimming the leading spaces from data coming from a SQLServer database. I have yet to find a way to keep it from doing that. The data in this particular view is being edited to remove such spaces, but only upon editing the row can any leading spaces be seen, meaning, at present, each row will have to be touched. With 12,000+ rows, that's a little much.
What little I've found on Google has mainly be concerned with trimming leading spaces. Is there a way to force GridView to show the data exactly as it is in the database, leading spaces and all?
View 1 Replies
Jan 23, 2012
How do I do that with the code?
protected void btnExportExcel_Click(object sender, EventArgs e)
{
    Response.Clear();
    Response.Buffer = true;
   Â
    Response.AddHeader("content-disposition",
     "attachment;filename=GridViewExport.xls");
[CODE]...
View 1 Replies
Feb 22, 2011
I have some code in my vb.net code behind that queries a database, and if there is data, outputs it from the codebehind to a datalist on my asp.net page. In addition to sending the data to the datalist on the page, I need to take the value from "mbillaty" that is returned from the sql query, and have that value be the selected value for a drop down box also on the page. I can get either the datalist to fill, or the selected value for the dropdown box to be selected depending upon which bit of code I place before the other (ARGH), but I can't get them to both work together on the page. What am I doing wrong?
[Code]....
View 2 Replies
Mar 12, 2011
What function do I use to reduce all entries in a database field to a maximum length. The field is 100 characters wide and I need to chop all existing entries in the field down to 20 characters. I prefer not to redefine the field to 20 wide to lose the data and then redefine back to 100.
UPDATE CmpyInfo
SET ( ShortName to 20 characters max )
WHERE ShortName.Length > 20
View 4 Replies
Jul 7, 2010
I have a Gridview with some cells in numbers while in some cell they could be null without numbers. I need to modify it such that the numbers in the Gridview are in these formats:-
(a) If it is 12345.333 becomes 12,345
(b) If it is blank, I wish the cells to display 0
This is the code I am using to achieve (a), but when it comes to blank, it returns error (I believe my code below failed to provide blank cases but I dunno how. So what should be the code to do (b) above ?
For i As
Integer = 1
To N
e.Row.Cells(i).Text = String.Format("{0:#,##0}", Convert.ToDouble(e.Row.Cells(i).Text))Next
View 13 Replies
Apr 28, 2010
I have a formview which binds to a table where one of the fields is an integer zip-code field. I want to pad the zip with a leading zero in the edit template when the zip is something like "02134". How do I edit the bound data without "breaking" the two-way binding?
I wrote simple function to add the zero and return a string:
Public
Function padZIP(ByVal zip
As
Integer)
As
String
Dim tmpStr
As
String =
CType(zip,
String)
If tmpStr.Length = 4
Then tmpStr =
"0" & tmpStr
Return tmpStr
End
Function
and I can call it in the itemtemplate fine:
<asp:Label
ID="ZipLabel"
runat="server"
Text='<%# padZIP(container.dataitem("Zip")) %>'
Width="30"
/>
but, trying to do that in the edititemtemplate breaks the binding?
View 2 Replies
Apr 23, 2010
I need to pass some info to a 3rd party (for tracking) and they require I provide a checksum value which is an md5 hashed amalgamation of some of the other values. This is my code :
[Code]....
They keep rejecting my checksum. When I have tested for the following value passed in preConvert - 300265215063.79 I get :
My code gives : ED4463C84DE9D21B54C4E62F2D72CE
An online MD5 hash gives : 0ed40463c84de9d21b54c4e62f2d72ce
Which apart from the case, is exactly the same apart from missing 2 zeroes.
View 1 Replies
Sep 20, 2010
I have an ASP.NET application that relies on the Random class to generate a pseudo-random string. It uses the following code (this is part of a larger piece of sample code provided by Google for apps SSO):
public static class SamlUtility
{
private static Random random = new Random();
private static char[] charMapping = { 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p' };
public static string CreateId()
{
byte[] bytes = new byte[20]; // 160 bits
[Code]...
This normally works very well, but from time to time it starts generating a string of 'a'. From what I can tell from debugging, Random simply stops returning random numbers and instead fills bytes with the same value over and over. I've patched this by using a GUID instead, but I'm curious what happened in the original code. I'm assuming some form of entropy exhaustion, but I can't find any reference in the docs. Also, each time this has happened, performing iisreset restored the correct behavior.
View 1 Replies
Mar 17, 2011
I want to remove all the extra Zeros from a string.For example string is: '5.00560000' then I want to show it like '5.0056'I used Convert.double for this purpose, it is working ok but when the string is '0.0000500' then it is showing '5E-06' which is not ok.
View 3 Replies
Jan 22, 2010
I've a string builder, and I need to convert it to a string, and then trim any commas if there are any there (I need to get rid of them because I'm building an sql query).
Here's what I'm doing:
myStringBuilder.ToString().TrimEnd(',');
Why isn't this working??? It's not trimming any commas at the end!
I'm using c# :)
View 9 Replies
Jul 12, 2010
I would like to dropdown box to show only starting from second row of the table. How to use data reader to do it?
View 9 Replies
Nov 26, 2010
I am trying to send session on Loop and trying get .
[code]....
In above code, I just only get same SessionId on every news headings, how do I get next row session id?
View 2 Replies
Feb 21, 2011
using vb.net/asp.net 2005 and sql server 2005. I'm querying the database and returning text which I am then adding to a string. I'm creating a crystal report with the text however this is not a crystal report question, its about the string data. what I"m noticing is that when I show the string on the pdf that there are some strange characters at the end of the string. I am both trimming the string and taking out null characters however the strange text shows up like this:
strangeText>
SÙÇ
TÙçy|Ü
DÙÇ
$ÛÇ
</strangeText>
does anyone know what these characters are and how to get rid of them?
View 7 Replies
Feb 17, 2011
I have a string variable that is a concatenation of text and a variable;
var selectQueryString = "SELECT * FROM WholesaleItems WHERE ProductClass like '" + @pc + "%'" ;
This returns with a space between the variable and the percent sign breaking the LIKE selector. I cannot find any way to trim the variable result.
View 14 Replies
Mar 23, 2011
C#. string SearchWords; SearchWords = TextBox1.Text (need to trim its value to a maximum length of 200)
SearchWords is a parameter being called by an SQL stored procedure. TextBox1 is a multiline text box on an aspx page.
View 5 Replies
Sep 6, 2010
I am observing a rather strange behavior. I have a procedure which selects a field from a matching record and returns it. The procedure works as expected returning proper values, when I execute the procedure from Visual Studio Server Explorer tab. The procedure is
[Code]....
This is being called from the DAL as follows:
[Code]....
The problem is if @ReturnValue is EAE then cmd.Parameter[outputParameterKey].Value is giving the value "E". If @ReturnValue is "Sassyboy" it is giving "S". why this behavior?
View 1 Replies
Feb 28, 2011
We're writing an app that has a requirement for allowing/disallowing access based on user role.In a traditional .net app of course you set the security trimming attribute in the web.config and set the nodes in the web.sitemap file and you were set.
View 2 Replies
Dec 24, 2010
is it possible to find row count of a table using data reader?
View 3 Replies
Feb 24, 2011
I have a web page where I want to return number of returned rows by datareader as I need to get Count of rows. My code is as follow :
SqlCommand cm = new SqlCommand(); SqlDataReader dr;sqlconnection cn; public int Returndatareader( int x)
{
int s;
string sqlstr = "SELECT COUNT(*) FROM P_Events as Counter";
cm.CommandText = sqlstr;
cm.Connection = cn;
cn.Open();
dr = cm.ExecuteReader();
if (dr.Read())
{
int y = dr.RecordsAffected;
s = y;
//return y;
}
cn.Close();
return x;
}
but the rows affected count is -1 everytime i run my code.
View 5 Replies
May 31, 2010
In my web.config I have configured a SiteMapProvider with securityTrimmingEnabled="true" and on my main master page is an asp:Menu control bound to an asp:SiteMapDataSource. In addition I have configured restricted access to all pages in a subfolder "Admin" (using another web.config in this subfolder).
If I put a sitemapNode in Web.sitemap...
<siteMapNode url="~/Admin/Default.aspx" title="Administration" description="" >
... only users in role "Admin" will have the menu item related to that siteMapNode. So this is working fine and as intended.
Now I have defined a URL route in Global.asax to map the physical file to a new URL:
System.Web.Routing.RouteTable.Routes.MapPageRoute("AdminHomeRoute",
"Administration/Home", "~/Admin/Default.aspx");
But when I use this route-URL in the SiteMap file...
<siteMapNode url="Administration/Home" title="Administration" description="" >
... it seems that security trimming does not work: The menu item is visible for all users. (Access to the page is still restricted though, so selecting the menu item by non-Admin users does not navigate to the restricted page.)
Question: Is there any setting I've missed so far to make security trimming working with URL routing in ASP.NET 4.0 Web Forms? Did I do something wrong? Is there any work-around?
View 1 Replies
Feb 14, 2010
i have a asp.net web site with it we have admin area with login page for admin only and all site is allowed for all - i need to ask how to define the right security configuration for it as i get this error Cannot use a leading .. to exit above the top directory. 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 codeAn 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.
[code]...
View 2 Replies
