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  34422 
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: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
