Hello,
in my aspx page I have the followong code:
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
....
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst")) %>
....
</ItemTemplate>
</asp:Repeater>
Whereby "tekst" one of the columns is being loaded in the dataset
In the code behind page data is loaded as as follows:
....
meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
ds = m.GetMeetingByID(meetingID);
dr = ds.Tables[0].Rows[0];
DataView dv = new DataView(ds.Tables[0]);
this.Repeater1.DataSource = dv;
this.Repeater1.DataBind();
....
The problem is that column "tekst" can be null.
In that case, I'm getting an error on
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst")) %>
because the (string) cast then goes wrong. If "tekst" is not null, it is ok.
Now this is just for "tekst", but also other columns in my table could be
null.
How can I deal with this is a nice way?
Eddy de Boer 11  34270 
You should test for null using IsDBNull(object) prior to allowing the value
in question to be used in your repeater.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com... Hello,
in my aspx page I have the followong code:
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
...
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
...
</ItemTemplate>
</asp:Repeater>
Whereby "tekst" one of the columns is being loaded in the dataset
In the code behind page data is loaded as as follows:
...
meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
ds = m.GetMeetingByID(meetingID);
dr = ds.Tables[0].Rows[0];
DataView dv = new DataView(ds.Tables[0]);
this.Repeater1.DataSource = dv;
this.Repeater1.DataBind();
...
The problem is that column "tekst" can be null.
In that case, I'm getting an error on
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
because the (string) cast then goes wrong. If "tekst" is not null, it is
ok.
Now this is just for "tekst", but also other columns in my table could be
null.
How can I deal with this is a nice way?
Eddy de Boer
Thank you for your answer.
But how would I do that?
Because if it is null, is it your intention to replace it with "" in case of
a strng and a 0 in case of a integer?
Then I should put the following code in the code behind like:
....
for each (Column cl in ds.Tables[i].Rows[j].Columns) )
{
if (cl.IsDBnull(cl))
{
if (cl.Type == DataType.Integer)
{
cl.Value = 0;
}
....
}
ds.ApplyUpdates()
something like this?
Or is there another way?
"Scott M." wrote: You should test for null using IsDBNull(object) prior to allowing the value
in question to be used in your repeater.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com... Hello,
in my aspx page I have the followong code:
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
...
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
...
</ItemTemplate>
</asp:Repeater>
Whereby "tekst" one of the columns is being loaded in the dataset
In the code behind page data is loaded as as follows:
...
meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
ds = m.GetMeetingByID(meetingID);
dr = ds.Tables[0].Rows[0];
DataView dv = new DataView(ds.Tables[0]);
this.Repeater1.DataSource = dv;
this.Repeater1.DataBind();
...
The problem is that column "tekst" can be null.
In that case, I'm getting an error on
<%# Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
because the (string) cast then goes wrong. If "tekst" is not null, it is
ok.
Now this is just for "tekst", but also other columns in my table could be
null.
How can I deal with this is a nice way?
Eddy de Boer
Write a function in the code-behind and call the function (instead of
Server.HtmlDecode) with the column parameters, the function can check if it
is a null (int or string) and return what you want, else the function calls
Server.HtmlDecode.
Your idea of going through the table and change the nulls will work as well.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:62**********************************@microsof t.com... Thank you for your answer.
But how would I do that?
Because if it is null, is it your intention to replace it with "" in case
of
a strng and a 0 in case of a integer?
Then I should put the following code in the code behind like:
...
for each (Column cl in ds.Tables[i].Rows[j].Columns) )
{
if (cl.IsDBnull(cl))
{
if (cl.Type == DataType.Integer)
{
cl.Value = 0;
}
....
}
ds.ApplyUpdates()
something like this?
Or is there another way?
"Scott M." wrote:
You should test for null using IsDBNull(object) prior to allowing the
value
in question to be used in your repeater.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com... > Hello,
>
> in my aspx page I have the followong code:
>
> <asp:Repeater id="Repeater1" runat="server">
> <ItemTemplate>
> ...
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> ...
> </ItemTemplate>
> </asp:Repeater>
>
> Whereby "tekst" one of the columns is being loaded in the dataset
> In the code behind page data is loaded as as follows:
>
> ...
> meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> ds = m.GetMeetingByID(meetingID);
> dr = ds.Tables[0].Rows[0];
> DataView dv = new DataView(ds.Tables[0]);
> this.Repeater1.DataSource = dv;
> this.Repeater1.DataBind();
> ...
>
> The problem is that column "tekst" can be null.
> In that case, I'm getting an error on
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> because the (string) cast then goes wrong. If "tekst" is not null, it
> is
> ok.
>
> Now this is just for "tekst", but also other columns in my table could
> be
> null.
> How can I deal with this is a nice way?
>
> Eddy de Boer
>
>
Sorry, to elaborate, instead of having
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
then you have
<%#
MyFunction(Container.DataItem,"tekst")
%>
"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:Oo**************@TK2MSFTNGP12.phx.gbl... Write a function in the code-behind and call the function (instead of
Server.HtmlDecode) with the column parameters, the function can check if
it is a null (int or string) and return what you want, else the function
calls Server.HtmlDecode.
Your idea of going through the table and change the nulls will work as
well.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:62**********************************@microsof t.com... Thank you for your answer.
But how would I do that?
Because if it is null, is it your intention to replace it with "" in case
of
a strng and a 0 in case of a integer?
Then I should put the following code in the code behind like:
...
for each (Column cl in ds.Tables[i].Rows[j].Columns) )
{
if (cl.IsDBnull(cl))
{
if (cl.Type == DataType.Integer)
{
cl.Value = 0;
}
....
}
ds.ApplyUpdates()
something like this?
Or is there another way?
"Scott M." wrote:
You should test for null using IsDBNull(object) prior to allowing the
value
in question to be used in your repeater.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com...
> Hello,
>
> in my aspx page I have the followong code:
>
> <asp:Repeater id="Repeater1" runat="server">
> <ItemTemplate>
> ...
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> ...
> </ItemTemplate>
> </asp:Repeater>
>
> Whereby "tekst" one of the columns is being loaded in the dataset
> In the code behind page data is loaded as as follows:
>
> ...
> meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> ds = m.GetMeetingByID(meetingID);
> dr = ds.Tables[0].Rows[0];
> DataView dv = new DataView(ds.Tables[0]);
> this.Repeater1.DataSource = dv;
> this.Repeater1.DataBind();
> ...
>
> The problem is that column "tekst" can be null.
> In that case, I'm getting an error on
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> because the (string) cast then goes wrong. If "tekst" is not null, it
> is
> ok.
>
> Now this is just for "tekst", but also other columns in my table could
> be
> null.
> How can I deal with this is a nice way?
>
> Eddy de Boer
>
>
Thank you for your answer!
"Chris Botha" wrote: Sorry, to elaborate, instead of having
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%>
then you have
<%#
MyFunction(Container.DataItem,"tekst")
%>
"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:Oo**************@TK2MSFTNGP12.phx.gbl... Write a function in the code-behind and call the function (instead of
Server.HtmlDecode) with the column parameters, the function can check if
it is a null (int or string) and return what you want, else the function
calls Server.HtmlDecode.
Your idea of going through the table and change the nulls will work as
well.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:62**********************************@microsof t.com... Thank you for your answer.
But how would I do that?
Because if it is null, is it your intention to replace it with "" in case
of
a strng and a 0 in case of a integer?
Then I should put the following code in the code behind like:
...
for each (Column cl in ds.Tables[i].Rows[j].Columns) )
{
if (cl.IsDBnull(cl))
{
if (cl.Type == DataType.Integer)
{
cl.Value = 0;
}
....
}
ds.ApplyUpdates()
something like this?
Or is there another way?
"Scott M." wrote:
You should test for null using IsDBNull(object) prior to allowing the
value
in question to be used in your repeater.
"eddy de boer" <ed********@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com...
> Hello,
>
> in my aspx page I have the followong code:
>
> <asp:Repeater id="Repeater1" runat="server">
> <ItemTemplate>
> ...
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> ...
> </ItemTemplate>
> </asp:Repeater>
>
> Whereby "tekst" one of the columns is being loaded in the dataset
> In the code behind page data is loaded as as follows:
>
> ...
> meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> ds = m.GetMeetingByID(meetingID);
> dr = ds.Tables[0].Rows[0];
> DataView dv = new DataView(ds.Tables[0]);
> this.Repeater1.DataSource = dv;
> this.Repeater1.DataBind();
> ...
>
> The problem is that column "tekst" can be null.
> In that case, I'm getting an error on
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
> %>
> because the (string) cast then goes wrong. If "tekst" is not null, it
> is
> ok.
>
> Now this is just for "tekst", but also other columns in my table could
> be
> null.
> How can I deal with this is a nice way?
>
> Eddy de Boer
>
>
If you are using a typed dataset you can set a property of the column
called NullValue and have it come back with a default value (which is a
empty string)
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:0F**********************************@microsof t.com: Hello,
in my aspx page I have the followong code:
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
...
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%> ...
</ItemTemplate>
</asp:Repeater>
Whereby "tekst" one of the columns is being loaded in the dataset
In the code behind page data is loaded as as follows:
...
meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
ds = m.GetMeetingByID(meetingID);
dr = ds.Tables[0].Rows[0];
DataView dv = new DataView(ds.Tables[0]);
this.Repeater1.DataSource = dv;
this.Repeater1.DataBind();
...
The problem is that column "tekst" can be null.
In that case, I'm getting an error on
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%> because the (string) cast then goes wrong. If "tekst" is not null,
it is ok.
Now this is just for "tekst", but also other columns in my table could
be null.
How can I deal with this is a nice way?
Eddy de Boer
Thank you for your response.
I don't know how to create a strong typed dataset, I will show you how I get
my data.
I'm using the folling DataHandler to get my data:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace meetmate.DataLayer
{
/// <summary>
/// Summary description for DataHandler.
/// </summary>
public class DataHandler
{
private SqlConnection conn;
private string connectionString;
public DataHandler()
{
connectionString = ConfigurationSettings.AppSettings["connectionString"];
conn = new SqlConnection(connectionString);
}
public DataSet GetDataSet(SqlCommand cmd)
{
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
public void ExecuteCommand(SqlCommand cmd)
{
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
}
In another module I call the Get like this:
public DataSet GetMeetingByID(int meetingID)
{
string qry = "select
titel,datum,tijd_van,tijd_tot,adres,plaats,tekst,v erslag " +
"from Meetings " +
"where ID = @ID";
SqlCommand cmd = new SqlCommand(qry);
cmd.Parameters.Add(new SqlParameter("@ID",meetingID));
DataHandler dh = new DataHandler();
DataSet ds = dh.GetDataSet(cmd);
return ds;
}
Then, in my BusinessLayer, I call the GetMeetingByID.
Do you know or have a reference how I could use typed DataSet in this?
Thank you,
Eddy
"James Doughty" wrote: If you are using a typed dataset you can set a property of the column
called NullValue and have it come back with a default value (which is a
empty string)
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:0F**********************************@microsof t.com:
Hello,
in my aspx page I have the followong code:
<asp:Repeater id="Repeater1" runat="server">
<ItemTemplate>
...
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%> ...
</ItemTemplate>
</asp:Repeater>
Whereby "tekst" one of the columns is being loaded in the dataset
In the code behind page data is loaded as as follows:
...
meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
ds = m.GetMeetingByID(meetingID);
dr = ds.Tables[0].Rows[0];
DataView dv = new DataView(ds.Tables[0]);
this.Repeater1.DataSource = dv;
this.Repeater1.DataBind();
...
The problem is that column "tekst" can be null.
In that case, I'm getting an error on
<%#
Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"))
%> because the (string) cast then goes wrong. If "tekst" is not null,
it is ok.
Now this is just for "tekst", but also other columns in my table could
be null.
How can I deal with this is a nice way?
Eddy de Boer
<%#
Server.HtmlDecode(IsDBNull(DataBinder.Eval(Contain er.DataItem,"tekst"))
? "" : (string) DataBinder.Eval(Container.DataItem,"tekst")) %>
Take a look at http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnhcvb03/html/vb03f9.asp
If you have any questions or don't understand something about let me
know.
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:AC**********************************@microsof t.com: Thank you for your response.
I don't know how to create a strong typed dataset, I will show you how
I get my data.
I'm using the folling DataHandler to get my data:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace meetmate.DataLayer
{
/// <summary>
/// Summary description for DataHandler.
/// </summary>
public class DataHandler
{
private SqlConnection conn;
private string connectionString;
public DataHandler()
{
connectionString =
ConfigurationSettings.AppSettings["connectionString"];
conn = new SqlConnection(connectionString);
}
public DataSet GetDataSet(SqlCommand cmd)
{
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
public void ExecuteCommand(SqlCommand cmd)
{
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
}
In another module I call the Get like this:
public DataSet GetMeetingByID(int meetingID)
{
string qry = "select
titel,datum,tijd_van,tijd_tot,adres,plaats,tekst,v erslag " +
"from Meetings " +
"where ID = @ID";
SqlCommand cmd = new SqlCommand(qry);
cmd.Parameters.Add(new SqlParameter("@ID",meetingID));
DataHandler dh = new DataHandler();
DataSet ds = dh.GetDataSet(cmd);
return ds;
}
Then, in my BusinessLayer, I call the GetMeetingByID.
Do you know or have a reference how I could use typed DataSet in this?
Thank you,
Eddy
"James Doughty" wrote:
If you are using a typed dataset you can set a property of the column
called NullValue and have it come back with a default value (which is
a empty string)
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:0F**********************************@microsof t.com:
> Hello,
>
> in my aspx page I have the followong code:
>
> <asp:Repeater id="Repeater1" runat="server">
> <ItemTemplate>
> ...
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"
> )) %> ...
> </ItemTemplate>
> </asp:Repeater>
>
> Whereby "tekst" one of the columns is being loaded in the dataset
> In the code behind page data is loaded as as follows:
>
> ...
> meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> ds = m.GetMeetingByID(meetingID);
> dr = ds.Tables[0].Rows[0];
> DataView dv = new DataView(ds.Tables[0]);
> this.Repeater1.DataSource = dv;
> this.Repeater1.DataBind();
> ...
>
> The problem is that column "tekst" can be null.
> In that case, I'm getting an error on
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"
> )) %> because the (string) cast then goes wrong. If "tekst" is not
> null, it is ok.
>
> Now this is just for "tekst", but also other columns in my table
> could be null.
> How can I deal with this is a nice way?
>
> Eddy de Boer
>
>
>
Thanks for your response!
"sp3d2orbit" wrote: <%#
Server.HtmlDecode(IsDBNull(DataBinder.Eval(Contain er.DataItem,"tekst"))
? "" : (string) DataBinder.Eval(Container.DataItem,"tekst")) %>
Thank you James
"James Doughty" wrote: Take a look at http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnhcvb03/html/vb03f9.asp
If you have any questions or don't understand something about let me
know.
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:AC**********************************@microsof t.com:
Thank you for your response.
I don't know how to create a strong typed dataset, I will show you how
I get my data.
I'm using the folling DataHandler to get my data:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace meetmate.DataLayer
{
/// <summary>
/// Summary description for DataHandler.
/// </summary>
public class DataHandler
{
private SqlConnection conn;
private string connectionString;
public DataHandler()
{
connectionString =
ConfigurationSettings.AppSettings["connectionString"];
conn = new SqlConnection(connectionString);
}
public DataSet GetDataSet(SqlCommand cmd)
{
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
public void ExecuteCommand(SqlCommand cmd)
{
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
}
In another module I call the Get like this:
public DataSet GetMeetingByID(int meetingID)
{
string qry = "select
titel,datum,tijd_van,tijd_tot,adres,plaats,tekst,v erslag " +
"from Meetings " +
"where ID = @ID";
SqlCommand cmd = new SqlCommand(qry);
cmd.Parameters.Add(new SqlParameter("@ID",meetingID));
DataHandler dh = new DataHandler();
DataSet ds = dh.GetDataSet(cmd);
return ds;
}
Then, in my BusinessLayer, I call the GetMeetingByID.
Do you know or have a reference how I could use typed DataSet in this?
Thank you,
Eddy
"James Doughty" wrote:
If you are using a typed dataset you can set a property of the column
called NullValue and have it come back with a default value (which is
a empty string)
=?Utf-8?B?ZWRkeSBkZSBib2Vy?= <ed********@discussions.microsoft.com>
wrote in news:0F**********************************@microsof t.com:
> Hello,
>
> in my aspx page I have the followong code:
>
> <asp:Repeater id="Repeater1" runat="server">
> <ItemTemplate>
> ...
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"
> )) %> ...
> </ItemTemplate>
> </asp:Repeater>
>
> Whereby "tekst" one of the columns is being loaded in the dataset
> In the code behind page data is loaded as as follows:
>
> ...
> meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> ds = m.GetMeetingByID(meetingID);
> dr = ds.Tables[0].Rows[0];
> DataView dv = new DataView(ds.Tables[0]);
> this.Repeater1.DataSource = dv;
> this.Repeater1.DataBind();
> ...
>
> The problem is that column "tekst" can be null.
> In that case, I'm getting an error on
> <%#
> Server.HtmlDecode((string)DataBinder.Eval(Containe r.DataItem,"tekst"
> )) %> because the (string) cast then goes wrong. If "tekst" is not
> null, it is ok.
>
> Now this is just for "tekst", but also other columns in my table
> could be null.
> How can I deal with this is a nice way?
>
> Eddy de Boer
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John Smith |
last post by:
Hello all:
Does anyone happen to know the best way to handle null values for
DateTimePickers? We have quite a few columns in our db that will not
necissarily have a date for certain entries. ...
|
by: DKode |
last post by:
I find myself writing repetitive functions for handling null values
from my DB like so:
Private Function SetDateNull(ByVal p_date As Object) As Date
If (TypeOf (p_date) Is System.DBNull) Then...
|
by: Jason Coyne |
last post by:
Here is another programming blog entry. Sorry for the normal friends :)
I recently ran into a problem with a web service I was trying to call
from c# where the web service returned null dates...
|
by: desmoduck |
last post by:
Hey Group,
I may just be suffering brain fade but I have searched around and not
been able to find a solution. My difficulty: I have a datagrid that
shows name, address, tel, fax and toll free...
|
by: psycho |
last post by:
how should i hanle null values returned by the datareader
i am using OleDbDataReader for accessing access database.
|
by: jehugaleahsa |
last post by:
Hello:
Is there a way to handle null values for ints, DateTime, etc. in
generated DataTables?
It seems it is not something the Microsoft crew thought of. That is
hard for me to believe.
...
|
by: tonialbrown |
last post by:
I have some code that updates a record's fields based on a selection from a list box (lstDelFrom). The user selects the record from the list box & it copies it into the fields , , etc.
My...
|
by: apache626 |
last post by:
I really need help with this one. I am using a script task to write data pulled from a MS SQL DB to a fixed width file. The script takes the ItemArray and writes the value of the column to the file...
|
by: NareshN |
last post by:
Hi,
I am using this stored procedure with pivot.If i dont have data i am getting null with this stored procedure.Can u tell me how to handle null.below query is pivot.
I am using like...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |
