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 am store ms word resume to image(BLOB) data type in sql server 2005. now i want to display this resume in HTML page or in text area. and for that i use
[code]....
I have a cart application I am working on where I need to assign a value based on a query string. I am telling the code behind to override the price returned by a linq query with the price in the value of the price variable passed by the string. The default linq value for this item is zero, and isn't updated by my attempt to override. Here is what I am trying with no success so far. Query format sent to page is .....aspx?Price=
Am I calling the string correctly?
[Code]....
I am looking to retrieve data from a database and assign those values to class objects which in turn will be turned into session variables. I am using an object datasource to retrieve the data from the database but I cannot find anywhere that shows how to assign these values to variables. The data is returned in a dataset. There is the added problem that there will be mulitple items returned which will have to be assigned to different arraylists of objects based on the a primary key in the database.
View 4 RepliesDim 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...
I have a sample xml as;
<?xml version="1.0" encoding="iso-8859-9"?>
<DropDownControl id="dd1" name="ShowValues" choices="choice1,choice2,choice3,choice4">
</DropDownControl >
I need to create a UI representation of this XML using XSL. I want to fill the drop down list with values specified in choices attribute.
I'm storing phone country codes. They range from 1 to about 300. What's going to be more performant for datatype: int or string? I'm using SQL server 2008 and linq-to-sql.
View 7 RepliesI'm loading data from my database into a DataTable, and one of the columns is a date field.
[Code]....
I'd like to format that column so that instead of containing a full date, it will be formatted like "MM/DD/YYYY".
I've tried looping through each row in the table and changing the cell for that column, but I get an error saying that the string isn't a valid DateTime object.
I tried changing the column DateType to a string, but I get an error saying I can't change the DateType after the table is filled.
How can I do this? This seems like such a simple thing, but I'm having so much trouble with it.
convert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
inside my model metadata, i have a timespan field that would like to display in all Create, Edit and Display views like "hh:mm". For this, is set DisplayFormatAttribute as follows:
[Code]....
When i try to create a new model object, the time field gets displayed as "00:00:00" im my model (00 is the initial values) instead of "00:00". Is there something i am doing wrong? Note that the same approach works for date fileds, where i want to be displayed as "dd/MM/yyyy" (for this is assign "{0:dd/MM/yyyy}" to the display format attribute).
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 RepliesI need to create a form showing our production numbers for the week on each line. I can do this in listview using grouping and totals. The problem is I want these numbers to show in a form so I can cutomize the look of the report. Is there any way to assign a query to each text box on a form?
View 2 RepliesNew to Linq and Var type have a method where linq query is executed, want to return the result and assign it to GridView. but method don't take the return type as var.
So was wondering how do i return this query result?
Should i assign this result to DataTable first and make the method return type as DataTable?
Here is the code, This is what i want to do but not sure what is the right way
[Code]....
I have an entry page that contains a datalist. I also have an ascx user control page that when it runs on page load, renders an html table template which contains category information from an SQL self referencing table. When the SQL query run on page load, it bind the results to a datalist called dlCategory, and repeats for all rows that have no value in a field in this SQL table called ParentCategoryCode. The SQL table is called ServiceRequestCategories and basically consists of CategoryCode, CategoryTitle, and CategoryDescription, and may or may not have a ParentCategoryCode associated with it.
Records without a ParentCategoryCode are top level categories, and anything that has a ParentCategoryCode are second or third level categories. The way I have the data set up, it ends up being 4 rows that are returned and rendered as 4 html tables. Each one of these is tied to the user control, and each user control runs another datalist, and shows all CategoryTitle values for each Category that has a ParentCategoryCode (second level categories). This works when you click on a LinkButton for any CategoryTitle. This all works fine.
My question is, how can I use an SQL select query to plug the value of the CategoryTitle into a label called lblCategoryBreadCrumb on my main entry page? Here is my code, but it does not seem to work.
Protected Sub ShowBreadcrumbLabel()
Dim strSQL As String
Dim dsData As DataSet
Dim dtData As DataTable
[Code] .....
Example:
[URL]
I added the iis tag because I am guessing it also depends on what server technology you use?
I used a query which returns some rows as result.. Querys is
var UserActivity = (from x in entity.user_activities
oin p in entity.team_group_friends on x.activity_doer equals p.userid
where p.userid == teamORGroupID
select x).ToList().Take(5);
There is no error in query...But when i assisg the UserActivity to a view model ..
I have an sql database, with a users table that has username and a colour.
My asp master page is reading the current users username and passing it to the content fine.
What I am trying to now do is in the content page grab the colour from the sql table where the username is the current username, and assign it to a string inside the default.aspx.cs file.
i have to assign value to bit varibale.so i declared bool variable . i am assigning string value to a bool variable . so i converted to boolean & assigned.Its not converting to bool..How to assign string value to bit variable.?i am getting error.Object reference not set to an instance of an object
[Code]....
I am using asp.net and C#. I want to send mail to my user in HTML format, I have the content in HTML format let say like this
<table style="width:100%;">
<tr>
<td style="width:20%; background-color:Blue;"></td>
<td style="width:80%; background-color:Green;"></td>
</tr>
</table>
Now I am unable to assign this to a string variable, so that I could send it as a mail. how can I bind this whole HTML content into a varibale.
I m facing some problem. i m not passing Dynamic string through query string..
I m using this code
string abc = "CPCB_" + TextBox1.Text + "_" + TextBox2.Text;
Response.Write("<script>window.open('xml.aspx?Flag=3&date='+abc,target='new');</script>");
When i do the following i am getting object ref not set to instance of an object: there is value in string variable would like to assign to a label.
lblFilename.Text = strFilename
I have a string like these:
String data = @"<table id="_grp:CONSUMER_APPLICATION" cellpadding="0" width="660">
<tbody>
<tr>
<td>
<table id="_headerTable" class="Dark" cellspacing="0" cellpadding="0" width="660" border="0">
[code]...
in my asp.net+vb+access web i am having a page in which i am counting and displying the numbers in text boxes/labels. it works fine.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:webWing.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
[Code].....
i want to amend the value with the value of the text boxes that i had tried manually it works fine.
Is It Possible to send a string consists of (,.&') in a query string ?
View 7 Replies